April 28, 2017

The nuances of building a financial model

January 29, 2011    PracticeРаспечатать эту статью

The nuances of building a financial model

The time when you could go to the investor with a descriptive business plan for fifty pages, has passed. Development Bank, in a moment so tired of these documents, which posted on its website its demands to the business plan and financial model. Now the detailed financial information – an important part of any business plan. But many entrepreneurs doing business for years, the fact that the financial model must be created in the format of Microsoft Excel, still baffled. At the request of Forbes Dmitry Kovalev , senior manager of corporate finance PricewaterhouseCoopers , identified a number of nuances to keep in mind when building financial models and writing a business plan.

  1. Banks prefer to have the financial model presented three predicted forms- the forecast balance sheet, profit and loss forecast, the forecast statement of cash flows. If your business plan, one of the predictions is not likely to have to redo.
  2. forecast should be made at least the entire payback period. Tables in the business plan is better cause a breakdown, which will be retained for all calculations (eg, quarterly).
  3. bankers have more confidence in estimates of revenue, which are supported by qualitative marketing research , as well as letters or preliminary agreements with potential buyerson company letterhead, indicating the purchase amount (copies is given in the Appendix). If no such arrangements and illiquid products, specifically, is your prediction for the proceeds will be a big question. The same is forecast to cost. It is better to attach a letter of preliminary agreements with suppliers.
  4. Monoproizvodstva rare, usually items (drivers) more revenue. Need a good understanding of their product range and expect forecast revenue for each of the products, giving the total amount of output. For example, a business center rents not only offices, but also space for shops, cafes and storage space. Rental rates on all of these categories are different. The same can be said about almost any business, be it a refinery or retail store.
  5. need to understand the nuances of pricingin a market where you are going to work. If it refers to hotels, the business plan can not be provided for 100 percent load, no one would believe it. It is better to split the download in different categories of rooms (suites, it can be 10%, and the usual numbers – 70%). It is also worth considering that the rooms you will sell to corporate discounts, etc.
  6. Most are calculated three scenarios(scenario analysis), business development and prepared the base, optimistic and pessimistic forecasts. Sometimes, to calculate the revenue forecast used sensitivity analysis or probabilistic methods, such as the method of Monte Carlo simulation.
  7. In case of any possible occurrence of any specific project risks banks are welcome, if the business plan covers the topic and listed tools to help the company hedge its risks.
  8. basic requirements for costing – reasonable detail, realism and attention to operating and capital expenditure, which must be calculated for the entire forecast period. If you’re planning a long-term growth in check, as to whether this power. Otherwise, the bankers immediately ask you, where CAPEX to expand production.
  9. calculations cash flowsto reflect the operating cash flow (how much money has come from customers as it took to supplier invoices), investment (what is spent on acquiring new assets or plan to gain from the sale of existing ) and financial (the body of credit, dividends, capital increase).
  10. the calculation of operating cash flow should be taken into account the turnover of goods, delay / difference in getting the money from customers as well as possible delays in its own – an entrepreneur needs to know from previous experience or from an analysis of competitors’ activities. Tax settlements should be done very carefully.
  11. residue, which is obtained at the end of the year in the forecast cash flows must correspond to what is stated in the article in the forecast balance sheet. If they do not converge, it is disturbing. When you check your own financial model on several occasions it is desirable to ensure proper functioning of the model, substituting the various assumptions and verifying it, that assets are liabilities, not having a negative cash balance in line, etc.
  12. No hidden sheets in Excel, the remnants of settlement in the fields should not be. If the three-year CAPEX figure 5 rubles, and in 2013 suddenly from a factor 1.1 is taken, it is necessary to explain that the planned scheduled maintenance. All entered into the model assumptions should be listed on the sheets assumptions , so that bankers can use their own assumptions when testing the financial model, and their numbers and verify the model itself.

Tags: , ,








  • 27ek

    а де фінансова модель,деееее.

