Calculate the regular income

Assignment Help Finance Basics
Reference no: EM13276182

Suppose you plan to retire one day with $200,000 saved up. You plan to live on this money for twenty years, withdrawing an income at the end of every year to live on. You expect to earn 8% interest on your remaining balance for the entire twenty years. a) Calculate the regular income that you can withdraw for twenty years. [Use the =PMT function in Excel for this (fill out the relevant information in the function screen)] b) Produce a schedule in Excel which shows your year-ending balance for each year from 1 to 20 (it should reach $0 at the end of year 20) and produce a chart in Excel illustrating this balance. . . Will rate you well if you show your work step by step and explain yourself! **Will not rate you if not. Thank You!

Reference no: EM13276182

Questions Cloud

Define benzene vapor pressure : A solution of 75.0 g of benzene (C6H6) and 75.0 g of toluene (C7H8) has a total vapor pressure of 80.9 mmHg at 303 K. Another solution of 100.0 g benzene and 50.0 g toluene has a total vapor pressure of 93.9 mmHg at this temperature.
Find all values of ckt elements lowpass butterworth filter : Determine the transfer function of the second-order (2 poles) lowpass Butterworth filter with a 3-dB cutoff frequency of 5 kHz. Design it using the Sallen-Key lowpass filter configuration, find all the values of the circuit elements
What would be crypton cost of capital : Dividends have grown at the rate of 5.1% per year and are expected to continue to do so for the forseeable future. What is Crypton's cost of capital where the firm's tax rate is 30%.
Define what is the total molar concentration of all the ions : What is the total molar concentration of all the ions in 0.030 M solutions of the following salts in water a) 0.030 M KCl = ________ M ions b) 0.030 M CuSO4 = _____ M ions c) 0.030 M CaCl2 = _______ M ions
Calculate the regular income : You expect to earn 8% interest on your remaining balance for the entire twenty years. a) Calculate the regular income that you can withdraw for twenty years.
Explain the partial pressure of carbon dioxide : The partial pressure of carbon dioxide is 675 mm Hg. If argon gas added to the mixture causes the total pressure to become 2410 torr, what is the partial pressure of argon? Report your answer in atm.
What is the value of the missing cash flow : The present value of the following cash flow stream is $7,300 when discounted at 8 % annually. What is the value of the missing cash flow? Year 1 cash flow $1500 Year 2 cash flow ? Year 3 cash flow $2700 Year 4 Cash flow $2900
Concept you are preparing for mandatory satellite meeting : Analyze three creative processes that could get the agency back on track with on-point client deliverables and for each, briefly explain what the process is and why it fits the stated business problem.
Explain the temperature is changed from 122 c to 28.5c : For 2.25 moles of an ideal gas, Pext=P=200x10^3 Pa. The temperature is changed from 122 C to 28.5C and Cv=3R/2. Calculate the q, w, delta U and delta H for an isochloric process.

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the cost of borrowing the maximum amount of credit

What is the cost of borrowing the maximum amount of credit available to MDM Inc. through the factoring agreement?

  Inflation, investment and costs

Steven & Dawn wanted to know how much it would cost to send their daughter Dawson to a private college. They have saved $20,000 to day for the purpose.

  Fundamental change in economy from consumer savings

Do you think this will have an impact on future consumer spending. With U.S. consumer representing approximately 70% of our GNP - will this fundamentally change our economy when the consumer saves more in future?

  Case study assignment

Case study questions: What would Exacta's true exposure be from its new U.S. operations, and how would it change from the company's current exposure?

  Compute the value of a share

Von Bora Company is expected to pay a $3.00 dividend at the end of this year. If you expect Von Bora Company's dividend to grow by 6 percent per year forever and VBC's equity cost of capital is 12%,

  Computing coefficient of variation

Mr. Sam Golff wants to invest a portion of his assets in rental property. He has narrowed his choices down to two apartment complexes, Palmer Heights and Crenshaw Village.

  Fishhook just went public and is considering a bond issue

FishHook (FH) just went public and is considering a bond issue with warrants attached

  What is cjs company cost of equity

CJ"s stock has a beta pf 0.9 the current risk free rate is 5.6 and the expected return or the market value is 13% . What is CJ's company cost of equity?

  What is the current share price

Gruber Corp. pays a constant $9 dividend on its stock. The company will maintain this dividned for the next 12 years and will then cease paying dividends forever. If the required return on this stock is 10 percent, what is the current share price?

  Construct a pro forma income statement

In year 2, Price per unit increases to $13.50, and unit of sales increases by 4%, all other assumptions remain the same.

  Reported significant earnings increases in nearly every qua

In late 2010, you purchased the common stock of a company that has reported significant earnings increases in nearly every quarter since your purchase.

  What is the npv of the lease

The magic box would cost $3,600 to buy and would be straight-line depreciated to zero salvage value over three years. The firm can borrow at 6%, and the marginal corporate tax rate is 30%. What is the NPV of the lease?

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!

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