Please correct answer and don't use hand raiting A father is now planning a savings program to put his daughter through college. She is 13,plans to enroll at the university in 5 years, and she should graduate 4 years later. Currently,the annual cost (for everything - food, clothing, tuition, books, transportation, and so forth)is $20,000, but these costs are expected to increase by 7% annually. The college requirestotal payment at the start of the year. She now has $7,000 in a college savings account thatpays 8% annually. Her father will make six equal annual deposits into her account; the firstdeposit today and sixth on the day she starts college. How large must each of the sixpayments be? (Hint: Calculate the cost (inflated at 7%) for each year of college and find thetotal present value of those costs, discounted at 8%, as of the day she enters college. Thenfind the compounded value of her initial $7,000 on that same day. The difference betweenthe PV of costs and the amount that would be in the savings account must be made up bythe father's deposits, so find the six equal payments that will compound to the requiredamount.) Do not round intermediate calculations. Round your answer to the nearest dollar.$

To solve this problem, we need to calculate the future cost of college, the present value of those…

Answered: A father is now planning a savings…

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

A father is now planning a savings program to put his daughter through college. She is 13, plans to enroll at the university in 5 years, and she should graduate 4 years later. Currently, the annual cost (for everything - food, clothing, tuition, books, transportation, and so forth) is $18,000, but these costs are expected to increase by 6% annually. The college requires total payment at the start of the year. She now has $7,000 in a college savings account that pays 9% annually. Her father will make six equal annual deposits into her account; the first deposit today and sixth on the day she starts college. How large must each of the six payments be? Do not round intermediate calculations. Round your answer to the nearest dollar. (Hint: Calculate the cost (inflated at 6%) for each year of college and find the total present value of those costs, discounted at 9%, as of the day she enters college. Then find the compounded value of her initial $7,000 on that same day. The difference…
A father is now planning a savings program to put hisdaughter through college. She is 13, plans to enroll at the university in 5 years, and shouldgraduate 4 years later. Currently, the annual cost (for everything—food, clothing, tuition,books, transportation, and so forth) is $12,000, but these costs are expected to increase by6% annually. The college requires total payment at the start of the year. She now has $10,000in a college savings account that pays 9% annually. Her father will make six equal annualdeposits into her account; the first deposit today and the sixth on the day she starts college.How large must each of the six payments be? (Hint: Calculate the cost (inflated at 6%) foreach year of college and find the total present value of those costs, discounted at 9%, as ofthe day she enters college. Then find the compounded value of her initial $10,000 on thatsame day. The difference between the PV of costs and the amount that would be in the savingsaccount must be made up by the…
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
2. A father is planning a savings program to put his daughter through university. His daughter is now 13 year old. She plans to enroll at the university in 5 years, and it should take her 4 years to complete her education. Currently, the cost per year (for everything – her food, clothing, tuition, books, transportation, and so forth) is GH¢ 12,000 per year. This cost is expected to remain constant throughout the four-year university education. The daughter recently received GH¢ 7,500 from her grandfathers, estate; this money will be invested at a rate of 8% to help meet the costs of the daughter's education. The rest of the costs will be met by money the father will deposit in a savings account which also earns 8 percent compound interest per year. He will make 5 equal deposits into the account, one deposit per annum starting one year from now until his daughter starts university. These deposits will begin one year from now. (Assume that school fees are paid at the beginning of the…
A couple is saving for their newborn daughter’s college education. She will need $25,000 per year for a four-year college program, which she will start when she is 18. What uniform deposits starting 2 years from now and continuing through year 17 are needed, if the account earns interest at 4%?
Your five-year old daughter has just announced that she would like to attend college. Your best guess is that it will cost approximately $25,000 per year for four years in tuition, books, rent, etc. for her to attend State College 12 years from now (first payment beginning on year 13). You believe that you can earn a rate of 9% on investment to meet this goal. a. If you were to invest a lump sum today in hopes of covering your daughter’s college costs, how much would you have to invest? b. If you now decided to invest annually instead, how much would you have to invest every year? (investment every year, years 1-12) c. You just learned of a $10,000 inheritance and plan to invest it in your daughter’s college fund (inheritance is available today at time 0). Given this new source of funds how much do you have to invest every year? d. Create a combo box that will switch provide the user with 5 different inheritance amounts ($8,000, $9,000, $10,000, $11,000 and $12,000)
a client plans to send a child to college for four years starting 18 years from now. having set aside money for tuition, she decides to plan for room and board also. She estimates these costs at $20,000 per year, payable at the beginning of each year, by the time her child goes to college. If she starts next year and makes 17 payments into a savings account paying 5 percent annually, what annual payments must she make?
A client's child will be attending college in 5 years. Assume current tuition and fees are $46, 142, and inflation for college costs averages 6.7 percent, and Anna can earn 3.4 percent on the money she invests for this purpose. The client wants to know how much she will need to set aside today to pay four years of tuition and fees.
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. Currently, college tuition, books, fees, and other costs, average $12,500 per year. On average, tuition and other costs have historically increased at a rate of 4% per year. Assuming that costs continue to increase an average of 4% per year, how much is the tuition and other costs for one year for this student in 18 years when she enters college?
Joann wants to save for her daughter's education. Tuition costs $9,000 per year in today's dollars. Her daughter was born today and will go to school starting at age 18. She will go to school for 4 years. She can earn 12% on her investments and tuition inflation is 6%. How much must she save at the end of each year if she wants to make her last savings payment at the beginning of her daughter's first year of college? $1,889 $2,117 $2,370 $1,700
Your parents have accumulated a $160,000 nest egg. They have been planning to use this money to pay college costs to be incurred by you and your sister, Courtney. However, Courtney has decided to forgo college and start a nall salon. Your parents are giving Courtney $31,000 to help her get started, and they have decided to take year-end vacations costing $11,000 per year for the next fou years. Use 9 percent as the appropriate interest rate throughout this problem. Use Appendix A and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. How much money will your parents have at the end of four years to help you with graduate school, which you will start then? (Roun your final answer to 2 decimal places.) Funds available for graduate school b. You plan to work on a master's and perhaps a PhD. If graduate school costs $29,260 per year, approximately how long will you be able to stay in school based on these funds?…
Revere College predicts that in 6 years it will take $150,000 to attend the college for four years. Emma has a substantial amount of cash and wishes to invest a lump sum of money for her child’s college fund. How much should Emma put aside in an account with an APR of 7% compounded monthly in order to have $150,000 in the account in 6 years? Round your answer to the nearest cent, if necessary.

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Personal Finance

Finance

ISBN:

9781337669214

Author:

GARMAN

Publisher:

Cengage

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS