🏷️ LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION →
Log in
Accounting
1
answer
0
watching
1,220
views


A father is now planning a savings program to put his daughterthrough college. she is 13 and she plans to enroll at theuniversity in 5 years, and she should graduate in 4 years.Currently the annual cost for everything (food, clothing tuition,books, transportation ,and so forth) is $15,000, but these costsare expected to increase by 5% annually. the college requires thatthis amount be paid at the start of the year. she now has $7,500 ina college savings account that pays 6% annually. her father willmake 6 equal annual deposits into her account, the first deposittoday and the 6th deposit on the day she starts college. How largemust each of the 6 payments be? [Hint: calculate the cost (inflated5%) for each year of college and find the total present value ofthose costs, discounted at 6%, as of the day she enters college.Then find the compounded value of her initial $7,500 on that sameday. The difference between the present value costs and the amountthat would be in the savings account must be made up by the fathersdeposits so find the 6 equal payments (starting immediately)thatwill compound to the required amount]

Watch
1
answer
0
watching
1,220
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Collen Von
Collen VonLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

Mary has been working for a university for almost 25 years andis now approaching retirement. She wants to address severalfinancial issues before her retirement and has asked you to helpher resolve the situations below. Her assignment to you is toprovide a 4-5 page report, addressing each of the following issuesseparately. You are to show all your calculations and provide adetailed explanation for each issue. Issue A: For the last 19years, Mary has been depositing $500 in her savings account , whichhas earned 5% per year, compounded annually and is expected tocontinue paying that amount. Mary will make one more $500 depositone year from today. If Mary closes the account right after shemakes the last deposit, how much will this account be worth at thattime? Issue B: Mary has been working at the university for 25years, with an excellent record of service. As a result, the boardwants to reward her with a bonus to her retirement package. Theyare offering her $75,000 a year for 20 years, starting one yearfrom her retirement date and each year for 19 years after thatdate. Mary would prefer a one-time payment the day after sheretires. What would this amount be if the appropriate interest rateis 7%? Issue C: Mary’s replacement is unexpectedly hired away byanother school, and Mary is asked to stay in her position foranother three years. The board assumes the bonus should stay thesame, but Mary knows the present value of her bonus will change.What would be the present value of her deferred annuity? Issue D:Mary wants to help pay for her granddaughter Beth’s education. Shehas decided to pay for half of the tuition costs at StateUniversity, which are now $11,000 per year. Tuition is expected toincrease at a rate of 7% per year into the foreseeable future. Bethjust had her 12th birthday. Beth plans to start college on her 18thbirthday and finish in four years. Mary will make a deposit todayand continue making deposits each year until Beth starts college.The account will earn 4% interest, compounded annually. How muchmust Mary’s deposits be each year in order to pay half of Beth’stuition at the beginning of each school each year?

________1. Randy Hill wants to retire in 10 years with $500,000.He can earn 6% per year on his investments. Compute how much heneeds to deposit each year to reach his goal. ________2. Joe Morriswants to start a savings fund from which his grandson couldwithdraw $3,000 a year for 10 years. The fund would earn 5%interest. Compute the amount Joe would have to deposit now to reachhis goal. ________3. Your rich aunt has offered to finance fiveyears of college for you. The annual cost will be $30,000 and theinterest rate is 5%. Compute how much money your aunt must give younow to finance the five years of college. ________4. Assume yourfather is 55 and wants to retire at age 65 with $300,000 in aretirement fund. The interest rate is 8%. Compute how much he mustdeposit at age 55 to accumulate the $300,000. ________ 5. Assumeyou want to have $25,000 for a down payment for a house in fiveyears. Compute the amount you would need to deposit today. Yourmoney will earn 5 percent. ________ 6. Jeff Renfro is planning togo to graduate school (Ph.D) in a program of study that will takesix years. Jeff wants to have $35,000 available each year forvarious school and living expenses. He can earn 5 percent on hismoney. Compute how much he must deposit at the start of his studiesto be able to withdraw $35,000 a year for six years. ________7.Angie Baden deposits $10,000 a year into her retirement account.These funds will earn 8 percent over the 10 years until herretirement. Compute what the value of her retirement account willbe when she retires. ________8. Assume you borrow $80,000 with a 7percent interest rate, to be repaid in seven equal yearly payments.Compute the amount of each payment.

