HomeworkLib
Question

Holland Brewery is considering adding a new piece of equipment that will improve labeling of bottles....

Holland Brewery is considering adding a new piece of equipment that will improve labeling of bottles. There are two possibilities that are mutually exclusive with the following cash flows: Year Jiffy Labeler Super Labeler 0 -$17,100 -$22,430 1 5,100 7,500 2 5,100 7,500 3 5,100 7,500 4 5,100 7,500 5 5,100 7,500 Assume Holland Brewery’s WACC is 14 percent. Calculate the payback period, the NPV, the Profitability Index, the IRR, and the MIRR for both the Jiffy Labeler and the Super Labeler. Based on your calculations, which Labeler should be purchased?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

L23 . А B | C / D | E | F | G | Year CF OHNM in Jiffy Labeler CF Cumulative CF ($17,100.00) ($17,100.00) $5,100.00 ($12,000.0

Cell reference -

DE F Jiffy Labeler Cumulative CF Year CE o =C4 -17100 5100 5100 5100 5100 5100 D4+C5 =D5+C6 =D6+C7 =D7+C8 =D8+c9 Super Labele

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

0 0
Add a comment
Know the answer?
Add Answer to:
Holland Brewery is considering adding a new piece of equipment that will improve labeling of bottles....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system,...

    Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firm's cost of capital is 14%. After-tax cash flows, including depreciation, are as follows: Year Truck Pulley 1 $5,100 $7,500 2 5,100 7,500 3 5,100 7,500 4 5,100 7,500 5 5,100 7,500 Calculate the IRR for each project....

  • 10. Company Z is considering adding a new piece of equipment which will produce a new...

    10. Company Z is considering adding a new piece of equipment which will produce a new product. The machine would be set up in unused space in Ace's plant. The will cost $288,000. It would cost $33,000 for shipping. $20,000 for a contract base for the machine, $12,000 for contractors to install the machine. Additionally, electric is installed at a cost of 24,000 and another $5,000 for electric for an adjacent machine which is not used to process the new...

  • Edelman engineering is considering two pieces of equipment, a truck and an overhead pulley system, in...

    Edelman engineering is considering two pieces of equipment, a truck and an overhead pulley system, in this years capital budget. The projects are independent. the cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firms cost of capital is 14%. After tax flows, including depreciation, are as follows: year: 1. 2. 3. 4. 5 truck 5,100 5,100 5,100 5,100 5,100 pulley. 7500 7500 7500 7500 7500 1. Calculate the IRR for each project....

  • . NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.) NPV A project has an initial...

    . NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.) NPV A project has an initial cost of $60,000, expected net cash inflows of $11,000 per year for 9 years, and a cost of capital of 10%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to the nearest cent. $   b.) NPVs and IRRs for Mutually Exclusive Projects Davis Industries must choose between a gas-powered and an electric-powered...

  • Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a...

    Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a $20,000 cash outlay today and is expected to generate after-tax cash flows of $11,000 in year 1, $8,500 in year 2, and $7,500 in year 3. Project Brandy requires a $30,000 cash outlay today and is expected to generate after-tax cash flows of $7,000 in year 1, $9,000 in year 2, $11,000 in year 3, and $16,000 in year 4. Neither project can be...

  • Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects....

    Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B 0 ($30) ($30) 1 $5 $20 2 $10 $10 3 $15 $8 4 $20 $6 a.   Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA...

  • Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive...

    Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive investments. The projects’ expected net cash flows are as follows: Expected Net Cash Flows for the 7 year Project are: Project A −$375, −300, −200, −100, 600, 600, 926 and, −200 Project B −$575, 190, 190, 190, 190, 190, 190 and, 0 If each project’s cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project...

  • 1.) Net Present Value: The Lees are considering adding a new piece of equipment that will...

    1.) Net Present Value: The Lees are considering adding a new piece of equipment that will speed up the process of building the bobble heads. The cost of the piece of equipment is $42000. It is expected that the new piece of equipment will lead to cash flows of $17000, $29000, and $40000 over the next 3 years. If the appropriate discount rate is 12%, what is the NPV of this investment? Explain the findings. 2.) Incremental Analysis: If production...

  • Problem 1 Sugar Land Company is considering adding a new line to its product mix and...

    Problem 1 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 urused space (Market Value Zero) in Sugar and main plant. Total cost of the machine is $300,000. The machinery has an economic if of 4 years and will be deprecated using MACRS for 3 year property dess. The machine will have a salvage value of...

  • Your company is looking at updating its production process by adding a new piece of equipment....

    Your company is looking at updating its production process by adding a new piece of equipment. The company uses a 9% cost of capital in its capital budgeting decisions. The new equipment will cost $350,000 and the company expects the following annual cash flows for 5 years as a result of the purchase (note that year 1 is negative): Year 1 (10,000) Year 2 45,000 Year 3 127,000 Year 4 168,000 Year 5 145,000 Continuing the scenario from question 1:...

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