103 398
Assignments Done
98.5%
Successfully Done
In November 2021

Question #173169

Suppose you are considering opening a deli in Rockville Centre. After looking at many potential locations, you find one which you believe is ideal. You purchase the location of a former CVS store. The purchase price of the building was $475,000. In addition, you need to invest another$200 to make the location suitable as a deli store. Assume these capital investments have an average life of five yrs with a $50,000 salvage value You estimate your initial investment in working capital is$145,000.  Assume going forward that net working capital is 25% of sales

You estimate first-year sales of $2,300,000 and you expect sales to increase at an annual rate of 2.3%. Your year 1 (2021) cost of goods (COGS) is estimated at 64% of sales and that percent declines 2% annually for the following four years.Your year 1 (2021) annual rent, utilities, insurance and other related costs (SG&A) is$175,000 per year and increases by \$2,500 annually for the following four years.

1
2021-03-22T12:04:04-0400

calculate investments, income and expenses in EXCEL

Thus, we can see that by the third year, the investment project will pay off

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!