Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Uncle's Caf sells regular coffee, but decides they want to offer Latte's to the menu. They expect to sell one Latte for $4.00. They

 

Uncle's Caf sells regular coffee, but decides they want to offer Latte's to the menu. They expect to sell one Latte for $4.00. They want to evaluate this decision using a break-even analysis and have hired you to do the work! They want to purchase two (2) Nespresso machines for the business to support this new product line. Details on costs are below. For this exercise, assume the following: . The useful life of the machine is 5-years Assume no salvage value in 5-years Discount Rate: 14%; Tax Rate: 24% Costs: Each machine costs $220 one-time, upfront. The cost of the machines are not amortized. To make each Latte drink the machine requires a coffee pod which costs $1.00 per pod and frothed milk $0.20 per drink. Cups, lids and other related expenses per cup are $0.20. How many Lattes must Uncle's sell per year to break-even on a Financial Basis (NPV) Basis? (1) Initially model your cash flows in Excel and calculate the NPV at 100 cups per year. (2) Then, create a separate tab (copy original) and calculate the Breakeven units using the goal seek function. Use the "Coffee Express" solution in your review problem sets plus the other resources at your disposal for guidance (notes, video lessons, etc...) Goalseek video link (3) Next, on another separate tab (copy #2) assume that taxes will rise to 35% in years 3, 4 and 5 and that pod costs will increase by 5% each year starting in year 2 (through 5).

Step by Step Solution

3.51 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

1 Computation of NPV at 100 cups per year Sale quantity 100 Sale price 400 Costs pod 100 frothed mil... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

John E Freunds Mathematical Statistics With Applications

Authors: Irwin Miller, Marylees Miller

8th Edition

978-0321807090, 032180709X, 978-0134995373

More Books

Students also viewed these Accounting questions

Question

How could loyalty programmes undermine brands?

Answered: 1 week ago