Calculate stream of expenses possible with assumed income

Assignment Help Financial Management
Reference no: EM131070637

Please indicate what formulas were used to figure these calcuations.

Make the following assumption about a person and put calculations in a spreadsheet.

• Age is 40, retirement in 25 years.

• Salary is 100,000; growth rate per year is 4%.

• Interest rate is 10% (savings grow at 10%).

• A constant living standard is desired. • Inflation (CPI rate) is 3%.

• Estimated years of retirement is 20.

• To maintain standard of living during retirement, one requires 80% of non-retirement expenditure.

Instructions:

1. Calculate the stream of expenses possible with the assumed income (Hint: the PV of salary MUST EQUAL the PV of all expenses).

2. Develop a spreadsheet with clearly labeled material that is formatted to be printable on 1 page (clearly indicate the stream of salary, expenses during working life and expenses during retirement).

Please submit the spreadsheet for this scenario

Reference no: EM131070637

Questions Cloud

Call option-stock with an exercise price : A call option on Jupiter Motors stock with an exercise price of $100 and one-year expiration is selling at $6. A put option on Jupiter stock with an exercise price of $100 and one-year expiration is selling at $4.5. If the risk-free rate is 8% and Ju..
Calculate the total profit per share at expiration : IBM stock price/share Exercise prices May Call premium May Put premium. It is 35 days to expiration on the options, and the interest is 4% per annual continuously compounding for all maturities. Use continuous compounding throughout. Draw the total p..
The project using the discounting approach method : Slow Ride Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 29,100 1 11,300 2 14,000 3 15,900 4 13,000 5 – 9,500 The company uses an interest rate of 8 percent on all of its projects. Calculate the MIRR of the project u..
Design risky portfolio based on two stocks : An investor can design a risky portfolio based on two stocks, A and B. The standard deviation of return on stock A is 24% while the standard deviation on stock B is 14%. The correlation coefficient between the return on A and B is 0.35. The expected ..
Calculate stream of expenses possible with assumed income : Please indicate what formulas were used to figure these calcuations. Make the following assumption about a person and put calculations in a spreadsheet. Calculate the stream of expenses possible with the assumed income. Develop a spreadsheet with cle..
Considering the purchase of one of two machines : You are considering the purchase of one of two machines used in your manufacturing plant. Machine A has a life of two years, costs $170 initially, and then $85 per year in maintenance costs. The discount rate is 12 percent and the tax rate is zero. C..
Economic state return probability : A portfolio manager has made an investment that will generate returns that are subject to the state of the economy during the year. Use the following information to calculate the standard deviation of the return distribution for the portfolio. Econom..
Calculate the standard deviation of return distribution : A portfolio manager has made an investment that will generate returns that are subject to the state of the economy during the year. Use the following information to calculate the standard deviation of the return distribution for the portfolio. What i..
What will the cash flows for this project be : KADS, Inc., has spent $460,000 on research to develop a new computer game. The firm is planning to spend $260,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated; What will the ..

Reviews

Write a Review

 

Financial Management Questions & Answers

  Deal provides credit enhancement for debt deals series

The GECAS deal provides credit enhancement for the debt deal's Series B Term Loan tranche by

  Estimate the present value of tax benefits from depreciation

Your company is considering a new project that will require $855,000 of new equipment at the start of the project. The equipment will have a depreciable life of 9 years and will be depreciated to a book value of $144,000 using straight-line depreciat..

  Included as short term financing

Which of the following would NOT be included as a short -term financing?

  The incremental cost of borrowing the additional funds

John purchased a house for $300,000 and seeks an loan. His lender presents two options; 80% LTV at 4% or 90% LTV a 5%. Both loans are paid monthly and have a 30 year terms. What is the incremental cost of borrowing the additional funds? How would you..

  Division of assets during divorce planning

Which of the following is not a relevant factor in a division of assets during divorce planning

  Statistics for a households annual cash flow

Consider the following statistics for a household's annual cash flow: Net Cash Flow ($3,400) ; Nondiscretionary Expenses ($32,750); Discretionary Expenses ($9,250); Retirement Investments ($13,500) and Debt Repayment ($4750). Calculate the Gross Savi..

  Growing rapidly and has strong prospects

The company you cofounded last year is growing rapidly and has strong prospects for an IPO in the next year or two. The additional capital that an IPO could raise would let you hire the brightest people in the industry and continue to innovate with n..

  What is the projects expected NPV in thousands of dollars

Drilling Experts, Inc. (DEI) finds and develops oil properties and then sells the successful ones to major oil refining companies. DEI is now considering a new potential field, and its geologists have developed the following data, in thousands of dol..

  Foreign direct investment

Consider this statement below and write a brief essay telling if it is true and then why or why not: “In the most emerging/developing countries (including China) over the past 30 years, foreign direct investment (FDI) came overwhelmingly in the form ..

  Preferred stock outstanding-coupon bonds outstanding

You are given the following information for Watson Power Co. Assume the company’s tax rate is 38 percent. Debt: 10,000 6.5 percent coupon bonds outstanding, $1,000 par value, 30 years to maturity, selling for 108 percent of par; the bonds make semian..

  Organizational vision-operating plans and actual operations

Describe the difference between organizational vision, core competencies, Organizational Strategies, Operating Plans and Actual Operations rations

  What is the operating cash flow at this level of output

A project has a contribution margin per unit of $9.64, fixed costs of $98,000, depreciation of $14,500, variable costs per unit of $21.07, and a financial break-even point of 13,039 units. What is the operating cash flow at this level of output?

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