User Account

All Pages

How much they will need to have the day

Assignment Help Accounting Basics
Reference no: EM133027679

Question - Create an Excel worksheet to calculate how much someone needs to save each year from now until retirement. Assume that anyone using your worksheet will live on a fixed income during retirement.

For the initial scenario, assume your current age, $1,000 current savings, a retirement age of 62, a life expectancy of 90 years, an inflation rate of 2.5%, an investment portfolio return of 8% and current purchasing power of income of $85,000. Set up your worksheet to compute and show the user:

(a) How much they will need to have the day they retire in order to fund their retirement with no additional contributions,

(b) How much they will need to invest in the fund each year until retirement to reach that goal.

Reference no: EM133027679

Questions Cloud

Calculate the bond expected rate of return : Mar's Corporation bonds with par of $1,000 mature in 15 years and pays 6.5% coupon interest. Calculate the bond expected rate of return
Calculate future value of your mother investment : Your mother will continue to save RM400.00 per month organize by Family and Women welfare ministry. Calculate future value of your mother investment
What is amount of goodwill arising from hanson acquisition : Marvin's goodwill suffered an impairment loss of $5,000 during 2019. What is the amount of goodwill arising from Hanson's January 1, 2019 acquisition
Find the amount which is invested : The CD chosen returns 6% per annum, and the bond 7 %. Find the amount, which is invested, in the CD and in the long-term bond
How much they will need to have the day : How much they will need to have the day they retire in order to fund their retirement with no additional contributions
What is the monthly mortgage payment : What is the monthly mortgage payment on the new house, assuming they have the $80,000 down payment? Will they qualify for the new mortgage loan
What is the firm wacc : The bonds have a 10-year maturity and a coupon rate of 10% paid semi-annually. The firm's corporate tax rate is 30%. What is the firm's WACC
Calculate equity value and firm value : SAM basic shares outstanding used in calculations (provide exact number of shares) - provide the excel file used to calculate Equity Value and Firm Value
What is the market yield you would expect : What is the market yield you would expect on a 3-year, BB-rated corporate bond that pays a 7.5% annual coupon

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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