Question

In: Finance

Q 1 Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years...

Q 1

Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years ago. The unit, which originally cost $500,000, has a current book value of $250,000. HFC is considering replacing the existing unit with a newer, more efficient one. The new unit will cost $750,000 and will also require an initial increase in net working capital of $40,000. The new unit will be depreciated on a straight‐line basis over five years to a zero balance. The existing unit is being depreciated at a rate of $50,000 per year. HFC expects to sell the existing machine today for $275,000. HFC’s tax rate is 30%.If HFC purchases the new unit, annual revenues are expected to increase by $100,000 (due to increased capacity), and annual operating costs (exclusive of depreciation) are expected to decrease by $20,000. Annual revenues and operating costs are expected to remain constant at this new level over the five‐year life of the project. Accumulated net working capital will be recovered at the end of five years. HFC’s (Simplified) Balance sheet is below:

Assets Liabilities & Equity

Current Assets 200,000 Debt 480,000

Fixed Assets 1,000,000 Equity 720,000

HFC’s equity beta is 1.3, cost of debt is 10% and the risk‐free rate and market return are

8% and 14% respectively.

Answer the following

(a) Calculate the project’s initial net investment.

Click or tap here to enter text.

(b) Calculate the annual net operating cash flows for the project.

Click or tap here to enter text.

(c) Calculate HFC’s cost of equity and weighted average cost of capital.

Click or tap here to enter text.

(d) Should HFC proceed with the project? Why?

Solutions

Expert Solution

(a) New unit cost = $750,000

Old unit expected selling price = $275,000

Old unit current book value = $250,000

Tax on profit on sell of old unit = ( $275,000 - $250,000 ) * 30%

= $25,000 * 30%

= $7,500

Increase in Net working Capital (NWC) = $40,000

Calculation of Initial Net Investment (at year 0)

Cost of New Unit $750,000

Add:  Increase in Net working Capital $40,000

Add: Tax on profit on sell of old unit     $7,500

Less: Old unit expected selling price ($275,000)  

  Net Initial Investment $522,500

(b)  Calculation of Annual Net Operating Cash Flow (From year 1 to 5)

Annual Revenue ( expected to increase )    $100,000

  Add : Decrease Cost (same impact as increase revenue ) $20,000

Less : Depreciation New ( 750,000 / 5 ) ($150,000)

Add : Opportunity cost on old depreciation ( 250,000 / 5 ) $50,000

Earning before Interest & Tax (EBIT) $20,000

Less : Tax @ 30% ($6,000)   

Earning after Tax (EAT) $14,000

Add: Incremental Depreciation ( New - Old ) $100,000   

Net Cash Flow $114,000

(c)

Cost of Equity (ke) = Risk free rate + Beta * ( Market return - risk free rate )

= 8% + 1.3 ( 14% - 8% )

= 8 + 1.3 * 6

= 8 + 7.8

= 15.8%

Cost of Debt (after tax) (kd) = Cost of debt * ( 1 - tax rate )

= 10 * ( 1 - 0.30 )

= 10 * 0.70

= 7%

weight of eqity (We) = 720,000 / 1,200,000 = 0.6

weight of debt (Wd) = 480,000 / 1,200,000 = 0.4

WACC (weighted average cost of capital) = ke * We + kd * Wd

= 15.8% * 0.6 + 7% * 0.4

= 9.48 + 2.8

= 12.28%

(d)

Accept : if replacement decision is wealth enhancing and create wealth.

Reject : if replacement decision diminish the wealth and fails to create wealth.

Calculation of Terminal Cash Flow (at year 5)

Increased revenue [after tax] ( 100,000 * 0.70 ) $70,000

+ Decreased Cost [after tax] ( 20,000 * 0.70 ) $14,000

+ Tax shield on Incremental Depreciation (100,000 * 0.30 )    $30,000

+ Working Capital Recovery $40,000

Net Cash Flow $154,000

Calculation of Net Present Value

Year Cash Flow PVIF @ 12.28% Present Value of Cash Flow
0 - $522,500 1 - $522,500.00
1 $114,000 0.8906 $101,528.40
2 $114,000 0.7932 $90,424.80
3 $114,000 0.7065 $80,541.00
4 $114,000 0.6292 $71,728.80
5 $154,000 0.5604 $86,301.60
Total - $91,975.40

Net present value is difference of present value of cash inflows and present value of cash outflow.

PVIF = 1 / ( 1 + rate )n

Conclusion : HFC should not accept the project or not proceed with the project as NPV is negative.


