Полное руководство по финансовому моделированию. Для предпринимателей. Никита Борисов

сказал: «Неужели менеджеры думают, что зубная фея понесёт капитальные затраты?», как раз отмечая, что показатель EBITDA, который не учитывает амортизации, не говорит о прибыльности предприятия в долгосрочной (десятки лет) перспективе, т.к. положительный EBITDA не всегда означает возможность окупить осуществленные капвложения в здания, сооружения, оборудование и нематериальные активы.

      4

      На самом деле, конечно же, здесь не учтены налоги, но мы упрощаем задачу для понимания сути движения активов и пассивов.

/9j/4AAQSkZJRgABAQABLAEsAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdCIFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFjcHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAAABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAADTAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJDAAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkZXNjAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZGVzYwAAAAAAAAAsUmVmZXJlbmNlIFZpZXdpbmcgQ29uZGl0aW9uIGluIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAALFJlZmVyZW5jZSBWaWV3aW5nIENvbmRpdGlvbiBpbiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHZpZXcAAAAAABOk/gAUXy4AEM8UAAPtzAAEEwsAA1yeAAAAAVhZWiAAAAAAAEwJVgBQAAAAVx/nbWVhcwAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAo8AAAACc2lnIAAAAABDUlQgY3VydgAAAAAAAAQAAAAABQAKAA8AFAAZAB4AIwAoAC0AMgA3ADsAQABFAEoATwBUAFkAXgBjAGgAbQByAHcAfACBAIYAiwCQAJUAmgCfAKQAqQCuALIAtwC8AMEAxgDLANAA1QDbAOAA5QDrAPAA9gD7AQEBBwENARMBGQEfASUBKwEyATgBPgFFAUwBUgFZAWABZwFuAXUBfAGDAYsBkgGaAaEBqQGxAbkBwQHJAdEB2QHhAekB8gH6AgMCDAIUAh0CJgIvAjgCQQJLAlQCXQJnAnECegKEAo4CmAKiAqwCtgLBAssC1QLgAusC9QMAAwsDFgMhAy0DOANDA08DWgNmA3IDfgOKA5YDogOuA7oDxwPTA+AD7AP5BAYEEwQgBC0EOwRIBFUEYwRxBH4EjASaBKgEtgTEBNME4QTwBP4FDQUcBSsFOgVJBVgFZwV3BYYFlgWmBbUFxQXVBeUF9gYGBhYGJwY3BkgGWQZqBnsGjAadBq8GwAbRBuMG9QcHBxkHKwc9B08HYQd0B4YHmQesB78H0gflB/gICwgfCDIIRghaCG4IggiWCKoIvgjSCOcI+wkQCSUJOglPCWQJeQmPCaQJugnPCeUJ+woRCicKPQpUCmoKgQqYCq4KxQrcCvMLCwsiCzkLUQtpC4ALmAuwC8gL4Qv5DBIMKgxDDFwMdQyODKcMwAzZDPMNDQ0mDUANWg10DY4NqQ3DDd4N+A4TDi4OSQ5kDn8Omw62DtIO7g8JDyUPQQ9eD3oPlg+zD88P7BAJECYQQxBhEH4QmxC5ENcQ9RETETERTxFtEYwRqhHJEegSBxImEkUSZBKEEqMSwxLjEwMTIxNDE2MTgxOkE8UT5RQGFCcUSRRqFIsUrRTOFPAVEhU0FVYVeBWbFb0V4BYDFiYWSRZsFo8WshbWFvoXHRdBF2UXiReuF9IX9xgbGEAYZRiKGK8Y1Rj6GSAZRRlrGZEZtxndGgQaKhpRGncanhrFGuwbFBs7G2MbihuyG9ocAhwqHFIcexyjHMwc9R0eHUcdcB2ZHcMd7B4WHkAeah6UHr4e6R8THz4faR+UH78f6iAVIEEgbCCYIMQg8CEcIUghdSGhIc4h+yInIlUigiKvIt0jCiM4I2YjlCPCI/AkHyRNJHwkqyTaJQklOCVoJZclxyX3JicmVyaHJrcm6CcYJ0kneierJ9woDSg/KHEooijUKQYpOClrKZ0p0CoCKjUqaCqbKs8rAis2K2krnSvRLAUsOSxuLKIs1y0MLUEtdi2rLeEuFi5MLoIuty7uLyQvWi+RL8cv/jA1MGwwpDDbMRIxSjGCMbox8jIqMmMymzLUMw0zRjN/M7gz8TQrNGU0njTYNRM1TTWHNcI1/TY3NnI2rjbpNyQ3YDecN9c4FDhQOIw4yDkFOUI5fzm8Ofk6Njp0OrI67zstO2s7qjvoPCc8ZTykPOM9Ij1hPaE94D4gPmA+oD7gPyE/YT+iP+JAI0BkQKZA50EpQWpBrEHuQjBCckK1QvdDOkN9Q8BEA0RHRIpEzkUSRVVFmkXeRiJGZ0arRvBHNUd7R8BIBUhLSJFI10kdSWNJqUnwSjdKfUrESwxLU0uaS+JMKkxyTLpNAk1KTZNN3E4lTm5Ot08AT0lPk0/dUCdQcVC7UQZRUFGbUeZSMVJ8UsdTE1NfU6pT9lRCVI9U21UoVXVVwlYPVlxWqVb3V0RXklfgWC9YfVjLWRpZaVm4WgdaVlqmWvVbRVuVW+VcNVyGXNZdJ114XcleGl5sXr1fD19hX7NgBWBXYKpg/GFPYaJh9WJJYpxi8GNDY5dj62RAZJRk6WU9ZZJl52Y9ZpJm6Gc9Z5Nn6Wg/aJZo7GlDaZpp8WpIap9q92tPa6dr/2xXbK9tCG1gbbluEm5rbsRvHm94b9FwK3CGcOBxOnGVcfByS3KmcwFzXXO4dBR0cHTMdSh1hXXhdj52m3b4d1Z3s3gReG54zHkqeYl553pGeqV7BHtje8J8IXyBfOF9QX2hfgF+Yn7CfyN/hH/lgEeAqIEKgWuBzYIwgpKC9INXg7qEHYSAhOOFR4Wrhg6GcobXhzuHn4gEiGmIzokziZmJ/opkisqLMIuWi/yMY4zKjTGNmI3/jmaOzo82j56QBpBukNaRP5GokhGSepLjk02TtpQglIqU9JVflcmWNJaflwqXdZfgmEyYuJkkmZCZ/JpomtWbQpuvnByciZz3nWSd0p5Anq6fHZ+Ln/qgaaDYoUehtqImopajBqN2o+akVqTHpTilqaYapoum/adup+CoUqjEqTepqaocqo+rAqt1q+msXKzQrUStuK4trqGvFq+LsACwdbDqsWCx1rJLssKzOLOutCW0nLUTtYq2AbZ5tvC3aLfguFm40blKucK6O7q1uy67p7whvJu9Fb2Pvgq+hL7/v3q/9cBwwOzBZ8Hjwl/C28NYw9TEUcTOxUvFyMZGxsPHQce/yD3IvMk6ybnKOMq3yzbLtsw1zLXNNc21zjbOts83z7jQOdC60TzRvtI/0sHTRNPG1EnUy9VO1dHWVdbY11zX4Nhk2OjZbNnx2nba+9uA3AXcit0Q3ZbeHN6i3ynfr+A24L3hROHM4lPi2+Nj4+vkc+T85YTmDeaW5x/nqegy6LzpRunQ6lvq5etw6/vshu0R7ZzuKO6070DvzPBY8OXxcvH/8ozzGfOn9DT0wvVQ9d72bfb794r4Gfio+Tj5x/pX+uf7d/wH/Jj9Kf26/kv+3P9t////2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAEpAk8DAREAAhEBAxEB/8QAHQABAAIDAQEBAQAAAAAAAAAAAAUGAwQHAgEICf/EAF4QAAAFAwICBAgICAsGBAQFBQECAwQFAAYRBxIIIRMxV9IUFhciQZOV0xUYGVFUVpSWIzI3U1VhtNEJM0JScXJ0dpKz1CQ1OIGRsjRDYqElNnODJkdjZLFmdYaio//EABwBAQACAwEBAQAAAAAAAAAAAAABAgMEBQYHCP/EAEYRAAECAwIJCQgBAwMDBQEBAAABAgMEERJRBRUhMVJTVJHRBhQWF2GBkqKxExhBcaHS4fAiBzIzNDWyQnLBCCNic4IkRP/aAAwDAQACEQMRAD8A/FzeBhFESKKRDM5zhuMYyJRER+fqr57Ozsy2ZiNbEVERV+K3n7K5OcnMERsESsSJKw1csNiqqsbVVsplXIWy0dD7hvyMmJmz9OjSzKAQ8Ikl2zQpitk8GNuN/wAimHl8w1SFGn4zVdDe5UTPlUzT8jyVwXFhwZyDBY6ItGorW5VyZsnahV/F6B/QrL1Bf3Vh59Nax29Tp9F8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Gk0gYM0g/IaIZiUhk9oCiXAZIHVyrYizsykKGqRHfH4recqS5N4HdOzTXSsOiKyn8G5P4J2G74vQP6FZeoL+6tfn01rHb1Or0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4Dxegf0Ky9QX91OfTWsdvUdF8CbJD8DeA8XoH9CsvUF/dTn01rHb1HRfAmyQ/A3gPF6B/QrL1Bf3U59Nax29R0XwJskPwN4F3044dLv1ZFyaw9OkpFuzECuXZk0kWyAj1AdVQSkAf1ZzWzLvwhNV9k9y07cm84mF4XJLAVnn8GE1XZksIrl+SIir9CBvLTBCxLlfWnPQ0P4fHnBNfwUyThIDCUDYBQmSm5CHUPXWKLNTkF6w3RFqn/wAjewfgbk/hOWbNwJRll2asNEXcqVQhvF6B/QrL1Bf3Vj59Nax29Td6L4E2SH4G8CIuuEhm8C5WQimiZy7MGIkUBDzw9Nb+DJyYfNNa6Iqpl+K3KeY5Zcn8Ey2BY0WDLMa5LOVGoi/3N7CwtP8AwyX9WtCe/wBVE/7l9T0/Jf8A2SU/+tn/ABQ/oPoMnbehulWmbe5NSrftV7dsqe552PkyrCrJRaiZmyKAdGQwAUSGMbzxANwh8w135KxJwISPejVctpUWuVMyIfH+U6zPKXCs86WlnxmwWeyhubZoyIio9zsqplqiJk+BXdNuH6xIC59fdO9QxZsoqKUiwZTC7QFjtGa7zJFUhHmXcmYpRMA8s5HkFYZeRhMfMQYuREpRbkVeB0cMcqp6alcEYRwfVz3+0tMRaI5zWZUW+ioq0N2w3jU/EdqhpxcWkFlNIyBhpR/HMl4JssdHwVAgNjAqJcmKYoAoPoMJxH01aCqc7iwXw20RFVEonwTIYMJw3JyckcIy83Fc+I+G1zkiOStty2kpXIqLkS6hV9IbPtHWHQu7dRL8hoGKaxF5t5OZdMGCTYUo1BluO2QKUA29KfYQCl5CY+awysKHNSz40VEREcirRKZETMnzOnh+fm+T+HJfB8g973Pgq1iOcrqvc/I51c9lKrVfglDqzi1dM1NTdQZ5tYMDHMW+mERNsW5bfRkCMVlcGE5GwgAKHwOB6hNjrreWFBWPEcjERLCKmRFp3HlWzuE0wZJwHR3ucs1EY5faKxXImSiu+CehqQenOn9was6GXASwoU8ZccdNJSLg8GSO+EXCKCggKkcOSp7OQlMAjuznlgKqyXhRI8B1hKOR1clK0TRM0zheflcE4Vl1mHW4ToStS2r7COcmaLnWvxTJQ5Rp