Question: PLEASE SHOW IN EXCEL. I have 80% complete trying to figure why my math is off Bobs Submarine Sandwiches expects annual sales of $198,000, annual

PLEASE SHOW IN EXCEL. I have 80% complete trying to figure why my math is off

Bobs Submarine Sandwiches expects annual sales of $198,000, annual fixed cash outlays are $57,750 a year at each location, variable cash outlays are 36 percent of sales, depreciation is $14,000 per year, and taxes are 24% (of pretax income). Opening promotion and other costs require an initial outlay of $86,000. The company does its analysis based on an 8-year store life. Bob believes the business can be sold for $118,000 after taxes (disposal value) at the end of its 8-year lifer. Using a 7.5% required return, what is the net present value of this venture?

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 Finance Questions!

The following are annual rates of return for U.S. government T-bills and U.S. common stocks. a. Compute the arithmetic mean rate of return and standard deviation of rates of return for the two...

Please see the attached instructions forwhat is required for this question For this assignment, you will complete the Financial Overview component of Amazon. To complete this assignment, use the...

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

Need help answering questions 8 and 9 on the attached spreadsheet and below....

I attached information regarding this project, i also attached the financials and also a sample of what i need. the chosen industry isSunCoke Energy Partners LP (NYS: SXCP). This is a 15 to 20 pages...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Hello, I attached the excel and word attachment to help with this practice problem. If you have any questions please let me know. Thanks Introduction: You are the senior financial analyst for Fosbeck...

Please present your recommendations in a report written for your supervisor, the firm Controller. Clearly show your analysis and communicate your conclusions and recommendations. Support your report...

Can you help me complete tabs 8 till 18 please You can input the formulas on the cells that way I know how you got the results YZ7742 I SEE THE LIGHT www.cybertext.com, The Book List, Building Blocks...

just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question 2..BTW,please focus the every step FINANCE SPOTLIGHT...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

After graduating from Yorkville University, you begin working as a senior manager for a major office cleaning company. Your boss has hired you at a salary of $127,000 per year because of your honesty...

1. SVM. Consider a supervised learning problem in which the training examples are points in 2-dimensional space. The positive examples (samples in class 1) are (1, 1) and (-1,-1). The negative...

Which of the following statements is correct? A South African company has the following financial information: Earnings R 1 5 million Capital expenditure R 2 1 million Depreciation R 8 million Debt...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".