IKBFU's Vestnik

2016 Issue №03

Back to the list Download an article

The modelling of investment and current costs in investment project evaluation using spreadsheet tables



This article focuses on the calculation of investment and current costs of an investment project. The structure of calculations and approaches to their classification are described. Recommendations on organizing calculations of investment and current costs of investment project calculations in spreadsheet tables are produced. It is proposed to consider such parameters as the investment payment period, variable cost per unit, starting date of fixed costs, taxation, price growth, etc. The author describes the logic behind the formulas taking into account these parameters. Spreadsheet formulas are proposed.


1. Филобокова Л. Ю., Уланова И. А. Управление материальными затратами организаций молочно-перерабатывающих производств инструментарием финансового бюджетирования // Финансовый менеджмент. 2015. № 5. С. 40—48.
2. Черемушкин С. В. Основы практического моделирования займов и кредитов в EXCEL // Финансовый менеджмент. 2015. № 4. С. 96—126.