Calculate the regular income

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.

User Account

All Pages