To do this, consider how much we will have money in the bank after a year under twenty percent, so we get to the bank through the year, six hundred thousand rubles. A second project brings us through the year six hundred and fifty thousand rubles, but we can not consider the benefits in the future – this is not correct, we need to bring value of the property six hundred and fifty thousand rubles today, for this we introduce the discount rate, which is equal to the rate we have an alternative project twenty percent per annum. So, we have six hundred fifty thousand present by a discount rate today, and get five hundred and forty-one thousand, that is, to us a year to get six hundred and fifty thousand rubles, we need to put the bank under the twenty percent per annum five hundred and forty-one thousand rubles. We have two of the project is the first bank and a second property, and money to invest five hundred thousand, that's the difference between five hundred and forty one thousand, and the fact that we invest – this is Net Present Value NPV. NPV of the project must be greater than zero, then the project is deemed promising. So we figured out with NPV. Now, as the net present value for any project with a lot of money flows. Take our favorite Excel, making it a table horizontally, we will have during the project, and on vertical our payments.
Here in the photo is clearly visible problem, we buy a car, train workers, enter the cost of the car and obtain income, interest rates, twelve thousand rubles. Enter all the streams in our table, we believe in the seventh column the amount of our payments go to the SUM formula and select the cell for example, B2: B6 and obtain the sum of flows for each of our year, now we need prodiskontirovat our cash flows by the discount rate twelve percent, again go into the formulas, financial, and find the NPV (net present value), choose a discount rate twelve percent of the net and choose the payment this year and get a discounted payment. To calculate the net present value of the project to all prossumirovat discounted payments of our project, receive one thousand eight hundred sixty-six rubles, which is a positive NPV of the project should join. So figured out the net present value, we now understand its significance, and the calculation of our business plan we have Bole free to operate it. Next, we will count one by one the other financial items in Excel, then put it all into one and create your first business plan in Excel, with charts and descriptions in accordance with UNIDO UN system, and after graduating from the switch to Excel, Project Expert, and then we'll see.