Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

why doesn't the formula at the very bottom work when i try to put it in excel if that is the correct form to input

image text in transcribedwhy doesn't the formula at the very bottom work when i try to put it in excel if that is the correct form to input it?
Initial Outlay = $2,500,000, After-tax operating cash flows for years 1-4 = $650,000 per year Additional after-tax terminal cash flow at end of Year 4 = $200,000 1 Compute the net present value of this project if the company's discount rate is 12 percent. A) -$412,238 B) $398,619 C$187,432 D) $349,217 Answer B =npv(12,-2500000,{650000,650000+200000},{3,1})=-$398,619

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Finance questions

Question

Management (inaugurated) the recycling policy six months ago.

Answered: 1 week ago

Question

Patients are charged premiums based on their risk rating.

Answered: 1 week ago