How much would your parents have to deposit each month into an account that grows at a rate of 12% per year, compounded semiannually, if they want to have $80,000 at the end of year 3 to cover part of your college expenses? Assume no interperiod compounding. Also, write the spreadsheet function to display the monthly amount.
What will be an ideal response?
First find equivalent amount per 6-months and then divide by 6 to get monthly deposit
A per semiannual period = 80,000(A/F,6%,6)
= 80,000(0.14336)
= $11,468.80
Monthly deposit = 11,468.80/6
= $1911.47
Spreadsheet function: = PMT(6%,6,,80000)/6 displays -$1911.50
You might also like to view...
Most commercial water closet installations use ____________________ valve fixtures.
Fill in the blank(s) with the appropriate word(s).
NEC Article 240 covers which of the following?
a. Wiring selection b. Listing and labeling c. Overcurrent protection d. Spliced conductors
What is the purpose of the company's vision statement??
What will be an ideal response?
What is the minimum dc working voltage rating for a capacitor that must drop 120 VRMS?
A) 170 V B) 339 V C) 84.8 V D) 120 V