Propiem 12-0 Consider the following information for HandyCraft Stores for 2014 and 2015: Total assets Noninterest-bearing current liabilities Net income Interest expense Sales Tax rate ROI Compute ROI for both years. (Round answers to 2 decimal places, e.g. 15.32 2015 LINK TO TEXT 2014 % Profit margin Investment turnover 2014 2015 $59,100,000 $56,500,000 4,410,000 4,970,000 3,630,000 4,910,000 2,420,000 2,950,000 66,000,000 96,250,000 40% 40% 2014 Break ROI down into profit margin and investment turnover. (Round answers to % 2015

Propiem 12-0 Consider the following information for HandyCraft Stores for 2014 and 2015: Total assets Noninterest-bearing current liabilities Net income Interest expense Sales Tax rate ROI Compute ROI for both years. (Round answers to 2 decimal places, e.g. 15.32 2015 LINK TO TEXT 2014 % Profit margin Investment turnover 2014 2015 $59,100,000 $56,500,000 4,410,000 4,970,000 3,630,000 4,910,000 2,420,000 2,950,000 66,000,000 96,250,000 40% 40% 2014 Break ROI down into profit margin and investment turnover. (Round answers to % 2015

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter5: Sales And Receivables

Section: Chapter Questions

Problem 76E: Ratio Analysis The following information was taken from Nash Inc.s trial balances as of December 31,...

See similar textbooks

Similar questions

Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
1. Use ratios to analyze a company's liquidity and solvency. Calculate Select Ratios - Excel FILE НОМE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Alignment Number Conditional Format as Formatting - Table - Paste I Cell Cells Styles - Clipboard Font Styles B36 fx A B C D 1 Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 2016 2015 185,000 $ 80,000 4 Cash $ 143,000 59,000 134,000 5 Accounts Receivable, Net 6 Inventory 104,000 7 Prepaid Insurance 11,900 5,880 Total Current Assets 380,900 341,880 9 Property and Equipment, Net 514,500 407,000 10 Total Assets $ 895,400 $ 748,880 11 12 Current Liabilities 2$ 85,300 $ 96,800 13 Long-term Liabilities 284,000 224,000 Total Liabilities 369,300 299,000 320,800 299,000 14 15 Contributed Capital 16 Retained Earnings Total Stockholders' Equity 227,100 129,080 428,080 17 526,100 18 Total Liabilities and Stockholders' Equity $ 895,400 $ 748,880 19 20 Income Statement $ 3,031,000…
Sales Cost of goods sold Accounts receivable 2021 $ 676,574 333,971 32,679 2020 $ 439,334 216,824 25,657 2019 $ 340,569 170,229 23,363 2018 $ 237,330 117,892 13,860 2017 $ 175,800 86,142 12,060 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: = Trend percent = % Is the trend percent for Net Sales favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Trend Percent for Cost of Goods Sold: Numerator: Denominator: Trend percent Is the trend percent for Cost of Goods Sold favorable or unfavorable? %
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…
Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000
view Policies Current Attempt in Progress Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 467,400 $ 410,000 Inventory $ 785,400 % $ 660,000 % Total assets $3,197,900 % $2,830,000 % eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answer
Profitability ratios The following selected data were taken from the financial statements of Robinson Inc. for December 31, 2016, 2015 and 2014: December31 2016 2015 2014 Total assets......................................... 4,800,000 4,400,000 4,000,000 Notes payable (8% interest)........................... 2,250,000 2,250,000 2,250,000 Common stock...................................... 250,000 250,000 250,000 Preferred 4% stock, 100 par (no change during year)........................... 500,000 500,000 500,000 Retained earnings................................... 1,574,000 1,222,000 750,000 The 2016 net income was 372,000, and the 2015 net income was 492,000. No dividends on common stock were declared between 2014 and 2016. a. Determine the rate earned on total assets, the rate earned on stockholders equity, and the rate earned on common Stockholders equity for the years 2015 and 2016. Round to one decimal place. b. What conclusions can be drawn from these data as to the companys profitability?
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Ratio Analysis The following information was taken from Nash Inc.s trial balances as of December 31, 2018, and December 31, 2019. Required: 1. Calculate the net profit margin and accounts receivable turnover for 2019. ( Note: Round answers to two decimal places.) 2. How much does Nash make on each sales dollar? 3. How many days does the average receivable take to be paid (assuming all sales are on account)?
Comprehensive/Spreadsheet Problem 16-15 FORECASTING FINANCIAL STATEMENTS Use a spreadsheet model to forecast the financial statements in Problems 16-13 and 16-14. 16-13 ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.'s 2014 financial statements arc shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2014 Morrissey Technologies Inc.: Income Statement for December 31, 2014 Sales 3.600.000 Operating costs including depreciation 3,279,720 E81T 320.280 Interest 20.280 EST 300.000 Taxes (40%} 120,000 Net Income 180.000 Per Share Data: Common stock price 45.00 Earnings per share (EPS) 1.80 Dividends per share (DPS) 1.08 Suppose that in 2015, sales increase by 10% over 2014 sales. 1hc firm currently has 100,000 shares outstanding. It expects to maintain its 2014 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would Like to reduce its Operating costs/Sales ratio to 87.5% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities to-assets ratio currently is too low relative to the industry average.) The firm will raise JOO/o of the 2015 forecasted interest bearing debt as notes payable, and it will issue long-term bonds for the remainder. the firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 12.5%. Assume that any common stock issuances or repurchases can be made at the firm's current stock price of S45. a. Construct the forecasted financial statements assuming that these changes are made. What are the firm's forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? b. If the profit margin remains at S'/o and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firm's sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.) 16-14 EXCESS CAPACITY Krogh Lumber's 2014 financial statements are shown here. Krogh Lumber: Balance Sheet as of December 31, 2014 (Thousands of Dollars) Krogh Lumber: Income Statement for December 31, 2014 (Thousands of Dollars) Sales 36,000 Operating costs including depredation 30,783 Earnings before interest and taxes 5,217 Interest 1,017 Earnings before taxes 4,200 Taxes (40%) 1680 Net income 2.520 Dividends (60%} 1,512 Addition to retained earnings 1,008 a. Assume that the company was operating at full capacity in 2014 with regard to all items except fixed assets; fixed assets in 2014 were being utilized to only 75% of capacity. By what percentage could 2015 sales increase over 2014 sales without the need for an increase in fixed assets? b. Now suppose 2015 sales increase by 25% over 2014 sales. Assume that Krogh cannot sell any fixed assets. AU assets other than fixed assets will grow at the same rate as sales; however, after reviewing industry averages, the firm would like to reduce its operating costs/sales ratio to 82% and increase its total liabilities-to-assets ratio to 42%. The firm will maintain its 60% dividend payout ratio, and it currently has 1 million shares outstanding. The firm plans to raise 35% of its 2015 forecasted interest-bearing debt as notes payable, and it will issue bonds for tile remainder. The firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 11%. Any stock issuances or repurchases will be made at the firm's current stock price of 40. Develop Krogh's projected financial statements like those shown in Table 16.2 What are the balances of notes payable, bonds, common stock, and retained earnings?
Financial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?