If you know the calculation method

[mstakh.i.mo.mi]

. Thus, the monthly amount of expenses in this case will be 102 thousand rubles. Let's calculate the approximate monthly income. So, if the average bill is 200 rubles, and the number of customers per day is at least 25 people, then the monthly revenue will be 150 thousand rubles (200 × 25 × 30). To calculate the simple payback period of a coffee business, we will use the formula: Payback period = Investments 150 thousand rubles – 102 thousand rubles) = 2.


5 months . It turns out that, taking into account the monthly expenses of a gambling data malaysia takeaway coffee outlet, the business payback period will be about 2.5 months. Determining the payback period of a business in an Excel calculator In the modern world, a special office application is used to work with calculation tables. If you can't make calculations using only a calculator or paper, you can use the Excel editor. Here, even with a simple method, it is possible to take into account data on overhead costs, profitability, and planned costs for work related to repairs.


you can easily make your own calculations in tabular form. To simplify the work, there are ready-made templates in which you can insert the specified parameters and get the necessary results. The benefit of maintaining such tables is quite noticeable, especially when it is necessary to recalculate the forecast and get up-to-date data based on the results of the reporting. Calculations in the Excel editor can be made using the DPP method, which allows the investor to adjust the payback period depending on factors such as: equipment obsolescence; inflation dynamics; accrued depreciation; life span of the industry; change in the liquidity of fixed assets.