You want to retire in 35 years to live off your savings. You want to have...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You want to retire in 35 years to live off your savings. You want to have $10,500 per quarter in real dollars (i.e accounts for inflation) to spend for the next 30 years upon retiring. You assume inflation will be about 4.5% per year when you retire and remain at the same value for the next 30 years. If you can earn 8.5% per year on investments before and after retirement, how much will monthly payments be before you retire if you want to achieve this goal upon retirement? inflation Upon Retiring Before Retiring 4.5% nominal APR 8.5% PV PV real rate 4.00% FV FV Frequency 4 IY 4.0% I/Y N 360 420 PMT $10,500.0 PMT Assuming we begin a project, which has the same OCFS and WACC as those in this company. You spend $4,000,000 to begin a project and you increase initial (beginning) net working capital by 50,000. At the end of the project, you will be able to recover 30% of your investment back as the salvage value. What are the NPV, IRR and profitability Index (PI) of this project. What if payback is 1.5 years, what will be your decision? What if discounted payback is 2.5years, what will be your decision? Using If statements, show whether you'll accept or reject the project. Year O values Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Initial Outlay $ 4,000,000 ЕBIT $ 2,950,000 Initial NWC 2$ 50,000 Depreciation $ 235,000 $ 2,950,000 $ 235,000 $ EBIT Тахes* $ 1,032,500 Depreciation OCF Change in NWC Capital spending 105,000 $ 475,000 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Increase per year ЕBIT 15% Depreciation Change in NWC Capital spending WACC 20% 10% 20% 9% Decision Using "If Statement" Tax rate 35% NPV IRR P.I. Payback Discounted Payback You want to retire in 35 years to live off your savings. You want to have $10,500 per quarter in real dollars (i.e accounts for inflation) to spend for the next 30 years upon retiring. You assume inflation will be about 4.5% per year when you retire and remain at the same value for the next 30 years. If you can earn 8.5% per year on investments before and after retirement, how much will monthly payments be before you retire if you want to achieve this goal upon retirement? inflation Upon Retiring Before Retiring 4.5% nominal APR 8.5% PV PV real rate 4.00% FV FV Frequency 4 IY 4.0% I/Y N 360 420 PMT $10,500.0 PMT Assuming we begin a project, which has the same OCFS and WACC as those in this company. You spend $4,000,000 to begin a project and you increase initial (beginning) net working capital by 50,000. At the end of the project, you will be able to recover 30% of your investment back as the salvage value. What are the NPV, IRR and profitability Index (PI) of this project. What if payback is 1.5 years, what will be your decision? What if discounted payback is 2.5years, what will be your decision? Using If statements, show whether you'll accept or reject the project. Year O values Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Initial Outlay $ 4,000,000 ЕBIT $ 2,950,000 Initial NWC 2$ 50,000 Depreciation $ 235,000 $ 2,950,000 $ 235,000 $ EBIT Тахes* $ 1,032,500 Depreciation OCF Change in NWC Capital spending 105,000 $ 475,000 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Increase per year ЕBIT 15% Depreciation Change in NWC Capital spending WACC 20% 10% 20% 9% Decision Using "If Statement" Tax rate 35% NPV IRR P.I. Payback Discounted Payback
Expert Answer:
Answer rating: 100% (QA)
1157 w ENG 19042020 12 GS13 GR GS GT GU GV GW GX GY GZ HB 1 3 INFLATION 450 UPON RET... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1259024962
6th Canadian edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus, Devashis Mitra, Elizabeth Maynes, William Lim
Posted Date:
Students also viewed these finance questions
-
You are 30 years old today. You want to retire at the age of 65. You expect to live until age 90. You would like to have annual income of $170,000 in retirement. How much do you have to save (per...
-
The Smiths are planning to retire in 35 years. They want an annual real income of $45,000, paid at the end of each month of their expected 20-year retirement and to bequeath $500,000, in real...
-
You want to retire has a millionaire. How much do you need to put away each month if: You use common stocks and have an average return of 10%? You use corporate bonds and have an average return of...
-
Below is the comparative income statement of Variline, Inc. Requirements 1. Prepare a horizontal analysis of the comparative income statement of Variline, Inc. Round percentage changes to the nearest...
-
Mega Communications Inc. (MCI) is a Canadian-owned public company operating throughout North America. Its core business is communications media, including newspapers, radio, television and cable. The...
-
Calculate the pH of the buffer system made up of 0.15 M NH3/0.35 M NH4Cl.
-
How do we map inheritance to a relational database? Describe the roles of primary and foreign keys in mapping.
-
Garnett Jackson, the founder and CEO of Tech Tune-Ups, stared out the window as he finished his customary peanut butter and jelly sandwich, contemplating the dilemma currently facing his firm. Tech...
-
Image transcription text timing, and colour represents brake thermal efficiency (landscape format, in colour) b) Analyse the heat loss (%) and ignition delay (deg) and plot them as a function of...
-
An infinite cylinder of radius R carries a uniform surface charge density o. We propose to set it spinning about its axis, at a final angular velocity ws. How much work will this take, per unit...
-
If your company raises a $4.5m at a $10.5m pre-$ valuation, and later sells for $20m. If you own one-third of the common stock. how much do you receive if investors have?
-
Discussion 2.1 - Biological Psychology No unread replies. No replies. Discussion 2.1: Biological Psychology Define the term Biological Psychology. Explain why it may be important to study biology in...
-
QUESTION A. 1. State how (mental Health Care for coronavirus Outbreak) aligns with General Psychology with an Emphasis in Integrating Technology, Learning and Psychology. 2. State the (Risk and...
-
Allport listed several components that must be present for a person to attain psychological maturity (his term for mental health) as follows: 1. Specific, enduring extensions of self 2. Dependable...
-
Think about some of your close same-sex friendships. Explain how you became close friends. How do you stay close friends? Is it through the ways that are traditionally associated with your gender...
-
need an explanation on the following. What effect would a left- or right-hemisphere stroke have on a person's ability to perceive emotions?
-
The solid brass rod (G = 39 GPa) is connected with the aluminum rod (G = 27 GPa). Determine the bending stresses at the top, bottom and the contact point fibers. (Mmax = PL/4) 50 mm 5m 10 kN 250 mm...
-
we have to compute the letter grades for a course. The data is a collection of student records stored in a file. Each record consists of a name(up to 20 characters), ID (8 characters), the scores of...
-
How would Yummy Food's 2015 required external financing change if the 2015 dividend payout ratio were cut to one-third? Use this revision to the financing model to generate a new financial plan for...
-
Patty's Pancakes orders pancake mix once a week. The mix is used up by the end of the week, at which point more is reordered. Each time Patty orders pancake mix, she spends about a half hour of her...
-
Barclays Canada provides many of the exchange-traded funds listed on the TSX. Go to www.ishares.ca and explore 3 different ETFs. The list is found on the home page under "products." For each ETF,...
-
Using the potential theory obtain the damping for a cycle of (i) plunge, (ii) pitch oscillations.
-
Obtain the vortex lift line slope, given by Eq. 8.14, for a supersonic delta wing. Eq. 8.14 Ky = -(cos A) ?
-
The state-space representation is based on a state function \(x\) satisfying the first order ODE \(\tau_{1} \dot{x}=x_{o}\left(\alpha-\tau_{2} \dot{\alpha} ight)-x\), where argument...
Study smarter with the SolutionInn App