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...
-
What is a wraparound filing?
-
You currently have $100,000 invested in a portfolio that has an expected return of 12% and a volatility of 8%. Suppose the risk-free rate is 5%, and there is another portfolio that has an expected...
-
The 2015 annual report of Bristol-Myers Squibb (BMS) discloses the following amounts included within other (income)/expense on its consolidated statement of earnings: Assume that on the companys...
-
Moran Company had $150,000 of net income in 2012 when the selling price per unit was $150, the variable costs per unit were $90, and the fixed costs were $570,000. Management expects per unit data...
-
Discuss two significant concerns regarding the threshold for probable cause and the areas in which the 4th amendment does not protect you. How might these concerns be minimized and what might be done...
-
Create a Case Study: Recycle4Change (R4C) - Enabling a Sustainable Recycling System 1. Introduction: Recycle4Change (R4C) is a social enterprise initiative under Chance Creators, affiliated with the...
-
Introduction *Explain why you are doing this assignment and the methods you will use to gather the information. Indicate that you will create user profiles in Hire Centennial, College Cornerstone and...
-
solving for the licensing fees as a percentage of sales revenue 1. return on invested capital is equal to profit/ assets= 2. The Profit made purely because of licenses technology 3. The margin of...
-
The Wall Street Journal that 30-day T-bills are currently yielding 5.1%. Your brother-in-law, a broker at Safe and Sound Securities, has given you the following estimates of current interest rate...
-
Envelope Company began operations this month mass-producing pull-and-seal envelopes. During the month of July, it completed 25,000 units and has 20,000 units that are 65% complete. It had product...
-
Draiman Corporation has bonds on the market with 14.5 years to maturity, a YTM of 5.3 percent, a par value of $1,000, and a current price of $987. The bonds make semiannual payments. What must the...
-
Suppose Flavor Fusion, a food company, produces beverages. Their total fixed cost is $ 1 5 , 0 0 0 , and the total variable cost is $ 5 0 0 0 . Let us calculate the total cost for the company.
-
what are examples of polya's problem solving in mathematical reasoning?
-
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,...
-
Find number of stages needed for a countercurrent extractor if 10 \(\mathrm{kmol} / \mathrm{h}\) feed that is \(10 \mathrm{~mol} \% \mathrm{CCl}_{4}\) and \(90 \mathrm{~mol} \%\) acetic acid is...
-
The horizontal settler calculation in Example 13-7 was done for a settler diameter of \(\mathrm{D}_{\mathrm{s}}=1.023 \mathrm{~m}\) with the dispersion band assumed to be at the center of the circle....
-
Suppose in Example 13-7 that we decide to build the settler with a diameter of \(1.0 \mathrm{~m}\) and a length of \(4.0 \mathrm{~m}\). What safety factor are we employing? Example 13-7 Design a...
Study smarter with the SolutionInn App