Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Correct calculations NPV = -1,000,000/(1 + 10.38%) 1 - 3,000,000/(1 + 10.38%) 2 - (750,000/10.38%) / (1 + 10.38%) 3 = - $905,961.22 - $2,462,297.22

Correct calculations

NPV = -1,000,000/(1 + 10.38%)1- 3,000,000/(1 + 10.38%)2- (750,000/10.38%) / (1 + 10.38%)3

= - $905,961.22 - $2,462,297.22 - $7,225,433.53/(1 + 10.38%)3

= - $905,961.22 - $2,462,297.22 - $5,372,701.85

NPV = $8,740,960.30

I compared my Excel function to the above results... I'm getting NPV= -$8,738,535.38 and not the NPV =$8,740,960.30 as noted on the equation above. Can you share the Excel function inputs that need be enter to calculate NPV for the above equation? I would like to compare it to my entries for a better understanding? Thank you!

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

Personal Finance

Authors: Jeff Madura

7th Edition

0134989961, 978-0134989969

More Books

Students also viewed these Finance questions