Transferring calculations to an office platform does not become more difficult using the discounted calculation form indicated in the examples above. First, it is determined what the profitability of the business is during the planned payback period. Subsequently, the calculation of cash receipts is carried out taking into account the adjustment rate. Example 1. For capital in the amount of 9 million rubles, the investor set a discount rate of 10%. It is necessary to enter the forecast values into the editor only once; for subsequent years of work, the formulas are simply copied.
Year: Calculation of discounted cash flows Calculation result (rubles) 1 3,000,000 / (1 + 0.1) 2 727 272 2 3,000,000 / (1 + 0.1) 2 2 479 389 3 3,000,000 / (1 + 0.1) 3 2 253 944 4 3,000,000 / (1 + 0.1) 4 2 049 040 Total: 7 460 605 The gambling data malaysia figures obtained as a result of calculations allow us to determine the payback period of the business in a time interval of 3-4 years.
we can easily calculate the expected period, which will be three quarters. It turns out that the store will be in the black in 3.75 years. Calculations are based on formulas (mathematical, simple, financial) to understand the principle of calculation by the discounting method. If you take the correction factor, then you will have to use the formula of raising to a power. You can get the final result by using the average value function.