Your younger sister, Barbara, will start college in five years. She has just informed your parents that she wants to go to Eastern University, which will cost $34,000 per year for four years (assumed to come at the end of each year). Anticipating Barbara's ambitions, your parents started investing $5,400 per year five years ago and will continue to do so for five more years. Use 12 percent as the appropriate interest rate throughout this problem (for discounting or compounding). How much more will your parents have to invest each year for the next five years to have the necessary funds for Barbara's education? (Use a Financial calculator to arrive at the answer. Do not round intermediate calculations. Round the final answer to the nearest whole dollar.) Investment each year

Your younger sister, Barbara, will start college in five years. She has just informed your parents that she wants to go to Eastern University, which will cost $34,000 per year for four years (assumed to come at the end of each year). Anticipating Barbara's ambitions, your parents started investing $5,400 per year five years ago and will continue to do so for five more years. Use 12 percent as the appropriate interest rate throughout this problem (for discounting or compounding). How much more will your parents have to invest each year for the next five years to have the necessary funds for Barbara's education? (Use a Financial calculator to arrive at the answer. Do not round intermediate calculations. Round the final answer to the nearest whole dollar.) Investment each year

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Your younger sister, Linda, will start college in five years. She has just informed your parents that she wants to go to Hampton University, which will cost $45,000 per year for four years (cost assumed to come at the end of each year). Anticipating Linda’s ambitions, your parents started investing $6,500 per year five years ago and will continue to do so for five more years. Use 11 percent as the appropriate interest rate throughout this problem (for discounting or compounding). How much will your parents have to save each year (A?) for the next five years in addition to the $6,500 they are currently saving to have the necessary funds for Linda's education? Use Appendix C and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Your younger sister, Brittany, will start college in five years. She has just informed your parents that she wants to go to Eastern State U., which will cost $30,000 per year for four years (cost assumed to come at the end of each year). Anticipating Brittany’s ambitions, your parents started investing $5,000 per year five years ago and will continue to do so for five more years. How much more will your parents have to invest each year for the next five years to have the necessary funds for Brittany’s education? Use 10 percent as the appropriate interest rate throughout this problem (for discounting or compounding). Round all values to whole numbers.
Your five-year old daughter has just announced that she would like to attend college. Your best guess is that it will cost approximately $25,000 per year for four years in tuition, books, rent, etc. for her to attend State College 12 years from now (first payment beginning on year 13). You believe that you can earn a rate of 9% on investment to meet this goal. a. If you were to invest a lump sum today in hopes of covering your daughter’s college costs, how much would you have to invest? b. If you now decided to invest annually instead, how much would you have to invest every year? (investment every year, years 1-12) c. You just learned of a $10,000 inheritance and plan to invest it in your daughter’s college fund (inheritance is available today at time 0). Given this new source of funds how much do you have to invest every year? d. Create a combo box that will switch provide the user with 5 different inheritance amounts ($8,000, $9,000, $10,000, $11,000 and $12,000)
Your sister will start college in five years. She has just informed your parentsthat she wants to go to a private university that will cost RM18,000.00 per yearfor four years (assumed at the end of each year). Your parents have startedinvesting RM3,000.00 per year since five years ago. How much will yourparents have to invest each year for the next five years to have the necessaryfunds for your sister's education? Use 10% interest rate throughout thisproblem.
Suppose your parents have decided that after your graduation at the end of the year they would start to save money to help pay for your younger sister to attend University to study. They plan to save money for 5 years before she starts college and to save during her university years. They plan to contribute $4,000 per year at the start of each of her 4 university years. Your parents would thus make monthly payments for 8 years; 5 year prior to and 3 during your sister's university education. The monthly interest rate earned on their savings is 0.45%. How much must the monthly savings be under this condition?
A father is now planning a savings program to put his daughter through college. She is 13, plans to enroll at the university in 5 years, and she should graduate 4 years later. Currently, the annual cost (for everything - food, clothing, tuition, books, transportation, and so forth) is $20,000, but these costs are expected to increase by 5% annually. The college requires total payment at the start of the year. She now has $7,000 in a college savings account that pays 7% annually. Her father will make six equal annual deposits into her account; the first deposit today and sixth on the day she starts college. How large must each of the six payments be? Do not round intermediate calculations. Round your answer to the nearest dollar. [Hint: Calculate the cost (inflated at 5%) for each year of college and find the total present value of those costs, discounted at 7%, as of the day she enters college. Then find the compounded value of her initial $7,000 on that same day. The difference…
Sharpy and Jane are saving for the college education of their newborn son, Kasuba. The couple estimate that college expenses will run K30,000 per year when their son reaches college in 18 years. The annual interest rate over the next few decades will be 14 percent.How much money must they deposit in the bank each year so that their son will be completely supported through four years of college? To simplify the calculations, assume that Kasuba is born today. His parents will make the first of his four annual tuition payments on his 18th birthday. They will make equal bank deposits on each of his first 17 birthdays, but no deposit at date 0.