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

----------------------------------------------

Please rework the prior problem to determine what annual sales volume is needed to generate a net present value of $0? To do this you will need to review the problem in the book and its excel answer. I will repeat the instructions here. You will need to calculate the net present value in the traditional way. You must make sure that the second year sales references the first year ( plus first year in the formula). You will then do a goal seek to solve this problem The goal seek function is accessed by clicking on the DATA tab -- then clicking on the what if box -- then clicking on the goal seek box. To use this function, you will set the npv cell to zero by changing the first years sales cell.