Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer with the correct formula pertaining to this question. Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to
please answer with the correct formula pertaining to this question.
Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to ossess liquidity 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for det management purposes, Can you explain to me how i am supposed to do Excel Sheets? You do the sheets the same way 'except you must use cell addresses and formulas instead of the numbers like you did on the fillin the blank where you keyed figures for example: Problem 11 Row 33 your calculated 40% as the Gross Margin but now you can not key it but rather must use the formula in cell C33 of =F9/F7 ROW 34 Current ratio (and must round to 2 decimals you would calculate 144 but now must show formula soch as-ROUND(B12/822,2) The round function puts in the formula but add the ROUND with the number of decimals after the 2. If you want no decimals use 0 at the end; for 4 decimals use 4) Row 35 Acid Test use =ROUND((B7-88-89)B22.2) and be careful using parentheses as you have to use them to add amounts before you divide so you may have several sets of parentheses C X 1 Selected Financial Ratios - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Gabri 10 LIAN % M B Paste BTW: Cells Editing Alignment Number Conditional Formatas Call Formatting Table Styles Styles Clipboard Font . C37 B E F 25 ockholders equity 26 common stock 1.150.000 Number of shares outstanding 57.300 1,150,000 431.000 Retained camin vtalstotholdereit 1125.000 225.000 28 2001 000 F E A B Number of shares outstanding 57,500 1,150,000 941.600 1,135.000 2,091,600 4585.000 3.9351.000 40W 1.44 25 stockholders equity 26 Common stock 1,150,000 27 Retained earnings 28 utal stockholders' equity 2285.000 29 otal liabilities and stockholders' equity 30 31 required: 32 Compute the following ratios for the current year only: 33 Gross margin percentage 34 Current ratio (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 36 Accounts receivable turnover (rounded to two decimal places) 37 Average collection period frounded to the nearest whole day) 38 Inventory turnover ratio (rounded to two decimal places) 39 Average sales period (rounded to the nearest whole day) 40 Debt-to-equity ratio (rounded to two decimal places) 41 Times interest earned (rounded to two decimal places) 42 Book value per share (rounded to two decimal places) 43 Earnings per share (rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places) 46 Price-earnings ratio (rounded to two decimal places) 0174 6.75 Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to ossess liquidity 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for det management purposes, Can you explain to me how i am supposed to do Excel Sheets? You do the sheets the same way 'except you must use cell addresses and formulas instead of the numbers like you did on the fillin the blank where you keyed figures for example: Problem 11 Row 33 your calculated 40% as the Gross Margin but now you can not key it but rather must use the formula in cell C33 of =F9/F7 ROW 34 Current ratio (and must round to 2 decimals you would calculate 144 but now must show formula soch as-ROUND(B12/822,2) The round function puts in the formula but add the ROUND with the number of decimals after the 2. If you want no decimals use 0 at the end; for 4 decimals use 4) Row 35 Acid Test use =ROUND((B7-88-89)B22.2) and be careful using parentheses as you have to use them to add amounts before you divide so you may have several sets of parentheses C X 1 Selected Financial Ratios - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Gabri 10 LIAN % M B Paste BTW: Cells Editing Alignment Number Conditional Formatas Call Formatting Table Styles Styles Clipboard Font . C37 B E F 25 ockholders equity 26 common stock 1.150.000 Number of shares outstanding 57.300 1,150,000 431.000 Retained camin vtalstotholdereit 1125.000 225.000 28 2001 000 F E A B Number of shares outstanding 57,500 1,150,000 941.600 1,135.000 2,091,600 4585.000 3.9351.000 40W 1.44 25 stockholders equity 26 Common stock 1,150,000 27 Retained earnings 28 utal stockholders' equity 2285.000 29 otal liabilities and stockholders' equity 30 31 required: 32 Compute the following ratios for the current year only: 33 Gross margin percentage 34 Current ratio (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 36 Accounts receivable turnover (rounded to two decimal places) 37 Average collection period frounded to the nearest whole day) 38 Inventory turnover ratio (rounded to two decimal places) 39 Average sales period (rounded to the nearest whole day) 40 Debt-to-equity ratio (rounded to two decimal places) 41 Times interest earned (rounded to two decimal places) 42 Book value per share (rounded to two decimal places) 43 Earnings per share (rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places) 46 Price-earnings ratio (rounded to two decimal places) 0174 6.75 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started