Personal Financial Planning Mini-Case

Jeff and Mary Douglas, a couple in their mid-30s, have twochildren - Paul age 6 and Marcy age 7. The Douglas' do not havesubstantial assets and have not yet reached their peak earningyears. Jeff is a general manager of a jewelry manufacturer inProvidence, RI while Mary teaches at the local elementary school inthe town of Tiverton, RI. The family needs both incomes to meettheir normal living expenses and to meet unforeseen emergencypurchases. Their cash flow situation is tight and they have haddifficulty growing a "nest egg" through savings and investing.

Jeff and Mary have discussed the needs of their two children whoare typical, healthy, and active kids. They have discussed tryingto have Mary stay at home, be with the kids more and run thehousehold but her income is very much needed and she also wants acareer and doesn't want to put her teaching job on hold to be astay-at-home mother. Jeff also wants (and needs) to work and hisjob often requires long days - beyond the 9-5 grind.

Now that both children are in school there is no day care needand Mary's job schedule actually matches nicely with the children'sschedule so she not only wants to continue to work but is thinkingabout completing a graduate degree. Currently, Mary is able to takemost of the summer off from teaching (when the children are home onvacation) and so she enjoys a great deal of flexibility in thesummer and spends quite a bit of time with the children in thesummer.

Jeff is the breadwinner of the family but Mary's contribution isalso very significant. Jeff earns about 65% of the total householdincome with Mary earning the remainder. By completing a graduatedegree, Mary could increase her salary by at least 20% but shewould need to commit to a continuing education program at eitherProvidence College or URI.

Although their net worth is not substantial, they have bigdreams and aspirations. Their personal financial objectives includegoals that if achieved would provide a better life for theirchildren than both Jeff and Mary had growing up in working classfamilies in the Fall River and New Bedford areas. They want to helptheir children go to good colleges and Jeff and Mary want to haveassets that allow them (Jeff and Mary) live a comfortableretirement. Both are in excellent health and have family historiesof long life expectancies. Their retirements (at age 65 or so)could be a period of 20 or more years.

They own their home which has an assessed value of $200,000 anda market value of about $300,000 (as determined by a real estateappraiser based on recent sales of comparable homes in similarneighborhoods.) The mortgage on the home has a balance of $140,000.A review of the Douglas' financial information, bank statements,and other documents shows the following as of 6/1/18:

- 2011 Camry worth about $11,000, with a bank loan balance of$3,000

- 2012 Volvo S60 worth about $15,000, with a bank loan balanceof $10,000

- An insurance policy on Jeff's life with a face value of$100,000 and no cash surrender value. Mary is the beneficiarylisted on Jeff's policy.

- An insurance policy on Mary's life with a face value of$10,000 and no cash surrender value. Jeff is the beneficiary listedon Mary's policy.

- Credit card balances that total $3,500.

- A savings account with a $1,000 balance.

- Two mutual funds earmarked for the children's collegeeducation. The account for Paul has a balance of $10,000 andMarcy's has $11,000 as a current balance. The fund has averaged an8% annual rate of return over its life.

- 100 shares of Apple Inc. (NASDAQ: stock symbol = AAPL),formerly Apple Computer, Inc. You need to value this stock based onthe 1/2/18 price per share. You will need to find that on theInternet.

- 200 Shares of AT&T.

- 150 shares of Twitter.

- A checking account with a balance of $3,000.

- Jeff estimates that their furniture, fixtures etc. in the homeare worth about $7,000.

- Jeff and Mary have retirement accounts that have a currentmarket value of approximately $200,000.

- Mary still has an education loan with an outstanding balanceof $15,000. It still has seven years left on it.

- A vacation loan of $750 due in 6 months and a home improvementloan of $2,000 due in 2 years (unsecured - not a home equityloan.)

