Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Present Value of Multiple Unequal Cash Fk To find the present value of multiple unequal cash flows, we will first discuss the same method we

image text in transcribed

Present Value of Multiple Unequal Cash Fk To find the present value of multiple unequal cash flows, we will first discuss the same method we used to find the future value of multiple unequal cash flows. Let's look at Andrew Luck's contract which was discussed in the chapter opener. What is the present value of the contract? t Cash flow 0 $ 18,400,000 1 19,400,000 2 24,400,000 3 27,525,000 4 28,400,000 5 21,000,000 Interest rate: 12% To find the present value of each cash flow, we can set up a table similar to the one we used to find the future value of each cash flow. So, the present value of the contract is: t Cash flow 0 1 ? 2 ? 3 ? 4 ? 5 ? Total: ? The NPV, or net present value, function in Excel can be used to fin the present value of unequal cash flows. We will discuss NPV in much more detail later, but for now, we will use it to find the present value of these cash flows. Using the NPV function, the present value of the contract is: Present value

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

What two methods can be used to deploy the bastion service

Answered: 1 week ago