I need help with the closing entries post closing trial bala
I need help with the closing entries, post closing trial balance, and the horizontal analysis.Use the information provided from the other statements below.
Janie\'s Cupcakes, Inc. Statement of Retained Earnings For Quarter Ended Sept 30, 2016 8 Beginning Balance 9 Add Net Income 0 Less Dividends 11 EndingBalance 2 4 STEP 9c 5 6 Janie\'s Cupcakes, Inc. Balance Sheet 30-Sep-16 8 9 Assets: 0 Cash 1 Accounts Receivable Prepaid Rent Prepaid Insurance Baking Supplies 3 24 5 Miscellaneous Supplies 6 Inventory 7 Equipment 28 9 Net Equipment 0 Total Assets Accumulated Depreciation 2 Liabilities 3 Accounts Payable 4 Interest Payable 5 Wages Payable 6 Note Payable 7 Total Liabilities 38 9 Equity 0 Retained Earnings 1 Common Stock 2 Total Equity 4 Total Liabilities & Equity 15 16Solution
Step 9b Janie\'s Cupcakes Inc Statement of Retained Earnings For Quarter Ended Sept 30, 2016 Particulars Amount Beginning Balance 0 Add Net Income 9856 Less Dividends 5000 Closing Balance 4856 Step 9c Janie\'s Cupcakes Inc Balance Sheet 30-Sep-16 Assets: Amount Cash 16680 Accounts Receivable 9750 Prepaid Rent 2000 Prepaid Insurance 500 Baking Supplies 500 Miscellaneous Supplies 50 Inventory 147 Equipment 8000 (-) Accumulated Dep 500 Net Equipment 7500 Total Assets 37127 Liabilities: Amount Accounts Payable 3500 Interest Payable 75 Wages Payable 696 Note Payable 10000 Total Liabilities 14271 Equity Amount Retained Earnings 4856 Common Stock 18000 Total Equity 22856 Total Liabilities and Equity 37127 Step 10 Janie\'s Cupcakes Inc Closing Entries For Quarter Ended Sept 30, 2016 Date Particulars Debit Credit 30-Sep Close Revenue Accounts Bakery Sales Dr 36500 Merchandise Sales Dr 525 To, Profit & Loss Account 37025 30-Sep Close Expense Accounts Profit & Loss Account Dr 27169 To, Cost of Goods Sold 323 To, Permits & Licensing Exp 325 To, Rent Exp 6000 To, Wages Exp 2976 To, Utilities Exp 420 To, Advertising Exp 250 To, Depreciation Exp 500 To, Interest Exp 75 To, Bakin Supplies Exp 15500 To, Miscellaneous Supplies Exp 700 To, Insurance Exp 100 30-Sep Close Income Summary Profit & Loss Account Dr 9856 To, Net Income 9856 Net Income Dr 9856 To, Retained Earnings 9856 30-Sep Close Dividends Retained Earnings Dr 5000 To, Dividends 5000 Step 11 Janie\'s Cupcakes Inc Post Closing Trial Balance 30-Sep-16 Particulars Debit Credit Cash 16680 Accounts Receivable 9750 Prepaid Rent 2000 Prepaid Insurance 500 Baking Supplies 500 Miscellaneous Supplies 50 Inventory 147 Equipment 8000 Accumulated Dep 500 Accounts Payable 3500 Interest Payable 75 Wages Payable 696 Note Payable 10000 Retained Earnings 4856 Common Stock 18000 TOTAL 37627 37627 Step 12 Horizontal Analysis Particulars July August Sept Bakery Sales 12,166 12,167 12,167 Since there is no information provided regarding breakup of sales among the three months of the sept ending quarter we have assumed that sales were even throughout the period Vertical Analysis Total Sales 37025 Particulars Amount % of Sales Bakery Sales 36500 98.58% Merchandise Sales 525 1.42% Total Revenue 37025 100.00% COGS 323 0.87% Gross Profit 36702 99.13% Permits & Licensing Exp 325 0.88% Rent Exp 6000 16.21% Wages Exp 2976 8.04% Utilities Exp 420 1.13% Advertising Exp 250 0.68% Depreciation Exp 500 1.35% Interest Exp 75 0.20% Bakin Supplies Exp 15500 41.86% Miscellaneous Supplies Exp 700 1.89% Insurance Exp 100 0.27% Ratio Analysis Current Ratio 2.08 Quick Ratio 2.04 Debt to Assets Ratio 0.38 Debt to Equity Ratio 0.62 Profit Margin 0.27 ROE 0.55 ROA 0.27 Days Receivables 23.70