Question: Compute the future value and present value of Cash Flows You need to use the functions built in in excel to answer the question. Manually

 Compute the future value and present value of Cash Flows
You need to use the functions built in in excel to answer the question. Manually fill in the answer will receive 0 point
a) What is the future value of these cash flows at the end of year 9 (Assume CFs occur at the end of each year)?
YearCF
115,000
217,000
321,040
422,987
524,000
635,800
721,900
815,890
924,000
Interest rate =6%
b) Compute the present value of the CFs in part a)
c) Repeat part a and b with the cash flows occur at the beginning of the period instead.
YearCF
115,000
235,000
324,000
417,000
512,500
635,800
724,000
815,890
920,000

Step by Step Solution

3.40 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Step1 A We need to calculate the future value of cash flows So we will use the FV function in excel to calculate this answer Just type FV in any cell ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!