- Jeff wants to finish the basement and he has discussed this atlength with Mary. He is getting estimates from contractors based onideas that both he and Mary have to create a play area for thechildren and a TV/den for the family. Jeff and Mary love to playping pong and pool and would love to introduce the children to both"sports." He believes that the project will cost about $30,000 andhe is interested in tapping into the home equity.

- Jeff is also an avid baseball fan and is looking at buying amembership to a local baseball/softball facility for both Paul andMarcy. He figures that since he doesn't have any expensive hobbies,it would be fun to get Paul started as a baseball player and Marcyas a softball player. The membership costs and related costs are asfollows: $1,500 per year (covers both kids), equipment $500 peryear, and team registration and travel costs will be about another$1,000 to $2,000 a year depending on how serious the kids become.Mary is not sure that this is a priority at this point and wants toexplore this possibility in more detail.

General instructions: Please read through the questions below,compile your own answers and responses. I need to have you submityour solution (answers to the questions below) by attaching fileswithin the Assignment tab in myCourses (not CONNECT!).PLEASE DO NOT EMAIL ME YOUR SOLUTION AS IT MAY GET LOST INTHE HUNDREDS OF EMAILS I RECEIVE EACH WEEK. IT MAKES THINGS MUCHEASIER IF YOU SUBMIT VIA MYCOURSES. ALSO YOUR GRADE FOR THIS CASEWILL ALSO BE REPORTED IN MYCOURSES.

1. What is the family's net worth? Please attach support forthis with either an Excel or MS Word document to the PersonalFinance Case assignment tab in myCourses. Your Excel or MS Wordfile should clearly reveal the Balance Sheet for the DouglasFamily. Please produce it in good form - emulating what you see forexamples in the book. The balance sheet "as of date" should be6/1/18

2. What is the current ratio? (Use the formula from thebook)

3. What is the debt ratio?

4. Any comments about the family’s investment portfolio? Pleasekeep in mind that their investment portfolio currently consists ofcommon stocks. Their home is not considered part of theirinvestment portfolio. Strengths or weaknesses?

5. If the family's monthly living expenses are about $6,000,what is their liquidity ratio?

6. Jeff Douglas believes strongly that they should help fullyfund the equivalent of a state university education (4 years) forPaul and Marcy. Both sets of grandparents have volunteered to makea lump sum donation (50/50 spilt) to the mutual funds today. Inother words, these generous grandparents have stated that they arewilling to pool their funds and make a substantial deposit tosupport an education fund.

Assuming that today's cost of that type of college education is$25,000 per year and that it will inflate by 4% per year, how muchmust the grandparents donate to the mutual funds to fully fundthese investments (to meet Jeff's goal)? (Assume that Paul andMarcy will start college in 12 and 11 years respectively. You willneed to determine the present value of the future college costs. Ihave put a worksheet at the end of this document that you mightfind helpful. If you are an Excel user, you can set this up withinan Excel worksheet. Here are some steps to follow:

A. First by growing the cost of education by 4% per year (12years into the future for Paul and 11 years for Marcy) and thencalculating the present value of those future cash flows. Keep inmind that Paul will be going to school for 4 years and so too willMarcy. So you will need to figure the future value of the cost ofeducation for the first year, second year, third year, and fourthyear - each year 4% more costly than the year before!

B. Calculate the present value of the future costs of educationusing the investment yield prediction (8% - see below and notice inthe data above that the investment fund has averaged 8% peryear).

C. Once you have the present value of the future costs - you cansubtract the current balance in these accounts to derive the"donation" that the grandparents will need to make.) Assume thatthe investment will grow at 8% per year as a result of investmentyields. How much (in total) must the grandparents invest today toestablish the education fund for Paul and Marcy?

NOTE: There is more on how to approach solving requirement 6 atthe end of this document.

7. Calculate the percentage of net worth represented by the homeand the next two largest assets. Take into account any loansattributed to those assets so that you show the following - theasset’s net value/Total family net worth. Count both cars as oneasset (Automobiles).

