C)Long Dated Growing Annuity. We are going to value the above asset, but now assuming the cash flows will grow 3% a year. Today's cash flow is still $100 You will purchase the asset after today's cash flow is paid. The first cash flovw you will receive is paid in one year; the last cash flow you will receive is paid in 100 years. 1) Excel function. Value the asset using the Excel NPV function. You will need to modify your 100 cash flows from above. 2)Growing annuity formula. Calculate the value of the asset using the growing annuity formula (see end of the quiz for formulas). You answers should be the same as 1-C-1. How does this formula compare to the formula for an annuity? 3)Growing perpetuity formula. Now assume the asset has an infinite life. You will receive the first cash flow in one vear. This cash flow is the same as you calculated above (1-C-1), but now you receive a cash flow every year in perpetuity. Value the asset using the growing perpetuity formula. How much more valuable is the perpetuity than the 100 year asset? How does this formula compare to the formula for an annuity