1. Calculate the following ratios. (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimalplaces.)CavalierRatioRoyale CompanyCompanyTests of Profitability:1. Net Profit Margin%%2. Gross Profit Percentage%%3. Fixed Asset Turnover4. Return on Equity%5. Earnings per Share6. Price/Earnings RatioTests of Liquidity:7. Receivables Turnover7. Days to Collect8. Inventory Turnover8. Days to Sell9. Current RatioTests of Solvency:10. Debt-to-Assets The financial statements for Royale and Cavalier companies are summarized here:CavalierRoyale CompanyCompanyBalance Sheet$ 33,00063,000126,000566,000148,000$ 53,00024,00041,000176,00054,000$ 348,000CashAccounts Receivable, NetInventoryEquipment, NetOther AssetsTotal Assets$ 936,000$ 136,000206,000488,00058,00048,000$ 936,000$ 31,00071,000218,00012,00016,000$ 348,000Current LiabilitiesNotes Payable (long-term)Common Stock (par $20)Additional Paid-In CapitalRetained EarningsTotal Liabilities and Stockholders' EquityIncome Statement$ 824,000488,000248,000$ 88,000$ 304,000158,000103,000$ 43,000Sales RevenueCost of Goods SoldOther ExpensesNet IncomeOther DataPer share price at end of yearSelected Data from Previous Year$ 12.00$ 20.00Accounts Receivable, NetNotes Payable (long-term)Equipment, NetInventoryTotal Stockholders' Equity$ 55,000206,000566,000103,000594,000$ 22,00071,000176,00046,000246,000These 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 $83,000 cashand Cavalier Company is asking for $38,000. The loans will be for a two-year period. Both companies estimate bad debts based on anaging analysis, but Cavalier has estimated slightly higher uncollectible rates than Royale. Neither company issued stock in the currentyear. Assume the end-of-year total assets and net equipment balances approximate the year's average and all sales are on account.

1)Calculation of Net profit margin as follows:- Net profit =Net income / Sales revenue x 100

1. Calculate the following ratios. (Use 365 days in a year. Round your intermediate calculations and final answers to 2 dec places.) Cavalier Ratio Royale Company Company Tests of Profitability: 1. Net Profit Margin % % 2. Gross Profit Percentage % % 3. Fixed Asset Turnover

1. Calculate the following ratios. (Use 365 days in a year. Round your intermediate calculations and final answers to 2 dec places.) Cavalier Ratio Royale Company Company Tests of Profitability: 1. Net Profit Margin % % 2. Gross Profit Percentage % % 3. Fixed Asset Turnover

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

View Policies Current Attempt in Progress Assume Sunland Company has the following reported amounts: Sales revenue $1,000,000, Sales returns and allowances $29,000, Cost of goods sold $649.599, and Operating expenses $215,600. (a) Compute net sales. Net sales $ (b) Compute gross profit. Gross profit S (c) Compute income from operations.
Edison Company reported the following for the current year: $ 84,000 59,000 21,080 63,000 77,080 Net sales Cost of goods sold Net income Beginning balance of total assets Ending balance of total assets Compute (a) profit margin and (b) return on total assets. Complete this question by entering your answers in the tabs below. Profit Margin Ratio Compute the return on total assets. Return On Total Assets Numerator: 7 7 7 Return On Total Assets Denominator: = Return On Total Assets Return on total assets II =
Book rences Required: a. Firm D has net income of $64,296, sales of $1,368,000, and average total assets of $760,000. Calculate the firm's margin, turnover, and ROI. b. Firm E has net income of $120,218, sales of $1,939,000, and ROI of 8.68%. Calculate the firm's turnover and average total assets. c. Firm F has ROI of 12.40%, average total assets of $1,540,000, and turnover of 0.8. Calculate the firm's sales, margin, and net income. Complete this question by entering your answers in the tabs below. Required A Required B Required C Firm D has net income of $64,296, sales of $1,368,000, and average total assets of $760,000. Calculate the firm's margin, turnover, and ROI. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Margin Turnover ROI % % Required B >
Excel Online Structured Activity: Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 1.2Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 27%Total liabilities-to-assets ratio: 45%Quick ratio: 0.90Days sales outstanding (based on 365-day year): 29.5 daysInventory turnover ratio: 4.0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income StatementInformation Sales $ fill in the blank 2 Cost of goods sold $ fill in the blank 3 Balance Sheet Cash $ fill in the blank 4 Accounts payable $ fill in the blank 5 Accounts receivable $ fill in the blank 6 Long-term debt $…
Horizontal analysis of the income statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income tax expense Income tax expense Net income $2,240,000 (1,925,000) $315,000 $(152,500) (118,000) $(270,500) $44,500 (17,800) $26,700 $2,000,000 (1,750,000) $250,000 $(125,000) (100,000) $(225,000) $25,000 (10,000) $15,000
Asset Efficiency Ratios Sammy Inc.'s financial statements for 2023 indicate the following account balances: Net sales Cost of goods sold Average accounts receivable Average inventory Average property, plant, and equipment Average total assets. Required: Round your answers to two decimal places. 1. Using this information, calculate Sammy's receivable turnover ratio. $307,608 170,100 21,329 3,960 85,367 144,140 2. Using this information, calculate Sammy's asset turnover ratio and also convert the ratio into days. Assume 365 days in a year. Round your answer to nearest whole day. Asset turnover ratio Conversion into days days
8. A company reports the following: Sales Average total assets $5,844,000 3,325,000 Determine the asset turnover ratio. Round to one decimal place.
Solve from the following facts. (Round your answers to the nearest hundredth.) Current assets $ 14,000 Net sales $ 40,000 Accounts receivable $ 5,000 Total assets $ 38,000 Current liabilities $ 20,000 Net income $ 10,100 Inventory $ 4,000 a. Calculate Current ratio. b. Calculate Acid test. c. Calculate Average day’s collection. d. Calculate Asset turnover. e. Calculate Profit margin on sales.
Calculate the firm's : 1) Current ratio 2) Quick Ratio 3) Days sales outstanding. Assume a 365 day per year for this calculation. 4) Total Assets turnover
All-Hands Property & Casualty Insurance Company has the following financial ratios. 2019 2018 Loss Ratio 67.8 68.1 Expense Ratio 24.2 25.1 Net Investment Yield 3.5 4.0 a. Calculate the Combined Ratio {Loss Ratio + Expense Ratio} for each year. Combined Ratio 2019 Combined Ratio 2018 b. Calculate the Overall Profitability Ratios Overall Profitability Ratio 2019 Overall Profitability Ratio 2018 why the Overall Profitability Ratio Changed in 2019 Based on the Loss Ratio, Expense Ratio, and Net Investment Yield Trends?
A company reports the following: Sales $8,782,430 Average total assets (excluding long-term investments) 1,111,700 Determine the asset turnover ratio. Round your answer to one decimal place.fill in the blank 1
Following is information from Skyway Inc. for the year (in thousands). Total annual revenue $3,206,980 Total revenue growth rate 5.0% Terminal revenue growth rate 2% Net operating profit margin (NOPM) 8.2% Net operating asset turnover (NOAT) 3.42 Projected total revenue for the following year would be: Select one: a. $3,469,952 b. None of these are correct c. $3,316,659 d. $3,271,120 e. $3,367,329