You are considering a savings plan that calls for a deposit of $12,000 at the end of each of the next five years. If the plan offers an interest rate of 8 percent, how much will you accumulate at the end of year 5?
Do this calculation by completing the following template using Excel. Your spreadsheet will do the FV calculation twice - once using the FV function (in Cell B4) and once using a simple table that shows the accumulation at the beginning of each year that would be similar to what you would show a client that does not understand future value accumulation very well.
A | B | C | D | |
1 | Annual payment | 12,000 | ||
2 | Interest rate | 8% | ||
3 | Number of years | 5 | ||
4 | Total value | ????????? | <--Use FV function | |
5 | ||||
6 | Year | Accumulation at beginning of year | Payment at end of year | Annual interest |
7 | 1 | 0 | 12,000 | 0 |
8 | 2 | 12,000 | 12,000 | |
9 | 3 | |||
10 | 4 | |||
11 | 5 | |||
12 | 6 |
You are considering a savings plan that calls for a deposit of $12,000 at the end...
You are considering a savings plan that calls for a deposit of $12,000 at the beginning of each of the next five years. If the plan offers an interest rate of 8 percent, how much will you accumulate at the end of year 5? Do this calculation by completing the following template using Excel. Your spreadsheet will do the FV calculation twice - once using the FV function (in Cell B4) and once using a simple table that shows the...
You are considering a savings plan that calls for a deposit of $12,000 at the BEGINNING of each of the next five years. If the plan offers an interest rate of 8 percent, how much will you accumulate at the end of year 5? Do this calculation by completing the following template using Excel. Your spreadsheet will do the FV calculation twice - once using the FV function (in Cell B4) and once using a simple table that shows the...
1)You plan to deposit $100 in a savings account at the end of each month for the next 10 years. How much will you have in 10 years, assuming a 2% annual interest rate. 2)You wish to purchase a car that costs $22,000 today. You will put $2,000 down and borrow the remaining $20,000. The interest will be 2.00% and you will make monthly payments (end of month) over 5 years. What will your monthly payment be? I need help...
5. You deposit $12,000 annually into a life insurance fund for the next 30 years, after which time you plan to retire. (LG 15-2) a. If the deposits are made at the beginning of the year and earn an interest rate of 7 percent, what will be the amount of retirement funds at the end of year 30? b. Instead of a lump sum, you wish to receive annuities for the next 20 years (years 31 through 50). What is...
At the end of each year, you plan to deposit $3,100 in a savings account. The account will earn 7% annual interest, which will be added to the fund balance at year-end. The first deposit will be made at the end of Year 1. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) Required: 1. Prepare the required journal entry at the end of Year 1. (If no...
Education Plus financial services is offering education savings plan. The plan calls for you to make sik annual payments of $5,000 each, with the first payment occurring today. your child's 12th birthday. Beginning on your child's 18th birthday, the plan will provide $10,000 per year for four years. What return is this investment offering? a) 4.61% b) 4.97% c) 5.87% d) 6.49% e) 8.83% (
A financial planning service offers a college savings program. The plan calls for you to make six annual payments of $15,500 each, with the first payment occurring today, your child’s 12th birthday. Beginning on your child’s 18th birthday, the plan will provide $28,000 per year for four years. What return is this investment offering?
At the end of each year, you plan to deposit $3,100 in a savings account. The account will earn 7% annual interest, which will be added to the fund balance at year-end. The first deposit will be made at the end of Year 1. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) Required: 1. Prepare the required journal entry at the end of Year 1. (If no...
8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next year. Then you wait two more years (until 4 years from now) and deposit $1,000. If your account always earns 6% annual interest and you make no withdrawals, how much will be in the account 11 years from now? 9-You deposit $5000 for 5 years at 4% annual interest. In 5 years, you add $15,000 to your account, but the rate on your account...
You deposit $12,000 annually into a life insurance fund for the next 30 years, after which time you plan to retire. (LG 15-2) If the deposits are made at the beginning of the year and earn an interest rate of 7 percent, what will be the amount of retirement funds at the end of year 30? Instead of a lump sum, you wish to receive annuities for the next 20 years (years 31 through 50). What is the constant annual...