Solution-Find the amount that spend first year of retirement

Find the amount that spend first year of retirement

Assignment Help Finance Basics

Reference no: EM133109944

Use the following information regarding your retirement planning:

You plan to work (and save) for 35 years, then retire (and spend money from your retirement account) for 15 years. After these 50 years, you would like your retirement saving account balance to have $275,000. You currently have $30,000 in your retirement account.
You plan to save $2,900 in year 1, and you will increase this amount by 2.5% a year
You want your retirement spending to increase by 1.5% per year
You expect to earn a rate of return of 5% during your working years and 4% during retirement
Cash flows occur at the end of each year

To solve this problem, find the amount that you spend your first year of retirement.

Could you please help me using excel?

Reference no: EM133109944

Questions Cloud

Determine the size of the equal payments : 1. What will be the PV if I deposit $ 600 at the end of each quarter for the next 20 years if the interest rate 5% compounded semi-annually?

What are the firm capital structure weights : What are the firm's capital structure weights (i.e., the proportions of financing that came from debt (WD) and equity (WE) assuming the firm uses only debt and

Set up the lock box system : Smith Corp. is establishing a lock-box system to reduce its float. The firm anticipates saving 2 days of mail time and 0.50 days of processing time through the

Exchange rates between japanese yen against eur : Suppose you are an investor based in Japan. You have invested in the common stocks of publicly listed firms in several countries. You plan to liquidate your hol

Find the amount that spend first year of retirement : You plan to work (and save) for 35 years, then retire (and spend money from your retirement account) for 15 years. After these 50 years, you would like your re

Elements of observable culture : Using an organization with which you are familiar, identify its corporate culture and the elements of its observable culture.

Calculate daily returns-volatility and annualized volatility : Download daily adjusted close prices for TESLA between 12/10/2020 and 12/09/2021. (TICKER:TSLA).

What is the amount due on the note : Valley Spa purchased $11,100 in plumbing components from Tubman Co. Valley Spa Studios signed a 120-day, What is the amount due on the note

What is the expected appreciation of malaysian ringgit : What is the expected appreciation of Malaysian Ringgit against dollar based on international fishers effect if nominal and real interest rates in US are 4.81% a

User Account

All Pages

Find the amount that spend first year of retirement

Reference no: EM133109944

Reference no: EM133109944

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT