Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help figuring out these five ratios please Prepare the following Ratios for January 2022: 1. Current Ratio 2. Acid-Test Ratio 3. Debt Ratio 4.

Need help figuring out these five ratios please image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Prepare the following Ratios for January 2022: 1. Current Ratio 2. Acid-Test Ratio 3. Debt Ratio 4. Profit Margin Ratio 5. Gross Margin Ratio Credits Debits 521,865.00 24.150.00 4100 63.00 15,000.00 5,450,00 10,500.00 315.00 2.940.00 368,250.00 620.000.00 48,100.00 94.500.00 18.250.00 108,750,00 16,625.00 Be Prepared Adjusted Trial Balance January 31, 2022 Account ID Account Description 1001 Cash S 1021 Accounts Receivable 1022 Allowance for Doubtful Ace 1027 Interest Receivable 1031 Notes Receivable 1051 Merchandise Inventory 1101 Store Supplies 111 Office Supplies 1125 Prepaid Insurance 1401 Land 1411 Building 1412 Accum Dept Building 1431 Office Equipment 1432 Accum Dep: Office Equipm 1451 Store Equipment 1452 Accum Depr: Store Equipm 1501 Patents 2001 Accounts Payable 2005 Income Taxes Payable 2031 Interest Payable 2101 Notes Payable long term 2301 Bonds Payable 2303 Discount on Bonds Payable 3001 Preferred Stock 3011 Common Stock 3101 Paid in Capital In Excess of por: Prefer 3111 Paid in Capital In Excess of part Com 3121 Paid In Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 40X01 Sales Revenue 100 Sales Count A003 Sales Returns & Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 72.775.00 25,000.00 7,500.00 4,778.00 200,000.00 375,000.00 10,500.00 412,500.00 115,000.00 15,375.00 265,750,00 180,000.00 82.485.00 180,000.00 ' 525,000.00 1,250,00 13.000.00 150.00 195.xx.00 2000 5012 Repairs Expense: Office 5015 Depreciation Expense: Building - General 5020 Depreciation Exp: Office Eq 5025 Supplies Expense - Selling 5027 Utilities Expense: Office 5030 Office Salaries Expense 5035 Office Payroll Tax Expense 6005 Depreciation Exp: Store Eq 6010 Amortization Expense: Pat-General 6015 Sales Salaries Expense 6020 Sales Payroll Tax Expense 6022 Utilities Expense: Store 6025 Delivery Expense - General 6030 Repairs Expense: Store 6040 Bad Debts Expense - Selling 2001 Interest Expense 2,500.00 850.00 2,500.00 1,200.00 1,500.00 15,000.00 1,200.00 875.00 725.00 10.000.00 800.00 1,100.00 1,000,00 800.00 460.00 7,978.00 2.292.996.00 $ 2.299,990.00 Be Prepared Inc. Balance Sheet December 31, 2021 $ 26,250 7,875 210,000 244,125 Assets Cash Accounts Receivable Merchandise Inventory Office Supplies Prepaid Insurance Land Building Accumulated Depreciation, Building Office Equipment Accumulated Depreciation, Office Equipment Store Equipment Accumulated Depreciation, Store Equipment Patents Total Assets Liabilities 28,875 Accounts Payable $ 42,000 Income Taxes Payable 52,500 Mortgage Payable 1,575 Total Liabilities 3,150 68,250 420,000 Stockholder's Equity (47,250) Preferred Stock 94,500 Common Stock (15,750) Paid in Capital in Excess of par: Preferred 78,750 Paid in Capital in Excess of par: Common (15,750) Retained Earnings 73,500 Total Stockholder's Equity 784,350 Total Liabilities and Stockholder's Equity $ 262,500 105,000 7.875 75,750 89,100 540,225 784,350 S 1. Be Prepared Income Statement for the Month of January 2022 Revesses Sales 5.25.000.00 Less: Sales discount -1.250,00 Less: Sales returns & allowances - 13.000.00 Net Sales 5.10.750.00 Cost of goods sold 1.95.000.00 Gross profit 3.15.750,00 Operating expenses Insurance expense - geriral Repaits expense office Depreciation expense - Building - general Depreciation expense - Office equipment Supplies expense - Selling Utilities expense - Office Office salaries expense Office payroll tax expense Depreciation expense - Store Eq Amortization expense pat general Sales salaries expense Sales payroll tax expense Utilities expense Store Delivery expense - General Repairs expense - store Bad debts expense - selling Total operating expenses Operating Income 200.00 2.500.00 850.00 2.500.00 1.200.00 1.500.00 15.000.00 1.200.00 875.00 725.00 10.000.00 800.00 1.100.00 1.000.00 800.00 460.00 40.710.00 2.75.040.00 -7.828.00 2.67.212.00 Other Income expenses Interest Tevi 150.00 Interest expense -7.978.00 Net other income/expenses Net Income 2. Be Prepared Statement of Retained Earnings For the Month of January 2022 Retained earnings at December 31, 2021 $ 89.100.00 Add: Net Income of January 2022 $2.67.212.00 Less: Cash dividends $ -5.615.00 Retained earnings at January 31, 2022 $3,50,697.00 3. Be Prepared INC CASH FLOW STATEMENT AS ON 31st January, 2022 Cash Flow From Operations Net Income 267,212.00 Add: Items not requiring in outlay of cash: Depreciation Expense for the period 4,950.00 272,162.00 Cash Flow From Operations: Changes in non cash working Capital Decrease in Accounts Receivable Increase in interest Receivable Increase in Notes Receivable Decrease in Merchandise Inventory Decrease in Office supplies Increase in store supplies Decrease in Prepaid Insurance Decrease in Accounts Payable Decrease in income tax payable Increase in interest payable Decrease in Discount on Bond Payable Net Changes in non Cash Working Capital Net Cash from Operations Cash Flow from Investing Increase in Land Increase in Building Increase in Store Equipment 18,333.00 (63.00) (15,000.00) 47,050.00 1,260.00 (10,500.00) 210.00 (1,250.00) (375.00) 4,778.00 (10,500.00 33,943.00 306,105.00 (300,000.00 (200,000.00 (30,000.00 Cash Flow From Investing B (530,000.00) Cash Flow from Financing Mortgage Paid Incease in Note Payable Increase in Bond Payable Increase in Prefered stock & Paid in Capital excess PS Increase in common stock & Paid in Capital excess Common Dividend Paid (210,000.00) 200,000.00 375,000.00 157,500.00 200,000.00 (5,615.00) 716,885.00 Cash Flow from Financing Net Change in Cash Cash balance at Beginning of Year Cash balance at End of the Year A+B+C 492,990.00 28,875.00 521,865.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Accounting Cases Investigating Issues of Fraud and Professional Ethics

Authors: Jay Thibodeau, Deborah Freier

4th edition

78025567, 978-0078025563

Students also viewed these Accounting questions

Question

Primary keys are required in every relational database table.

Answered: 1 week ago