Can you explain how to get 5-year cumulative EBITDA? NPV Analysis Free Cash Flows EBIT(1-t) plus depreciation
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
NPV Analysis Free Cash Flows EBIT(1-t) plus depreciation less ANWC less capital expenditures Free Cash Flow Terminal 3.00% Initial Outlays Net working capital Net property, plant & Discount 8.40% Present value Net Present Value $ NPV without Terminal 1 $ IRR Analysis Cash Flows IRR Payback Analysis L Cash flows Cumulative cash flow Payback period 5-year Cumulative EBITDA (750) 0 2010 2011 2012 2013 2014 350 596 766 835 152 152 152 152 (107) (427) (84) (113) (952) (152) (152) (334) (750) (557) 169 682 541 (800) (1470) 1.0000 0.9225 0.8510 0.7851 (3,020) (514) 144 536 7,150 (146) 2010 2011 2012 2013 (3,020) (557) 169 682 24.0% 0.7242 392 2014 541 2014 2010 (3,020) (557) 2011 2012 2013 169 682 (3,020) (3,577) (3,408) (2,726) (2,185) 541 2015 2016 2017 2018 2019 902 974 1,052 1,136 1,227 164 178 192 207 224 (122) (132) (143) (154) (167) (361) (389) (421) (454) (491) 583 630 680 735 793 0.6681 0.6163 0.5686 0.5245 0.4839 390 388 387 385 384 2015 2016 2017 583 630 680 2015 2016 2017 2018 583 (1,602) $ 6,522 2019 630 680 735 793 443 (972) (291) 7.40 years 2020 1,325 242 (180) (530) 857 16,345 2018 2019 2020 735 793 17,202 0.4464 7679 2020 17,202 NPV Analysis Free Cash Flows EBIT(1-t) plus depreciation less ANWC less capital expenditures Free Cash Flow Terminal 3.00% Initial Outlays Net working capital Net property, plant & Discount 8.40% Present value Net Present Value $ NPV without Terminal 1 $ IRR Analysis Cash Flows IRR Payback Analysis L Cash flows Cumulative cash flow Payback period 5-year Cumulative EBITDA (750) 0 2010 2011 2012 2013 2014 350 596 766 835 152 152 152 152 (107) (427) (84) (113) (952) (152) (152) (334) (750) (557) 169 682 541 (800) (1470) 1.0000 0.9225 0.8510 0.7851 (3,020) (514) 144 536 7,150 (146) 2010 2011 2012 2013 (3,020) (557) 169 682 24.0% 0.7242 392 2014 541 2014 2010 (3,020) (557) 2011 2012 2013 169 682 (3,020) (3,577) (3,408) (2,726) (2,185) 541 2015 2016 2017 2018 2019 902 974 1,052 1,136 1,227 164 178 192 207 224 (122) (132) (143) (154) (167) (361) (389) (421) (454) (491) 583 630 680 735 793 0.6681 0.6163 0.5686 0.5245 0.4839 390 388 387 385 384 2015 2016 2017 583 630 680 2015 2016 2017 2018 583 (1,602) $ 6,522 2019 630 680 735 793 443 (972) (291) 7.40 years 2020 1,325 242 (180) (530) 857 16,345 2018 2019 2020 735 793 17,202 0.4464 7679 2020 17,202
Expert Answer:
Answer rating: 100% (QA)
To calculate the 5year cumulative EBITDA Earnings Before Interes... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324597707
12th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these accounting questions
-
Write a proposal for my app with the given information: *my name is Ahmad. *app name is Kids learning sound app. *In this app there are different categories and in these categories there are...
-
Suppose your firm buys a drilling machine in Month 0, and sells it in Month 102. Perform a complete tax calculation and find the after-tax present value of buying, using and selling the asset, given...
-
Peter owned dividend paying shares of a public corporation. The shares appreciated in value since the time Peter purchased them. Peter sells all shares to his daughter Brianna, who is 12 years old,...
-
What is meant by date alignment? Does it exist on the consolidated worksheet under the following methods, and if not, how is it created prior to elimination of the investment account under each of...
-
A particle moves in a plane under the action of a force which is always perpendicular to the particle's velocity and depends on a distance to a certain point on the plane as 1/m, where n is a...
-
Wet air containing 4.0mole% water vapor is passed through a column of calcium chloride pellets. The pellets adsorb 97.0% of the water and none of the other constituents of the air. The column packing...
-
You are an internal auditor for the Military Industrial Company. You are presently preparing test transactions for the companys weekly payroll processing pro gram. Each input record to this program...
-
Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco, and Office Max. Scholes is concerned about the possible effects of inflation on its operations....
-
Examining Exhibit 7 reveals the financial statement forecast and underlying assumptions driving it. Return on invested capital (ROIC) represents the efficiency with which a company generates profits...
-
What are the major causes of information risk? How can information risk be reduced?
-
In determining if a law firm's efforts to prevent unauthorized disclosure are reasonable, factors to consider do not include: The sensitivity of the information. The likelihood of disclosure if...
-
What racial issues do you believe are facing sports today? Do you believe Title VII has resulted in progress regarding racial discrimination in sports? Title IX Mary Williams was an outstanding...
-
Problem 1: From what height can a 1 kg falling object cause fracture of the skull? Assume that the object is hard, that the area of contact with the skull is 1 cm, and that the duration of impact is...
-
PERSONAL FINANCE Money Management & Creating a Budget 1. How much income do you receive each month? a. includes job, allowance, gift $, etc. name: 2. Figure out your major expense/spending categories...
-
Suppose a person in New York (who has never been to Texas), purchases a custom motorcycle from a Texas company over the Internet. After receiving the motorcycle, the New York resident is in a wreck...
-
Legal sanctions are important in a property-based legal system because with no punishment people will not listen to the law and they will take other people's property. People need a remedy they can...
-
What is managed health care? What are the three types of managed health care plans? What are the advantages and disadvantages of each? Describe the basic intention of the Patient Protection and...
-
(a) With not more than 300 words, examine why Malaysia missed its 2020 targets to divert 40% of waste from landfills and increase recycling rates to 22%. (10 marks) b) Why arent Malaysian recycling?...
-
OBrien Computers Inc. needs to raise $35 million to begin producing a new microcomputer. OBriens straight, nonconvertible debentures currently yield 12%. Its stock sells for $38 per share, the last...
-
Cotner Clothes Inc. is considering the replacement of its old, fully depreciated knitting machine. Two new models are available: (a) Machine 190-3, which has a cost of $190,000, a 3-year expected...
-
Why would a company choose to issue floating-rate as opposed to fixed-rate preferred stock?
-
Create a table about the password policies enforced at the following: a. Your schools network b. Your schools email system c. Your personal email account (at Yahoo, Gmail, etc.) d. Your financial...
-
Camille Stibbe is general manager of Alden Corporation. She suggests that the budgeted income statement and the cash budget seem to show the same information. Therefore, she recommends that one of...
-
Thomas Baker, president of Brundage Corporation, says he has observed that an increase in sales almost always results in an increase in net income. Therefore, he is considering recommending that the...
Study smarter with the SolutionInn App