Take the following results for JJ?s Jammers and create a Balance Sheet and Income Statement in the 2012 columns of the template showing JJ?s Jammers 2011 results (In alphabetical order). Make sure you make the embedded calculations for the caption accounts (like total Current Assets or Gross Profit)

Accounts Receivable 77251: Cash and Securities 315954: Goodwill and Other Assets 448484: Inventories 40712: less: Accumulated Depreciation -594200: Other Current Assets 21349: Plant & Equipment 1023458: Accounts payables and accruals 373807: Accrued Taxes 19: Additional Paid in Capital 842967: Common Stock 179798: Long Term Debt 563748: Notes payable 10578: Retained Earnings 166634: Treasury stock (571,320) shares -25303.

Cost of Goods sold 1158228: Depreciation and Amortization 83729: Dividends 5310: Interest (5.5%) 56000: Net Sales 1701013: Selling and Admin Expenses 247637: Taxes (33%) 51287.

Assets 2012 Cash and securities Accounts receivable Inventories Other Current Assets Total Current Assets Plant & Equipment less: accumulated Depreciation Net plant and Equipment Goodwill and Other Assets Total Assets JJ's Jammers You may be off by $5 due to rounding Liabilities and Stockholder Equity 2011 288592 Accounts payables and accruals 306245 Notes payable 423897 Accrued Taxes 21349 1040083 Total Current Liabilities Long Term Debt 1023458 Total Liabilities -512200 Common Stock 511258 Additional Paid in Capital Retained Earnings 450213 Treasury stock (571,320) shares Total Stockholder equity 2001554 Total Liabilities and Equity 2012 2011 349352 10578 18 359948 574326 934274 179798 842967 67815 -23300 1067280 2001554 JJ's Jammers Income Statement 2012 Net Sales Cost of Goods sold Gross Profit Selling and Admin Expenses EBITDA Depreciation and Amortization EBIT Interest (5.5%) EBT Taxes (33%) Net Income Dividends Addition to retained earnings 2011 1589732 1082457 507275 231437 275838 83729 192109 56000 136109 46277 89832 4581 85251 You may be off by $5 due to rounding (Depreciation is 82,000 and amortization is 1729) Dividend payout is 5.1% of net income JJ's Jammers Cash flow Reconciliation Statement Starting Cash Net Income Increase in receivables ( ) Increase in Inventory ( ) Decrease in Fixed Assets Decrease in Intangibles Increase in Payables Increase in Accrued Taxes Decrease in Long term debt Ending Cash 288592 You may be off by $5 due to rounding Assets Cash and securities Accounts receivable Inventories Other Current Assets Total Current Assets 2012 315954 404933 494282 21349 1236518 Plant & Equipment less: accumulated Depreciation Net plant and Equipment 1023458 -594200 429258 Goodwill and Other Assets Total Assets 448484 2114260 Jeneane's Jammers Liabilities and Stockholder Equity 2011 288592 Accounts payables and accruals 306245 Notes payable 423897 Accrued Taxes 21349 1040083 Total Current Liabilities Long Term Debt 1023458 Total Liabilities -512200 Common Stock 511258 Additional Paid in Capital Retained Earnings 450213 Treasury stock (571,320) shares Total Stockholder equity 2001554 Total Liabilities and Equity 315954 0 2012 373807 10578 19 2011 349352 10578 18 386416 563748 359948 574326 950164 179798 842967 166634 -25303 1164096 2114260 934274 179798 842967 67815 -23300 1067280 2001554 Jeneane's Jammers Income Statement 2012 Net Sales Cost of Goods sold Gross Profit Selling and Admin Expenses EBITDA Depreciation and Amortization EBIT Interest (5.5%) EBT Taxes (33%) Net Income Dividends Addition to retained earnings 1701013 1158229 542784 247638 295147 83729 211418 56000 155418 51288 104130 5311 98819 2011 1589732 1082457 507275 231437 275838 83729 192109 56000 136109 46277 89832 4581 85251 (Depreciation is 82,000 and amortization is 1729) Dividend payout is 5.1% of net income JJ's Jammers Cash flow Reconciliation Statement 2012 Starting Cash Net Income Increase in receivables ( ) Increase in Inventory ( ) Decrease in Fixed Assets Decrease in Intangibles Increase in Payables Increase in Accrued Taxes Decrease in Long term debt Ending Cash 288592 27353 315945 98819 -98688 -70384 82000 1729 24454 1 -10578