PA13-6 (Algo) Using Ratios to compare Loan Requests from Two Companies (LO 13-4, 13-5) The financial statements for Royale and Cavalier companies are summarized here: Royale Company Cavalier Company $ 26,000 56,000 112,000 552,000 141,000 $887,000 $122,000 192,000 481,000 51,000 41,000 $887,000 Balance Sheet Cash Accounts Receivable, Net Inventory Equipment, Net Other Assets Total Assets Current Liabilities Note Payable (long-term) Common Stock (par $20) Additional Paid-In Capital Retained Earnings Total Liabilities and Stockholders' Equity Income Statement Sales Revenue Cost of Goods Sold Other Expenses Net Income Other Data Per share price at end of year Selected Data from Previous Year Accounts Receivable, Net Note Payable (long-term) Equipment, Net Inventory Total Stockholders' Equity $ 46,000 17,000 27,000 162,000 47,000 $299,000 $ 17,000 57,000 211,000 5,000 9,000 $299,000 $803,000 481,000 241,000 $ 81,000 $283,000 151,000 96,000 $ 36,000 $ 19.00 $ 11.00 $ 48,000 192,000 552,000 96,000 573,000 $ 15,000 57,000 162,000 39,000 225,000 These two companies are in the same business and state but different cities. Each company has been in operation for about 10 years. Both companies received an unqualified audit opinion on the financial statements. Royale Company wants to borrow $76,000 cash and Cavalier Company is asking for $31,000. The loans will be for a two-year period. Both companies estimate bad debts based on an aging analysis, but Cavalier has estimated slightly higher uncollectible rates than Royale. Neither company issued stock in the current year. Assume the end-of-year total assets and net equipment balances approximate the year's average and all sales are on account. Required: 1. Calculate the following ratios. (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal places.) Ratio Royale Cavalier Company Company 10.09% 12.72% 40.10 % 46.64% 1.45 1.75 14.14% $ 3.19 16.001% $ 2.62 Tests of Profitability: 1. Net Profit Margin Gross Profit 2. Percentage Fixed Asset Turnover 4. Return on Equity 5. Earnings per Share Price/Earnings Ratio Tests of Liquidity: Receivables Turnover Days to Collect 8. Inventory Turnover Days to Sell 9. Current Ratio Tests of Solvency 10. Debt-to-Assets