Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jeff Madura

6th Edition

0134082915, 9780134082912

More Books

Students also viewed these Finance questions

Question

Explain the various methods of job evaluation

Answered: 1 week ago

Question

Differentiate Personnel Management and Human Resource Management

Answered: 1 week ago

Question

Describe the functions of Human resource management

Answered: 1 week ago