Purchase Solution

Calculating project NPV: Who Dat Restaurant

Not what you're looking for?

Ask Custom Question

I know how to calculate NPV, but this problems wants me to calculate operating costs and I can not figure out sales. I really help with this one.
Thanks.

Who Dat Restaurant is considering the purchase of a $39000 souffle maker. The souffle maker has an economic
life of six years and will be fully depreciated by the straight-line method.
The machine will produce 2,500 souffles per year, with each costing $2 to make and priced at $7.
assume that the discount rate is 14% and the tax rate is 34%.
Should the company make the purchase?

CHAPTER 8: PROBLEM 1

Cost of Souffle Maker $39,000 ($39,000)
Economic Life 6 years
# of Souffles produced per year 2,500
Cost to make each Souffle $2
Price of each Souffle $7
Discount Rate 14%
Tax Rate 34%

Step 1: First calculate the Operating Cash Flow #NAME?

Step 2: Place the answer you get for your Operating Cash Flow in the year 1 thru year 6 cells below
Year 1 #NAME?
Year 2 #NAME?
Year 3 #NAME?
Year 4 #NAME?
Year 5 #NAME?
Year 6 #NAME?

Step 3: Now find the NPV. Be sure to include the initial cost by using cell C58 as it is negative
NPV = #NAME? (You will accept the project if the NPV is positive)

See attached Excel sheet for more details.

Attachments
Purchase this Solution
Solution Summary

The expert calculates the project NPV for Who Dat Restaurants.

Solution provided by:
Manal Elkhoshkhany, MBA
Education
  • BA, Ain Shams University, Cairo Egypt
  • MBA, California State University, Sacramento
Recent Feedback
  • "ty i have more need help with"
  • "ty i have jmore i need help with"
  • "great help"
  • "excellent help"
  • "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

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

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • Calculating the Internal Rate of Return

    398746 Calculating the Internal Rate of Return You are a boss of a restaurant considering the purchase of a self-ordering machine. The upfront cost is estimated to be $23,828.

  • Multiple choice

    The NPV of a relatively low risk project should be found using a relatively high WACC. Which of the following statements is CORRECT?

  • Capital budgetings

    Salary and medical costs for production personnel who will be employed only if the project is accepted.

  • NPV, Payback Period, IRR, Profitibility Index & Project NPV

    Calculating NPV Year Project A Project B 0 −$12,700 −$9,400 1 $7,000 $4,800 2 $5,500 $3,750 3 $2,500 $3,400 Problem 2.

  • Project Management Problems

    STEP 6 Three key learning points from the "Managing Project Risks" "Who could or could not do the job": Through out our project risk evaluation we have considered who would be the appropriate person to do the job.

  • Calculating the NPV for the Project

    281220 Calculating the NPV for the Project Please help with the following homework problem 11-3: 1) Calculating the NPV for the project 2) What would be the NPV if the production is not sold? Any helpful tips will help.

  • Calculate payback period and NPV

    262834 Calculate payback period and NPV Calculating payback period and NPV. Incosoft, Inc., has the following mutually exclusive projects.

  • Calculating Payback period and NPV

    annuity factor for n=8 and rate=10%=52000*5.3349=277416 NPV=-142000+277416+10263=145679 c) NPV is a positive number, product should be accepted Solution describes the steps for calculating payback period and NPV for the given investment

  • Calculating net present value of a project

    The solution assists with calculating the net present value of a project.

View More Related Solutions