What is the nominal growth rate in her investment amount

Assignment Help Finance Basics
Reference no: EM13909670

Jane has a child and wishes to begin saving for college expenses. Child will enter college in 6 years. Assume child will spend 4 years in college, that the real (ie: inflation adjusted) annual cost of a college education will remain at $24,000, that the nominal interest rate is 4.55%, that the expected rate of inflation is 2.0%, and that the first college payment is due at time 6 and the last payment is due at time 9. Jane wants to make 9 annual investments (beginning 1 year from now and ending 9 years from now) such that the savings will cover the cost of college. Her first investment (at 1) will be $A (in real terms) and subsequent investments will grow (in real terms) by 1% per year.

NEED TO SHOW EXCEL FORMULAS:

1) What is the nominal growth rate in her investment amount?

2) What initial nominal investment, A, will be required, at time 1, if Ms. Wells wishes to exactly cover the college expenses? Show your logic.

3) What is the nominal amount of your last investment, in year 9?

4) What is the real amount invested in year 1 and in year 9?

5) Now assume that she wants to pay off the college over 12 years rather than 9 years. When she had less money than needed to pay for college, she needs to take out a loan at an interest rate of 7.10%. Answer (2) and (3) for this scenario.

Reference no: EM13909670

Questions Cloud

Appreciable levels of glucose phosphatase : What is the metabolic significance of the following observations? (1) Only the liver form of pyruvate kinase is inhibited by alanine, and (2) only gluconeogenic tissues contain appreciable levels of glucose-6-phosphatase?
Direct labor and overhead are added evenly : Tamar Co. manufactures a single product in one department. All direct materials are added at the beginning of the manufacturing process.
Good opportunity to expand your day : You have decided that this is a good opportunity to expand your day care business as you have received many inquiries for childcare
Find the probability density of the time between reversals : Find the probability density of the time between reversals. Find the density of the time from one A to B reversal to the next A to B reversal.
What is the nominal growth rate in her investment amount : What initial nominal investment, A, will be required, at time 1, if Ms. Wells wishes to exactly cover the college expenses? Show your logic.
Common models of absorption : What are: the Common Models of Absorption across Membranes and Transport to Target Sites and the Major Modes/Pathways for Biotransformation and Elimination and for the chemical for the following chemicals with giving one example of a Mechanism of ..
Similarities and differences railway labor act and labor .. : Discuss the similarities and differences of the Railway Labor Act and the Labor Management Relations Act.
Identify the government structure : Identify the government structure
Evaluate proposal that jack borrow rather than cash : Verify that the numbers for total interest paid ($4,779.20) and total interest earned ($5,672.56), quoted in the article, and are correct (within rounding).

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the banks cost of preferred stock

Sixth Fourth Bank has an issue of preferred stock with a $6.10 stated dividend that just sold for $123 per share. What is the bank's cost of preferred stock?

  Using the sample financial statements create pro forma

decide upon an initiative you want to implement that would increase sales over the next five years for example market

  Project one will be using the verizon (vz) stock

Project one will be using the Verizon (VZ) Stock

  What was barbell net cash flow

Barbell Corporation's income statment reports that the company's "bottom line" was $180,000 in 2008. The Statement also shows that the company had depreciation and amortization expenses equal to $50,000 and taxes equal to $120,000. What was Barbel..

  Select a company that has gone public in the last few years

select a company that has gone public in the last few years on an organized exchange anywhere in the world.answer the

  Determining capital structure

Mention and describe three issues which a firm should consider when determining its capital structure.

  Which type of risk declines

Beginning with an investment in one company's securities, as we add securities of other companies to our portfolio, which type of risk declines?

  Relationship between variables in loan amortization

What is the relationship between the variables in a loan amortization and the total interest cost?

  What is the minimum cash balance

A firm has an ending cash balance of $1,700 and a cumulative surplus of $1,300. What is the minimum cash balance?

  Cash flow under the new capital structure

Buffet enterprises is planning a change from its current capital structure. Buffet currently has an all equity capital structure and is considering a capital structure with 40 percent debt.

  One-year treasury bills currently earn 345 percent if the

one-year treasury bills currently earn 3.45 percent. you expected that one year from now one-year treasury bill rates

  Time value of money are saving for the college education

Time Value of Money You are saving for the college education of your two children. They are two years apart in age, one will begin college 15 years from today and the other will begin 17 years from today. You estimate your children's college expenses..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd