Question

In: Finance

Question: In Case 1, when calculating incremental unlevered net income, should we include all the expenses...

Question:

In Case 1, when calculating incremental unlevered net income, should we include all the expenses mentioned in the case? If not, what expenses should we exclude and why?

Case 1:

Chem Tough Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending $500,000 on the research of the potential market for the new chemical, Chem Tough is considering a project that requires an initial investment of $9,000,000 in manufacturing equipment.

 The equipment must be purchased before the chemical production can begin. For tax purposes, the equipment is subject to a 5-year straight-line depreciation schedule, with a projected zero salvage value. For simplicity, however, we will continue to assume that the asset can actually be used out into the indefinite future (i.e., the actual useful life is effectively infinite).

 Chem Tough anticipates that the sales will be $30,000,000 in the first year (Year 1). They expect that sales will initially grow at an annual rate of 6% until the end of sixth year. After that, the sales will grow at the estimated 2% annual rate of inflation in perpetuity.

 The cost of goods sold is estimated to be 72% of sales.

 The accounting department also estimates that at introduction in Year 0, the new product's required initial net working capital will be $6,000,000. In future years accounts receivable are expected to be 15% of the next year sales, inventory is expected to be 20% of the next year’s cost of goods sold and accounts payable are expected to be 15% of the next year’s cost of goods sold.

 The selling, general and administrative expense is estimated to be $6,000,000 per year, but $1 million of this amount is the overhead expense that will be incurred even if the project is not accepted.

 The market research to support the product was completed last month at a cost of $500,000 to be paid by the end of next year.

 The annual interest expense tied to the project is $1,000,000.

 Chem Tough has a cost of capital of 20% and faces a marginal tax rate of 30% and an average tax rate is 20%.

Solutions

Expert Solution

Unlevered Free Cash flow can be calculated as:

EBIT (Earnings Before Interest & taxes)*(1-Tax Rate)

Add: Depreciation & Amortization

Less: Capital Expenditure

Less: increase in Working Capital

{Since it is unlevered cashflows - taxes are recalculated before deducting interest expenses}

a) $500,000 spent on research - this is already spent and will not have an impact on the future cashflow generation capability of the project. However the initial investment requirement of $9 Mn will be considered to evaluate the project and hence included in the cashflows as Capital Expenditure.

b) Depreciation expenses will be calculated on the basis of Taxation. $9Mn will be depreciated on a straight line basis for 5 years implying a depriciation expense of $1.8 Mn. Depreciation expense gives the project cashflows, a tax benefit i.e lower taxes on lower EBIT due to higher depreciation expense

c) Revenues will be considered to calculate the EBIT, However, while considering the revenues - only the incremental revenue from introduction of the new asset should be considered.

d) Cost of goods sold will be considered to compute the EBIT

e) Increase in working capital requirements will be deducted to arrive at the unlevered cashflows

f) Only $5Mn of the SG&A will be considered to arrive at the EBIT, since $1mn of the total SG&A of $6Mn is an overhead expenses that will be incrurred even if the project is not accepted. It is a sunk cost

g) the market research expense will not be considered - since it is also a sunk cost.

h) Annual interest expenses are not considered, since we are calculating unlevered cashflows.

i) cost of capital = 20%, we discount the unlevered cashflows basis 20%

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Terminal Value
Revenue 30,000,000 31,800,000 33,708,000 35,730,480 37,874,309 40,146,767 40,949,703
Cost of Good Solds 21,600,000 22,896,000 24,269,760 25,725,946 27,269,502 28,905,672 29,483,786
SG&A 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000
Depreciation 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000
EBIT 1,600,000 2,104,000 2,638,240 3,204,534 3,804,806 6,241,095 6,465,917
Less Taxes 1,120,000 1,472,800 1,846,768 2,243,174 2,663,365 4,368,766 4,526,142
Add: Depreciation 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 0 0
Less: Capex 9,000,000
AR (15% of Revenue) 4,500,000 4,770,000 5,056,200 5,359,572 5,681,146 6,022,015 6,142,455
Inventory(20% of Cost of Goods Sold) 4,320,000 4,579,200 4,853,952 5,145,189 5,453,900 5,781,134 5,896,757
AP (15% of Cost of Goods Sold) 3,240,000 3,434,400 3,640,464 3,858,892 4,090,425 4,335,851 4,422,568
Working Capital 5,580,000 5,914,800 6,269,688 6,645,869 7,044,621 7,467,299 7,616,645
Less: Increase in Working Capital 6,000,000 -420,000 334,800 354,888 376,181 398,752 422,677 149,346
Unlevered CashFLows -15,000,000 2,700,000 2,096,400 2,236,584 2,385,179 2,542,690 1,449,651 1,790,429
Terminal Value 9,946,828
Total Cashflows -15,000,000 2,700,000 2,096,400 2,236,584 2,385,179 2,542,690 11,396,479
Discounted at Cost of Capital -15,000,000 2,250,000 1,455,833 1,294,319 1,150,260 1,021,850 3,816,658
NPV -4,011,079

