Finances (2) Excel Off AutoSave OSearch QuickBooks Help View Review Data Formulas Page Layout Draw Insert File Home Wrap Text General 11 A A X Cut Calibri Condit $ .% 43 Copy Paste EMerge & Center Formatt A BIU Format Painter Number Alignment Font Clipboard Peter Lewis B5 H G E F C A Game Card 1 2 Financial Statements 3 December 31, 2017 4 Peter Lewis 5 Prepared By To provide financial information about the current state 6 Purpose of the Game Card store 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Documentation Income Statement Expenses Balance Sheet Cash Flow Draw Page Insert Home File Wra A A X Cut 20 Calibri Light 1 Me A Paste Copy BIU Format Painter Alignment Font Clipboard Game Card A1 B A Game Card 1 2 Income Statement 3 January 1, 2017 to December 31, 2017 5 Income 6 Gross Sales 7 Less returns and allowances 8 Net Sales $ 417,600 34,100 383,500 10 Cost of Goods 11 Inventory, January 1 12 Purchases 13 Delivery Charges 14 Total Merchandise Handled 123,200 78,000 14,400 215,600 15 16 Less Inventory, December 31 114,600 17 18 Cost of Goods Sold 101,000 19 20 Gross Profit 282,500 21 22 Interest Income 3,700 23 Total Income 286,200 Expenses Documentation Income Statement Balance Sheet Cash Fl Calculate Type here to search CO Review View Data Formulas Draw Page Layout Home Insert File XCut 22 Wr 20 A A Calibri Light Copy Paste WEEEEMe A BIU Format Painter Font Alignment Clipboard fr Game Card A1 A 19 20 Gross Profit 282,500 21 22 Interest Income 23 Total Income 3,700 286,200 24 25 Expenses 26 Salaries and Benefits 27 Utilities 28 Rent 29 Office Supplies 125,200 14,300 10,100 6,800 30 Insurance 4,500 31 Advertising 32 Website 9,300 3,100 8,700 182,000 33 Taxes & Licenses 34 Total Expenses 35 36 Net Income 104,200 37 38 39 40 41 42 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate Type here to search Jil Excel Finances (2) OSearch Help QuickBooks Chart Design Format View Review Mo Switch Row/ Select Data Change Chart Type Cha Column Data Type Loca Chart Styles + GAME CARD EXPENSES Taxes & Licenses Website 5% Advertising 2% Y 5% Insurance 2% Office Supplies 4% Rent 5% Utilities 8 % Salaries and Benefits 69% AutoSave Off 41 Formulas Review View Help C File Page Layout Data Home Insert Draw X Cut Wrap Text A A 20 Calibri Light [B Copy Paste A BIU Merge & Center Format Painter Clipboard Font Alignment for A1 Game Card A B C E F G H Game Card 2 Balance Sheet 3 December 31, 2017 4 Current 6 Assets Amounts % of Total Current Assets 7 Cash S 15,500 8.4% Accounts Receivable Inventory Fixed Assets 5,500 Cash 3.0% 15% 114,600 #Accourts Recevable 62.1% 12% 10 21,800 Inventory 11.8 % 11 Other Fived Assets 27,200 184,600 14.7% 62 % 12 Total Assets Other 100.0 % 13 14 Liabilities Amounts % of Total 15 Accounts Payable Current Liabilities S 13,100 9.2% 16 Business Loans 75,200 31,400 53.0% Accourts Payable 16% Capital Investments Other Debts 19 Total Liabilities 17 22.1 % 18 Business Loans 22,300 15.7 % 100.0% 22% $ 142,000 Capital Investmerts 53M 20 Other Debts 21 Net Worth 22 Total Liabilities and Equity 42,600 184,600 23.1% 100.0% 23 24 25 26 27 28 29 30 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate Help View Review Data Formulas Page Layout Draw Insert File Home Wrap Text 20 X Cut A A Calibri Light Copy Paste Merge & Cente WEEEE A B IU Format Painter Alignment Font Clipboard fr Game Card A1 D B A Game Card 1 2 Cash Flow Statement 3 End of Year: 2017 4 5 Operating Cash Flow Net Income After Tax $ 104,200 3,200 7 Depreciation Increase in Accounts Receivable 8 (9,100) (15,300) (4,700) 6,300 84,600 Increase in Inventory Decrease in Accounts Payable Increase in Accrued Expenses 12 Total Operating Cash Flow 10 11 13 14 Investing Cash Flow Purchase of Equipment 15 (31,500) 16 Decrease in Notes Receivable 700 17 Total Investing Cash Flow (30,800) 18 19 Financing Cash Flow 20 Increase in Long Term Notes Payable $ 21,500 4,500 21 Increase in Term Loan 22 Conversion of Notes to Shareholders 23 Total Financing Cash Flow. Documentation 26.000. Balance Sheet Income Statement Expenses Cash Flow Calculate Tyne hero to Off AutoSave View Review Formulas Data File Home Insert Draw Page Layout XCut 2 Wrap Calibri Light 20 A A = Paste Copy EMerge A BIU Format Painter Alignment Font Clipboard fr A1 Game Card B Decrease in Accounts Payable Increase in Accrued Expenses 12 Total Operating Cash Flow 10 (4,700) 6,300 11 84,600 13 14 Investing Cash Flow Purchase of Equipment 15 $ (31,500) 700 (30,800) 16 Decrease in Notes Receivable 17 Total Investing Cash Flow 18 19 Financing Cash Flow 20 Increase in Long Term Notes Payable 21,500 4,500 21 Increase in Term Loan 22 Conversion of Notes to Shareholders 23 Total Financing Cash Flow 26,000 24 25 Total Cash Flow 26 Cash at beginning of the year 79,800 73,100 27 28 Cash at the end of the year 152,900 29 30 31 32 33 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate Finances (2) Excel Off AutoSave OSearch QuickBooks Help View Review Data Formulas Page Layout Draw Insert File Home Wrap Text General 11 A A X Cut Calibri Condit $ .% 43 Copy Paste EMerge & Center Formatt A BIU Format Painter Number Alignment Font Clipboard Peter Lewis B5 H G E F C A Game Card 1 2 Financial Statements 3 December 31, 2017 4 Peter Lewis 5 Prepared By To provide financial information about the current state 6 Purpose of the Game Card store 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Documentation Income Statement Expenses Balance Sheet Cash Flow Draw Page Insert Home File Wra A A X Cut 20 Calibri Light 1 Me A Paste Copy BIU Format Painter Alignment Font Clipboard Game Card A1 B A Game Card 1 2 Income Statement 3 January 1, 2017 to December 31, 2017 5 Income 6 Gross Sales 7 Less returns and allowances 8 Net Sales $ 417,600 34,100 383,500 10 Cost of Goods 11 Inventory, January 1 12 Purchases 13 Delivery Charges 14 Total Merchandise Handled 123,200 78,000 14,400 215,600 15 16 Less Inventory, December 31 114,600 17 18 Cost of Goods Sold 101,000 19 20 Gross Profit 282,500 21 22 Interest Income 3,700 23 Total Income 286,200 Expenses Documentation Income Statement Balance Sheet Cash Fl Calculate Type here to search CO Review View Data Formulas Draw Page Layout Home Insert File XCut 22 Wr 20 A A Calibri Light Copy Paste WEEEEMe A BIU Format Painter Font Alignment Clipboard fr Game Card A1 A 19 20 Gross Profit 282,500 21 22 Interest Income 23 Total Income 3,700 286,200 24 25 Expenses 26 Salaries and Benefits 27 Utilities 28 Rent 29 Office Supplies 125,200 14,300 10,100 6,800 30 Insurance 4,500 31 Advertising 32 Website 9,300 3,100 8,700 182,000 33 Taxes & Licenses 34 Total Expenses 35 36 Net Income 104,200 37 38 39 40 41 42 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate Type here to search Jil Excel Finances (2) OSearch Help QuickBooks Chart Design Format View Review Mo Switch Row/ Select Data Change Chart Type Cha Column Data Type Loca Chart Styles + GAME CARD EXPENSES Taxes & Licenses Website 5% Advertising 2% Y 5% Insurance 2% Office Supplies 4% Rent 5% Utilities 8 % Salaries and Benefits 69% AutoSave Off 41 Formulas Review View Help C File Page Layout Data Home Insert Draw X Cut Wrap Text A A 20 Calibri Light [B Copy Paste A BIU Merge & Center Format Painter Clipboard Font Alignment for A1 Game Card A B C E F G H Game Card 2 Balance Sheet 3 December 31, 2017 4 Current 6 Assets Amounts % of Total Current Assets 7 Cash S 15,500 8.4% Accounts Receivable Inventory Fixed Assets 5,500 Cash 3.0% 15% 114,600 #Accourts Recevable 62.1% 12% 10 21,800 Inventory 11.8 % 11 Other Fived Assets 27,200 184,600 14.7% 62 % 12 Total Assets Other 100.0 % 13 14 Liabilities Amounts % of Total 15 Accounts Payable Current Liabilities S 13,100 9.2% 16 Business Loans 75,200 31,400 53.0% Accourts Payable 16% Capital Investments Other Debts 19 Total Liabilities 17 22.1 % 18 Business Loans 22,300 15.7 % 100.0% 22% $ 142,000 Capital Investmerts 53M 20 Other Debts 21 Net Worth 22 Total Liabilities and Equity 42,600 184,600 23.1% 100.0% 23 24 25 26 27 28 29 30 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate Help View Review Data Formulas Page Layout Draw Insert File Home Wrap Text 20 X Cut A A Calibri Light Copy Paste Merge & Cente WEEEE A B IU Format Painter Alignment Font Clipboard fr Game Card A1 D B A Game Card 1 2 Cash Flow Statement 3 End of Year: 2017 4 5 Operating Cash Flow Net Income After Tax $ 104,200 3,200 7 Depreciation Increase in Accounts Receivable 8 (9,100) (15,300) (4,700) 6,300 84,600 Increase in Inventory Decrease in Accounts Payable Increase in Accrued Expenses 12 Total Operating Cash Flow 10 11 13 14 Investing Cash Flow Purchase of Equipment 15 (31,500) 16 Decrease in Notes Receivable 700 17 Total Investing Cash Flow (30,800) 18 19 Financing Cash Flow 20 Increase in Long Term Notes Payable $ 21,500 4,500 21 Increase in Term Loan 22 Conversion of Notes to Shareholders 23 Total Financing Cash Flow. Documentation 26.000. Balance Sheet Income Statement Expenses Cash Flow Calculate Tyne hero to Off AutoSave View Review Formulas Data File Home Insert Draw Page Layout XCut 2 Wrap Calibri Light 20 A A = Paste Copy EMerge A BIU Format Painter Alignment Font Clipboard fr A1 Game Card B Decrease in Accounts Payable Increase in Accrued Expenses 12 Total Operating Cash Flow 10 (4,700) 6,300 11 84,600 13 14 Investing Cash Flow Purchase of Equipment 15 $ (31,500) 700 (30,800) 16 Decrease in Notes Receivable 17 Total Investing Cash Flow 18 19 Financing Cash Flow 20 Increase in Long Term Notes Payable 21,500 4,500 21 Increase in Term Loan 22 Conversion of Notes to Shareholders 23 Total Financing Cash Flow 26,000 24 25 Total Cash Flow 26 Cash at beginning of the year 79,800 73,100 27 28 Cash at the end of the year 152,900 29 30 31 32 33 Documentation Income Statement Expenses Balance Sheet Cash Flow Calculate