ZZZ Corp will receive pay $1,000 today. It will receive $500 in one year, $500 in two years, and $400 in three years. The discount rate is 4% Make a table where you can enter the year, the interest rate, and the future cash flows. Write an Excel formula to calculate the present value of the cash flows: 4 CBA Corp will receive $500 a year, every year, forever. The discount rate is 10% Make a table where you can enter the interest rate and the future cash flow. Write an Excel formula to calculate the present value of the cash flows: (Use the formula for the present value of a perpetuity.) 5 BCA Corp will receive a payment every year forever. It will receive $500 one year from now. Each year, the payment will grow by 2%. The discount rate is 10% Make a table where you can enter the interest rate and the future cash flow. Write an Excel formula to calculate the present value of the cash flows: (Use the Gordon growth model.) 6 ZZZ Corp will receive pay $1,000 today. It will receive $500 in one year, $500 in two years, and $400 in three years. The discount rate is 4% Make a table where you can enter the year, the interest rate, and the future cash flows. Write an Excel formula to calculate the present value of the cash flows: 4 CBA Corp will receive $500 a year, every year, forever. The discount rate is 10% Make a table where you can enter the interest rate and the future cash flow. Write an Excel formula to calculate the present value of the cash flows: (Use the formula for the present value of a perpetuity.) 5 BCA Corp will receive a payment every year forever. It will receive $500 one year from now. Each year, the payment will grow by 2%. The discount rate is 10% Make a table where you can enter the interest rate and the future cash flow. Write an Excel formula to calculate the present value of the cash flows: (Use the Gordon growth model.) 6