Question
H. Using Part 2 of your project, calculate** the following ratios: Current ratio Acid test ratio Debt to Equity Inventory Turnover Accounts Receivable Turnover At
H. Using Part 2 of your project, calculate** the following ratios: Current ratio Acid test ratio Debt to Equity Inventory Turnover Accounts Receivable Turnover At least 8 other ratios of your choosing **Must link to income statement and/or balance sheet. You will not receive any credit if any of the inputs are hard-keyed (not formula driven). Exception for P/E ratio where price is given. You will not receive credit for calculation of additional ratios. Please calculate at least two ratios from each category: liquidity, solvency and profitability.
Panther Builders, Inc. Statement of Retained Earning December 31, 2021 2021 2020 $ ASSETS Current Assets Cash Accounts Receivable Less: Allowance for Doubtful Accounts Short-term Investments Fair Value Adjustment-ST Inventory PPD Insurance Supplies Total Current Assets 1,646,663 879,500 (30,000) 14,000 $ 3,310,788.00 $ 1,756,720.00 $ (35,134.40) $ 14,000.00 $ (1,500.00) $ 933,104.10 $ 43,750.00 $ 5,016.00 $ 6,026,743.70 2,400,000 50,000 3,600 4,963,763 $ Property, Plant, & Equipment Land Building Less: Accumulated Dep. Building Machinery Less: Accumulated Dep. Machinery Equipment Less: Accumulated Dep. Equip. Del. Truck Less: Accumulated Dep. Truck Property, Plant, & Equipment (Net) $ 1,135,000.00 $ 3,000,000.00 $ (346,154.08) $ 850,000.00 $ (183,300.00) $ 650,000.00 $ (203,923.85) $ 56,500.00 $ (48,166.56) $ 4,909,955.52 1,135,000 3,000,000 (269,231) 850,000 (14,100) 260,000 (184,923) 56,500 (42,611) $ 4,790,635.00 Long-term Investments Available for Sale Investments Fair Value Adjustment-AFS $ $ $ 483,800.00 5,200.00 489,000.00 100,000 15,000 115,000 $ 55,000.00 60,000 Intangible Assets Patents Other Non-current Assets Right of use Asset Total Assets $ 500,000.00 $ 11,980,699.22 $ 9,929,398.00 Current Liabilities A/P Salaries Payable Utilities Payable Payroll Taxes Payable Interest Payable Dividends Payable Note Payable-Short Term Income Tax Payable Total Current Liabilities $ 358,598.10 $ 1,722,000.00 $ 9,000.00 $ 33,990.00 $ 50,750.00 $ 350,000.00 $ 150,000.00 $ 190,247.00 $ 2,864,585.10 1,141,754 1,177,000 11,000 73,000 13,000 400,000 50,000 126,000 2,991,754 Long Term Liabilities Lease Liability Note Payable-Long Term Bond Payable Discount on Bond Payable Total Long Term Liabilities $ 417,250.00 $ 454,500.00 $ 2,500,000.00 $ (128,224.00) $ 3,243,526.00 500,000 2,500,000 (146,139) 2,853,861 $ Total Liabilities $ 6,108,111.10 $ 5,845,615 Stockholders' Equity Common Stock, $1 par, $1M Shares Authorized; 295,000 Shares Issued and 279,500 shares Outstanding Additional Paid in Capital - Common Stock RE Unrealized gain(loss) Available for Sale Securities Less: Unearned Compensation Less: Treasury Stock (net) Total Stockholders' Equity $ 295,000.00 $ 4,463,193.00 $ 1,313,472.89 $ 5,200.00 $ 157,777.78 $ 46,500.00 $ 5,872,588.12 200,000 2,823,193 1,045,590 15,000 4,083,783 Total Liabilities and Stockholders' Equity $ 11,980,699.22 $ 9,929,398.00 Panther Builders, Inc. Income Statement 8186460 4550000 3636460 Tell me what you want December 31, 2021 Sales Cost of Goods Sold Gross Profit Operating Expenses Compensation Expense 2222 Salaries Expense 2045000 Bad Dept Expense 23734 Payroll Tax Expense 88990 Advertisting Expense 125000 Insurance Expense 121250 Supplies Expense 22989 Depreciation Expense 277679 Amortization Expense 5000 Utilities Expense 9000 Miscellaneous Expenses 9300 Operating Income (Loss) Realized Gains (Losses) 3500 Unrealized Gains (Losses) Income 1500 EBIT Interest Expense EBT Income Tax Expense Net Income 2730165 906295 2000 908295 126165 782130 164247 617883 EPS 2.64 Weighted Average Common Stock Dates Fraction of Year Weighted Shares Outstanding Shares Outstanding Date Shares Changes Shares Outstanding 1-Jan 30-Jun 12-Dec 1/1 - 6 / 30 6/30 - 12/12 12/12 - 12/3 235,000 270,000 285,000 235,000.00 270,000.00 15,000.00 41.67% 50.00% 8.3333% 97,917 135,000 1,250 35000 15000 234,167Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started