Question

In: Finance

Bebe Enterprise needs someone to supply it with 100,000 pcs of generators per year to support...

Bebe Enterprise needs someone to supply it with 100,000 pcs of generators 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 $600,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 5 years, this equipment can be salvaged for $50,000 (before tax). Your fixed production costs will be $500,000 per year, and your variable production costs should be $30 per pcs. You also need an initial investment in net working capital of $100,000. If your tax rate is 30% and you require a 12% return on your investment, what is our proper bid price per pcs?

(PLEASE ANSWER IT WITH GOOGLE DRIVE LINK (GOOGLE SHEET) )

ok no prob

Solutions

Expert Solution

Note: The minimum selling price was calculated by using Goal Seek Function in excel where Value of NPV was set to 0 by changing the selling price value
Also, the working capital that was invested earlier is recovered at the end of the project even though it is not mentioned in the question

Our minimum bid price or selling price = $36.96 i.e. at this price the NPV of the project is 0. Any price quoted above the minimum selling price will result in Positive NPV and hence the project will be accepted

Net Present Value = PV of Cash Inflow - PV of Cash Outflow
PV of Cash Inflow = Cash Inflow / (1 + Cost of Capital)n
PV of Cash Outflow = Purchase Price of Machine - Working Capital Invested


Related Solutions

Bebe Enterprise needs someone to supply it with 100,000 pcs of generators per year to support...
Bebe Enterprise needs someone to supply it with 100,000 pcs of generators 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 $600,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 5 years, this equipment can be salvaged for $50,000 (before tax). Your fixed production costs will be $500,000 per year,...
Smith Enterprise needs someone to supply it with 125,000 cartons of machine screws per year to...
Smith Enterprise needs someone to supply it with 125,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 $720,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 5 years, this equipment can be salvaged for $50,000 (before tax). Your fixed production costs will be $285,000 per...
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