User Account

All Pages

Expected annual return on your savings before you retire

Assignment Help Financial Management
Reference no: EM131908164

You save $600 every quarter (4 months) and plan to retire in 30 years. You are planning to spend 20 years in retirement.

You currently have an expected return on your savings before retirement of 10% (EAR) and and an expected return on savings during retirement of 15% (APR)

You also hope to be able to spend $5,000 each quarter (4 months) during retirement.

Questions (Using Excel).

1. What is the expected annual return on your savings before you retire (Converted to APR)

2. What is the amount you will have saved in your account at retirement based on the $600 you save ever quarter? (Using Excel FV)

3. What is the amount that you will be able to spend each period once you are retired?

4. How much more (or less) would you need to earn if you chose to retire FIVE years earlier than anticipated? (In APR)

5. Convert that APR to an EAR

6. Since you want to have $5,000 available to spend every quarter once you are retired, how much money will you need to have in your account? (USING PV FUNCTION in Excel)

7. What is the amount you need to save each period before you retire to meet that $5,000 a quarter goal? (USING PMT FUNCTION in Excel)

Reference no: EM131908164

Questions Cloud

What is the project net present value : If the discount rate of 14.6 percent, what is the project's net present value?
What is the value of this firm if you ignore taxes : What is the value of this firm if you ignore taxes?
Explain the rationale for your decision : You are the manager of a factory of the Make-It Company. You have 5,000 parts that must be shipped by Friday at 5:00 p.m.
What will the total finance charge be : How much will your monthly payment be? What will the total finance charge be?
Expected annual return on your savings before you retire : What is the expected annual return on your savings before you retire (Converted to APR)
What is basic earning power ratio : Its total assets at the end of the year was $15,000,000. What is its Basic Earning Power ratio?"
What does business intelligence really mean to a business : In your opinion, what does business intelligence really mean to a business? How do you believe does a database and data warehouse support business intelligence?
Describe the role of the the anterior pituitary hormones : BIO/405 Version 3 - Label the parts of the organ or structure, and describe the structure and its function - Reproductive System Worksheet
Proposal to replace the machine : 1. Should they accept or reject the proposal to replace the machine?

Reviews

Write a Review

Financial Management Questions & Answers

  All future dividends are expected to grow

Johnny Cake Ltd. has 12 million shares of stock outstanding selling at $19 per share and an issue of $60 million in 9 percent annual coupon bonds with a maturity of 16 years, selling at 93.5 percent of par. Assume Johnny Cake’s weighted-average tax r..

  Recently issued bond with the characteristics

Duke Energy has recently issued a bond with the following characteristics: maturity: 20 years, coupon rate: 6% (paid semi-annually), face value: $1000. Your investment advisor has told you that the yield-to-maturity on this bond is 7.5%. What should ..

  What will be the firm operating cycle

Assume that all of LilyMac’s sales are on credit. What will be the firm’s operating cycle?

  Your corporation declares cash dividend

What would be the amount of cash dividend per share if your corporation declares a cash dividend?

  Use the weighted average cost of capital

Calliope Company is considering an investment of $60 million in plant and machinery. The property and machinery will be depreciated to a zero book value based on MACRS. It is in the 3-year property class. The firm has a 4-year planning horizon. Calli..

  Holding foreign stock denominated in foreign currency

While a U.S. investor is holding a foreign stock denominated in a foreign currency, will that investor have a higher return if the U.S. dollar (A) appreciates versus the foreign currency, or (B) depreciates versus the foreign currency? Pick A or B an..

  Calculate the next expected dividend per share

Cost of Equity Radon Homes's current EPS is $6.16. It was $4.07 5 years ago. The company pays out 55% of its earnings as dividends, and the stock sells for $34. Calculate the historical growth rate in earnings. Calculate the next expected dividend pe..

  Compute the cost of capital for the firm

Compute the cost of capital for the firm for the? following. A bond that has a ?$1,000 par value? (face value) and contract or coupon interest rate of 11.6%

  What is the dollar amount chrysler will pay

What is the dollar amount Chrysler will pay (or recieve) to settle this transaction three months from now?

  What is the expected return for the stock

Stock ABC has a beta of 1.4 and the standard deviation of its returns is 30%. What is the expected return for the stock?

  What equal payments be

Mr. Bill S. Preston Esq. purchased a new house for $160,000. He paid $15,000 down and agreed to pay the rest over the next 10 years in 10 equal end of year payments plus 5 percent compound interest on the unpaid balance. What equal payments be?

  Bondholders can convert their bond into firm common stocks

WAS Inc. issued a convertible bond which bondholders can convert their bond into firm’s common stocks right after the third year. This bond is 15-year, 8 percent coupon bond with $1,000 face value. What would be the price of this convertible bond.

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