John and Jessica are saving for their child's education. Their daughter is currently eight years old and will be entering college 10 years from now (t=10). College costs are currently $15,000 a year and are expected to increase at a rate of 5% a year. They expect their daughter to graduate in four years, and that all annual payments will be due at the beginning of each year (t=10, 11, 12, and 13). Right now, John and Jessica have $5,000 in their college savings account. Starting today, they plan to contribute $3,000 a year at the beginning of each of the next five years (t-0, 1, 2, 3, and 4). Then their plan is to make six equal annual contributions at the end of each of the following six years (t=5, 6, 7,8, 9, and 10). Their investment account is expected to have an annual return of 12%. How large of an annual payment do they have to make in the subsequent six years (t=5, 6, 7, 8, 9, and 10) in order to meet their child's anticipated college costs?

John and Jessica are saving for their child's education. Their daughter is currently eight years old and will be entering college 10 years from now (t=10). College costs are currently $15,000 a year and are expected to increase at a rate of 5% a year. They expect their daughter to graduate in four years, and that all annual payments will be due at the beginning of each year (t=10, 11, 12, and 13). Right now, John and Jessica have $5,000 in their college savings account. Starting today, they plan to contribute $3,000 a year at the beginning of each of the next five years (t-0, 1, 2, 3, and 4). Then their plan is to make six equal annual contributions at the end of each of the following six years (t=5, 6, 7,8, 9, and 10). Their investment account is expected to have an annual return of 12%. How large of an annual payment do they have to make in the subsequent six years (t=5, 6, 7, 8, 9, and 10) in order to meet their child's anticipated college costs?

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

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.
Your parents start saving for your sister's college education. She will begin college at age 18 and will need $4,000 per year at the end of each of the next 4 years. They will make a deposit one year from today in an account which pays 6% compounded annually, and an identical deposit each year including the year she starts college. If a deposit of $1,987 will allow them to reach their goal, how old is your sister now?
Nana and Abena Sarfo are saving for the university education of their newborn daughter, Akosua. The Sarfos estimate the university expenses will run GH₵ 30000 per year when their daughter reaches university in 18years. The annual interest rate over the next few decades will be 14%. How much should they deposit in the bank each year so that their daughter will be completely supported four years of university? Assume she enters the university on her 18th birthday.
A parent is now planning a savings program to put a daughter through college. She is 13 and plans to enroll in college in 5 years, and she should graduate 4 years later. Currently, the annual cost for college is $15,000 and is expected to increase 4% each year. The college requires that the costs be paid at the start (hint: beginning) of each year. The child now has $7,500 saved for college in an account and is expected to have a return of 6% annually. The parent will make five equal payments starting today and where the fifth and final payment will be one year before she starts college and will make no more additional payments. How much must each of the payments be to fully fund the college cost? Answer the following questions: 1. What is the expected cost of college in each of the 4 years? 2. How much will need to be in the account before the first payment to fully pay for college? 3. How much will the initial savings grow to before the first payment is…
A parent is now planning a savings program to put a daughter through college. She is 13 and plans to enroll in college in 5 years, and she should graduate 4 years later. Currently, the annual cost for college is $15,000 and is expected to increase 4% each year. The college requires that the costs be paid at the start (hint: beginning) of each year. The child now has $7,500 saved for college in an account and is expected to have a return of 6% annually. The parent will make six equal payments starting today and the sixth on the day she starts college and make no more additional payments. How much must each of the payments be to fully fund the college cost? Tip: Use PMT function at ‘END’ to solve and not ‘BEGINNING’. Think about what the ‘END’ parameter is doing to grow the cash flows. Treat ‘today’ as if the decision to make the investment in the college was 12 months ago and that ‘today’ is the first payment. Answer the following questions: 1. What is the…
The Smiths are planning ahead for their daughter’s education. She’s 8 now and will start college in 10 years. How much will they need to set aside each year to have $65,000 in 10 years if the annual interest rate is 7%?
John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (at t= 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Ellen should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, John and Daphne have accumulated $14,000 in their college savings account (at t= 0). Their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Ellen's anticipated college costs? a. $3,326.86 b. $2,970.41 C.…
James and Tanisha are saving for their daughter Nalah's college education. Nalah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $16,000 a year, but they are expected to increase at a rate of 3.5% a year. Nalah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, James and Tanisha have accumulated $14,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $6,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Nalah's anticipated college costs? O a. $3,501.99 O O b.…
You are saving for the college education of your two children. They are two years apart in age; one will begin college 15 years from today and the other will begin 17 years from today. You estimate your children’s college expenses to be $40,000 per year per child, payable at the beginning of each school year. The appropriate interest rate is 7 percent. Your deposits begin one year from today. You will make your last deposit when your oldest child enters college. Assume four years of college for each child. How much money must you deposit in an account each year to fund your children’s education?
Elijah and Laila are saving for their daughter Tanisha's college education. Tanisha just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,500 a year, but they are expected to increase at a rate of 4.0% a year. Tanisha should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11).So far, Elijah and Laila have accumulated $17,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $6,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 7%. How large must the annual payments at t = 5, 6, and 7 be to cover Tanisha's anticipated college costs?
Michael and Ava want to know how much it will cost to put their daughter Lily through college. She will begin college in 13 years. Assume college costs $12,000 per year today. Lily will attend college for 4 years. College costs increase 4.0% each year. How much money do Michael and Ava need to have on hand on the day Lily BEGINS college, in order to fund her entire college degree? (Assume the money will earn 6% annual interest while it is in her college savings account). Lily will spend the entire amount available during her college years. Each year of college she will withdraw more than the prior year (the amount will increase by the college cost inflation rate). (amortize the balance in her account to zero at the end of the 4 college years...base calculations on a growing annuity withdrawal schedule). (amortize the balance in her account to zero at the end of the 4 college years). O $73,292.32 O $69,235.87 O $48,000.00 O $79,923.53
1. Joe and Sarah Fabozzi are saving for the college education of their newborn daughter (born today), Beth. The Fabozzi's estimate that college expenses will run $55,000 per year when their daughter reaches college in 18 years. In other words, the first withdrawal will be made on Beth's 18th Birthday, and the last payment will be made on Beth's 17th Birthday. The expected interest rate while saving and in college is 10%. The first deposit will be made one year from today. Calculate the annual payment the Fabozzi's must make to the account so their daughter will be supported through four years of college. (Round to 2 decimals) 2. George Anders has just been offered a job at $75,000 per year, with the first payment made one year from today. He anticipates his salary will grow by 4% per year until his retirement in 30 years. Given an interest rate of 10%, calculate the present value of his lifetime salary. (Round to 2 decimals)