Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Financial Analysis: Net Present Value (NPV) and Internal Rate of Return (IRR) Calculation, Assignments of MS Microsoft Excel skills

Biểu đồ xương cá (Biểu đồ Ishikawa) là biểu đồ thể hiện nguyên nhân và kết quả để giải quyết mọi vấn đề trong kinh doanh, quản lý và lãnh đạo. Trong

Typology: Assignments

2009/2010

Uploaded on 10/30/2023

ha-hii
ha-hii 🇻🇳

11 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Year 0 1 2 3
1. Revenue 100 120 140
2. Other revenue
2.1 liquidation of fixed assets
2.2 working capital recovery
3. Investment 300
4. operating costs 25 30 35
5. Depreciation 29.5 29.5 29.5
6. Interest 12 12 12
7. Income taxes 33.5 48.5 63.5
8. Tax 6.7 9.7 12.7
9. After-tax income 26.8 38.8 50.8
10. Additional investment value 5 5
11. After-tax cash flow -300 63.3 75.3 92.3
12. Discount rate (1/(1+r)^n) 0.869565217 0.756143667 0.657516232
13. PVCFi -300 55.04347826 56.93761815 60.68874825
14. NPV 141.742834
15. T 55.04347826 111.9810964 172.6698447
17. IRR 25%
interset 0 1 2 3
original 50 50
remainding debt 150 150 100 50
interest 12 12 12
pf2

Partial preview of the text

Download Financial Analysis: Net Present Value (NPV) and Internal Rate of Return (IRR) Calculation and more Assignments MS Microsoft Excel skills in PDF only on Docsity!

2. Other revenue

2.1 liquidation of fixed assets

  • Year
    1. Revenue
    1. Investment 2.2 working capital recovery
    1. operating costs
    1. Depreciation 29.5 29.5 29.
    1. Interest
    1. Income taxes 33.5 48.5 63.
    1. Tax 6.7 9.7 12.
    1. After-tax income 26.8 38.8 50.
    1. Additional investment value
    1. After-tax cash flow -300 63.3 75.3 92.
    1. Discount rate (1/(1+r)^n) 0.869565217 0.756143667 0.
    1. PVCFi -300 55.04347826 56.93761815 60.
    1. NPV 141.
    1. T 55.04347826 111.9810964 172.
  • interset 17. IRR 25%
  • original
  • remainding debt
  • interest

91.1 88.4 88.4 88.4 88.4 88.4 192.4 r= 15% 0.571753246 0.49718 0.432 0.375937 0.326902 0.284262 0. 52.08672067 43.9504 38.22 33.23283 28.89812 25.1288 47. 224.7565653 268.707 307 340.1576 369.0557 394.1845 441. 4 50 0 6