Question: please include all excel functions and steps taken. thank you! 12-3. Denver Doughnuts is considering a new store location. For accounting purposes, fixed operating costs

please include all excel functions and steps taken. thank you! please include all excel functions and steps taken. thank you! 12-3. Denver

12-3. Denver Doughnuts is considering a new store location. For accounting purposes, fixed operating costs for a store are $23,500 a year, and vari- able costs are 40 percent of sales. Compute the break-even sales level for a store location. a. If average revenue per customer is $1.40, how many customers must be served each hour to break even in earnings? (The stores are open twenty-four hours a day, 365 days a year.) b. If the price (only) is raised 10 percent, what will be the new earnings break-even point? 12-4. For Denver Doughnuts (problem 3), fixed cash outlays are $18,750 a year at each location, and variable cash outlays are 40 percent of sales. A store requires an initial outly of $60,000, and the company uses a 14 percent bintang required return. Because of changing neighborhood characteristics, the company does its analysis based on a 10-year store life. Since the loca- tions are leased, the terminal value is minimal. dana. What annual sales volume will be needed to generate a net present value of $0? b. The after-tax risk-free interest rate is 6 percent. What annual sales value will be needed to generate a net present value of $0 using a 6 percent discount rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!