Purchase Solution

Capital Budgeting in Excel for Beryl Iced Tea

Not what you're looking for?

Ask Custom Question

Submit answer in an Excel spreadsheet:

Beryl's Iced Tea currently rents a bottling machine for $50,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 $20,000 per year in ongoing maintenance expenses.

b. Purchase a new, more advanced machine for $250,000. This machine will require $ 15,000 per year in ongoing maintenance expenses and will lower bottling costs by $10,000 per year. Also, $35,000 will be spent up front in training the new operators of the machine.

Suppose the appropriate discount rate is 8% 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 ten-year life with a negligible salvage value. The marginal corporate tax rate is 35%. Should Beryl's Iced Tea continue to rent, purchase its current machine, or purchase the advanced machine?

Purchase this Solution
Solution Summary

Capital Budgeting is presented.

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

View More Free Quizzes
Related BrainMass Solutions

  • Lease Versus Purchase Decision

    372697 Finance: Beryl's Iced Tea machine, continue to rent, buy, buy new machine Beryl's Iced Tea currently rents a bottling machine for $50,000 per year, including all maintenance expenses.

  • Calorimetry involving temperature and phase changes in making iced tea

    29609 temperature and phase changes in making iced tea See attached file. Calorimetry involving temperature and phase changes in making iced tea.

  • Heterogeneous and homogeneous mixture

    Homogeneous mixtures contain only 1 phase and usually we can't separate the individual phases a) Iced tea: heterogeneous because we can separate the ice from the tea b) Salad: heterogeneous because it contains a lot of things in there that we can

  • Assessing Marketing Opportunities

    The tea also refreshes and makes supple a person's skin (Edgar, 2011). The relative price for the product is similar to market price of iced tea drink in other companies.

  • Food Manufacturing Company Project Proposal: Reily Foods

    Use of the CBK (Common Body of Knowledge) areas For food manufacturing in the United States you can use companies such as Lipton or Sara Lee. I've loosely based my answers on Reily Foods Company / Luzianne Iced tea.

  • Parent-child (or caregiver-child) communication

    to her child when she picked up the wrong bottle of iced tea for the parent in a different aisle. The child's face grew red and then she hung her head in disappointment.

  • Arguments and Fallacies

    Sandy Beach's past history and lack of formal qualifications are irrelevant to whether she has a good argument for bi-lingual education. 10. Green tea is leafy, green, aromatic, and tastes great as an iced or hot beverage.

  • Why does differentiation occur in an organization?

    Consider the example of soft drinks, you have different kinds of soft drinks, coke, Pepsi, sprite, iced tea (products are differentiated) but you cannot say one is strictly better than the other (and even if you ranked them, someone else will disagree

  • Alternative Capital Budgeting Techniques

    Finally, it discusses the most- and least-valuable capital budgeting techniques, and why they were listed as such. Attached in Excel.

View More Related Solutions