I already know the answer of NPV and IRR, please show me how to get them. show
Fantastic news! We've Found the answer you've been seeking!
Question:
I already know the answer of NPV and IRR, please show me how to get them. show the work process in Excel, Thank you!
Transcribed image text: 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% Transcribed image text: 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%
Posted Date: