Using the financials for Starbucks 2016(DATA ATTACHED), which you have, calculate the NPV and IRR of opening a new store. Make whatever assumptions you need to calculate the cash flow. Discount the cash flows at the WACC you already calculated for Starbucks.(WACC=5.65%)

Use the Starbucks 2016 financials to calculate the cash flow to be obtained in first ways, for both ways use 25,000 stores: 1-Subtract the depreciation and amortization expense from the total operating expense. 2-Subtract the result obtained in part 1 from the total net revenues. 3-Consider the average Starbucks store to cost $500,000, calculate the depreciation for this store over 15 years. 4-Calculate the cash flows per store with these measures 5-Using the WACC you already have, calculate the NPV and IRR for a store over 15 years. Suppose the cash flow does not vary over time.

Balance Sheet All numbers in thousands Period Ending Current Assets Cash And Cash Equivalents Short Tem Investments Net Receivables Inventory 10/2/2016 2,128,800 134.400 768,800 1,378,500 Other Current Assets 347.400 Total Current Assets Long Term Investments Property Plant and Equipment 4,757,900 1,496,200 4,533,800 1,719,600 516,300 Goodwill Intangible Assets Accumulated Amortization Other Assets 403,300 885,400 14,312,500 Defered Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities 2,975,700 399,900 1,171,200 4,546,800 3, 185,300 689,700 Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities 6,700 8,428,500 Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets 1,500 5,949,800 41,100 108,400 5,884,000 3,648,100