Question
Part II: (Worth 5 marks) Fill in all the (non-zero) entries in the spreadsheet below. Kilburg Inc. is considering buying a new football manufacturing machine
Part II: (Worth 5 marks) Fill in all the (non-zero) entries in the spreadsheet below.
Kilburg Inc. is considering buying a new football manufacturing machine
It will cost $10 million and is depreciated in the 3-year MACRS class
Kilburg paid an engineer $500,000 last month to design the machine
It will cost $100,000 to install the machine
It is assumed to have a salvage value of $1,000,000 at the end of its 3-year economic life
It will generate annual incremental profits (before taxes and depreciation) of $4,000,000
The machine will require additional working capital of $700,000 (an opportunity cost)
Kilburgs tax rate is .30
Part III: Worth 5 points. Fill in the blanks in the following table.
(Data in millions) | Nick Inc. |
EBIT | 100 |
Tax | 20 |
EBIAT | |
Depreciation and amortization | 30 |
Increase in working capital | 10 |
Unlevered FCF from Ops | |
Capital expenditures | 30 |
Unlevered Free cash flow | |
Interest expense | 5 |
Tax shield on interest | 1 |
Free cash flow | |
Free cash flow to equity | |
| |
Equity | 450 |
Debt | 160 |
Cash | 10 |
Enterprise value | 600 |
Revenue | 200 |
| |
Multiples | |
Revenue | |
EBIT | |
EBITDA | |
Unlevered free cash flow | |
Free cash flow to equity |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started