Question

Show how to enter into EXCEL

1. You have decided to place $153 in equal deposits every month at the beginning of the month into a savings account earning 4.69 percent per year, compounded monthly for the next 15 years. The first deposit is made today. How much money will be in the account at the end of that time period?
Round the answer to two decimal places

2. What is the present value of the following annuity?
$4,765 every half year at the beginning of the period for the next 9 years, discounted back to the present at 10.98 percent per year, compounded semiannually.
Round the answer to two decimal places

3. You plan to buy a house in 4 years. You want to save money for a down payment on the new house. You are able to place $403 every month at the end of the month into a savings account at an annual rate of 4.03 percent, compounded monthly. How much money will be in the account after you made the last payment?
Round the answer to two decimal places.

4. You are going to save money for your son’s education. You have decided to place $2,329 every half year at the end of the period into a saving account earning 14.66 percent per year, compounded semi-annually for the next 8 years. How much money will be in the account at the end of that time period?
Round the answer to two decimal places.

5. A car dealership offers you no money down on a new car. You may pay for the car for 5 years by equal monthly end-of-the-month payments of $549 each, with the first payment to be made one month from today. If the discount annual rate is 16.41 percent compounded monthly, what is the present value of the car payments?
Round the answer to two decimal places.

6. What is the present value of the following annuity?
$3,151 every quarter year at the end of the quarter for the next 11 years, discounted back to the present at 4.98 percent per year, compounded quarterly?
Round the answer to two decimal places.

Answer 1

Future value at year 15 fv= (1+r) pmt x ((1+r)^n-1))/r $40,009.26 [1.0039*153*(((1.0039^180)-1)/0.0039)]