Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use the following information to complete the calculation of NPV, IRR and Payback, while all other info stays the same. Microsoft, 1160000 increases by 1%
use the following information to complete the calculation of NPV, IRR and Payback, while all other info stays the same.
Microsoft,
1160000 | increases by 1% each year |
Clipboard Alignment fe NPV(0.2, C17: F17)+B17 B19 Cash Flows 13 2132444.6 2194352.6 2239743 2231680.576 14 Operating Cash Flow 15 Changes in NWC 1150000 350000 15000 15150 1545451.5 16 Net Capital Spending 1310000 545270 17 Cash Flow From Ass (2,460,000) 1.782.445 2,179,353 2.224.593 4.322.402 18 Net value T$3.910.682 19 Present 20 IRR 79.86% 1.31 -1+(ABS(B17-c17)D17 21 Payback Period 1150000 1500000 1515000 1530150 1545451.5 23 24 Change in NWC 1150000 15301.5 350000 15000 15150 25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started