This is called the “dominant” asset – other words, if a familyis “car rich” then that would mean a significant percentage oftheir wealth (as defined by net worth) would be from the value ofits cars. The cars would be the dominant asset. If the family’s networth is mostly from their retirement accounts, then we could saythat a significant amount of their wealth is from pensions.

8. Jeff is considering applying for a home equity loan tofinance the basement project. What is the maximum home equity loanthe Douglas' could possibly get based only on equity (and ignoringcash flow considerations)? Assume that a bank is willing to loan upto 80% of the value of the home (between the mortgage and the homeequity loan).

9. Home equity loans have many advantages. For example, the homeequity loan may be the source of funds to help Jeff and Mary finishtheir basement. The interest on the loan will be tax deductible.The arrangement that Jeff and Mary are looking at will involve a15-year payback period and would allow for them to draw down on anyunused funds in a credit line arrangement.

Please describe two disadvantages of a home equity loan andrecommend an amount that Jeff and Mary should request for theirline of credit.

10. In your textbook chapter on Life Insurance,read about "Determining Your Life Insurance Needs." Please use thefollowing methods: Easy Method (assume Jeff makes $70,000 per yearand Mary makes about $40,000), DINK method (even though they dohave two kids still use DINK to come up with an estimated amountand assume that funeral expenses will be $10,000 for Jeff and$10,000 for Mary.) and the "Family Need" method. Also, when usingthe DINK method, assume that "other debts" are 100% of the balancesfor the vacation, home improvement, and education loans.

For the Family Need method, use the samecalculations as shown the book example. Assume that living expensesare 70% of their income (you need this to estimate an emergencyfund). Be conservative and estimate an emergency fund of 6 monthsof living expenses. Keep in mind that when using the "Family Need"method, you have to run the analysis twice (see the bookexample) - once based on the what-if assumption that Jeffdies now and once based on the what-if assumption that Mary diesnow. Assume that the retirement account on the balance sheet is 90%Jeff's funds and 10% Mary's. Ignore social security death benefits.Also, the assumption should be that the Mutual Fund investmentshould not be considered as a liquid asset because it is earmarkedfor the children's education.

What do you recommend for death benefit amounts for each person(Jeff and Mary)? Please write a paragraph or two mentioning theamount of life insurance each needs and why you chose the amountyou did.

11. Pretend you are a personal financial planning professionalattempting to devise a comprehensive personal financial plan forJeff and Mary. What other areas of Jeff and Mary's personalfinancial situation should be examined? Please mention at least 2other concepts that they should take a careful look at. Pleasewrite a few paragraphs that answer this question. Feel free to poseadditional questions that you would like to ask Jeff and Mary as away of making sure you, as a financial planner, understand theirsituation.

_________________________________________________________________

Requirement 6 of the Douglas Personal Financial PlanningCase

These steps and the worksheet below might help you solverequirement 6. I find it easier to set this type of thing up withinan Excel worksheet and I like to utilize the FV and PV functions ofExcel. However, you can also do this with the time value of moneytables within the text or with a financial calculator. It’s up toyou. In any event, please show your work - how you derived yourfinal answer.

1. First step involves growing the cost of education by 4% peryear (12 years into the future for Paul and 11 years for Marcy) andthen finding the present value of those future costs by assuming an8% annual return. So here's what you need to do. Set upa table like these for both kids:

(GO TO NEXT PAGE)

Paul's projections

Years (end of year)

Future Value of Education Cost (4%)

Present value of Education Costs (using 8% as the discountrate)

12

$40,026

$15,894.80

13

$41,627

$$15,306.10

14

$43,292

$14,739.21

15

$45,024

$14,193.31

Total

$60,133.42

Marcy's projections

Years (end of year)

Future Value of Education Cost (4%)

Present value of Education Costs (using 8% as the discountrate)

11

12

13

14

Total

$

Once you have the present value of the future costs - you cansubtract the current balance in the current education accounts toderive the "donation" that the grandparents will need to make.) Howmuch (in total) must the grandparents invest today to establish theeducation fund for Paul and Marcy? Use the following formula:

Total present value of the education costs less the $21,000 inthe current education accounts = the donation that the grandparentswill make.

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in