Question

In: Finance

Consider a project with a 6-year life. The initial cost to set up the project is...

Consider a project with a 6-year life. The initial cost to set up the project is $450,000. This amount is to be linearly depreciated to zero over the life of the project. The firm expects to be able to sell the equipment for $90,000 after 6 years.

The price per unit is $380, variable costs are $304 per unit and fixed costs are $45,000 per year. The project has a required return of 12% and a tax rate of 28%.

How many units must be sold per year for the project to achieve financial break-even?

Solutions

Expert Solution

Annual depreciation = Initial cost/Number of useful years

                             = $ 450,000/6 = $ 75,000

To achieve financial breakeven, NPV of the project should be zero.

Contribution per unit = Sales – Variable cost = $ 380 - $ 304 = $ 76

Suppose annual breakeven sales unit is X.

Contribution for X units = $ 76 X

NPV of the project

= Annual cash inflows x PVIFA (r, n) + after tax scrap value x PVIF (r, n) – Initial investment

Hence,

[(76 X – $ 45,000) - $ 75,000] x (1-0.28) + $ 75,000 x PVIFA (12 %, 6) + {$ 90,000 x (1-0.28)} x PVIF (12 %, 6) - $ 450,000 = 0

[(76 X – $ 45,000) - $ 75,000] x 0.72 + $ 75,000 x PVIFA (12 %, 6) + ($ 90,000 x 0.72) x PVIF (12 %, 6) - $ 450,000 = 0

[(76 X – $ 45,000) - $ 75,000] x 0.72 + $ 75,000 x PVIFA (12 %, 6) + ($ 90,000 x 0.72) x PVIF (12 %, 6) = $ 450,000

[{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000] x 4.1114 + ($ 90,000 x 0.72 x 0.50663) = $ 450,000

[{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000] x 4.11141 + $ 32,829.624 = $ 450,000

[{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000] x 4.11141 = $ 450,000 - $ 32,829.624

[{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000] x 4.11141 = $ 417,170.376

[{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000] = $ 417,170.376/4.11141

{(76 X – $ 45,000) - $ 75,000} x 0.72 + $ 75,000 = $ 101,466.498354579

{(76 X – $ 45,000) - $ 75,000} x 0.72 = $ 101,466.498354579 - $ 75,000

{(76 X – $ 45,000) - $ 75,000} x 0.72 = $ 26,466.498354579

(76 X – $ 45,000) - $ 75,000 = $ 26,466.498354579/0.72

(76 X – $ 45,000) - $ 75,000 = $ 36,759.0254924709

76 X – $ 45,000 = $ 36,759.0254924709 + $ 75,000

76 X – $ 45,000 = $ 111,759.025492471

76 X = $ 111,759.025492471 + $ 45,000

76 X = $ 156,759.025492471

X = $ 156,759.025492471/76

X = 2062.618756 or 2,063 units

2,063 units must be sold per year for the project to achieve financial breakeven.


Related Solutions

Consider a project with a 6-year life. The initial cost to set up the project is...
Consider a project with a 6-year life. The initial cost to set up the project is $1,200,000. This amount is to be linearly depreciated to zero over the life of the project. You expect to sell the equipment for $240,000 after 6 years. The project requires an initial investment in net working capital of $120,000, which will be recouped at the end of the project. You estimated sales of 63,000 units per year at a price of $160 each. The...
3. Consider a project with a 6-year life. The initial cost to set up the project...
3. Consider a project with a 6-year life. The initial cost to set up the project is $1,200,000. This amount is to be linearly depreciated to zero over the life of the project. You expect to sell the equipment for $240,000 after 6 years. The project requires an initial investment in net working capital of $120,000, which will be recouped at the end of the project. You estimated sales of 57,000 units per year at a price of $167 each....
Consider a project with a 4-year life. The initial cost to set up the project is...
Consider a project with a 4-year life. The initial cost to set up the project is $1,200,000. This amount is to be linearly depreciated to zero over the life of the project. You expect to sell the equipment for $240,000 after 4 years. The project requires an initial investment in net working capital of $120,000, which will be recouped at the end of the project. You estimated sales of 52,000 units per year at a price of $177 each. The...
Consider a project with a 4-year life. The initial cost to set up the project is...
Consider a project with a 4-year life. The initial cost to set up the project is $1,200,000. This amount is to be linearly depreciated to zero over the life of the project. You expect to sell the equipment for $240,000 after 4 years. The project requires an initial investment in net working capital of $120,000, which will be recouped at the end of the project. You estimated sales of 52,000 units per year at a price of $177 each. The...
Consider a project with a 4-year life. The initial cost to set up the project is...
Consider a project with a 4-year life. The initial cost to set up the project is $1,200,000. This amount is to be linearly depreciated to zero over the life of the project. You expect to sell the equipment for $240,000 after 4 years. The project requires an initial investment in net working capital of $120,000, which will be recouped at the end of the project. You estimated sales of 77,000 units per year at a price of $137 each. The...
Consider a project with a 5-year life. The initial cost to set up the project is...
Consider a project with a 5-year life. The initial cost to set up the project is $100,000. This amount is to be linearly depreciated to zero over the life of the project and there is no salvage value. The required return is 13% and the tax rate is 34%. You've collected the following estimates: Base case Pessimistic Optimistic Unit sales per year (Q) 8,000 6,000 10,000 Price per unit (P) 50 40 60 Variable cost per unit (VC) 20 35...
Consider a project with an initial investment of $60,000, a 6 year usefule life (and study...
Consider a project with an initial investment of $60,000, a 6 year usefule life (and study period), and a $10,000 salvage value. You expect an annual net revenue of $15,000 (before tax), a MARR before tax of 15.3%, and an effective tax rate of 35%. The capital equipment is to be depreciated using MACRS GDS and a 3 year class life. Develop the after-tax cash flows and draw the cash flow diagram
Consider the project where the initial cost is $200,000, and the project has a 5-year life....
Consider the project where the initial cost is $200,000, and the project has a 5-year life. There is no salvage. Depreciation is straight-line (Depreciation = 200,000/5 = 40,000) Unit Sales = 6000, Price per unit = $80 (Sales = 6,000 x 80) Variable cost per unit = $60 (Variable Costs = 6,000 x 60)The required return is 12%, and the tax rate is 21%  What are the cash flow each year, NPV and IRR in each case, if we...
A firm is considering a project with a 5-year life and an initial cost of $1,000,000....
A firm is considering a project with a 5-year life and an initial cost of $1,000,000. The discount rate for the project is 10%. The firm expects to sell 2,500 units a year for the first 3 years. The after-tax cash flow per unit is $120. Beyond year 3, there is a 50% chance that sales will fall to 900 units a year for both years 4 and 5, and a 50% chance that sales will rise to 3,000 units...
Your firm is considering a project with a four-year life and an initial cost of $87,000....
Your firm is considering a project with a four-year life and an initial cost of $87,000. The discount rate for the project is 15 percent. The firm expects to sell 1,800 units a year. The cash flow per unit is $19. The firm will have the option to abandon this project after two years at which time they expect they could sell the project for $40,000. At what level of sales should the firm be willing to abandon this project?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT