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 want

image text in transcribed
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

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions