In: Finance
The Madison Prefabricated Buildings Co. is considering adding a new line to its product mix. Marcy Mulholland is to conduct a capital budgeting analysis on the project. The production line would be set up in unused space in Madison's main plant. The space could be leased out at $25,000 per year. The machinery's invoice price is approximately $200,000; $10,000 in shipping charges would be required; and it would cost $30,000 to install the machinery. The firm's inventories would have to be increased by $25,000 to handle the new line, but its accounts payable would rise by $5,000. The machinery has an economic life of 4 years, and qualifies as a MACRS 3-year asset. The machinery is expected to have a salvage value of $25,000 after 4 years. The new line would generate $125,000 in additional revenues in each of the next 4 years. The firm's marginal tax rate is 40% and its required return is 10 percent.
a.Construct the cash flows for each year by modifying an income statement. Be able to describe why you treated each cash flow as you did.
b.If the new product line decreases sales of the firm's other lines by $50,000 per year, should this information be included in the analysis? If so, how would Ms. Mulholland do it?
c.Determine whether the machine should be purchased. Explain your decision.
d.How much taxes did you save by having depreciation expense?
The Madison Prefabricated Buildings Co. | |
Capital Investment Analysis: | |
Total Capitalization of Machine | |
Machine purchase cost | 200,000 |
Shipping charge | 10,000 |
Installation cost | 30,000 |
Total Capitalizations cost | 240,000 |
Annual Depreciation : | ||||||
MACRS 3 year depreciation | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Total |
MACRS Rate | 33.33% | 44.45% | 14.81% | 7.41% | ||
Annual Depreciation : | 79,992 | 106,680 | 35,544 | 17,784 | ||
Tax Rate =40% | ||||||
Annual Depreciation Tax savings =Depreciation expense *40% | 31,997 | 42,672 | 14,218 | 7,114 | 96,000 |
So Total Tax saved from depreciation =$96,000 | Ans d |
Salvage Value after 4 years | 25,000 |
Tax on Salvage @40% | 10,000 |
After Tax salvage | 15,000 |
Increase in Inventory | 25,000 |
Less Increase in AP | (5,000) |
Net Increase in Working Capital | 20,000 |
Increased Revenue from new machine | 125,000 |
Less Tax @40% | 50,000 |
After Tax increase in Revenue | 75,000 |
Ans a. | ||||||
Cash flow from Project : | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
Initial Investment | ||||||
Machine cost | (240,000) | |||||
Net Investment in WC | (20,000) | |||||
Opportunity Loss of Lease Rental | (25,000) | (25,000) | (25,000) | (25,000) | (25,000) | |
a | Initial Investment +Lease rental Opp Loss | (285,000) | (25,000) | (25,000) | (25,000) | (25,000) |
Cash flow from Operations | ||||||
After Tax incremental Revenue | 75,000 | 75,000 | 75,000 | 75,000 | ||
Depreciation Tax savings | 31,997 | 42,672 | 14,218 | 7,114 | ||
b | Total Cash flow from Operations | 106,997 | 117,672 | 89,218 | 82,114 | |
Terminal Cash flow | ||||||
After Tax salvage | 15,000 | |||||
Recovery of NWC | 20,000 | |||||
c | Total Terminal Cash flow | 35,000 | ||||
d | Free Cash flow from the New Line =a+b+c | (285,000) | 81,997 | 92,672 | 64,218 | 92,114 |
Ans b. | |
If new machine line reduces revenue of other product | |
lines , that loss need to be considered as opportunity | |
cost of lost sale. | |
Here the Annual loss of sale of other product line is = | (50,000) |
Annual incremental revenue from new line = | 125,000 |
Net Incremental sales = | 75,000 |
Less Tax 40% | 30,000 |
Net Incremental After Tax revenue increase/year | 45,000 |
We have to change the incremental after tax annual | |
revenue to 45,000 from 75,000 in such case. |
And c. | |
Considering the sales loss and reworking cash flow for NPV |
Ans a. | ||||||
Cash flow from Project : | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
Initial Investment | ||||||
Machine cost | (240,000) | |||||
Net Investment in WC | (20,000) | |||||
Opportunity Loss of Lease Rental | (25,000) | (25,000) | (25,000) | (25,000) | (25,000) | |
a | Initial Investment +Lease rental Opp Loss | (285,000) | (25,000) | (25,000) | (25,000) | (25,000) |
Cash flow from Operations |
Related SolutionsThe Madison Prefabricated Buildings Co. is considering adding a new line to its product mix. Marcy...The Madison Prefabricated Buildings Co. is considering
adding a new line to its product mix. Marcy Mulholland is to
conduct a capital budgeting analysis on the project. The production
line would be set up in unused space in Madison's main plant. The
space could be leased out at $25,000 per year. The machinery's
invoice price is approximately $200,000; $10,000 in shipping
charges would be required; and it would cost $30,000 to install the
machinery. The firm's inventories would have to...
Superficial Casting Company is considering adding a new line to its product mix.
Superficial Casting Company is considering adding a new line to its product mix. The production line would be set up in unused space in Superficial’s main plant based in Hollywood, California. The machinery’s invoice price is $208,000, another $12,000 in shipping charges is required, and installation costs would amount to $27,000. The machinery has an economic life of 4 years, and Superficial management has obtained a special tax ruling that places the equipment in MACRS 3-year class. The machinery...
Shrieves Casting Company is considering adding a new line to its product mix, and the company...Shrieves Casting Company is considering adding a new line to its
product mix, and the company hires you, a recently business school
graduate, to conduct capital budgeting analysis. The production
line would be set up in unused space in Shrieves' main plant. The
machinery’s invoice price would be approximately $200,000; another
$10,000 in shipping charges would be required; and it would cost an
additional $30,000 to install the equipment. The machinery has an
economic life of 4 years, and would...
Shrieves Casting Company is considering adding a new line to its product mix, and the company...Shrieves Casting Company is considering adding a new line to its
product mix, and the company hires you to conduct capital budgeting
analysis. The production line would be set up in unused space in
Shrieves' main plant. The machinery’s invoice price would be
approximately $200,000; another $10,000 in shipping charges would
be required; and it would cost an additional $30,000 to install the
equipment. The machinery has an economic life of 4 years, and would
be a class 8 with...
Shrieves Casting Company is considering adding a new line to its product mix, and the company...Shrieves Casting Company is considering adding a new line to its
product mix, and the company hires you, a recently business school
graduate, to conduct capital budgeting analysis. The production
line would be set up in unused space in Shrieves' main plant. The
machinery’s invoice price would be approximately $200,000; another
$10,000 in shipping charges would be required; and it would cost an
additional $30,000 to install the equipment. The machinery has an
economic life of 4 years, and would...
Shrieves Casting Company is considering adding a new line to its product mix, and the capital...Shrieves Casting Company is considering adding a new line to its
product mix, and the capital budgeting analysis is being conducted
by Sidney Johnson, a recently graduated MBA. The production line
would be set up in unused space in Shrieves’ main plant. The
machinery’s invoice price would be approximately $200,000, another
$10,000 in shipping charges would be required, and it would cost an
additional $30,000 to install the equipment. The machinery has an
economic life of 4 years, and Shrieves...
Sugar Land Company is considering adding a new line to its product mix, and the capital...Sugar Land Company is considering adding a new line to its
product mix, and the capital budgeting analysis is being conducted
by a MBA student. The production line would be set up in unused
space (Market Value Zero) in Sugar Land’ main plant. Total cost of
the machine is $240,000. The machinery has an economic life of 4
years, and MACRS will be used for depreciation. The machine will
have a salvage value of $25,000 after 4 years. MACRS calculated...
ABC Company is considering adding a new line to its product mix, and the capital budgeting...ABC Company is considering adding a new line to its product mix,
and the capital budgeting
analysis is being conducted by Jameel, a recently graduated MBA.
The production line would be
set up in unused space in the main plant. The machinery’s invoice
price would be approximately Rs
5,000,000, another Rs 250,000 in shipping charges would be
required, and it would cost an
additional Rs 750,000 to install the equipment. The machinery has
an economic life of 4 years, and...
Shrieves Casting Company is considering adding a new line to its product mix, and the capital...Shrieves Casting Company is considering adding a new line to its
product mix, and the capital
budgeting analysis is being conducted by Sidney Johnson, a
recent business school graduate.
The production line would be set up in unused space in
Shrieves's main plant. The machinery's
invoice price would be approximately $200,000, another $10,000
in shipping charges would be
required, and it would cost an additional $30,000 to install the
equipment. The machinery has
an economic life of 4 years and...
Company is considering adding a new line to its product mix, and the capital budgeting analysis...Company is considering adding a new line to its product mix, and
the capital budgeting analysis is being conducted by a MBA student.
The production line would be set up in unused space (Market Value
Zero) in Sugar Land’ main plant. Total cost of the machine is
$350,000. The machinery has an economic life of 4 years and will be
depreciated using MACRS for 3-year property class. The machine will
have a salvage value of $35,000 after 4 years.
The...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|