Exercise 1\ Solve the following problems using Excel. Submit your Excel file through Blackboard.\ A complex annuity makes the following payments. For these cash flows, the appropriate discount rate / period is

9%

. What is the present value of this complex\ A complex annuity makes the following payments. For these cash flows, the appropriate discount rate / period is

9%

. What is the period 6 future value of this annuitv? (12.5 Points)\ An annuity pays each period for 10 periods, the appropriate discount rate / period is

8.0%

, and the present value is

$272.16

. What is the payment each period? (10 Points)\ An annuity pays

$160.00

each period for 14 periods, and the present value is

$1399.27

. What is the discount rate / period of this annuity? (10 Points)\ An annuity pays

$50.00

each period, the appropriate discount rate / period is

6.6%

, and the present value is

$357.77

. What is the number of periods? (10 Points)

Solve the following problems using Excel. Submit your Excel file through Blackboard. 1. A complex annuity makes the following payments. For these cash flows, the appropriate discount rate / period is 9%. What is the present value of this complex annuitv? (12.5 Points) 2. A complex annuity makes the following payments. For these cash flows, the appropriate discount rate / period is 9%. What is the period 6 future value of this annuity? (12.5 Points) 3. An annuity pays each period for 10 periods, the appropriate discount rate / period is 8.0%, and the present value is $272.16. What is the payment each period? (10 Points) An annuity pays $160.00 each period for 14 periods, and the present value is $1399.27. What is the discount rate / period of this annuity? (10 Points) An annuity pays $50.00 each period, the appropriate discount rate / period is 6.6%, and the present value is $357.77. What is the number of periods? (10 Points)