A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance. Putting specifics aside, you start to ponder the retirement nest-egg this could help you accumulate over the next 30 years. As a diligent finance student you do some research and find that the money can be invested into an account paying a fixed 4% rate, compounded quarterly. How much retirement money would be in the account after 30 years? (round to nearest dollar)It turns out that the gentleman in Question 5 is really a devious centaur looking to con good people out of their hard earned money. Undeterred, you decide to calculate how much money you would need to put aside at the beginning of each month for the next 30 years in order to have the sum of money determined in Question 5. You estimate conservatively that your money will earn 3% a year, compounded monthly. What will your monthly contribution to the account need to be? Answer in Excel.

Question
Asked Sep 15, 2019
747 views

A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance. Putting specifics aside, you start to ponder the retirement nest-egg this could help you accumulate over the next 30 years. As a diligent finance student you do some research and find that the money can be invested into an account paying a fixed 4% rate, compounded quarterly. How much retirement money would be in the account after 30 years? (round to nearest dollar)

It turns out that the gentleman in Question 5 is really a devious centaur looking to con good people out of their hard earned money. Undeterred, you decide to calculate how much money you would need to put aside at the beginning of each month for the next 30 years in order to have the sum of money determined in Question 5. You estimate conservatively that your money will earn 3% a year, compounded monthly. What will your monthly contribution to the account need to be? Answer in Excel.

check_circle

Expert Answer

Step 1

Inherited amount, PV = $ 1 mn = $ 1,000,000

Interest rate = fixed 4% rate, compounded quarterly

here, a quarter is one period.

Please see the white board. Since you have asked for the solution in excel, i have attached a snapshot of my excel m...

help_outline

Image Transcriptionclose

A 1 Inherited amount, PV 1,000,000 4% Compounded quarterly 0.01B2/4 2 Interest rate 3 interest rate per period 4 number of years 5 Number of period 30 120B4*4 Retirement money 3,300,387 B1*(1+B3)^B5 would be in the account after 30 years 6

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Finance

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: One year ago, Berardi corporation issued a series of 13% semiannual coupon callable bonds with par v...

A: We will use the RATE function inexcel to calculate the yield. Before we do so, please note the follo...

question_answer

Q: Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so t...

A: The answers for Part 1 and Part 2 are as follows:Excel Spreadsheet:

question_answer

Q: What is the yield to maturity for a seven-year bond that pays 11% interest on a $1000 face value sem...

A: Calculation of yield to maturity (YTM): Excel spread sheet:

question_answer

Q: Boulder Furniture has bonds outstanding that mature in 13 years, have a 6 percent coupon, and pay in...

A: Calculation of Yield to Maturity:Excel Spreadsheet:

question_answer

Q: Tater and Pepper Corp. reported free cash flows for 2021 of $53.1 million and investment in operatin...

A: Calculate the earnings before interest and tax (EBIT) as follows:

question_answer

Q: You borrowed $700 at 5% compounded quarterly. Yourpayments are $150 at the end of each year. How man...

A: We will adopt the following approach:It's a typical time value of money case, where we have to find ...

question_answer

Q: The Alenso corporation's target capital stucture is 50% debt and 50% common equity. The cost of comm...

A:  Formula to calculate WACC:

question_answer

Q: b) The Moore Corporation has operating income (EBIT) of $750,000. The company’s depreciation expense...

A: Net income = (EBIT - interest) x (1 - tax rate)EBIT = $ 750,000As compnay is 100% equity finance, th...

question_answer

Q: If $1 million face amount of commercial paper(270 day paper) is sold for $982,500, what is the simpl...

A: Calculating the value of simple rate of interest paid on commercial paper. We have,Face value of com...