Please solve last 3 tables : Statement of Retained earnings, Balance sheet and financial analysis
Adjusting entries Debit Credit 137,400.00 2,000.00 Unadjusted trial balance Debit Credit 64,713.72 165,250.00 25,750.00 7,500.00 2,400.00 17,000.00 3,285.72 10,000.00 2,000.00 2,300.00 1,600.00 30,401.00 10,000.00 2,642.86 2,000.00 1,350.00 1,468.75 27,325.00 22,800.00 5 6 Account 7 Cash 8 Baking Supplies 9 Merchandise Inventory (FIFO) 10 Prepaid Rent 11 Prepaid Insurance 12 Baking Equipment 13 Accumulated Depreciation 14 Leasehold Improvements 15 Accumulated Amortization 16 Trademark 17 Office Supplies 18 Accounts Receivable 19 Notes Payable 20 Interest Payable 21 Accounts Payable 22 Wages Payable 23 Loans Payable 24 Common Stock 25 Dividends 26 Bakery Sales 27 Merchandise Sales 28 Baking Cost of Goods Sold 29 Rent Expense 30 Interest Expense 31 Insurance Expense 32 Depreciation Expense 33 Amortization Expense 34 Misc. Expense 35 Office Supplies Expense 36 Business License Expense 37 Advertising Expense 38 Wages Expense 39 Telephone Expense 40 Merchandise COGS (FIFO) 41 42 Total Adjusted trial balance Debit Credit 64,713.72 27,850.00 25,750.00 7,500.00 400.00 17,000.00 5,928.58 10,000.00 4,000.00 2,300.00 250.00 30,401.00 10,000.00 1,468.75 27,325.00 22,800.00 21,000.00 30,000.00 20,000.00 335,675.00 35,200.00 137,400.00 90,000.00 1,468.75 2,000.00 2,642.86 2,000.00 2,780.00 1,350.00 375.00 5,200.00 22,800.00 3,456.00 15,760.00 21,000.00 30,000.00 20,000.00 335,675.00 35,200.00 137,400.00 90,000.00 1,468.75 2,000.00 2,642.86 2,000.00 2,780.00 1,350.00 375.00 5,200.00 22,800.00 3,456.00 15,760.00 464,485.72 464,485.72 169,661.61 169,661.61 493,397.33 493,397.33 Adjusting Journal Entries 2017 Credit Date Accounts 31-Dec Depreciation Expense Accumulated depreciation Debit 2,642.86 2,642.86 2,000.00 31-Dec Amortization Expense Accumulated Amortization 2,000.00 1,468.75 31-Dec Interest Expense Interest Payable 1,468.75 2,000.00 31-Dec Insurance Expense Prepaid Insurance 2,000.00 137,400.00 31-Dec Baking Cost of Goods Sold Baking Supplies 137,400.00 1,350.00 31-Dec Office Supplies Expense Office Supplies 1,350.00 22,800.00 31-Dec Wages Expense Wages Payable 22,800.00 169,661.61 169,661.61 Peyton Approved Income Statement For Year Ending 12/31/2017 Bakery Sales Merchandise Sales Total Revenues Merchandise Cost of Goods Sold (FIFO) Baking Cost of Goods Sold Gross Profit 335,675.0 35,200.0 370,875.0 15,760.0 137,400.0 217,715.0 Operating Expenses: Rent Expense Interest Expense Insurance Expense Depreciation Expense Amortization Expense Misc. Expense Office Supplies Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Total Operating Expenses: 90,000.0 1,468.8 2,000.0 2,642.9 2,000.0 2,780.0 1,350.0 375.0 5,200.0 22,800.0 3,456.0 134,072.6 Net Income 83,642.4 Credit Date Accounts 31-Dec Bakery Sales Merchandise Sales Income Summary Debit 335,675.00 35,200.00 370,875.00 287,232.61 31-Dec Income Summary Baking Cost of Goods Sold Rent Expense Interest Expense Insurance Expense Depreciation Expense Amortization Expense Misc. Expense Office Supplies Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Merchandise Cost of Goods Sold (FIFO) 31-Dec Income Summary Retained Earnings 137,400.00 90,000.00 1,468.75 2,000.00 2,642.86 2,000.00 2,780.00 1,350.00 375.00 5,200.00 22,800.00 3,456.00 15,760.00 83,642.39 83,642.39 20,000.00 31-Dec Retained Earnings Dividends 20,000.00 761,750.00 761,750.00 Peyton Approved Statement of Retained Earnings For Year Ending 12/31/2017 Beginning Balance: plus Net Income less Dividends: Ending Balance: Peyton Approved Balance Sheet As of December 31, 2017 Assets Current Assets: Cash Baking Supplies Merchandise Inventory (FIFO) Prepaid Rent Prepaid Insurance Office Supplies Accounts Receivable Total Current Assets Liabilities and Owners' Equity Current Liabilities: Accounts Payable Wages Payable Interest Payable Total Current Liabilities Long Term Liabilities: Notes Payable Loans Payable Total Long Term Liabilities: Total Liabilities: Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Common Stock Retained Earnings Leasehold Improvements Accumulated Amortization Total Equity Trademark Total Assets Total Liabilities & Equity 2017 2016) 2.2 0.55 1 2 3 Quick Ratio 4 Gross Margin 5 Net Margin 6 Return on Equity 7 8 2015 Industry Standard 2.8 1.75 0.7 0.7 0.32 0.24) 0.78 0.8 0.22 0.9 8
