Question

In: Finance

Your son Tommy was just born today (Year 0), and you are plannjng for his college...

Your son Tommy was just born today (Year 0), and you are plannjng for his college education. You would like to make equal depostis every 26 weeks into a college savings account starting in Year 1 and ending in Year 21 (41 deposits), so that Tommy can make annual withdrawala in Year 18, 19, 20, and 21 for tuition. Tuition is currently (Year 0) $2500/year, and it is expected to grow at 4%/year for each of the next 10 years, and then at 5%/year for all years after. You can earn a nominal annual rate or 8.45% with interest compounded weekly in a college savings account. How much must eaxh lf the 41 depostions be to exactly fund the expexted tuition expense?

Solutions

Expert Solution

Assume a year has 52 weeks, so the weekly interest rate can be found rom the nominal annual rate of 8.45% as

Follow the excel sheet instructions for the solution

The depositions should be $ 218.739 respectively to exactly fund the tuition expense


Related Solutions

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 and your partner are saving for your son Sam's (who today turned 10) college expenses....
You and your partner are saving for your son Sam's (who today turned 10) college expenses. Sam will enter college eight years from today. Annual tuition and other expenses at UCLA are currently $14,500, but they increase at a rate of 3.5 percent every year. Sam, you hope, will graduate in four years. Naturally, you need to pay tuition (and other fees) at the beginning of each year (at t = 8, 9, 10, and 11). So far, you and...
A son is born with Kleinfelter's syndrome and hemophilia. His father is normal but his mother...
A son is born with Kleinfelter's syndrome and hemophilia. His father is normal but his mother is a carrier of the recessive X-linked, blood-clotting disorder. Which of the following best describes how the boy inherited hemophillia?
A son is born with Kleinfelter's syndrome and hemophilia. His father was normal and his mother...
A son is born with Kleinfelter's syndrome and hemophilia. His father was normal and his mother was a carrier for the recessive X-linked blood clotting disorder. What occurred in meiosis to produce this genetic outcome? a. Nondisjunction in meiosis I of the mother b. Nondisjunction in meiosis II of the father c. Nondisjunction in either meiosis I or meiosis II of the father d. Nondisjunction in meiosis II of the mother e. Nondisjunction in meiosis I of the father
Tommy, a 3-year-old boy with tetralogy of Fallot, has just returned to his hospital room from...
Tommy, a 3-year-old boy with tetralogy of Fallot, has just returned to his hospital room from the cardiac catheterization recovery room. His mother calls you to the bedside to tell you that he is vomiting and bleeding. You arrive to find Tommy anxious, pale, crying, and sitting in a puddle of blood. Questions 1. Evidence—Is there sufficient evidence to draw conclusions about Tommy’s situation? 2. Assumptions—Describe an underlying assumption about each of the following: a. Risks of cardiac catheterization b....
Your son has been accepted into college. This college guarantees that your​ son's tuition will not...
Your son has been accepted into college. This college guarantees that your​ son's tuition will not increase for the four years he attends college. The first $11,000 tuition payment is due in six months. After​ that, the same payment is due every six months until you have made a total of eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 6% (semiannual) guaranteed to remain the...
. Assume that Randall Ezno was born today and to celebrate his birth, his parents deposited...
. Assume that Randall Ezno was born today and to celebrate his birth, his parents deposited $10,000 into an account in his name. The account pays interest of 2.35 percent p.a., with monthly compounding, and it is expected to continue paying this amount forever. Assume that exactly 1.5 years after the deposit was made, Randall’s parents changed their minds and withdrew $10,000 from the account (all that remained in the account was the interest earned in the first 18 months)....
Babu is saving for his son’s college tuition. His son iscurrently 11 years old and...
Babu is saving for his son’s college tuition. His son is currently 11 years old and will begin college in seven years. Babu has an index fund investment worth $7,500 that is earning 9.5 percent annually. Total expenses at the Black Hills State University, where his son says he plans to go, currently total $15,000 per year, but are expected to grow at roughly 6 percent each year. Babu plans to invest in a mutual fund that will earn 11...
A 60 year old alum donates 300000 today (at t-0) to the College for an annual...
A 60 year old alum donates 300000 today (at t-0) to the College for an annual scholarship that will start with the first scholarship payment in t=20, and thereafter, the scholarship amount will grow at a rate of 3% / year to account for inflation. If the College's discount rate is 7%%, how large will the first payment in t=20 be?? I ONLY HAVE THIS INFORMATION Please answer only when you are 100%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT