temaining Time: 1 hour, 57 minutes, 32 seconds.Question Completion Status:4.6.8101112131415161718192U.Anew intermationarmarketQUESTION 21Answer the following questions based on Daktronic Inc's selected financial data provided in the table below:Selected Income Statement FiguresSelected Balance Sheet FiguresAmts in USD20X8 Amts in USD20X820X7AccountsCash SalesCredit Sales3,000,000 Receiva ble10,000,000 Inventory600,000500,000250,000225,000Accounts13,000,000 PayableTotal SalesCost ofGoods Sold160,000120,0008,000,000(a) what is the average inventory turnover for Daktronics Inc?(b) What is the average payable days for the firm?(c) What is the average receivables collection days?(d) What changes have taken place in Daktronics Inc working capital requirement, year-on-year?For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).В IParagraphArial14pxA.x X2土Click Save and Submit to save and submit. Click Save All Answers to save all answers.田!!!

Company calculates the ratios with an intention to evaluate and analyze the past events and also…

QUESTION 21 Answer the following questions based on Daktronic Inc's selected financial data provided in the table below: Selected Balance Sheet Figures 20X7 Selected Income Statement Figures 20X8 20X8 Amts in USD Accounts 3,000,000 Receiva ble 10,000,000 Inventory Accounts 13,000,000 Payable Amts in USD Cash Sales Credit Sales 600,000 500,000 250,000 225,000 Total Sales Cost of Goods Sold 160,000 120,000 8,000,000 (a) what is the average inventory turnover for Daktronics Inc? (b) What is the average payable days for the firm? (c) What is the average receivables collection days? (d) What changes have taken place in Daktronics Inc working capital requirement, year-on-year?

QUESTION 21 Answer the following questions based on Daktronic Inc's selected financial data provided in the table below: Selected Balance Sheet Figures 20X7 Selected Income Statement Figures 20X8 20X8 Amts in USD Accounts 3,000,000 Receiva ble 10,000,000 Inventory Accounts 13,000,000 Payable Amts in USD Cash Sales Credit Sales 600,000 500,000 250,000 225,000 Total Sales Cost of Goods Sold 160,000 120,000 8,000,000 (a) what is the average inventory turnover for Daktronics Inc? (b) What is the average payable days for the firm? (c) What is the average receivables collection days? (d) What changes have taken place in Daktronics Inc working capital requirement, year-on-year?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

O DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 Example: NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). 400,000 650,000 2,800,000 Accounts Receivable 30000 ÷ •1• 500000 6.0 % olo % 010
Assume the following information is given:Income statementNet sales sh. 200,000Operating income 10,000 Balance sheetCurrent assets 95,000Total assets 150,000 Current liabilities 80,000Total liabilities 125,000Retained earnings 25,000 The market value of equity is sh. 300,000Required:Evaluate the credit worthiness of the borrower using Altman Z
Consider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 245 Current liabilities Long-term debt 630 Other liabilities Equity $ 875 Required: a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities) Note: Round your answer to 2 decimal places. b. What is the ratio of total long-term debt to total long-term capital? Note: Round your answer to 2 decimal places. c. What is its net working capital? d. What is its current ratio? Note: Round your answer to 2 decimal places. $ 170 215 140 350 $ 875 a Debt-equity ratio b. Long-term debt-to-capital ratio c. Net working capital d. Current ratio
Vertical Analysis of Balance Sheet Balance sheet data for a company for the years ended December 31, 20Y2 and 20Y1, are shown below. 20Y2 20Υ1 Current assets $ 752,000 $ 602,000 Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000 Current liabilities 504,000 427,000 Long-term liabilities 1,504,000 1,197,000 Common stock 1,248,000 1,253,000 Retained earnings 4,744,000 4,123,000 | Prepare a comparative balance sheet for 20Y2 and 20Y1, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. Round your answers to one decimal place. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 Amount 20Y2 Percent 20Y1 Amount 20Y1 Percent Assets Current assets $752,000 % $602,000 % Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000
Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leverage
Consider this simplified balance sheet for Geomorph Trading: Current assets $ 120 Current liabilities $ 70 Long-term assets 520 Long-term debt 270 Other liabilities 90 Equity 210 $ 640 $ 640 Required: What is the company’s debt-equity ratio? Note: Round your answer to 2 decimal places.
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 460,000 780,000 3,164,000 Example: Dec. 31, 2021 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). Accounts Receivable 2022 400,000 650,000 2,800,000 30000 ÷ 500000 = 6.0 % %
Balance Sheet Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. Note: Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (L.e., .2345 should be entered as 23.45). Assats Current assets Cash Income Statement Marketable securities Accounts receivable (net) Inventories Prepaid Items Total current assets Investments Plant (net) Land Total long-term assets Total assets Liabilities and stockholders' equity Liabilities Current liabilities Notes payable Accounts payable Salaries payable Total current liabilities Noncurrent liabilities Bonds payable Other FANNING COMPANY Vertical Analysis of Balance Sheeta Year 4 Total noncurrent liabilales Total abilities Stockholders' equity Preferred stock (par value $10, 4% cumulative, nonparticipating: 6,600 shares authorized and issued) Common stock (no par; 50,000 shares authorized; 10,000 shares issued) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity…
Consider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 110 510 Net working capital $ 620 a. Debt-equity ratio b Long-term debt-to-capital ratio C. d. Current ratio a. What is the company's debt-equity ratio? (Round your answer to 2 decimal places.) b. What is the ratio of total long-term debt to total long-term capital? (Round your answer to 2 decimal places.) c. What is its net working capital? d. What is its current ratio? (Round your answer to 2 decimal places.) Current liabilities Long-term debt Other liabilities Equity $ 65 275 80 200 $ 620
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
Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.
Requirements: a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx b. Evaluate the company's financial position and results of operation using the comparative statement analysis i. Short-term solvency analysis ii. Long-term financial position analysis iii. Operating efficiency and profitability analysis