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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!