Suppose that a young couple has just had their firstbaby and they wish to ensure that enough money willbe available to pay for their child's college education.Currently, college tuition, books, fees, and other costsaverage $ 12 comma 700$12,700 per year. On average,tuition and other costs have historically increased at arate of 44% per year. Assuming that college costscontinue to increase an average of 44% per year andthat all her college savings are invested in an accountpaying 77% interest, then the amount of money shewill need to have available at age 18 to pay for all fouryears of her undergraduate education is closest to:PLEASE SOLVE IN EXCEL AND SHOW THE WORK

Step 1: The question has been solved in writing. You can put it into Excel format. (My Excel is not…

Answered: Suppose that a young couple has just…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Gabe and Sarah would like to begin saving for their children's college education. They would like to know the amount of college funds that would be necessary on day one of college to pay for all tuition costs for each child. The current tuition at the university is $25,000. The couple is comfortable assuming an annual rate of return of 6% on their college investment savings program. They anticipate that each child will begin college at age 18 and attend for four years. The Consumer Price Index (CPI) is expected to be 3% and the expected college inflation rate is 5% per year.
You are saving for the university education of your two children. They are two years apart in age; one will begin university 15 years from today and the other will begin 17 years from today. You estimate your children's university expenses to be $45,000 per year per child, payable at the beginning of each school year. The annual interest rate is 7.5 percent. Your deposits begin one year from today. You will make your last deposit when your older child enters university. Assume four years of university. How much money must you deposit in an account each year to fund your children's education? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) Annual savings $
Your daughter needs to be able to draw $50,000 a year from her college savings fund (you started from birth) to pay for college expenses to obtain a medical degree (assume she spends 4 years for bachelor, 4 years for med school, then additional 2 years as resident and yearly spending will be consistent from year to year). At start of her college career, she intends to invest her savings in government securities that should return 5.5% a year compuounded continuously. a. Obtain the equation for dP/dt and then find the genearl solution of P(t) with, as yet undetermined, initial value P_0. b. How large must your daughter's initial college savings be so that she can continue drawing her $50,000 income until she becomes a doctor?
Rodriguez: Attempt 1 to have $120,000 in 15 years for their children's college education. How much should be paid. semiannually into an account paying 6.8% compounded semiannually? Problem: A newborn child receives a one time $20,000 gift toward college from her grandparents. How much will the $20,000 be worth in 17 years if it is invested at 7% compounded quarterly? Problem: If you buy a computer directly from the manufacturer for $2,500 and agree to repay it in 48 equal installments at 1.25% interest per month on the Q Search ly 1. A F 2. A=P 3. A- PA
← A newborn child receives a $8,000 gift toward a college education from her grandparents. How much will the $8,000 be worth in 19 years if it is invested at 5.9% compounded quarterly? It will be worth $ (Round to the nearest cent.)
A wealthy graduate of a local university wants to establish a scholarship to cover the full cost of one student each year in perpetuity at her university. To adequately prepare for the administration of the scholarship, the university will begin awarding it starting in three years. The estimated full cost of one student this year is $32,000 and is expected to stay constant in real terms in the future. If the scholarship is invested to earn an annual real return of 10 percent, how much must the donor contribute today to fully fund the scholarship? Note: Negative value should be indicated by a parenthesis. > Answer is complete but not entirely correct. $(240,421) X Contribution
A wealthy graduate of a local university wants to establish a scholarship to cover the full cost of one student each year in perpetuity at her university. To adequately prepare for the administration of the scholarship, the university will begin awarding it starting in three years. The estimated full cost of one student this year is $38,000 and is expected to stay constant in real terms in the future. If the scholarship is invested to earn an annual real return of 5 percent, how much must the donor contribute today to fully fund the scholarship?
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 $15,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 $9,000 in a college savings account that pays 8% 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? (Hint: Calculate the cost (inflated at 6%) for each year of college and find the total present value of those costs, discounted at 8%, as of the day she enters college. Then find the compounded value of her initial $9,000 on that same day. The difference between the PV of costs and the amount that would be in the savings account must be…
The Jeffersons have asked you what would be needed to fund the children’s future college costs. Assume each child will begin college at age 18 and graduate in four years. Assume current costs are $24,000 per year and are expected to increase by 5% per year and investments earn 7%. A. Assuming no existing assets are dedicated to college, what is the annual savings amount required to fund the children’s education? The Jeffersons’ goal is to have an amount at the beginning of the freshman year for each child that is sufficient to fund a serial payment covering the $24,000 of current costs of college adjusted for inflation for each of the four years of college. Please include your calculator keystroke inputs [PV, I/YR, N, FV, and PMT (if needed)] for each step of this calculation. Also include whether any PMTs are in the end mode or the begin mode. B. What would you say to the Jeffersons about their education funding situation? Write a script of a single paragraph as if you…
Suppose that you need $30,000 for your last year of college. You could go to a private lending institution and apply for a signature student loan; rates range from 7% to 14%. However, your Aunt Sally is willing to loan you the money from her retirement savings, with no repayment until after graduation. All she asks is that in the meantime you pay her each month the amount of interest that she would otherwise get on her savings (since she needs that to live on), which is 4%.What is your monthly payment to her, and how much interest will you pay her over the year (9 months)?(Fill in the blanks below and give your answers as whole numbers.)The amount of interest per month you would pay Aunt Sally is $__(1)__ .The total interest you will pay her over the year (9 months)is $__(2)__ .
You calculate that you will need $75,000 in ten years to be able to pay for your daughter's college education. If you invest $20,000 today, what rate of return will you need to achieve this goal? Select one: A. Between 12% and 13% B. Between 13% and 14% C. Between 14% and 15% D. Between 15% and 16%
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS