Question: What inputs do I need to put for the =PV( function on excel to get the Present Value of each of the years? Am trying

 What inputs do I need to put for the =PV( function
What inputs do I need to put for the =PV( function on excel to get the Present Value of each of the years?
Am trying to figure out the equation that needs to be inputted in excel.
Here are what each of the years should equate to:

Year 1: $6,711,409.40

Year 2: $8,273,207.04

Year 3: $9,694,820.22

Year 4: $10,140,141.43

Year 5: $10,532,265.79

Year 6: $10,874,822.70

$ 5 Annuity of Cash Flows 6 Years for Annuity 7 Year of First Annuity PM 8 Year 1 Cash Flow 9 Year 2 Cash Flow 10 Year 3 Cash Flow 11 Year 4 Cash Flow 12 Year 5 Cash Flow 13 Year 6 Cash Flow 14 Interest Rate 15 Bond Y Value 16 Bond Y Maturity 17 Bond Y Duration 18 19 Duration of Liability 20 1 21 2 22 3 23 4 24 5 6 26 $ 15,000,000.00 30 7 $ 7,000,000.00 $ 9,000,000.00 $ 11,000,000.00 $ 12,000,000.00 $ 13,000,000.00 $ 14,000,000.00 4.30% $ 125,000,000.00 10.5 7.3 PV PV(t) $ $ $ $ $ $ 7,000,000.00 9,000,000.00 11,000,000.00 12,000,000.00 13,000,000.00 14,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0 25 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!