Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, my manual NPV calculation is not matching the excel NPV formula and I can't understand why. Here is the problem set up. You and

Hello, my manual NPV calculation is not matching the excel NPV formula and I can't understand why. Here is the problem set up. You and your business partner identify an apartment building which you can purchase for $6 million today.

According to your calculations, your annual profit (after all expenses) will be $600,000 received at the end of each of the next four years (ex: your first $600,000 payment will be received at the end of Year 1).

Finally, having established a track record, you plan on selling the buildings for $10.6 million at the end of the fourth year.

Using a table, lay out the stream of cash flows from this project as shown in class.Clearly indicate the period, the cash inflow / outflow during each period, and the source (or use) of the cash flow.

My manual answer is= $4,295,103.92

Excel NPV formula is= $4,032,961.43

Can you please help me identify (1) which is correct, (2) why they aren't matching.

Thanks.

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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

More Books

Students also viewed these Finance questions

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago

Question

What is the different between uncertainty and risk?

Answered: 1 week ago