2. Present Value and Multiple Cash Flows. Investment X offers to pay you $7,000 per year for eight years, whereas investment Y offers to pay you $9,000 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 22 percent?
5.     Calculating Annuity Cash Flows If you put up $28,000 today in exchange for 8.25 percent, 15-year annuity, what will the annual cash flow be?
6. Calculating Annuity Values Your company will generate $65,000 in annual
revenue each year for the next eight years from a new information database. If the
appropriate interest rate is 8.5 percent, what is the present value of the savings?

7. Calculating Annuity Values If you deposit $3,000 at the end of each of the next
20 years into an account paying 10.5 percent interest, how much money will you
have in the account in 20 years? How much will you have if you make deposits for
40 years?

8. Calculating Annuity Values You want to have $80,0(X) in your savings account
10 years from now, and you're prepared to make equal annual deposits into the
account at the end of each year. If the account pays 6.5 percent interest, what
amount must you deposit each year?

9. Calculating Annuity Values Dinero Bank offers you a $30,000, seven-year term
loan at 8 percent annual interest. What will your annual loan payment he?

16. Calculating Future Values What is the future value of $1,400 in 20 years assuming
an interest rate of 9.6 percent compounded semiannually?

17. Calculating Future Values Corpstein Credit Bank is offering 8.4 percent compounded
daily on its savings accounts. If you deposit $6,000 today, how much will
you have in the account in 5 years? In 10 years? In 20 years?

20. Calculating Loan Payments You want to buy a new sports coupe for $61.800,
and the finance office at the dealership has quoted you a 7.4 percent APR loan for
60 months to buy the car. What will your monthly payments be? What is the effective
annual rate on this loan?

24. Calculating Annuity Future Values You are planning to make monthly deposits
of $250 into a retirement account that pays 10 percent interest compounded
monthly. If your first deposit will be made one month from now, how large will
your retirement account be in 30 years?

26. Calculating Annuity Present Values Beginning three months from now, you
want to be able to withdraw $1,500 each quarter from your bank account to cover
college expenses over the next four years. If the account pays .75 percent interest
per quarter, how much do you need to have in your bank account today to meet
your expense needs over the next four years?

36. Comparing Cash Flow Streams You've just joined the investment banking firm
of Dewey, Cheatum, and Howe. They've offered you two different salary arrangements.
You can have $90,000 per year for the next two years, or you can have
$65,000 per year for the next two years, along with a $45,000 signing bonus today.
The bonus is paid immediately, and the salary is paid at the end of each year. If the
interest rate is 10 percent compounded monthly, which do you prefer?

40. Calculating the Number of Payments You're prepared to make monthly payments
of $225, beginning at the end of this month, into an account that pays 9 percent
interest compounded monthly. How many payments will you have made when
your account balance reaches $20,000?

44. Calculating Present Values You just won the TVM Lottery. You will receive $1
million today plus another 10 annual payments that increase by $400,000 per year.
Thus, in one year, you receive $1.4 million. In two years you get $1.8 million, and
so on. If the appropriate interest rate is 9 percent, what is the present value of your
winnings?



These are the original questions: I have figured out the answer I just don't know how to do it in excel

thank you

thank you
about how much longer do you think?

Thank you so much ! You are wonderful

I can not find 11,14 and 15

Ok i must have missed that completely I do not have them. Thank you for all of your help!