Terminal Value = Cashflow in Year 7/(WACC - Perpetual growth)


Related Solutions

Question: In the Case, when calculating incremental unlevered net income, should we include all the expenses...
Question: In the Case, when calculating incremental unlevered net income, should we include all the expenses mentioned in the case? If not, what expenses should we exclude and why? (I know that I need to exclude interest expenses but can someone let me know if I also need to exclude overhead expenses? I am confused) Other than that I don't think I missed anything else but, feel free to correct me if I am wrong. Information: Canyon Buff Corp. has...
When determining incremental unlevered net income, should all the expenses listed be included? If not, what...
When determining incremental unlevered net income, should all the expenses listed be included? If not, what expenses should we exclude and why? Initial Capital Expenditure Useful Life of Equipment Annual Depreciation Sales in Year 1 Sales Growth through Year 6 Sales Growth Year 6 Onward Free Cash Flow Year 6 Onward Cost of Goods Sold (% of sales) Incremental SG&A Expense                 25% of the Incremental SG&A Expense is an overhead expense that will be incurred even if                  the project...
Why do we want to include Net Working Capital in our calculation to convert unlevered net...
Why do we want to include Net Working Capital in our calculation to convert unlevered net income to free cash flow?
Which one of the following below should be added to net income in calculating net cash...
Which one of the following below should be added to net income in calculating net cash flow from operating activities using the indirect method? a. A decrease in accounts payable  b. Dividends paid on common stock  c. An increase in accrued liabilities  d. A gain on the sale of land 
Tick the factors that financial manager should include when computing the incremental free cash flows of...
Tick the factors that financial manager should include when computing the incremental free cash flows of an investment decision. Project externalities Opportunity costs Sunk costs Financing costs
i)How should you use operating costs when calculating incremental cash flows? a) Do not subtract operating...
i)How should you use operating costs when calculating incremental cash flows? a) Do not subtract operating costs, and then subtract taxes on operating income before operating costs. b)Subtract operating costs, calculate taxes off of that number, and then add them back. c)Subtract taxes as though operating costs were not tax-deductible. Then subtract operating costs. d) Subtract operating costs. ii) At the end of a project, the equipment purchased at the beginning is expected to have a positive market value that...
Identify what would be added to net income when calculating income from operations using indirect method.
Identify what would be added to net income when calculating income from operations using indirect method.
I'm stuck on questions 1-6, any thoughts? Key Concepts Break Even = Incremental Expenses on Income...
I'm stuck on questions 1-6, any thoughts? Key Concepts Break Even = Incremental Expenses on Income Statement/Contribution Margin % Expenses are items that show up on the Income Statement or Profit/Loss Inventory by itself is not an expense. Inventory is an asset and shows up on the balance sheet. Inventory Expense for Full Lot Inventory Profile = Inventory * Inventory Carrying Cost % * Days/365 Fixed Overhead is not an incremental expense on the Income Statement. It is “Fixed”. You...
Which of the following should be deducted from net income in calculating net cash flow from operating activities using the indirect method
19. Which of the following should be deducted from net income in calculating net cash flow from operating activities using the indirect method? a depreciation expense b. gain on sale of land c a loss on the sale of equipment d dividends declared and paid 20. Which of the following below increases cash? a depreciation expense b. acquisition of treasury stock c. borrowing money by issuing a six-month note d. the declaration of a cash dividend 21. Which one of the following...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. Eighty percent of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT