A couple wants to set up a college fund for their child. The fund will give the child $1,000 per month for 48 months. The first withdrawal will occur when the child turns 18 years old. Assume that the college fund will earn j12=6%. a) How much money will need to be in the account on the child's 18th birthday in order to sustain the withdrawals? b) How much money should be set aside to establish the fund on the child's first pirthday?
Q: A man wants to set up a 529 college savings account for his granddaughter. How much would he need to…
A: The equivalent annual cost is the periodic payment made towards the acquisition of an asset or…
Q: Mr. Wise is creating a college investment fund for his daughter. He will put in P850 per year for…
A: To open the "FV function" window - MS-Excel --> Formulas --> Financials --> FV.
Q: Soon-to-be proud parents of a new born baby are planning to establish a scholarship fund for their…
A: To calculate the lump sum amount we need to calculate the present value of all the future cash flows…
Q: Parents have set up a sinking fund to have $180000 in 15 years for their child's education. How much…
A: Given information: Sinking fund (FV) = $180,000 Period (NPER) = 15 years Interest rate (rate) =5.2%…
Q: Grandparents plan to open an account on their grandchild's birthday and contribute each month until…
A: Annuity is type of financial instrument (insurance contract) in which you pay certain amount…
Q: A couple plans to invest money for their child's college education. What principal must be deposited…
A: Present Value = Future Value / [ 1 + Peroidic Interest rate ]Number of periods
Q: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…
A: Determine the present value of the annual withdrawals after 5 year of deposit using the Excel PV…
Q: New parents wish to save for their newborn's education and wish to have $40,000 should the parents…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Laura is saving for the college education of hertwochildren. They are two years apart in age; one…
A: As a first step let’s plot the cash flows on a time diagram.Please see the white board. In the table…
Q: . How much should you deposit monthly to accumulate $85,000 in 15 years?
A: Future Value of Annuity: It represents the future worth of current annuity payments made…
Q: A metallurgical engineer decides to set aside money for his newborn daughter's college education. He…
A: Let’s assume the engineer deposits X for one year for 14 years:
Q: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…
A: The question is related to the annuity due. The details are given. The present value of annuity due…
Q: You intend to create a college fund for your baby. If you can get an APR of 3.0% and want the fund…
A:
Q: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…
A: The present value or discounting value method is an important part of the time value of money. It…
Q: Nana and Abena Sarfo are saving for the university education of their newborn daughter, Akosua. The…
A: Annual university expenses (E) = GH₵ 30000 Expense period (p) = 4 years Interest rate (r) = 0.14…
Q: A young couple is planning for the education of their two children. They plan to invest the same…
A: Annuities are insurance contracts that promise to pay you regular income either immediately or in…
Q: Suppose that a young couple has just had their first baby and they wish to ensure that enough money…
A: There is need of proper planning for the future requirements and if you make proper planning on time…
Q: A couple wants to begin saving money for their daughter's education. $16,000 will be needed on the…
A: The present value of the annuity is the current worth of a series of cash flows at a certain rate of…
Q: Suppose that a young couple has just had their first baby and they wish to insure that enough money…
A:
Q: Suppose that you want to create a "college fund" for your newborn child and place $300 in a bank…
A: Answer - Future Value Formula - = P [ (1+i)n - 1] / I Given, P = 300 i = 0.07 n = 20 years…
Q: Revere College predicts that in 6 years it will take $150,000 to attend the college for four years.…
A: Given information: Future value is $150,000 APR is 7% Number of years is 6
Q: Grandparents plan to open an account on their grandchild's birthday and contribute each month until…
A: Future value required (FV) = $ 200,000 Interest rate = 5% Monthly interest rate (r) = 5%/12 =…
Q: is thinking of establishing a fund for his daughter’s college education. He wants his daughter to be…
A: There is need of planning for savings for the education of the children so that they can study…
Q: A young engineer wants to provide his newly born daughter a lump sum of P 2.0M when she graduates…
A: Future value required (FV) = P 2,000,000 Period = 21 Years Number of monthly payments (N) = 21*12 =…
Q: Heather needs to invest to help with her child's college fund. How much would she have to invest to…
A: Money’s value declines with the time. Discounting is a way which is used to get the PV of future…
Q: Revere College predicts that in 18 years it will take $200,000 to attend the college for four years.…
A: Present Value = Future value / (1+rate)^n Where, Future Value = $200000 n = 18*12 = 216 r= 9%…
Q: A couple with a newborn son wants to save for their child's college expenses in advance. The couple…
A: Given Information: Amount required for college fund = $50,000 Annual Interest rate = 8% Duration of…
Q: How much money should a grandparent deposit in a college savings fund today for their newborn…
A: Future value refers to the value that an amount would assume at a future time period after…
Q: Mr. and Mrs. Megabucks would like to set up a college fund for their grandson. They want him to be…
A: Given: N = 24, FV = 0, PMT = 1750, rate = 2.4%/12 = 0.2
Q: A couple plans to save for their child's college education. What principal must be deposited by the…
A: Present Value Present value is the present worth of any sum of a money to be received in the future…
Q: Millet wants to provide a 200,000 graduation gift for her daughter mae is now 16 years old. She…
A: We'll use compound interest formula to determine the amount of deposit (principal amount): A=P1+rnnt…
Q: on. How much should be deposited?
A: Present Value of Annuity: It represents the present worth of the future value of the annuity and is…
Q: A mother is thinking about funding her daughter’s medical education in 6 years when she is expected…
A: A concept through which it is studied that the current worth of money is higher than its future…
Q: As a savings program toward their child’s college education, parents decide to deposit 100 dollars…
A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…
Q: how much do they need to invest at the end of each 6-month period for the next 18 years to begin…
A: The present value of an annuity: A=R[(1-(1+i)-n)i] A=35,000[(1-(1+0.03)-16)0.03] A = 439,639
Q: Ann and Tom want to establish a fund for their grandson's college education. What lump sum must they…
A: To calculate the deposit amount we will use the present value formula as follows: Deposit amount =…
Q: A father has saved money in a fund to finance his son's 4-year university program. The fund pays out…
A: Quarterly Compounded Rate = 8% Number of compounding periods = 4 Withdrawals or Payouts: 300…
Q: Holly wants to have $200,000 to send a recently born child to college. She sets up a 529 plan and…
A: Using excel PMT function
Q: A couple plans to save for their child’s college education. What principal must be deposited by the…
A: Savings refers to money put aside for some specific work or for emergency needs. Saving is used to…
Q: What lump sum do parents need to deposit in an account earning 10%, compounded monthly, so that it…
A: The present value of a future amount can be calculated by using this equation Present value =Future…
Q: A man needs to set up a 529 colleges saving account for his granddaughter. How much will he need to…
A: using the PMT function in excel
Q: A couple wishes to establish a college fund at a bank for their five-year-old child. The college…
A: In an approach, here we need to convert any of the cash flow elements in dollars into an actual…
Q: Mr. Blochirt is creating a college investment fund for his daughter. He will put in $7,000 per year…
A: In this question we need to compute the amount of money Mr. Blochirt daughter have when she starts…
Q: Arnett College predicts that in 18 years it will take $350,000 to attend the college for four…
A: Amount =P 1 +R100N Where P = Principal amount r = Rate of Interest n = Number of Years / Months
Q: Arnett College predicts that in 18 years it will take $350,000 to attend the college for four…
A: An annual percentage rate (APR) is the interest rate to be paid each year on a loan, credit card, or…
Q: A family want to have a $241,000.00 higher education fund for their children at the end of 22 years.…
A: The calculation is:
Q: How much money will be in the account when the child turns 18?
A: Time value of money(TVM) means that the money received in the present days will have more value…
Step by step
Solved in 3 steps with 2 images
- A couple wants to begin saving money for their daughter's education. $16,000 will be needed on the child’s 18th birthday, $18,000 on the 19th birthday, $20,000 on the 20th birthday, and $22,000 on the 21st birthday. Assume 5% interest with annual compounding. The couple is considering two methods of accumulating the money. a. How much money would have to be deposited into the account on the child's first birthday to accumulate enough money to cover the education expenses? (Note: A child’s “first birthday” is celebrated 1 year after the child is born.) b. What uniform annual amount would the couple have to deposit each year on the child’s first through seventeenth birthdays to accumulate enough money to cover the education expenses?1) Suppose that you want to create a "college fund" for your newborn child and place $300 in a bank account at the end of each of the next 20 years. If that account earns an annual rate of return of 7%, how much will be in that account at the end of the twentieth year? A) $13,420.00 B) $12,977.53 C) $13,178.20 D) $11,828.32 E) $12,298.65A couple with a newborn son wants to save for their child's college expenses in advance. The couple can establish a college fund that pays 8% annual interest. Assuming that the child enters college at age 18, the parents estimate that an amount of $50,000 per year will be required to support the child's college expenses for four years. Determine the equal annual amounts that the couple must save until they send their child to college. (Assume that the first deposit will be made on the child's first birthday and the last deposit on the child's 18th birthday. The first withdraw will be made at the beginning of the freshman year, which also is the child's 18th birthday.) O $4,775.80 O $6,016.13 O $6,138.52 O $4,609.37
- Grandparents plan to open an account on their grandchild's birthday and contribute each month until she goes to college. How much must they contribute at the beginning of each month in an investment that pays 7%, compounded monthly, if they want the balance to be $200,000 at the end of 18 years? (a) State whether the problem relates to an ordinary annuity or an annuity due. ordinary annuity annuity due (b) Solve the problem. (Round your answer to the nearest cent.)A couple wishes to establish a college fund at a bank for their five-year-old child. The college fund will earn an 8% interest compounded quarterly. Assuming that the child enters college at age 18, the couple estimates that an amount of $30,000 per year. in terms of today's dollars (dollars at child's age of five), will be required to support the child's college expenses for four years. College expenses are estimated to increase at an annual rate of 6%. Determine the equal quarterly deposits the couple must make until they send their child to college. Assume that the first deposit will be made at the end of the first quarter and that deposits will continue until the child reaches age 17. The child will enter college at age 18, and the annual college expense will be paid at the beginning of each college year. In other words, the first withdrawal will be made when the child is 18.Grandparents plan to open an account on their grandchild's birthday and contribute each month until she goes to college. How much must they contribute at the beginning of each month in an investment that pays 7%, compounded monthly, if they want the balance to be $170,000 at the end of 18 years? (a) State whether the problem relates to an ordinary annuity or an annuity due. (b) Solve the problem. (Round your answer to the nearest cent.)
- A new mother would like to start a college fund for her newborn daughter. She makes quarterly deposits of $400 into a college fund that earns 6% compounded quarterly for the next 18 years. How much will her daughter have available in her college fund when she turns 18? $ Round to the nearest dollar What is total amount the mother deposited into the fund over the 18 years? $ Round to the nearest dollar How much interest was earned over the 18 years? $ Use the WHOLE DOLLAR AMOUNTS you entered in as your answers above. 4 Round to the nearest dollarSuppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 4% per year. The parents deposit $ 10,000 on their daughter's first birthday and plan to increase the size of their deposits by 2% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then the amount available for the daughter's college expenses on her 18th birthday is closest to: $1,012,908 $ 147,489 $500,000 $298,785You are planning on having your first child next month and your parents have told you that they are going to open an account with $3,000 on the day your child is born. The money is to be used for college. You plan to also put $1,500 of your own money into the same account on the day your child is born, and then another $1,500 into the account each year on your child's birthday, through his/her 18th birthday. If the account averages an 8% annual return, what will the account balance be on your child's 18th birthday? Please use appropriate excel formula and show how you arrived at your answer.
- Suppose that a young couple has just had their first baby and they wish to ensure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 7%. The parents deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits by 5% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then what is the amount available for the daughter's college expenses on her 18th birthday?Mr. J. J. Parker is creating a college fund for his daughter. He plans to make 15 yearly payments of $1500 each with the first payment deposited today on his daughter’s first birthday. Assuming his daughter will need four equal withdrawals from this account to pay for her education beginning when she is 18 (i.e. 18, 19, 20, 21), how much will she have on a yearly basis for her college career? J. J. expects to earn a hefty 12% annual return on his investment. (show work)A man needs to set up a 529 colleges saving account for his granddaughter. How much will he need to deposit each year in order to have 80000 saved up for when she goes to college in 17 years, assuming the account earns 6% return.