Question

In: Finance

Assume the total cost of a college education will be $375,000 when your infant child enters...

Assume the total cost of a college education will be $375,000 when your infant child enters college in 17 years. How much you invest at the end of each month in order to accumulate the required $375,000 at the end of 17 years if your monthly investments earn an annual interest rate of 4 percent, compounded monthly?

Solutions

Expert Solution

SOLVED USING EXCEL AND ALSO USING FINANCIAL EQUATION


Related Solutions

11- Assume the total cost of a college education will be $303,000 when your child enters...
11- Assume the total cost of a college education will be $303,000 when your child enters college in 18 years. You presently have $54,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child's college education? (Enter answer on percent with two decimals, i.e. 32.16) 12- You have $24,000 you want to invest for the next 40 years. You are offered an investment plan that will pay you 7 percent...
Calculating Interest Rates. Assume the total cost of a college education will be $345,000 when your...
Calculating Interest Rates. Assume the total cost of a college education will be $345,000 when your child enters college in 18 years. You presently have $73,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education? Calculating the Number of Periods. At 6.1 percent interest, how long does it take to double your money? To quadruple it? Calculating Interest Rates. According to the Census Bureau, in October 2016,...
Your child was just born and you are planning for his/her college education. Based on your...
Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Managerial Economics you decide to send your child to Binghamton University as well. You anticipate the annual tuition to be $60,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday every year starting today, the day of your child’s birth. No deposits will be made after starting college. The first tuition payment...
Your child was just born and you are planning for his/her college education. Based on your...
Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Advanced Finance you decide to send your child to Binghamton University as well. You anticipate the annual tuition to be $50,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday EVERY OTHER YEAR for the ages one through seventeen inclusive to fund his/her education. Assume the first tuition payment is due in...
You want to save money for your newborn niece’s college education. Assume that today’s all-in cost...
You want to save money for your newborn niece’s college education. Assume that today’s all-in cost of attending a prestigious college for four years is $250,000. This number is already discounted back to the beginning of the four years in college, i.e., you need $250,000 in your savings account today to fully fund a college student for the next four years. This all-in cost of college is expected to increase by 5 percent per year forever. You expect your niece...
2. You are currently saving for your child's college education. The current cost of college is...
2. You are currently saving for your child's college education. The current cost of college is $10,000 a year. You expect that college costs will continue to increase at a rate of 5 percent a year. Your child is scheduled to begin attending a four-year college 10 years from now (i.e., college payments will be made at t=10, t=11, t=12, and t=13). You currently have $25,000 in an account which earns 6 percent after taxes. You would like to have...
You are currently saving for your child's college education. The current cost of college is $10,000...
You are currently saving for your child's college education. The current cost of college is $10,000 a year. You expect that college costs will continue to increase at a rate of 5 percent a year. Your child is scheduled to begin attending a four-year college 10 years from now (i.e., college payments will be made at t=10, t=11, t=12, and t=13). You currently have $25,000 in an account which earns 6 percent after taxes. You would like to have all...
preparing for your (future) child (or grandchild)’s college education. 20 years later from now, your (future)...
preparing for your (future) child (or grandchild)’s college education. 20 years later from now, your (future) child will go to college. Currently, you’re considering two colleges for your (future) child (or grandchild). University 1 University 2 Princeton University University of Notre Dame 1.       Please visit the website of each university and find tuition and related information. Use out-of-state tuition information. Make sure that you include accurate information and citation source (20 points). 2.       Using the tuition and related information in (1), you...
You are saving for your child's college education. You plan on making a total of six...
You are saving for your child's college education. You plan on making a total of six tuition payments each one-year apart (college plus a masters program). The annual estimated tuition payment will be made 14-years from today (at t=14), and you estimate that payment will be $50,000. The remaining five-payments will be made from t=15 to t=19. You decide to make 15 yearly contributions into an investment account. The first contribution is made today (t=0) and your last contribution will...
You are saving for your child's college education. You plan on making a total of six...
You are saving for your child's college education. You plan on making a total of six tuition payments each one-year apart (college plus a masters program). The annual estimated tuition payment will be made 14-years from today (at t=14), and you estimate that payment will be $50,000. The remaining five-payments will be made from t=15 to t=19. You decide to make 15 yearly contributions into an investment account. The first contribution is made today (t=0) and your last contribution will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT