Gentle Ben Corp decides they want to invest in a new equipment to expand their production...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Gentle Ben Corp decides they want to invest in a new equipment to expand their production of cleaning products. Here are the cashflows for the project: -230,000 upfront payment in period 0, $100,000 inflows for periods 1 and 2, -$50,000 outflow in period 3 and $80,000 inflows in periods 4 and 5. Assume the Discount rate is 12.0% and the Reinvestment Rate is 4%. Delieverable: FIRST (#1): Please model the original (given) Project cash flows in a timeline ('Project CashFlows'). Then model a second set of MODIFIED cashflows for the purpose of calculating MIRR= one negative, upfront cash flow and one, positive, future value lump sum cash flow. NEXT (#2): After you model all of the cash flows below (original project and modified); calculate the MIRR using 3 methods listed below. Your answer should be: 8.134% | Refer back to your notes and video as needed. Original Cashflow Project Cashflows PV of Outflows FV of Inflows Modified Cash Flows Outflows Inflows Total Modified Cash Flow MIRR Calcs: discount rate reinvestment rate 0 0 12.00% 4.00% 1 0 2 0 3 0 4 0 5 0 Using Return Formula Using =MIRR() Excel Formula with 'Total Modified Cash Flow' Using =MIRR() Excel Formula with 'Project Cash Flows' Gentle Ben Corp decides they want to invest in a new equipment to expand their production of cleaning products. Here are the cashflows for the project: -230,000 upfront payment in period 0, $100,000 inflows for periods 1 and 2, -$50,000 outflow in period 3 and $80,000 inflows in periods 4 and 5. Assume the Discount rate is 12.0% and the Reinvestment Rate is 4%. Delieverable: FIRST (#1): Please model the original (given) Project cash flows in a timeline ('Project CashFlows'). Then model a second set of MODIFIED cashflows for the purpose of calculating MIRR= one negative, upfront cash flow and one, positive, future value lump sum cash flow. NEXT (#2): After you model all of the cash flows below (original project and modified); calculate the MIRR using 3 methods listed below. Your answer should be: 8.134% | Refer back to your notes and video as needed. Original Cashflow Project Cashflows PV of Outflows FV of Inflows Modified Cash Flows Outflows Inflows Total Modified Cash Flow MIRR Calcs: discount rate reinvestment rate 0 0 12.00% 4.00% 1 0 2 0 3 0 4 0 5 0 Using Return Formula Using =MIRR() Excel Formula with 'Total Modified Cash Flow' Using =MIRR() Excel Formula with 'Project Cash Flows'
Expert Answer:
Answer rating: 100% (QA)
It appears you are looking to calculate the Modified Internal Rate of Return MIRR for a project based on given cash flows using three different method... View the full answer
Related Book For
Fundamentals Of Investing
ISBN: 9780135175217
14th Edition
Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Please find the attached case study of Saurabh Enterprises who is trying to make a capital budgeting decisions. Please help the company with its decision making. Please work all the calculations in...
-
How would one do the following in excel? PROJECT STEPS Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format departmental data for the years...
-
Propose structures for the two compounds whose 1 H NMR spectra are shown. (a) C 4 H 9 Br (b) C 4 C 8 Cl 2 TMS O ppm 10 6. Chemical shift (8) 5 3 TMS O ppm 10 8. 6. Chemical shift (8) Intensity...
-
Suppose the spring/balance device in Figure P13.10 is adjusted so that the spring is slightly stretched and the balance arm is level when the device is in an elevator at rest relative to the ground...
-
The 2015 annual report of the Procter & Gamble Company (P&G) is available at www.pginvestor.com. After reviewing P&Gs annual report, respond to the following questions: a. When does P&G recognize...
-
Suppose a textbook monopoly can produce any level of output it wishes at a constant marginal (and average) cost of $5 per book. Assume that the monopoly sells its books in two different markets that...
-
What do we mean by accrual accounting? ANSWER Sure I AM SURE Formally, accrual accounting is a basis of accounting that reflects economic events when they happen rather than only when cash exchanges...
-
Overview The milestone for Project One involves applying accounting principles and methods to long-term liabilities and equity. You will also evaluate these financial statement components for...
-
If you want to have $5,000 in 10 years, how much money should you put in a savings account today? (Assume the savings account pays 4% and is compounded daily; round to the nearest $1.)
-
What can you expect from an industry in perfect competition in the long run? What will the price be? What quantity will be produced? What will be the relation between marginal cost, average cost, and...
-
Air at \(40^{\circ} \mathrm{C}\) flows over a long, \(25 \mathrm{~mm}\) diameter cylinder with an embedded electrical heater. Measurements of the effect of the free stream velocity, \(v_{\infty}\),...
-
The magnetic field a distance \(z\) above the centre of a circular loop of radius \(r\) carrying current \(I\) in the \(x y\) plane is \(\vec{B}=\frac{\mu_{0} I r^{2}}{2\left(r^{2}+z^{2} ight)^{3 /...
-
Private swimming pools can be dangerous. There are serious accidents each year in those areas of the United States where backyard pools are common. Should pools be banned? In other words, should the...
-
Using the model of perfect competition, explain what it means to say, Too much electricity is generated, or Too little education is produced. Would the firm be producing at the bottom of the ATC...
-
A street light is at the top of a 12-ft-tall pole. A 6-ft tall woman walks away from the pole with a speed of 4 ft/sec along a straight path (see figure). How fast is the tip of her shadow moving, in...
-
Explain five different cases of income exempt from tax with clear examples.
-
Akasuki works for an investment firm in Japan and is managing two portfolios for two different clients: the Nakamura family and the Saito family. Both portfolios had the same holding period return...
-
Suppose you look back over the past 10 years and identify firms that have increased dividends every year. You notice that these stocks outperformed the broader market over the decade too. Does this...
-
For each of the investments shown in the following table, calculate the rate of return earned over the period. Investment A BUDE C Cash Flow During Period -$ 800 $15,000 $ 7,000 $ 80 $ 1,500...
-
Michael Atisse, a carpenter, has the following trial balance as at 31 December 2012. You have the following additional information. 1. Closing inventory of tools 4,500 2. Depreciation is to be...
-
Clare Analetto, an antique dealer, has the following trial balance as at 31 December 2012. You also have the following notes to the accounts. 1. Closing inventory of antiques is 7,000. 2....
-
Michelle Angelo has trade receivables of 40,000 at the year end. However, she feels that 4,000 are irrecoverable. Required: Prepare the appropriate statement of financial position and income...
Study smarter with the SolutionInn App