FIN3250 Term Project Instruction 1) Use CSU Caf's Income Statement, Balance Sheet and Cash Flow Statement for the last three fiscal Years and recreate a 3-statement financial statements. *Input P&L to derive a Net Income, Link each period's Net Income to that year's Balance Sheet, Generate Cashflow statement from the changes on Balance sheet using the indirect methods (no need to calculate cash flow for 2013), and finally link the Balance Sheet's Cash to the Cash Flow produced in the Cash Flow Statement. **Do not use CSU Cafe's Cash Flow Statement numbers to replicate Cash Flow Statement. I provide Cash Flow Statement only for you to find depreciation and dividend, which are not available on income statement. 2) Create a common sized Income Statement and Balance Sheet 3) CSU Cafe's General and Administrative Expenses on the Income Statement includes the Company's Depreciation expense. As a result, you need to go to the Company's Cash Flow Statement and find the annual depreciation amount, input that number, and subtract that number from the General and Administrative Expenses to input to the General and Administrative Expenses on the template. ***Certain plug numbers will be provided in this spreadsheet template. Read the comments carefully. 3/17/2024 3:17 AM CSU Caf Inc Income Statement for the Years 2013 through 2015 (FYE December 31, $ in millions) 1 Revenue 1 Cost of Revenue Food & Beverage and Packaging 1 Labor 1 Occupancy 1 Other Operating costs 1 Total Cost of Revenue 1 Gross Profit Operating Expense 1 General and Administrative 1 1 Depreciation and Amortization Pre-opening Costs 1 Other Expense (Income) 1 Total Operating Expense 1 Earnings Before Interest & Taxes (EBIT) 1 Other Operating Expense (Income) Interest and Other (Income) 1 Interest Expense 1 Other 1 Total Other Operating Expense (Income) 1 Earnings Before Taxes (EBT) 1 Income Tax 1 Net Income 1 EBITDA 3/17/2024 3:17 AM $ 2013 2014 2015 Consolidated Statement of Income In millions, except per share data REVENUES Sales by Company-operated restaurants Revenues from franchised restaurants Total revenues OPERATING COSTS AND EXPENSES Company-operated restaurant expenses Food & paper Payroll & employee benefits Occupancy & other operating expenses Franchised restaurants-occupancy expenses Selling, general & administrative expenses Other operating (income) expense, net Years ended December 31, 2015 2014 2013 $18,874.2 9,231.5 28,105.7 $18,602.5 8,964.5 27,567.0 $18,292.8 8,713.2 27,006.0 6,361.3 6,318.2 6,167.2 4,824.1 4,710.3 4,606.3 4,393.2 4,195.2 4,064.4 1,624.4 1,527.0 1,481.5 2,385.6 2,455.2 2,393.7 (247.2) (243.5) (236.8) Total operating costs and expenses 19,341.4 18,962.4 18,476.3 Operating income 8,764.3 8,604.6 8,529.7 Interest expense-net of capitalized interest of $15.5, $15.9 and $14.0 521.9 516.6 492.8 Nonoperating (income) expense, net 37.9 Income before provision for income taxes 8,204.5 9.0 8,079.0 24.7 8,012.2 Provision for income taxes 2,618.6 2,614.2 2,509.1 Net income $ 5,585.9 $ 5,464.8 $ 5,503.1 Earnings per common share-basic $ 5.59 $ 5.41 $ 5.33 Earnings per common share-diluted Dividends declared per common share Weighted-average shares outstanding-basic Weighted-average shares outstanding-diluted $ 3.12 998.4 1,006.0 $ 5.55 $ 5.36 $ 5.27 $ 2.87 $ 1,010.1 2.53 1,032.1 1,020.2 1,044.9