Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: NPV result EUR

 |  |  | NPV result EUR |  |  |  |  |  |  |  |  |  |  |  | Prog.Vers.: | V5.0
 |  |  | Project1 |  |  |  |  |  |  |  |  |  |  |  | Print Date: | 1900-01-01 00:00:00
 |  |  | 321 |  |  |  |  |  |  |  |  |  |  |  | Respons.: | 0
 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Overview input data (cash in/cash out)
Investment | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash revenues | 3797.511193630168 | 3890.51876539933 | 3988.176715756951 | 4090.717563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash expenses | -3422.897833906907 | -902.275 | -902.275 | -902.275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Scenarios
Financing | E
Discount rate (%) | 10
Interest rate income (%) | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5
Interest rate expenses (%) | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5
Tax (%) | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
Economic analysis before taxes
Cash flow | 174.6133597232611 | 2988.24376539933 | 3085.901715756951 | 3188.442563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow adjustment for IKV | -0.01 | 2988.24376539933 | 3085.901715756951 | 3188.442563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accumulated cash flow | 174.6133597232611 | 3162.857125122591 | 6248.758840879542 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994 | 9437.201404511994
Discounted cashflow | 174.6133597232611 | 2716.585241272118 | 2550.331996493347 | 2395.524089881631 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accumulated discounted cashflow | 174.6133597232611 | 2891.198600995379 | 5441.530597488726 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358 | 7837.054687370358
Calculation pay back period | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Economics before taxes
Discount rate (%) | 0.1
rate of return (ROR) | 298824.4092206524
Net present value (NPV) inEUR | 7837.054687370358
Budgeted Pay back period | 0
#N/A
4. Impact of project on profit- and loss statement
4.1. Cash Revenues | 3797.511193630168 | 3890.51876539933 | 3988.176715756951 | 4090.717563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.2. Cash Expenses | -3422.897833906907 | -902.275 | -902.275 | -902.275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.3. Depreciation | 0 | -50 | -50 | -50 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.4. Provisions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.5. EBIT | 374.6133597232611 | 2938.24376539933 | 3035.901715756951 | 3138.442563632452 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.6. Interest income/expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.7. Financial result | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.8. Profit on ordinary activities | 374.6133597232611 | 2938.24376539933 | 3035.901715756951 | 3138.442563632452 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.9. Taxes | -93.65333993081528 | -734.5609413498325 | -758.9754289392376 | -784.6106409081129 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.10. Profit after tax | 280.9600197924458 | 2203.682824049498 | 2276.926286817713 | 2353.831922724339 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.11. Profit / loss carry forward | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.12. NIAT (net income after tax) | 280.9600197924458 | 2203.682824049498 | 2276.926286817713 | 2353.831922724339 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4.13. EBITD | 374.6133597232611 | 2988.24376539933 | 3085.901715756951 | 3188.442563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Freie Mittel | 280.9600197924458 | 2253.682824049498 | 2326.926286817713 | 2403.831922724339 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mittelaufbau (kum.) | 80.96001979244579 | 2334.642843841943 | 4661.569130659656 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996
5. Impact of project on cashflow statement
5.1. Application of funds
a) Invest | -200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
b) Repayment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
5.2. Source of funds
a) NIAT | 280.9600197924458 | 2203.682824049498 | 2276.926286817713 | 2353.831922724339 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
b) Borrowing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
c) Depreciation | 0 | 50 | 50 | 50 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5.3. Cash built-up (+) /reduction(-) | 80.96001979244579 | 2253.682824049498 | 2326.926286817713 | 2403.831922724339 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash built-up accumulated | 80.96001979244579 | 2334.642843841943 | 4661.569130659656 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996
6. Economic analysis after taxes
Cash flow | 80.96001979244578 | 2253.682824049498 | 2326.926286817713 | 2403.831922724339 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash flow adjustment for IKV | -0.01 | 2253.682824049498 | 2326.926286817713 | 2403.831922724339 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accumulated cash flow | 80.96001979244578 | 2334.642843841943 | 4661.569130659656 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996 | 7065.401053383996
Discounted cashflow | 80.96001979244578 | 2048.802567317725 | 1923.079575882407 | 1806.034502422493 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accumulated discounted cashflow | 80.96001979244578 | 2129.762587110171 | 4052.842162992578 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071 | 5858.876665415071
[NAME]. [NAME]. Rückzahlungszeitraum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Economics after taxes
Internal rate of return (ROR) | 225368.314904407
Net present value (NPV) in EUR | 5858.876665415071
Budgeted Pay back period | 0