Graff, Inc., has sales of $49,800, costs of $23,700, depreciation expense of $2,300, and interest expense...

 

Transcribed Image Text:

Graff, Inc., has sales of $49,800, costs of $23,700, depreciation expense of $2,300, and interest expense of $1,800. If the tax rate is 22 percent, what is the operating cash flow, or OCF? Input area: Sales $49,800 Costs $23,700 Depreciation Expense $2,300 Interest Expense $1,800 22% Tax rate (Use cells A6 to B10 from the given information to complete this question.) Output area: Sales Costs Depreciation expense EBIT Interest expense EBT Taxes (22%) Net income Operating cash flow A1 1 2 34 L ab Wrap Merge v General .00 0 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 9. The required answers are in rows 15 through 17. R S T B C E F G H J K L M N P Q U W Calibri (Body) A The 2020 balance sheet of Dugan, Inc., showed current assets of $5,320 and current liabilities of $2,510. The 2021 balance sheet showed current assets of $5,970 and current liabilities of $3,240. What was the company's 2021 change in net working capital, or NWC? Input area: 5 6 Dec. 31, 2020 Current assets $ 5,320 7 Dec. 31, 2020 Current liabilities $ 2,510 8 Dec. 31, 2021 Current assets $ 5,970 9 Dec. 31, 2021 Current liabilities $ 3,240 10 11 (Use cells A6 to B9 from the given information to complete this question.) 12 13 Output area: 14 15 Ending NWC 16 Beginning NWC 17 Additions to net working capital 18 19 20 X 5 SDJ, Incorporated, has net working capital of $1,090, current liabilities of $6,750, and inventory of $1,160. a. What is the current ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the quick ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. a. Current ratio b. Quick ratio times times 6 Rogers, Incorporated, has an equity multiplier of 1.36, total asset turnover of 1.65, and a profit margin of 8 percent. What is the company's ROE? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. ROE % A1 A Calibri (Body) 11 A BIU ab Wrap Merge v General 0 .00 0 X fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in columns A, B and D. The required answers are in column C. B C D E F G H 1 9 10 11 12 13 14 2345678222EENEN2222 17 18 19 20 Solve for the unknown interest rate in each of the following: (Your answers should be positive values.) Output area: Input area: Present value Years Interest rate Future value $181 8 $335 $48,000 13 $317 $1,080 $40,353 11 25 $185,382 $534,618 15 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 16 Nothing in this area will be graded, but it will be submitted with your assignment. J K L M N P Q R S T U V W 00 For each of the following, compute the future value: Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Present Value Years Interest Rate Future Value $ 2,250 9 18 % 10,253 22 6% 107,305 16 11 % 245,382 28 5% Graff, Inc., has sales of $49,800, costs of $23,700, depreciation expense of $2,300, and interest expense of $1,800. If the tax rate is 22 percent, what is the operating cash flow, or OCF? Input area: Sales $49,800 Costs $23,700 Depreciation Expense $2,300 Interest Expense $1,800 22% Tax rate (Use cells A6 to B10 from the given information to complete this question.) Output area: Sales Costs Depreciation expense EBIT Interest expense EBT Taxes (22%) Net income Operating cash flow A1 1 2 34 L ab Wrap Merge v General .00 0 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 9. The required answers are in rows 15 through 17. R S T B C E F G H J K L M N P Q U W Calibri (Body) A The 2020 balance sheet of Dugan, Inc., showed current assets of $5,320 and current liabilities of $2,510. The 2021 balance sheet showed current assets of $5,970 and current liabilities of $3,240. What was the company's 2021 change in net working capital, or NWC? Input area: 5 6 Dec. 31, 2020 Current assets $ 5,320 7 Dec. 31, 2020 Current liabilities $ 2,510 8 Dec. 31, 2021 Current assets $ 5,970 9 Dec. 31, 2021 Current liabilities $ 3,240 10 11 (Use cells A6 to B9 from the given information to complete this question.) 12 13 Output area: 14 15 Ending NWC 16 Beginning NWC 17 Additions to net working capital 18 19 20 X 5 SDJ, Incorporated, has net working capital of $1,090, current liabilities of $6,750, and inventory of $1,160. a. What is the current ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the quick ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. a. Current ratio b. Quick ratio times times 6 Rogers, Incorporated, has an equity multiplier of 1.36, total asset turnover of 1.65, and a profit margin of 8 percent. What is the company's ROE? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. ROE % A1 A Calibri (Body) 11 A BIU ab Wrap Merge v General 0 .00 0 X fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in columns A, B and D. The required answers are in column C. B C D E F G H 1 9 10 11 12 13 14 2345678222EENEN2222 17 18 19 20 Solve for the unknown interest rate in each of the following: (Your answers should be positive values.) Output area: Input area: Present value Years Interest rate Future value $181 8 $335 $48,000 13 $317 $1,080 $40,353 11 25 $185,382 $534,618 15 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 16 Nothing in this area will be graded, but it will be submitted with your assignment. J K L M N P Q R S T U V W 00 For each of the following, compute the future value: Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Present Value Years Interest Rate Future Value $ 2,250 9 18 % 10,253 22 6% 107,305 16 11 % 245,382 28 5%