Question

In: Finance

Mongo Inc. needs someone to supply it with 200,000 cartons of machine screws per year to...

Mongo Inc. needs someone to supply it with 200,000 cartons of machine screws per year to support its manufacturing needs over the next 5 years, and you've decided to bid on the contract. It will cost you $1,200,000 after-tax to install the equipment necessary to start production; you'll depreciate this cost straight-line to zero over the project's life. You estimate that in 5 years, this equipment can be salvaged for $75,000 before-tax. Your fixed production costs will be $350,000 before-tax per year, and your variable production costs should be $12.00 before-tax per carton. You also need an initial increase in account receivables of $100,000 and a decrease in account payable of $150,000, all of which will be recovered when the project ends. Your tax rate is 20 percent and you require a 10 percent return on your investment. What bid price per carton should you submit?

Solutions

Expert Solution

Operating cash flow (OCF) each year = income after tax + depreciation

Investment in working capital = increase in receivables + decrease in payables

Investment in working capital = $100,000 + $150,000 = $250,000

profit on sale of equipment at end of year 5 = sale price - book value

book value = original cost - accumulated depreciation

The book value is zero as the equipment is fully depreciated

after-tax salvage value = salvage value-+ tax on profit on sale of equipment

First, we assume the bid price to be $15, and compute the NPV.

NPV is calculated using NPV function in Excel

NPV is -$319,399

Minimum bid price is where the NPV equals zero.

Minimum bid price is calculated using GoalSeek in Excel

Minimum bid price is $15.52


Related Solutions

Kirksville Enterprises needs someone to supply it with 200,000 cartons of machine screws per year to...
Kirksville Enterprises needs someone to supply it with 200,000 cartons of machine screws per year to support its manufacturing needs over the next 5 years, and you've decided to bid on the contract. It will cost you $1,200,000 after-tax to install the equipment necessary to start production; you'll depreciate this cost straight-line to zero over the project's life. You estimate that in 5 years, this equipment can be salvaged for $75,000 before-tax. Your fixed production costs will be $350,000 before-tax...
Guthrie Enterprises needs someone to supply it with 200,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 200,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $2,550,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $210,000. Your fixed production costs will be $695,000 per year, and your...
Guthrie Enterprises needs someone to supply it with 225,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 225,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $2,800,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $235,000. Your fixed production costs will be $720,000 per year, and your...
Guthrie Enterprises needs someone to supply it with 150,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 150,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $2,050,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $160,000. Your fixed production costs will be $645,000 per year, and your...
Guthrie Enterprises needs someone to supply it with 150,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 150,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $2,050,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $160,000. Your fixed production costs will be $645,000 per year, and your...
Komoka Enterprises needs someone to supply it with 156,000 cartons of machine screws per year to...
Komoka Enterprises needs someone to supply it with 156,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $956,000 to install the equipment necessary to start production. The equipment will be depreciated at 30% (Class 10), and you estimate that it can be salvaged for $101,000 at the end of the five-year contract. Your fixed production costs will be $451,000 per...
Martin Enterprises needs someone to supply it with 110,000 cartons of machine screws per year to...
Martin Enterprises needs someone to supply it with 110,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $745,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that, in five years, this equipment can be salvaged for $93,000. Your fixed production costs will be $335,000 per year, and...
Guthrie Enterprises needs someone to supply it with 220,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 220,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost $2,750,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years this equipment can be salvaged for $230,000. Your fixed production costs will be $715,000 per year, and your...
Komoka Enterprises needs someone to supply it with 151,000 cartons of machine screws per year to...
Komoka Enterprises needs someone to supply it with 151,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $951,000 to install the equipment necessary to start production. The equipment will be depreciated at 30% (Class 10), and you estimate that it can be salvaged for $96,000 at the end of the five-year contract. Your fixed production costs will be $446,000 per...
Guthrie Enterprises needs someone to supply it with 153,000 cartons of machine screws per year to...
Guthrie Enterprises needs someone to supply it with 153,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $1,930,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that in five years, this equipment can be salvaged for $163,000. Your fixed production costs will be $278,000 per year, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT