Question

In: Accounting

Proud parents wish to establish a college savings fund for their newly born child. Monthly deposits...

Proud parents wish to establish a college savings fund for their newly born child. Monthly deposits will be made into an investment account that provides an annual rate of return of 4% compounded monthly. Four withdrawals from the savings fund will be made to pay for college expenses. The estimated need is $25,000 when the child turns 18 years old; $28,000 at 19 years; $31,000 at 20 years; and $34,000 at age 21. The last monthly payment to the investment account occurs when the child turns 21. This is also the time that the last withdrawal is made. Determine the monthly deposit required to meet this goal.

Add the cash flow digram with the answer

Solutions

Expert Solution

here, First i have calculated cash outflow future value at the end of the year which gave me the cash flow needed at the end of the period

then accordingly i have calculated monthly cash flow


Related Solutions

your wonderful parents established a college savings plan for you when you were born. They deposited...
your wonderful parents established a college savings plan for you when you were born. They deposited $50 into the account on the last day of each month. The account has earned 10% compounded monthly. Now you are off to Monash university. What equal amount can they withdraw beginning today (your 18th birthday) and each year for 4 years to spend on your education, assuming that the account now earns 7% annually?
The parents of a disabled child are setting up a trust fund so that the child...
The parents of a disabled child are setting up a trust fund so that the child will have guaranteed income of $3000 per month when he turns 21 and they want him to be able to draw on this fund for 20 years. They started investing in the fund quarterly when the child was born and wanted to have it funded within 14 years. We'll assume their money is earning 5.5% interest, compounded quarterly both during the accumulation phase and...
1. The parents of a 5-year old child wish to have $250,000 when the child starts...
1. The parents of a 5-year old child wish to have $250,000 when the child starts college at the age of 18. How much should they deposit monthly in an account that pays 4.5% compounded monthly to achieve their goal? 2. A 25-year old saves for retirement by making monthly deposits of $1000 in an account that pays 4.9% compounded monthly. How much would be in the account at retirement age of 65? Please provide answers ASAP. Thanks
A child is born with hemophilia (inherited as an X-linked recessive) and Klinefelter's syndrome to parents...
A child is born with hemophilia (inherited as an X-linked recessive) and Klinefelter's syndrome to parents who both have normal blood clotting. In which parent (mother or father) and during which round of meiosis (I or II) did the nondisjunction event occur? * note that Klinefelter syndrome is 47 chromosomes, so 2n+1 (47,XXY)
A) Assume that you wish to make annual deposits into a savings account. The interest rate...
A) Assume that you wish to make annual deposits into a savings account. The interest rate offered by the bank is 11%, and you plan to save for the next 12 years. If your goal is for the present value of your savings to be equal to $4,058, how much money must you deposit every year? B) Assume you've just received a bonus at work of $3,812. You deposit that money in the bank today, where it will earn interest...
Plot a graph and briefly describe the monthly fixed deposits rate (12 months), savings deposits rates...
Plot a graph and briefly describe the monthly fixed deposits rate (12 months), savings deposits rates and lending rates of commercial banks for the period between Jan 2018-July 2020. You may plot the graph in excel, copy and paste in the word document for your submission. Based on the information in (a), write an essay, approximately 500 word, to suggest three ways of financing the purchase of a house in Malaysia. In suggestion, compute and compare the cost of each...
Juanita Domingo's parents want to establish a college trust for her. They want to make 16...
Juanita Domingo's parents want to establish a college trust for her. They want to make 16 quarterly withdrawals of $2000, with the first withdrawal 3 months from now. If money is worth 6.8%, compounded quarterly, how much must be deposited now to provide for this trust? It is an ordinary annuity.
Nataya makes monthly deposits into Fund A at the beginning of each month for 25 years....
Nataya makes monthly deposits into Fund A at the beginning of each month for 25 years. Her first deposit is $40, and each subsequent deposit increases by $10. Aarif contributes $250,000 once, today, into Fund B. The nominal rate that both of these funds earn is 6% per year. However, Fund A compounds interest monthly and Fund B compounds interest quarterly. What is the difference in the balance between these two funds at the end of 25 years?
Katie is a 7-month-old baby girl, the second child born to her parents. Her mother had...
Katie is a 7-month-old baby girl, the second child born to her parents. Her mother had a healthy, full-term pregnancy, and Nona’s birth weight was normal. She did not respond well to breastfeeding and was changed entirely to a formula based on cow’s milk at 4 weeks. Between 7 and 12 weeks of age, she was admitted to the hospital twice with a history of screaming after feeding, but was discharged after observation without a specific diagnosis. Elimination of cow’s...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT