Question

In: Finance

IBM is considering a new expansion project and the finance staff has received information summarized below:...

IBM is considering a new expansion project and the finance staff has received information summarized below:

- The project require IBM to purchase $1,000,000 of equipment in 2013 (t=0) - Inventory will increase by $100,000 and accounts payable will rise by $50,000

- The project will last for four years. The company forecasts that they will sell 1,000,000 units in 2014, 2,000,000 units in 2015, 3,000,000 units in 2016, and 4,000,000 units in 2017. Each unit will sell for $3.00

- The fixed cost of producing the product is $2 million each year

- The variable cost of producing each unit is $1.00 each year

- The equipment will be depreciated under the MACRS system using the applicable rates of 33%, 45%, 15%, and 7% respectively

- When the project is completed in 2017 (t=4), the company expects that it will be able to salvage the equipment for $100,000, and it expects that it will fully recover the NWC.

- The estimated tax rate is 40% - Based on the perceived risk, the project's WACC is estimated to be 12%

1. Create the projected Free Cash Flow Schedule for the project

2. Use the capital budgeting techniques to evaluate free cash flows

Solutions

Expert Solution

Working capital = Inventory - account payable

= 100,000 - 50,000

= 50,000

Cash outflow = purchase price + working capital

= 1,000,000 + 50,000

= 1,050,000

Free cash flow schedule

Year (units) 1 2 3 4
Sales (Rs 3 per unit) 3,000,000 6,000,000 9,000,000 12,000,000
(-)Variable Cost (Rs 1 per unit) (1,000,000) (2,000,000) (3,000,000) (4,000,000)
(-) Fixed cost (2,000,000) (2,000,000) (2,000,000) (2,000,000)
Ebitda 0 2,000,000 4,000,000 6,000,000
(-)depreciation (297,000) (405,000) (135,000) (63,000)
EBT (297,000) 1,595,000 3,865,000 5,937,000
(-) Tax (40%) (118,800) (638,000) (1,546,000) (2,374,800)
Net Profit (415,800) 957,000 2,319,000 3,562,200
(+)Depreciation 297,000 405,000 135,000 63,000
(+)Working capital 50,000
Free cash flow (118,800) 1,362,000 2,454,000 3,675,200

Depreciation =( purchase price - salvage value) × depreciation rate

2. Using calculator to calculate Npv and irr

Inputs : C0 = -1,050,000

C1 = -118,800. Frequency= 1

C2 = 1,362,000. Frequency= 1

C3 = 2,454,000. Frequency= 1

C4 = 3,675,200. Frequency= 1

I = 12%

Npv = compute

Irr = compute

We get, Npv = $4,012,785.69

  Irr = 84.16%


Related Solutions

IBM is considering a new expansion project and the finance staff has received information summarized below:...
IBM is considering a new expansion project and the finance staff has received information summarized below: - The project require IBM to purchase $1,000,000 of equipment in 2013 (t=0) - Inventory will increase by $100,000 and accounts payable will rise by $50,000 - The project will last for four years. The company forecasts that they will sell 1,000,000 units in 2014, 2,000,000 units in 2015, 3,000,000 units in 2016, and 4,000,000 units in 2017. Each unit will sell for $3.00...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.348 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $260,400. The project requires an initial investment in net working capital of $372,000. The project is estimated to generate $2,976,000 in annual sales, with costs of $1,190,400. The tax rate is 32 percent and the required...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $5.616 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $436,800. The project requires an initial investment in net working capital of $624,000. The project is estimated to generate $4,992,000 in annual sales, with costs of $1,996,800. The tax rate is 31 percent and the required...
Finance Is Fun is considering a new 3-year expansion project that requires an initial fixed asset...
Finance Is Fun is considering a new 3-year expansion project that requires an initial fixed asset investment of $4.5 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $348,600 after 3 years. The project requires an initial investment in net working capital of $498,000. The project is estimated to generate $3,984,000 in annual sales, with costs of $1,593,600. The tax rate is 35 percent and the required return on the...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.458 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $113,400. The project requires an initial investment in net working capital of $162,000. The project is estimated to generate $1,296,000 in annual sales, with costs of $518,400. The tax rate is 34 percent and the required...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.456 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $268,800. The project requires an initial investment in net working capital of $384,000. The project is estimated to generate $3,072,000 in annual sales, with costs of $1,228,800. The tax rate is 31 percent and the required...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.836 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $142,800. The project requires an initial investment in net working capital of $204,000. The project is estimated to generate $1,632,000 in annual sales, with costs of $652,800. The tax rate is 32 percent and the required...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $6.318 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $491,400. The project requires an initial investment in net working capital of $702,000. The project is estimated to generate $5,616,000 in annual sales, with costs of $2,246,400. The tax rate is 34 percent and the required...
A mining company is considering a new project. Because the mine has received a permit, the...
A mining company is considering a new project. Because the mine has received a permit, the project would be legal; but it would cause significant harm to a nearby river. The firm could spend an additional $10 million at Year 0 to mitigate the environmental Problem, but it would not be required to do so. Developing the mine (without mitigation) would cost $60 million, and the expected cash inflows would be $20 million per year for 5 years. If the...
A mining company is considering a new project. Because the mine has received a permit, the...
A mining company is considering a new project. Because the mine has received a permit, the project would be legal; but it would cause significant harm to a nearby river. The firm could spend an additional $10.66 million at Year 0 to mitigate the environmental Problem, but it would not be required to do so. Developing the mine (without mitigation) would cost $66 million, and the expected cash inflows would be $22 million per year for 5 years. If the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT