Question

Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96...

Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96 million. The coffee will cost $34,500 to run, will save the firm $129,600 in labour costs, and will be useful for 12 years. Suppose that for tax purposes, the coffee will be in an asset class with a CCA rate of 25%. Maiden has many other assets in this asset class. The coffee is expected to have a 12-year life with a salvage value of $99,000. The actual market value of the coffee at that time will also be $99,000. The discount rate is 8% and the corporate tax rate is 35%. What is the NPV of buying the new coffee?

Please dont use excel. i need to know steps. thanks.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

NPV of the project is present value of future cash flows discounted at required rate of return less the initial investment.

To calculation NPV, free cash flow of the project can be calculated as follows:

Free Cash Flow = Operating Cash Flow - Capital Expenditures - Change in working capital

Operating Cash Flow = EBIT*(1-Tax Rate)+Depreciation

NPV can be calculated as follows:

Formula sheet

A1 B C Free cash flow can be calculated as follows: Free Cash Flow Operating Cash Flow - Capital Operating Cash Flow- EBIT (1-Tax Rate)+Depre Tax Rate Equipment Cost Life of Machine Salvage value at year 10 Market Value at year 10 CCA Rate Year Depreciation Expense Book Value (Note: In CCA Calculation Salvage Value is ignore Net Proceed from sale calculation: Initial Cost of machine Market Value at the end of 12th year Book Value of machine at the end of 12th year P14 Gain or Loss on sale of Machine 0.35 12 years 12 D14 $DS11 E14 $D$11 N14 SD$11 014 SD$11 -D14-E13 -D7 -E14-F13 N14-013 -014-P13 18 -Proceed From -D18-D19 getformula D21 Gain or Loss on sale of Machine Tax on Gain& Loss Net Proceed from Sale -D21 -D23 D6 -Proceed from S -D18-D24 -getformula(D23 -getformula(D24 25 getformula(D26 Free cash flow can be calculated as followed: Year Savin Operating Cost Depreciation Operating Income Before Tax (EBIT Tax (@35% After Tax operating income (EBIT (1-T)) Add Depreciation Operating Cash Flow Initial investment in Equipment Net Proceed from Sale of Machine Free Cash Flow 29 12 30 -E13 -F13 -013 -P13 SUM(E30:E32) SUM(F30:F32) SUM(O30:032) SUM(P30:P32) -E33+E34 -E32 E35+E36 -F33+F34 E-F32 F35+F36 -033+034 -032 -035+036 -P33+P34 P32 P35+P36 -D26 -D38 -E37 -F37 037+039 P37+P39 NPV of the project is present value of future cas Given the following cash flow and discount rate Year Free Cash Flow (FCF Discount rate (i (P/F.i,n) for each year -E40 -F40 P40 0.08 -1/((1+SD$46)E1/((1+SD$46)F 1/((1+SD$46)Ad-1/((1+SD$46)A Present Value of cash flows FCF (P/F,i,n Present value if future cash flows E45 E47 F45 F47 045 047 P45 P47 SUM(E48:P48) getformula(D4 NPV for Project -Present value f D49+D45 -getformula(D52 Hence NPV of the project is D52

Add a comment
Know the answer?
Add Answer to:
Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96...

    Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96 million. The coffee will cost $34,500 to run, will save the firm $129,600 in labour costs, and will be useful for 12 years. Suppose that for tax purposes, the coffee will be in an asset class with a CCA rate of 25%. Maiden has many other assets in this asset class. The coffee is expected to have a 12-year life with a salvage value...

  • Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96...

    Maiden Industries, Inc., needs a new coffee. It can buy a new high-speed coffee for $0.96 million. The coffee will cost $34,500 to run, will save the firm $129,600 in labour costs, and will be useful for 12 years. Suppose that for tax purposes, the coffee will be in an asset class with a CCA rate of 25%. Maiden has many other assets in this asset class. The coffee is expected to have a 12-year life with a salvage value...

  • Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.94...

    Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.94 million. The lathe will cost $30,700 to run, will save the firm $129,600 in labour costs, and will be useful for 10 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. Ilana has many other assets in this asset class. The lathe is expected to have a 10-year life with a salvage value...

  • Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.94...

    Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.94 million. The lathe will cost $30,700 to run, will save the firm $129,600 in labour costs, and will be useful for 10 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. Ilana has many other assets in this asset class. The lathe is expected to have a 10-year life with a salvage value...

  • Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.09...

    Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.09 million. The lathe will cost $38,600 to run, will save the firm $121,500 in labour costs, and will be useful for 8 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. Ilana has many other assets in this asset class. The lathe is expected to have a 8-year life with a salvage value...

  • llana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.09...

    llana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.09 million. The lathe will cost $32,100 to run, will save the firm $119,300 in labour costs, and will be useful for 11 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. Ilana has many other assets in this asset class. The lathe is expected to have a 11-year life with a salvage value...

  • ABC Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.95...

    ABC Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $0.95 million. The lathe will cost $33,100 to run, will save the firm $131,300 in labour costs, and will be useful for 11 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. ABC has many other assets in this asset class. The lathe is expected to have a 11-year life with a salvage value...

  • Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.01 million. The lathe will cost $...

    Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.01 million. The lathe will cost $36,500 to run, will save the firm $126,100 in labour costs, and will be useful for 8 years. Suppose that for tax purposes, the lathe will be in an asset class with a CCA rate of 25%. Ilana has many other assets in this asset class. The lathe is expected to have a 8-year life with a salvage value...

  • Ilana Industries Inc. needs a new lathe. It can buy a new high-speed lathe for $1.8...

    Ilana Industries Inc. needs a new lathe. It can buy a new high-speed lathe for $1.8 million. The lathe will cost $53,000 per year to run, but it will save the firm $183,000 in labor costs and will be useful for 10 years. Suppose that for tax purposes, the lathe is entitled to 100% bonus depreciation. At the end of the 10 years, the lathe can be sold for $500,000. The discount rate is 12%, and the corporate tax rate...

  • Ilana Industries Inc. needs a new lathe. It can buy a new high-speed lathe for $1.5...

    Ilana Industries Inc. needs a new lathe. It can buy a new high-speed lathe for $1.5 million. The lathe will cost $50,000 per year to run, but it will save the firm $160,000 in labor costs and will be useful for 10 years. Suppose that for tax purposes, the lathe is entitled to 100% bonus depreciation. At the end of the 10 years, the lathe can be sold for $400,000. The discount rate is 10%, and the corporate tax rate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT