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.

jeff jeffy answered 1 year ago

Next > < Previous

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 77,000 units per year at a price of $137 each. The...

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?...

A project has an initial cost of $27,000 and a three year life. The company uses...

A project has an initial cost of $27,000 and a three year life. The company uses straight line depreciation to a book value of zero over the life of the project. The project net income from the projects is $1,600, $2,200, and $1,700 a year for the next three years, respectively. What is the average accounting return?

Western Industrial Products is considering a project with a five-year life and an initial cost of...

Western Industrial Products is considering a project with a five-year life and an initial cost of $110,000. The discount rate for the project is 13 percent. The firm expects to sell 2,400 units a year. The cash flow per unit is $25. The firm will have the option to abandon this project at the end of year three (after year three's sales) at which time the project's assets could be sold for an estimated $55,000. The firm should abandon the...

Subjects