Paste Font Clipboard C37 A 48 3-1 Purchase Inventory 49 for $3,000 cash 50 51 3-2 Revenue Growth +20% 52 Service Revenue $47,500 53 Sales Rey $4,000; COGS $2,000 54 55 3-3 Debt Repayment @ 1/1/yr3 56 1/4 of Original Note 57 58 3-4 Operating Expenses 59 (Salaties $10.600 60 Rent $6.000 61 Insurance & Utilities $4,000 62 Advertising $1000 63 Maintenance $5,000) 64 Total Operating Exp. $26,600 65 Depreciation Exp. equip.cost x 17 66 Interest Exp. - Note Pay. * 8%x12/13 67 68 3.5 Dividend Payment 69. Common Stock x 10% 70 Horizontal Transact be here to search Search Save OD Big Picture Project ACC 2001 2000 (1) Ercel Page Layout Formules Data Review View Help De sert le Home Number $ -% 93 Sinert De INFO X ca - 12-AA 13 Wap Tort BIURO-A-Mer & Center Conditional Format Cell Foming Table Style Styles umber Al Font Opboard > G Income Statement Revenue Expense 31 Big Picture Project Horizontal Transaction Analysis Balance Sheet 33 Assets Year Cash Accumulated How Inventory Equipment Depreciation Liabilities Notes Stockholders Equity Common Retained Cock Farines 16 11 3T 29 40 - 45 34 4334 4 cont 46 o 18 Type here to search 8 7 9 0 3 4 5 E R T Year 4 1 Big Picture Project 2020 Survey Proforma Statements for Bert's Bikes 2 Year 1 Year 2 Year 3 3 Income Statement 4 Service Revenue 5 Sales Revenue 6 Total Revenue 7 Cost of Goods Sold 8 Operating Expenses 19 Depreciation Expense 10 Interest Expense 11 Total Expense 12 Net Income fo A15 Beginning Common Stock D E B 13 Statement of Stockholders Equity 14 15 Beginning Common Stock 16 Plus: Common Stock Issued 17 Ending Common Stock 18 Beginning Retained Earnings 19 + Net Income 20 - Dividends 21 Ending Retained Earnings 22 Total Stockholders Equity 23 Balance Sheet 1 5 Assets 6 Cash 7 Inventory 8 Equipment 9 Accumulated Depreciation 30 Total Assets 31 Liabilities 32 Notes Payable 33 Total Liabilities 34 Stockholders Equity 35 Common Stock 36 Retained Earnings 37 Total Stockholders Equity 38 Total Liabilities & SE 39 4 Horizontal Transaction Analysis Sheet Financial Statements Transaction Detail A15 X Beginning Common Stock D E B C Statement of Cash Flows 40 41 Net Cashflow from Operating 42 Net Cashflow from Investing 43 Net Cashflow from Financing 44 Net Change in Cash 45 Beginning Cash Balance 46 Ending Cash Balance 47 48 49 Paste Font Clipboard C37 A 48 3-1 Purchase Inventory 49 for $3,000 cash 50 51 3-2 Revenue Growth +20% 52 Service Revenue $47,500 53 Sales Rey $4,000; COGS $2,000 54 55 3-3 Debt Repayment @ 1/1/yr3 56 1/4 of Original Note 57 58 3-4 Operating Expenses 59 (Salaties $10.600 60 Rent $6.000 61 Insurance & Utilities $4,000 62 Advertising $1000 63 Maintenance $5,000) 64 Total Operating Exp. $26,600 65 Depreciation Exp. equip.cost x 17 66 Interest Exp. - Note Pay. * 8%x12/13 67 68 3.5 Dividend Payment 69. Common Stock x 10% 70 Horizontal Transact be here to search Search Save OD Big Picture Project ACC 2001 2000 (1) Ercel Page Layout Formules Data Review View Help De sert le Home Number $ -% 93 Sinert De INFO X ca - 12-AA 13 Wap Tort BIURO-A-Mer & Center Conditional Format Cell Foming Table Style Styles umber Al Font Opboard > G Income Statement Revenue Expense 31 Big Picture Project Horizontal Transaction Analysis Balance Sheet 33 Assets Year Cash Accumulated How Inventory Equipment Depreciation Liabilities Notes Stockholders Equity Common Retained Cock Farines 16 11 3T 29 40 - 45 34 4334 4 cont 46 o 18 Type here to search 8 7 9 0 3 4 5 E R T Year 4 1 Big Picture Project 2020 Survey Proforma Statements for Bert's Bikes 2 Year 1 Year 2 Year 3 3 Income Statement 4 Service Revenue 5 Sales Revenue 6 Total Revenue 7 Cost of Goods Sold 8 Operating Expenses 19 Depreciation Expense 10 Interest Expense 11 Total Expense 12 Net Income fo A15 Beginning Common Stock D E B 13 Statement of Stockholders Equity 14 15 Beginning Common Stock 16 Plus: Common Stock Issued 17 Ending Common Stock 18 Beginning Retained Earnings 19 + Net Income 20 - Dividends 21 Ending Retained Earnings 22 Total Stockholders Equity 23 Balance Sheet 1 5 Assets 6 Cash 7 Inventory 8 Equipment 9 Accumulated Depreciation 30 Total Assets 31 Liabilities 32 Notes Payable 33 Total Liabilities 34 Stockholders Equity 35 Common Stock 36 Retained Earnings 37 Total Stockholders Equity 38 Total Liabilities & SE 39 4 Horizontal Transaction Analysis Sheet Financial Statements Transaction Detail A15 X Beginning Common Stock D E B C Statement of Cash Flows 40 41 Net Cashflow from Operating 42 Net Cashflow from Investing 43 Net Cashflow from Financing 44 Net Change in Cash 45 Beginning Cash Balance 46 Ending Cash Balance 47 48 49