Related Solutions

Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years ago. The...
Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years ago. The unit, which originally cost $500,000, has a current book value of $250,000. HFC is considering replacing the existing unit with a newer, more efficient one.Thenewunitwillcost$ 750,000 and will also require an initial increase in net working capital of $40,000. The new unit will be depreciated on a straight‐line basis over five years to a zero balance. The existing unit is being depreciated at a...
Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years ago. The...
Healthy Foods Company (HFC) currently processes seafood with a unit it purchased several years ago. The unit, which originally cost $500,000, has a current book value of $250,000. HFC is considering replacing the existing unit with a newer, more efficient one.Thenewunitwillcost$ 750,000 and will also require an initial increase in net working capital of $40,000. The new unit will be depreciated on a straight‐line basis over five years to a zero balance. The existing unit is being depreciated at a...
International Foods (IFC) currently processes seafood with a unit it purchased several years ago. The unit,...
International Foods (IFC) currently processes seafood with a unit it purchased several years ago. The unit, which originally cost $500,000, currently has a book value of $250,000. IFC is considering replacing the existing unit with a newer, more efficient one. The new unit will cost $700,000 and will also require an initial increase in net working capital of $40,000. Additionally, in order to make the new unit operational shipping and installation costs will require a further $50,000 investment. The new...
Kirksville Foods Corporation (KFC) currently processes seafood with a unit it purchased three years ago. The...
Kirksville Foods Corporation (KFC) currently processes seafood with a unit it purchased three years ago. The unit will be built on the lot that was purchased for $200,000 after-tax last year. The lot is currently appraised for $250,000 after-tax and is expected to be sold for $300,000 after-tax in five years. The unit, which originally cost $480,000 after-tax, is expected to be used five more years and have a market value of $15,000 after-tax after five years. KFC is considering...
Q. 1: Two years ago, a company purchased a machine. Currently, the machine can be sold...
Q. 1: Two years ago, a company purchased a machine. Currently, the machine can be sold for Rs. 2500 having a book value of Rs. 2100. The remaining life of the machine is 6 years and is depreciated using a straight-line depreciation method. Therefore, it records Rs. 350 per year as an annual depreciation expense. The company may sell the machine for Rs. 500 after it completes its useful life if it is not replaced with a new one which...
3. Blue Ocean Tech currently operates with a unit it purchased four years ago. The unit...
3. Blue Ocean Tech currently operates with a unit it purchased four years ago. The unit which originally cost $530,000 currently has a book value of $90,100. (There are 2 years of depreciation remaining using the MACRS rates below). Blue Ocean is considering replacing the machine with a newer more efficient one. The new unit will cost $650,000 and will require an additional $35,000 for delivery and installation. The firms expects to be able to reduce net operating working capital...
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On...
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 2019, the firm’s general ledger contained the accounts and balances that follow. ACCOUNTS AND BALANCES Cash $ 30,700 Dr. Accounts Receivable 35,800 Dr. Allowance for Doubtful Accounts 480 Cr. Merchandise Inventory 86,600 Dr. Supplies 11,000 Dr. Prepaid Insurance 6,120 Dr. Office Equipment 8,500 Dr. Accum. Depreciation—Office Equipment 2,710 Cr. Warehouse Equipment 31,600 Dr. Accum. Depreciation—Warehouse Equipment 10,800 Cr. Notes Payable—Bank 35,000 Cr....
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On...
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 2019, the firm’s general ledger contained the accounts and balances that follow. ACCOUNTS AND BALANCES Cash $ 30,600 Dr. Accounts Receivable 35,700 Dr. Allowance for Doubtful Accounts 470 Cr. Merchandise Inventory 86,500 Dr. Supplies 10,900 Dr. Prepaid Insurance 6,000 Dr. Office Equipment 9,800 Dr. Accum. Depreciation—Office Equipment 2,700 Cr. Warehouse Equipment 36,300 Dr. Accum. Depreciation—Warehouse Equipment 10,600 Cr. Notes Payable—Bank 34,500 Cr....
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On...
Healthy Eating Foods Company is a distributor of nutritious snack foods such as granola bars. On December 31, 2019, the firm’s general ledger contained the accounts and balances that follow. ACCOUNTS AND BALANCES Cash $ 30,300 Dr. Accounts Receivable 35,400 Dr. Allowance for Doubtful Accounts 440 Cr. Merchandise Inventory 86,200 Dr. Supplies 10,600 Dr. Prepaid Insurance 5,640 Dr. Office Equipment 9,700 Dr. Accum. Depreciation—Office Equipment 2,670 Cr. Warehouse Equipment 34,200 Dr. Accum. Depreciation—Warehouse Equipment 10,000 Cr. Notes Payable—Bank 33,000 Cr....
Your company processes several polymer resins that are purchased from an outside supplier. The melt viscosities...
Your company processes several polymer resins that are purchased from an outside supplier. The melt viscosities of the resins are changing from batch to batch, presumably from differences in the molecular weight and PDI. Your boss asks you to set up a method for determining the molecular weights and molecular weight distributions for all incoming batches so that processing equipment temperatures can be appropriately adjusted. The method needs to provide actual molecular weight values and should require a relatively little...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT