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
|
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 ..
|