Beryl's Iced Tea currently rents a bottling machine for $52,000 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options: a. Purchase the machine it is currently renting for $150,000. This machine will require $22,000 per year in ongoing maintenance expenses. b. Purchase a new, more advanced machine for $260,000. This machine will require $19,000 per year in ongoing maintenance expenses and will lower bottling costs by $13,000 per year. Also, $40,000 will be spent upfront training the new operators of the machine. Suppose the appropriate discount rate is 9% per year and the machine is purchased today. Maintenance and bottling costs are paid at the end of each year, as is the rental of the machine. Assume also that the machines will be depreciated via the straight-line method over seven years and that they have a 10-year life with a negligible salvage value. The corporate tax rate is 35%. Should Beryl's Iced Tea continue to rent, purchase its current machine, or purchase the advanced machine? Note: To make this decision, calculate the NPV of the FCF associated with each alternative. The NPV will be negative, and represents the PV of the costs of the machine in each case. The NPV of renting the machine is $. (Round to the nearest dollar. Enter a negative NPV as a negative value.)

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

use excel to solve please

 
Beryl's Iced Tea currently rents a bottling machine for $52,000 per year, including all maintenance expenses. It is
considering purchasing a machine instead, and is comparing two options:
a. Purchase the machine it is currently renting for $150,000. This machine will require $22,000 per year in ongoing
maintenance expenses.
b. Purchase a new, more advanced machine for $260,000. This machine will require $19,000 per year in ongoing
maintenance expenses and will lower bottling costs by $13,000 per year. Also, $40,000 will be spent upfront training the
new operators of the machine.
Suppose the appropriate discount rate is 9% per year and the machine is purchased today. Maintenance and bottling
costs are paid at the end of each year, as is the rental of the machine. Assume also that the machines will be
depreciated via the straight-line method over seven years and that they have a 10-year life with a negligible salvage
value. The corporate tax rate is 35%. Should Beryl's Iced Tea continue to rent, purchase its current machine, or
purchase the advanced machine? Note: To make this decision, calculate the NPV of the FCF associated with each
alternative. The NPV will be negative, and represents the PV of the costs of the machine in each case.
The NPV of renting the machine is $
CICCO
(Round to the nearest dollar. Enter a negative NPV as a negative value.)
102
Transcribed Image Text:Beryl's Iced Tea currently rents a bottling machine for $52,000 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options: a. Purchase the machine it is currently renting for $150,000. This machine will require $22,000 per year in ongoing maintenance expenses. b. Purchase a new, more advanced machine for $260,000. This machine will require $19,000 per year in ongoing maintenance expenses and will lower bottling costs by $13,000 per year. Also, $40,000 will be spent upfront training the new operators of the machine. Suppose the appropriate discount rate is 9% per year and the machine is purchased today. Maintenance and bottling costs are paid at the end of each year, as is the rental of the machine. Assume also that the machines will be depreciated via the straight-line method over seven years and that they have a 10-year life with a negligible salvage value. The corporate tax rate is 35%. Should Beryl's Iced Tea continue to rent, purchase its current machine, or purchase the advanced machine? Note: To make this decision, calculate the NPV of the FCF associated with each alternative. The NPV will be negative, and represents the PV of the costs of the machine in each case. The NPV of renting the machine is $ CICCO (Round to the nearest dollar. Enter a negative NPV as a negative value.) 102
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education