this is year one create horizontal analysis and the following financial statements

Big Picture Project Transactions Plan B 1-1 Start Up Funding Sign Note for $12,000 @ 8% Issue Stock for $51,000 1-2 Purchase Equipment @1/1 Purchase showroom displays for $5,000 cash; SL Depreciation 5 yr. useful life, $0 salvage value 1-3 Purchase Inventory for $28,000 cash 1-4 Service & Sales Revenue Service Revenue $6,000 Sales Rev $50,000; COGS $25,000 1-5 Operating Expenses Salaries $6,000 Rent $10,000 Insurance & Utilities $4,000 Total Operating Exp. $20,000 Depreciation Exp. = equip. cost x 1/5 Interest Exp. = Note Pay. x 8%x12/12 Income Statement Revenue - Expense Stockholders Equity Common Retained Stock Earnings Project Horizontal Transaction Analysis Balance Sheet Assets Liabilities Year! Cash Accumulated 4 Trans flow Cash Inventory Equipment Depreciation Notes Payable Year 1 5 Balance 6 1-1 7 1-1 8 1-2 9 13 10 1-4 11 1-4 121-4 13 1-5 14 1-5 15 1-5 16 Closing 17 Total 18 Year 5 B D E Big Picture Project 2020 Survey Proforma Statements for Bert's Bikes Year 1 Year 2 Year 3 Year 4 Income Statement Service Revenue - Sales Revenue Total Revenue 7 Cost of Goods Sold 8 Operating Expenses 9 Depreciation Expense 10 Interest Expense 11 Total Expense 12 Net Income 13 14 Statement of Stockholders Equity 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 24 Balance Sheet 25 Assets 26 Cash 27 Inventory 28 Fruinment Horizontal Transaction Analysis Sample Fin Stmt Financial Statements Transaction Detail Balance Sheet Assets Cash Inventory Equipment Accumulated Depreciation Total Assets Liabilities Notes Payable 3 Total Liabilities 4 Stockholders Equity -5 Common Stock 56 Retained Earnings 37 Total Stockholders Equity 38 Total Liabilities & SE 39 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 Statement of Cash Flows 47