PHVsPjxsaT48c3Ryb25nPndvb19hZF9jb250ZW50PC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2NvbnRlbnRfYWRzZW5zZTwvc3Ryb25nPiAtIDxzY3JpcHQgYXN5bmMgc3JjPVwiLy9wYWdlYWQyLmdvb2dsZXN5bmRpY2F0aW9uLmNvbS9wYWdlYWQvanMvYWRzYnlnb29nbGUuanNcIj48L3NjcmlwdD4NCjwhLS0g0J/RgNC10LTQv9GA0LjQvdC40LzQsNGC0LXQu9GMICjQkiDRgdGC0LDRgtGM0LUpIC0tPg0KPGlucyBjbGFzcz1cImFkc2J5Z29vZ2xlXCINCiAgICAgc3R5bGU9XCJkaXNwbGF5OmlubGluZS1ibG9jazt3aWR0aDo0NjhweDtoZWlnaHQ6MTVweFwiDQogICAgIGRhdGEtYWQtY2xpZW50PVwiY2EtcHViLTMyNzE1MzExMjk0MzQ3ODBcIg0KICAgICBkYXRhLWFkLXNsb3Q9XCIxOTc4NTgzNDQxXCI+PC9pbnM+DQo8c2NyaXB0Pg0KKGFkc2J5Z29vZ2xlID0gd2luZG93LmFkc2J5Z29vZ2xlIHx8IFtdKS5wdXNoKHt9KTsNCjwvc2NyaXB0PjwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2NvbnRlbnRfaW1hZ2U8L3N0cm9uZz4gLSBodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yOS1yZXN0b3Jhbi1iaXMuanBnPC9saT48bGk+PHN0cm9uZz53b29fYWRfY29udGVudF91cmw8L3N0cm9uZz4gLSBodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvZW50cmVwcmVuZXVyc2hpcC9wcmFjdGljZS9vcGVuLXJlc3RhdXJhbnQ8L2xpPjxsaT48c3Ryb25nPndvb19hZF9oZWFkZXI8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fYWRfaGVhZGVyX2NvZGU8L3N0cm9uZz4gLSA8c2NyaXB0IGFzeW5jIHNyYz1cIi8vcGFnZWFkMi5nb29nbGVzeW5kaWNhdGlvbi5jb20vcGFnZWFkL2pzL2Fkc2J5Z29vZ2xlLmpzXCI+PC9zY3JpcHQ+DQo8IS0tINCf0YDQtdC00L/RgNC40L3QuNC80LDRgtC10LvRjCAoVG9wKSAtLT4NCjxpbnMgY2xhc3M9XCJhZHNieWdvb2dsZVwiDQogICAgIHN0eWxlPVwiZGlzcGxheTppbmxpbmUtYmxvY2s7d2lkdGg6NDY4cHg7aGVpZ2h0OjYwcHhcIg0KICAgICBkYXRhLWFkLWNsaWVudD1cImNhLXB1Yi0zMjcxNTMxMTI5NDM0NzgwXCINCiAgICAgZGF0YS1hZC1zbG90PVwiODAyNTExNzA0OVwiPjwvaW5zPg0KPHNjcmlwdD4NCihhZHNieWdvb2dsZSA9IHdpbmRvdy5hZHNieWdvb2dsZSB8fCBbXSkucHVzaCh7fSk7DQo8L3NjcmlwdD48L2xpPjxsaT48c3Ryb25nPndvb19hZF9oZWFkZXJfaW1hZ2U8L3N0cm9uZz4gLSBodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yOC1yZXN0b3Jhbi1iaXMtcy5qcGc8L2xpPjxsaT48c3Ryb25nPndvb19hZF9oZWFkZXJfdXJsPC9zdHJvbmc+IC0gaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL2VudHJlcHJlbmV1cnNoaXAvcHJhY3RpY2Uvb3Blbi1yZXN0YXVyYW50PC9saT48bGk+PHN0cm9uZz53b29fYWRfbGVhZGVyYm9hcmRfZjwvc3Ryb25nPiAtIHRydWU8L2xpPjxsaT48c3Ryb25nPndvb19hZF9sZWFkZXJib2FyZF9mX2NvZGU8L3N0cm9uZz4gLSA8b2JqZWN0IHdpZHRoPVwiNzI4XCIgaGVpZ2h0PVwiOTBcIiBjb2RlYmFzZT1cImh0dHA6Ly9kb3dubG9hZC5tYWNyb21lZGlhLmNvbS9wdWIvc2hvY2t3YXZlL2NhYnMvZmxhc2gvc3dmbGFzaC5jYWIjdmVyc2lvbj02LDAsMjksMFwiIGNsYXNzaWQ9XCJjbHNpZDpkMjdjZGI2ZS1hZTZkLTExY2YtOTZiOC00NDQ1NTM1NDAwMDBcIj48cGFyYW0gdmFsdWU9XCIvd3AtY29udGVudC93b29fdXBsb2Fkcy84LTUtNzI4eDkwYS5zd2ZcIiBuYW1lPVwibW92aWVcIj48cGFyYW0gdmFsdWU9XCJoaWdoXCIgbmFtZT1cInF1YWxpdHlcIj48ZW1iZWQgd2lkdGg9XCI3MjhcIiBoZWlnaHQ9XCI5MFwiIHR5cGU9XCJhcHBsaWNhdGlvbi94LXNob2Nrd2F2ZS1mbGFzaFwiIHBsdWdpbnNwYWdlPVwiaHR0cDovL3d3dy5tYWNyb21lZGlhLmNvbS9nby9nZXRmbGFzaHBsYXllclwiIHF1YWxpdHk9XCJoaWdoXCIgYmdjb2xvcj1cIiNmZmZmZmZcIiBzcmM9XCIvd3AtY29udGVudC93b29fdXBsb2Fkcy84LTUtNzI4eDkwYS5zd2ZcIj48L29iamVjdD48L2xpPjxsaT48c3Ryb25nPndvb19hZF9sZWFkZXJib2FyZF9mX2ltYWdlPC9zdHJvbmc+IC0gaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvOC01LTcyOHg5MGEuanBnPC9saT48bGk+PHN0cm9uZz53b29fYWRfbGVhZGVyYm9hcmRfZl91cmw8L3N0cm9uZz4gLSBodHRwOi8vYXJ0ZXhtZWRpYS5jb20udWE8L2xpPjxsaT48c3Ryb25nPndvb19hbHNvX3NsaWRlcl9lbmFibGU8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fYWxzb19zbGlkZXJfaW1hZ2VfZGltZW50aW9uc19oZWlnaHQ8L3N0cm9uZz4gLSAxMTU8L2xpPjxsaT48c3Ryb25nPndvb19hbHRfc3R5bGVzaGVldDwvc3Ryb25nPiAtIGRlZmF1bHQuY3NzPC9saT48bGk+PHN0cm9uZz53b29fYXJjaGl2ZV9wYWdlX2ltYWdlX2hlaWdodDwvc3Ryb25nPiAtIDE1MDwvbGk+PGxpPjxzdHJvbmc+d29vX2FyY2hpdmVfcGFnZV9pbWFnZV93aWR0aDwvc3Ryb25nPiAtIDE1MDwvbGk+PGxpPjxzdHJvbmc+d29vX2F1dG9faW1nPC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9tZW51PC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NvbnRhY3RfcGFnZV9pZDwvc3Ryb25nPiAtIDEzNjQ8L2xpPjxsaT48c3Ryb25nPndvb19jdXN0b21fY3NzPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fY3VzdG9tX2Zhdmljb248L3N0cm9uZz4gLSBodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy9mYXZpY29uLmljbzwvbGk+PGxpPjxzdHJvbmc+d29vX2V4Y2VycHRfZW5hYmxlPC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2ZlYXR1cmVkX2ltYWdlX2RpbWVudGlvbnNfaGVpZ2h0PC9zdHJvbmc+IC0gMzcwPC9saT48bGk+PHN0cm9uZz53b29fZmVhdHVyZWRfc2lkZWJhcl9pbWFnZV9kaW1lbnRpb25zX2hlaWdodDwvc3Ryb25nPiAtIDc1PC9saT48bGk+PHN0cm9uZz53b29fZmVhdHVyZWRfdGFnPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fZmVhdHVyZWRfdGFnX2Ftb3VudDwvc3Ryb25nPiAtIDU8L2xpPjxsaT48c3Ryb25nPndvb19mZWVkYnVybmVyX3VybDwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2dvb2dsZV9hbmFseXRpY3M8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19oaWdobGlnaHRzX3Nob3c8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29faGlnaGxpZ2h0c190YWc8L3N0cm9uZz4gLSBwcmFrdGljaGVza2l5LXNvdmV0PC9saT48bGk+PHN0cm9uZz53b29faGlnaGxpZ2h0c190YWdfYW1vdW50PC9zdHJvbmc+IC0gMzwvbGk+PGxpPjxzdHJvbmc+d29vX2hpZ2h0bGlnaHRzX2ltYWdlX2RpbWVudGlvbnNfaGVpZ2h0PC9zdHJvbmc+IC0gNzU8L2xpPjxsaT48c3Ryb25nPndvb19sb2dvPC9zdHJvbmc+IC0gaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMzItMzAtbG9nby5wbmc8L2xpPjxsaT48c3Ryb25nPndvb19tYW51YWw8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb20vc3VwcG9ydC90aGVtZS1kb2N1bWVudGF0aW9uL3RoZS1qb3VybmFsLzwvbGk+PGxpPjxzdHJvbmc+d29vX25hdl9leGNsdWRlPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fcmVjZW50X2FyY2hpdmVzPC9zdHJvbmc+IC0gIzwvbGk+PGxpPjxzdHJvbmc+d29vX3Jlc2l6ZTwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fc2hvcnRuYW1lPC9zdHJvbmc+IC0gd29vPC9saT48bGk+PHN0cm9uZz53b29fc2luZ2xlX3Bvc3RfaW1hZ2VfaGVpZ2h0PC9zdHJvbmc+IC0gMzUwPC9saT48bGk+PHN0cm9uZz53b29fc2luZ2xlX3Bvc3RfaW1hZ2Vfd2lkdGg8L3N0cm9uZz4gLSAyOTM8L2xpPjxsaT48c3Ryb25nPndvb19zbGlkZXJfaGVhZGluZzwvc3Ryb25nPiAtINCf0L7RgdC70LXQtNC90LjQtSDQv9GD0LHQu9C40LrQsNGG0LjQuDwvbGk+PGxpPjxzdHJvbmc+d29vX3RoZW1lbmFtZTwvc3Ryb25nPiAtIFRoZSBKb3VybmFsPC9saT48bGk+PHN0cm9uZz53b29fdXBsb2Fkczwvc3Ryb25nPiAtIGE6MjU6e2k6MDtzOjY1OiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8zMy1mYXZpY29uLmdpZiI7aToxO3M6NjU6Imh0dHA6Ly9wcmVkcHJpbmltYXRlbC5jby51YS93cC1jb250ZW50L3dvb191cGxvYWRzLzMyLTMwLWxvZ28ucG5nIjtpOjI7czo2NToiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMzEtMzAtbG9nby5wbmciO2k6MztzOjYyOiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8zMC1sb2dvLnBuZyI7aTo0O3M6NzA6Imh0dHA6Ly9wcmVkcHJpbmltYXRlbC5jby51YS93cC1jb250ZW50L3dvb191cGxvYWRzLzI5LXJlc3RvcmFuLWJpcy5qcGciO2k6NTtzOjcyOiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yOC1yZXN0b3Jhbi1iaXMtcy5qcGciO2k6NjtzOjcyOiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yNy1yZXN0b3Jhbi1iaXMtcy5qcGciO2k6NztzOjcwOiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yNi1yZXN0b3Jhbi1iaXMuanBnIjtpOjg7czo3MDoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMjUtcmVzdG9yYW4tYmlzLmpwZyI7aTo5O3M6NzA6Imh0dHA6Ly9wcmVkcHJpbmltYXRlbC5jby51YS93cC1jb250ZW50L3dvb191cGxvYWRzLzI0LXJlc3RvcmFuLWJpcy5qcGciO2k6MTA7czo3MDoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMjMtcmVzdG9yYW4tYmlzLmpwZyI7aToxMTtzOjY1OiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8yMS0xNS1sb2dvLnBuZyI7aToxMjtzOjY1OiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8xOC1mYXZpY29uLmdpZiI7aToxMztzOjY2OiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy8xNy1mYXZpY29uMi5naWYiO2k6MTQ7czo2NToiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTYtZmF2aWNvbi5naWYiO2k6MTU7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTUtbG9nby5wbmciO2k6MTY7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTQtbG9nby5wbmciO2k6MTc7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTMtbG9nby5wbmciO2k6MTg7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTItbG9nby5wbmciO2k6MTk7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTEtbG9nby5wbmciO2k6MjA7czo2MjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMTAtbG9nby5wbmciO2k6MjE7czo2MToiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvOS1sb2dvLnBuZyI7aToyMjtzOjY2OiJodHRwOi8vcHJlZHByaW5pbWF0ZWwuY28udWEvd3AtY29udGVudC93b29fdXBsb2Fkcy84LTUtNzI4eDkwYS5qcGciO2k6MjM7czo2NjoiaHR0cDovL3ByZWRwcmluaW1hdGVsLmNvLnVhL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvOC01LTcyOHg5MGEuanBnIjtpOjI0O3M6NjY6Imh0dHA6Ly9wcmVkcHJpbmltYXRlbC5jby51YS93cC1jb250ZW50L3dvb191cGxvYWRzLzgtNS03Mjh4OTBhLmpwZyI7fTwvbGk+PC91bD4=