Question

The technique for calculating a bid price can be extended to many other types of problems....

The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. Guthrie Enterprises needs someone to supply it with 154,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 $1,940,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 $164,000. Your fixed production costs will be $279,000 per year, and your variable production costs should be $10.80 per carton. You also need an initial investment in net working capital of $144,000. The tax rate is 24 percent and you require a return of 13 percent on your investment. Assume that the price per carton is $17.40.

  

a.

Calculate the project NPV. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

b.

What is the minimum number of cartons per year that can be supplied and still break even? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

c.

What is the highest fixed costs that could be incurred and still break even? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

NPV of the project is the present value of future cash flows discounted at the required rate of return less the initial investment.

To calculate NPV, free cash flow can be calculated as follows:

Free Cash Flow = Operating Cash Flow - Capital Expenditures - Change in working capital

Operating Cash Flow = EBIT*(1-Tax Rate)+Depreciation

The breakeven point is where the NPV of the project is 0.

A1 B C Free cash flow can be calculated as follows: Free Cash Flow Operating Cash Flow - Capital Expenditures- Change in working capital 6 Operating Cash Flow EBIT (1-Tax Rate)+Depreciation 7Tax Rate 8 Number of Cartons to be sold per year 24% 154,000 $17.40 10 11 12 Price Per Carton Life of the project Return on investment Fixed cost per year Variable Cost per carton 5 years 13% $279,000 $10.80 $164,000.00 14Market value of machine at the end of 5th vear 15 16 17 18 19 Year Revenue $2,679,600 $2,679,600$2,679,600 2,679,600 $2,679,600 $D$8 SD$9 21 22 23 Immediate investment in Equipment Initial investment in working capital Total initial investment $1,940,000 $144,000 $2,084,000 Depreciation each year can be calculated as follows Machine Cost Life of Machine Salvage value Depreciation per year $1,940,000 25 26 27 28 5 years (Investment-Salvage Value)/Expected life of equipment $388,000 -(D25-D27)/D26 31 Hence depreciation each year can be calculated as follows: 32 Year 1 Year 2 Year 3 Year 4 Year 5 $388,000 $388,000 $388,000 388,000 $1,940,000 $1,552,000$1,164,000 388,000 $388,000 $776,000 ciation (B*rt Book Value $0 H34-133 34 35 36 38 39 40 41 Net Proceed from sale calculation: Market Value at the end of 5th vear Book Value of machine at the end of 5th year Gain or Loss on sale of Machine $77,000 $0 -Proceed From Sale Book value at the end of sale $77,000 D37-D38 $77,000 43 44 45 Gain or Loss on sale of Machine Tax on Gain & Loss Net Proceed from Sale of System & Softwares $10,010.00 -Proceed from Sale Tax Expense on gain or loss $66,990D37-D43 47

Add a comment
Know the answer?
Add Answer to:
The technique for calculating a bid price can be extended to many other types of problems....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The technique for calculating a bid price can be extended to many other types of problems....

    The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. 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...

  • The technique for calculating a bid price can be extended to many other types of problems....

    The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. Guthrie Enterprises needs someone to supply it with 145,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...

  • The technique for calculating a bid price can be extended to many other types of problems....

    The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. 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...

  • To solve the bid price problem presented in the text, we set the project NPV equal to zero and fo...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems Romo Enterprises needs someone to supply it with 124,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. Martin Enterprises needs someone to supply it with 130,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. Martin Enterprises needs someone to supply it with 126,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. Martin Enterprises needs someone to supply it with 134,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. Martin Enterprises needs someone to supply it with 126,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. 0.58 points eBook Martin Enterprises needs someone to supply it with 138,000 cartons of machine screws per year to support its manufacturing needs over the next five...

  • To solve the bid price problem presented in the text, we set the project NPV equal...

    To solve the bid price problem presented in the text, we set the project NPV equal to zero and found the required price using the definition of OCF. Thus the bid price represents a financial break-even level for the project. This type of analysis can be extended to many other types of problems. Martin Enterprises needs someone to supply it with 132,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT