Barry's Beer and Bacon Barn is a local brewery and bacon smokery based in West Kelowna,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Barry's Beer and Bacon Barn is a local brewery and bacon smokery based in West Kelowna, B.C. that caters to a varied clientele. Their tasting room is always full, but they are having a difficult time lately keeping up with demand, resulting in frequent 'stock-outs' of their popular craft beer. This situation is nothing new, but Barry Allmark, the owner, always figured it was better to have customers and no beer, rather than the other way around. Barry has been the brewmaster since the business opened back in 2012, and the used brewing equipment he purchased back then is now well past its useful life. Barry feels it is now time for a state-of-the-art brewing system that will allow for greater flow rates. The new equipment will allow the brewery to meet the ever-increasing demand, and to expand its product line to include some new and popular beers (including the recently launched, 'Okanagan Apple Sour'). After deciding on the supplier for the new equipment, Barry was trying to decide whether he should lease it or purchase it outright. As a frequent customer, Barry has reached out to you asking for help assessing the two financing options. While pouring a pint of your favourite Hazy IPA, Barry summed up the situation by saying, "I brew beer, you know the numbers stuff! If you can help me with this decision how to finance the new equipment, you'll have an open bar tab here for the rest of the year, ON ME!" After concluding that Barry's offer is too good to pass on, you gather the following information: Purchase Option Purchase price Salvage value after 10 years Annual maintenance costs $ $ $ Other Information Annual cost savings (after tax) New equipment useful life CCA Rate for new equipment ** Tax rate Lease Option * Annual payment $ * With the lease option, all maintenance is included. 500,000 60,000 18,000 $ 85,000 Paid at the beginning of each year 75,000 Due to efficiencies with the new equipment. 10 years 20% 35% Discount rate 6% ** Assume the half-year rule at acuisition. Ignore any lost future CCA at disposal (for simplicity). Required: 1. Complete the following quantitative analysis: a. Determine the net present value (NPV) for each financing option. b. Determine the following other measures for each financing option: ii. Internal rate of return (IRR). ii. Modified internal rate of return (MIRR). c. Determine the NPV for the lease option if the annual lease payment was decreased to $80,000. Barry's Beer and Bacon Barn is a local brewery and bacon smokery based in West Kelowna, B.C. that caters to a varied clientele. Their tasting room is always full, but they are having a difficult time lately keeping up with demand, resulting in frequent 'stock-outs' of their popular craft beer. This situation is nothing new, but Barry Allmark, the owner, always figured it was better to have customers and no beer, rather than the other way around. Barry has been the brewmaster since the business opened back in 2012, and the used brewing equipment he purchased back then is now well past its useful life. Barry feels it is now time for a state-of-the-art brewing system that will allow for greater flow rates. The new equipment will allow the brewery to meet the ever-increasing demand, and to expand its product line to include some new and popular beers (including the recently launched, 'Okanagan Apple Sour'). After deciding on the supplier for the new equipment, Barry was trying to decide whether he should lease it or purchase it outright. As a frequent customer, Barry has reached out to you asking for help assessing the two financing options. While pouring a pint of your favourite Hazy IPA, Barry summed up the situation by saying, "I brew beer, you know the numbers stuff! If you can help me with this decision how to finance the new equipment, you'll have an open bar tab here for the rest of the year, ON ME!" After concluding that Barry's offer is too good to pass on, you gather the following information: Purchase Option Purchase price Salvage value after 10 years Annual maintenance costs $ $ $ Other Information Annual cost savings (after tax) New equipment useful life CCA Rate for new equipment ** Tax rate Lease Option * Annual payment $ * With the lease option, all maintenance is included. 500,000 60,000 18,000 $ 85,000 Paid at the beginning of each year 75,000 Due to efficiencies with the new equipment. 10 years 20% 35% Discount rate 6% ** Assume the half-year rule at acuisition. Ignore any lost future CCA at disposal (for simplicity). Required: 1. Complete the following quantitative analysis: a. Determine the net present value (NPV) for each financing option. b. Determine the following other measures for each financing option: ii. Internal rate of return (IRR). ii. Modified internal rate of return (MIRR). c. Determine the NPV for the lease option if the annual lease payment was decreased to $80,000.
Expert Answer:
Answer rating: 100% (QA)
Quantitative Analysis of Financing Options for Barrys Beer and Bacon Barn 1 Purchase Option a Net Present Value NPV Year Cash Flow Discount Factor 6 P... View the full answer
Related Book For
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey
Posted Date:
Students also viewed these accounting questions
-
Barry recently sold some stock after holding it for two years. The stocks price rose 150% during the first year, but fell 40% in the second year. At what price did he buy the stock if he sold it for...
-
New Belgium Brewing Company has expanded its product offerings to include many varieties of specialty and seasonal brews. Kim Jordan, CEO of New Belgium Brewing Company, realizes that financial...
-
A local brewery distributes beer in bottles labeled 32 ounces. A government agency thinks that the brewery is cheating its customers. The agency selects 50 of these bottles, measures their contents...
-
For this final discussion board, please reflect back on your accounting courses and answer the following questions: 1. Which course in the accounting program did you find to be the most difficult? 2....
-
1. What was the nature of the interest that Clayton transferred to his daughter, Marion Watkins? 2. Why didnt Bernis become the severalty owner of the Somerset property upon Claytons death? 3. How...
-
At NIL Team, our mission is to empower athletes by equipping them with the essential information, resources, and networks needed to make well-informed decisions regarding NIL deals. We recognize the...
-
A tattoo shop has the following revenue stream over a 5 -year period: $\$ 9,000, \$ 17,000, \$ 19,000, \$ 11,000$, and $\$ 22,000$. What is the EUAW of this business (assume $\mathrm{i}=12 \%$ ).
-
LLL Avionics Ltd. has contacted your certified general accounting firm to inquire about the cost of an external audit. The company's president explained that he feels that "the previous auditor...
-
Windsor Advertising was founded in January 2013. Presented below are adjusted and unadjusted trial balances as of December 31, 2020. WINDSOR ADVERTISING TRIAL BALANCE DECEMBER 31, 2020 Unadjusted Dr....
-
Refer back to the beginning of this chapter to the excerpt from a Los Angeles Times article about Reed Slatkin's fraud. The article insinuates that the FBI and IRS's raiding of Slatkin's office...
-
Consider an Open Economy with Fixed Exchange Rate. What is the accompanying movement in IS/LM when AS shifts. Assume that AD is downward sloping and does not shift. a. IS shift b. LM shift c. Both a....
-
A small hydro turbine is placed between tank 1 and tank 2. The water is flowing at a mass flow rate of 2.2 kg/s from tank 1 to tank 2. There are three pipe sections between the two tanks as follow:...
-
1. Figure (a) shows the Staubli 6R robot, with its zero configuration shown in Figure (b). Draw appropriate link reference frames, and derive the Denavit-Hartenberg parameters. STUBLI TX40 STUBLI (a)...
-
10. At a certain point at the beach, the coast line makes a right angle bend, as shown in part (a) of the below figure. The flow of salt water in this bend can be approximated by the potential flow...
-
A coolant is transported in a pipe with external wall temperature of -30 C and with outer diameter of 10 cm. The tube is thermally isolated by two layers: 1) an internal layer of foamed polypropylene...
-
Fig. shows a plate cam with translatingin-line roller follower and a plate cam with translating offset roller follower. R=100 mm, OA=20 mm, e=10 mm, r =10 mm. Indicate the pressure angles and the...
-
$10,000 is used to purchase an appropriate size annuity that has level annual payments for 16 years. The price of the annuity is based on an effective annual rate of 8.8%. As each payment is...
-
Write a paper detailing a geographic information system (GIS) of your own design that would utilize data in an original manner.
-
The Mavericks are a professional football team with a long tradition of winning. However, over the last three years, the team has not won a major championship, and attendance at games has dropped...
-
Becky Tan is the CFO at Frosters Systems, a diversified company with eight different business units (divisions). Becky has been asked by the CEO to develop a shared bonus pool system. Required What...
-
Recently the Victorian Government introduced a solar rebate of $2500 for eligible home owners. How might such an initiative impact on the budget variances for a business that installs solar panels...
-
Give an example of a requirement on a computer printer.
-
Briefly describe the distinction between requirements and specification.
-
Give an example of a requirement on a digital still camera.
Study smarter with the SolutionInn App