Planning for your retirement

Assignment Help Financial Management

Reference no: EM131893212

Excel Exercise

You are planning for your retirement. You estimate that you will have $600,000 at the time of your retirement. Your goal is to have a $0 balance at the end of 20 years (at which point you plan on becoming a burden to society and your family). You estimate your expenses at $50,000/Year. You estimate interest on your savings at 5%/year. You estimate inflation at 3%/year. Assume interest and expense payments are made at the beginning of the year.

Objectives:

Determine if $600,000 is sufficient

If not, determine what you will need

Provide all related spreadsheet models

Provide a short recommendation

State any other assumptions you feel you need to make for this exercise

Reference no: EM131893212

Questions Cloud

How much would it be willing to lend business owner : If the bank is charging customers 11.00 percent APR, how much would it be willing to lend the business owner?

Another option for financing is to call in outstanding bonds : Another option for financing is to call in the outstanding bonds you have issued and obtain a loan with more favorable terms than the bonds you would issue.

Mortgage payment stream is usually divided : A mortgage payment stream is usually divided into a principal payment cash- flow and an interest payment cash-flow.

What is cost of equity after recapitalization : What is the WACC? What is the cost of equity after recapitalization?

Planning for your retirement : You are planning for your retirement. You estimate that you will have $600,000 at the time of your retirement.

What is acetate debt-equity ratio : What is Acetate’s debt-equity ratio? What is the cost of capital for an otherwise identical all-equity firm?

Firm has the book-value balance sheet : A firm has the following book-value balance sheet; Debt =$ 14 ,000, Common Stock ($1 par)= 11 and Retained Earnings = $ 23 ,000.

Concept affecting security prices and rates of return : Risk is an important concept affecting security prices and rates of return.

Risk and rates of return-stand-alone risk : What is the stock's expected return? What is the stock's standard deviation? What is the stock's coefficient of variation?

User Account

All Pages