Consider the present value calculation of a financial asset whose cash flows are given below. Use Goal Seek to find the discount rate such that the present value of the asset’s cash flows is $800.

Transcribed Image Text:

1234 A 1 Discount rate B 12.00% C Year Cash flow 1 100 5 2 200 6 3 300 7 4 400 8 5 500 9 10 Present value $1,000.18