Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I already know the answer of NPV and IRR, please show me how to get them. show the work process in Excel, Thank you! 0
I already know the answer of NPV and IRR, please show me how to get them. show the work process in Excel, Thank you!
0 1 2 3 4 -390000 -36000 Year Initial Capex NWC Investment Operating Cash Flows Terminal Year Cash Flow After Tax Incremental Cash Flows 145797 157275 135417 131822 19750 -390000 109797 157275 135417 151572 Calculation of NPV, IRR, Profitability Index & Payback Period We have the cash flows from the project, using Excel por a financial calculator we can very easily calculate the NPV and IRR of the project. NPV = 8476.29 IRR = 15.01% 0 1 2 3 4 -390000 -36000 Year Initial Capex NWC Investment Operating Cash Flows Terminal Year Cash Flow After Tax Incremental Cash Flows 145797 157275 135417 131822 19750 -390000 109797 157275 135417 151572 Calculation of NPV, IRR, Profitability Index & Payback Period We have the cash flows from the project, using Excel por a financial calculator we can very easily calculate the NPV and IRR of the project. NPV = 8476.29 IRR = 15.01%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