[The following information applies to the questions displayed below.]Simon Company's year-end balance sheets follow.At December 31AssetsCashAccounts receivable, netMerchandise inventoryPrepaid expensesPlant assets, netTotal assetsCurrent Year$ 27,97080, 264100,9179,097251,134$ 469,382Income tax expenseTotal costs and expensesNet incomeLiabilities and EquityAccounts payableLong-term notes payableCommon stock, $10 par valueRetained earningsTotal liabilities and equityFor both the current year and one year ago, compute the following ratios:$ 116,87690,891163,50098,115$ 469,382$ 372,220189,16110,3737,933The company's income statements for the current year and 1 year ago, follow.For Year Ended December 31SalesCost of goods soldOther operating expensesInterest expenseCurrent Year1 Year Ago$ 31,40058, 34977,1048,412229,375$ 404,640Exercise 13-10 (Algo) Analyzing efficiency and profitability LO P3$ 610,197$ 70,43692,137163,50078,567$ 404, 640579,687$ 30,510$ 1.882 Years Ago$ 33,71745,40148,3613,635206,086$ 337,200$ 312,989121,82511,0757,223Earnings per shareFor both the Current Year and 1 Year Ago, compute the following ratios:$ 45,84673,776163,50054,078$ 337,2001 Year Ago$ 481,522453,112$ 28,410$ 1.75 For both the Current Year and 1 Year Ago, compute the following ratios:(1-a) Profit margin ratio.(1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago?(2) Total asset turnover.(3-a) Return on total assets.(3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago?Complete this question by entering your answers in the tabs below.Required 1A Required 1B Required 2 Required 3A Required 3BCompute profit margin ratio for the current year and one year ago.Profit Margin RatioI77Current Year:1 Year Ago:Numerator:Denominator:= Profit Margin RatioProfit margin ratio===%

Solution:-1a Calculation of profit margin as follows under:- Profit margin =Net profit/sales x 100 Current year =$30,510/$610,197x100 =5% 1 Year ago =$28,410/$481,522x100 =5.9% Solution:-1b Worsen Reason:- Profit margin for the current year decreased compared to 1 year ago Solution:-2 Asset turnover ratio =Net sales / Average total assets Current year =$610,197/ ($469,382+$404,640)/2 =1.4 1 Year ago =$481,522/ ($337,200+$404,640)/2 =1.3 Solution:-3a Return on total assets =Net income/Average assets Current year =$30,510/ ($469,382+$404,640)/2 =6.98% 1 Year ago =$28,410/ ($337,200+$404,640)/2 =7.66% As per the Bartley by guidelines I am able to answer first three sub parts only... I hope helpful to you... If you are satisfied... Support me... Thank you...

Business

Accounting

For both the Current Year and 1 Year Ago, compute the following ratios: (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (2) Roturn on total accots

For both the Current Year and 1 Year Ago, compute the following ratios: (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (2) Roturn on total accots

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

Required: Compute the following ratios for 2020: 1. Current Ratio 2. Quick Ratio 3. Receivable Turnover 4. Average Collection Period 5. Inventory Turnover 6. Average Sales Period 7. Working Capital 8. Debt Ratio 9. Equity Ratio 10. Debt to Equity Ratio 11. Time Interest Earned 12. Gross Profit Ratio 13. Operating Profit Margin 14. Net Profit Margin 15. Return on Assets
Indicate the effect of the transactions listed in the following table on total current assets, current ration, and net income. Use (+) to indicate an increase, (-) to indicate a decrease, and (0) to indicate either no effect or an indeterminate effect. Be prepared to state any necessary assumptions and assume an initial current ratio of more than 1.0. Federal income tax due for the previous year is paid.
Common size analysis of the balance sheet expresses each item as a percentage of the _____________. Total Asset Revenue Base year figure Current asset
Do npt give image format
Hello! look at the attached images and answee the following points: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. Return on year-end capital employed Net asset turnover Gross profit margin Net profit margin Current ratio Closing inventory holding period Trade receivables’ collection period viii. Trade payables’ payment period Dividend yield Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thank you a lot!
Use Table 1 and the following information on Company X to perform a pro-forma financial modeling using a percentage sales method, and answers the next questions. Note: When applying the percentage sales method, you should assume that the 2024 percentage values with respect to sales of the (i) costs except depreciation, (ii) depreciation, (iii) cash and equivalents, (iv) accounts receivable, (v) inventories, (vi) property, plant and equipment, and (vi) accounts payable will remain equal to those percentages of 2023. Sales in 2024 are expected to grow at a rate of 20%, with respect to the values of 2023. Assume also that the total values in 2024 of interest expense and debt will not change from its 2023 values; income tax will remain at 30% of the Pretax Income; and that Company X initially plans to payout 35% of its net income to its shareholders. 1. What is the forecasted value of sales for 2024? 2. What is the forecasted value of EBITDA for 2024? 3. What is the forecasted value of…