1. Annuities Use Excel to construct your own set of annuity tables showing the annuity factor for a selection of interest rates and years.
2. Declining perpetuities and annuities You own an oil pipeline that will generate a $2 million cash return over the coming year. The pipeline’s operating costs are negligible, and it is expected to last for a very long time. Unfortunately, the volume of oil shipped is declining, and cash flows are expected to decline by 4% per year. The discount rate is 10%.
a. What is the PV of the pipeline’s cash flows if its cash flows are assumed to last forever?
b. What is the PV of the cash flows if the pipeline is scrapped after 20 years?