Question

In: Accounting

Please show your work and do not use calculators. You need to accumulate $114,480 for your...

Please show your work and do not use calculators.

You need to accumulate $114,480 for your son's education. You have decided to place equal year-end deposits in a savings account for the next 14 years. The savings account pays 6.88 percent per year, compounded annually. How much will each annual payment be?

Please show your work and do not use calculators.

Solutions

Expert Solution

Given

Future value of amount = $114,480

Number of years = 14years

Rate of interest = 6.88%

Let the amount to be deposited is 'A'

Calculation of annual payment to be made every year (amount in $)

future value = A + [A x (1+i) ] + [A x (1+i)2] + [A x (1+i)3] + [A x (1+i)4] + [A x (1+i)5] + [A x (1+i)6] + [A x (1+i)7] + [A x (1+i)8] + [A x (1+i)9] + [A x (1+i)10] + [A x (1+i)11] + [A x (1+i)12] + [A x (1+i)13] $114,480 = A + [A x (1.0688)] + [A x (1.0688)2] + [A x (1.0688)3] + [A x (1.0688)4] + [A x (1.0688)5] + [A x (1.0688)6] + [A x (1.0688)7] + [A x (1.0688)8] + [A x (1.0688)9] + [A x (1.0688)10] + [A x (1.0688)11] + [A x (1.0688)12] + [A x (1.0688)13]

Thee right hand side equation is in geometric progression

Here first term is 'A'

Common ratio is '1.0688'

Therefore sum of the progression is A x [1-(1.0688)14]/[1-1.0688]

$114,480 = A x [1-2.538]/[1-1.0688]

$114,480 = A x [-1.538]/[-0.0688]

$114,480 = A x 22.35

A = $114,480/22.35

A = $5122

Therefore amount to be invested at the end of every year is $5122.


Related Solutions

Please Show your work. 13. If you want to accumulate $250 after 30 years and your...
Please Show your work. 13. If you want to accumulate $250 after 30 years and your bank pays 2%, how much will you have to deposit monthly? 14. If you borrow $250 for 25 years at 6%, what will be your monthly payment? 15. If you can earn 15%, how long will it take for an investment today of $700 to grow to $5000? 16. If you save $100 monthly and your bank promises 15%, how many months will it...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 8 Reflection: The National Center for Education...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 9 Reflection: Annual expenditures for prescription drugs...
( PLEASE SHOW ALL YOUR WORK) You will need your ticker code (company abbreviation) for stock...
( PLEASE SHOW ALL YOUR WORK) You will need your ticker code (company abbreviation) for stock prices for this question. Use your ticker code to obtain the closing prices for the following two time periods to obtain two data sets: March 2, 2019 to March 16, 2019 Data set A February 16, 2019 to February 28, 2019 Data set B Take the closing prices from data set B and add 0.5 to each one of them. Treat data sets A...
Please show all your work if you use the Calculator. If done in Excel, please send...
Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. (Please show all work and do not use excel) 3. Forrest Corporation has 500,000 shares of common stock, 10,000 shares of preferred stock, and 5,000 bonds with 8 percent (coupon) outstanding. The common stock currently sells for $25 per share and has a beta of 0.95. Preferred stocks pay a...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. (Please show all work and do not use excel) 2. At an output level of 2,000 units, you calculate that the degree of operating leverage is 3. Fixed costs are $35,000. (a) If output rises to 2,500 units, calculate the percentage change in OCF, new OCF and new DOL. (b)...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. 3. You are taking out a thirty-year mortgage loan of $470,000 from your bank. The interest rate is 4 percent per year, and the loan calls for equal monthly payments. How much interest is paid in the fourth month? How much total principal is paid after four months? (Draw an...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. Please do not use excel. Thank you! 3. You are taking out a thirty-year mortgage loan of $470,000 from your bank. The interest rate is 4 percent per year, and the loan calls for equal monthly payments. How much interest is paid in the fourth month? How much total principal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT