solve through excel

Visit us 8. You own an oil pipeline that will generate a $2 million cash retum 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