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

  A clothing manufacturer produced a t-shirt emblazoned

For this task, write a paper in which you evaluate and analyze the following three cases: Case 1: A clothing manufacturer produced a T-shirt emblazoned with a ferocious red and blue eagle beneath the words "American Made." However, a small lab..

  An individual consists of 30000 invested in a stock with a

an individual has 30000 invested in a stock with a beta of 0.7 and another 45000 invested in a stock with a beta of

  Question on computing ytm and ytc

Delta Industries has just issued callable ten-year, 8% coupon bonds with semi-annual coupon payments. What is an investor's Yield to Maturity? What is an investor's Yield to Call?

  What is the markets expectation of the yield

One year Treasury securities yield 5 percent. Three year Treasury securities yield 5.2 percent. Assume the pure expectations theory holds. What is the market's expectation of the yield on two year Treasury securities one year from today?

  Various types of merger arbritrage

Describe the mechanics of various types of merger arbitrage, I.e., Cash Deals, Stock Mergers, and complex merger transactions (cash, and various types of stock exchanges).

  Analyzing methods of businesses which manage working capital

Analyze methods in which businesses manage working capital. Find out the single greatest challenge to small businesses and how those challenges may be addressed.

  What is the amount of the operating cash flow

Le Place has sales of $439,000, depreciation of $32,000, and net working capital of $56,000. The firm has a tax rate of 34% and a profit margin of 6%. The firm has no interest expense. What is the amount of the operating cash flow?

  Parent inc is contemplating a tender offer to acquire 80 of

parent inc. is contemplating a tender offer to acquire 80 of subsidiary corporations common stock. subsidiarys shares

  What percentage of the firm capital funding should be debt

The Color Box uses a combination of common stock, preferred stock, and debt financing. The company wants preferred stock to represent 8 percent of the total financing.

  What is most likely total of long-term debt equity capital

If the firm follows a maturity matching (or moderate) working capital financing policy, what is the most likely total of long-term debt plus equity capital? Please show your calculations.

  What is the npv of this project

Suppose that to raise the funds for the initial investment, the project is sold to investors as an all-equity firm. The equity holders will receive the cash flows of the project in one year. How much money can be raised in this way—that is, what is t..

  Unbiased expectations hypothesis

The Wall Street Journal reports that the rate on two year Treasury securities is 2.10% and the rate on four year Treasury securities is 3.05%.

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