80.2K

Verified Solution

Link Copied!

Could you please help me whit this lab , please show formulas and workings in excel

Logical

In column H create an IF function to show "High ROA" for all stocks whose ROA is above 20% and "Low ROA" for all others

In column I use an OR function to show "True" all stocks that has ROA above 20% or net profit margin above 17.5%

In column J create an AND function to show "True" all stocks gross profit margin above 52.5% and net profit margin above 17.5.

In column K combine the IF and AND functions to find all stocks whose current ratio is above 1.78 and quick ratio above 0.67

For companies that meet the criteria (is true) have the function write High Liquidity. For companies that do not meet the

criteria (is false), print nothing. To make nothing appear, use consecutive double quotes ().

stock	gross profit margin	net profit margin	Roa	ROE	Current ratio	if	or	and	if	AND
82298	39.2%	15.1%	11.4%	8.1%	2.7
23819	14.6%	7.1%	17.1%	38.7%	1.68
80926	80.9%	22.3 %	23.1%	15.6%	o.95

statistical

Question 2 excel ( please show formulas and workings

Question 3

Thanks for the help in advance

pool 99 K A B. C D E F G H 1. In column H create an IF function to show "High ROA" for all stocks whose ROA is above 20% and "Low ROA" for all others. 2. In column I use an OR function to show "True" all stocks that has ROA above 20% or net profit margin above 17.5%. 3. In column I create an AND function to show "True" all stocks gross profit margin above 52.5% and net profit margin above 17.5. 4. In column K combine the IF and AND functions to find all stock hose current ratio is above 1.78 and quick ratio above 0.67. For companies that meet the criteria (is true) have the function te "High Liquidity".For companies that do not meet the criteria (is false), print nothing. To make nothing appear, use consecutive double quotes (""). IF OR AND IF AND Gross Profit Net Profit Stock ID Margin Margin ROA 82298 39.2% 15.1% 11.4% 23819 14.6% 7.1% 17.1% 80926 80.9% 22.3% 23.1% 80912 37.6% 15.9% 71.3% 62341 28.4% 13.3% 20.0% 79915 85.1% 14.5% 31.9% 34833 51.1% 34.9% 31.3% 79857 42.3% 18.2% 44.6% 61815 77.1% 28.8% 24.1% 79444 78.9% 22.6% 26.1% 79066 -30.9% -35.6% -5.8% 59089 25.4% 10.4% 11.9% 78877 59.0% 18.3% 25.0% 78841 86.5% 36.4% 93.9% 15069 11.3% 3.9% 20.7% 58975 25.0% 5.8% 18.4% 32707 25.0% 0.7% 9.9% Logical Statistical LineChart ROE Current Ratio Quick Ratio 8.1% 2.70 2.59 38.7% 1.68 1.51 15.6% 0.95 0.95 163.4% 1.18 1.08 20.5% 0.98 0.95 9.9% 0.77 0.74 38.4% 1.29 1.13 23.5% 2.27 2.17 23.7% 0.99 0.96 13.3% 0.95 0.95 -59.1% 0.37 0.78 12.5% 3.71 2.37 19.5% 0.58 0.40 59.5% 3.17 3.12 21.4% 1.34 0.93 11.8% 1.72 1.45 0.4% 4.10 3.76 View Help X Cut [Copy Times New Roman 12 a Wrap Text ' a. A. Custom Paste BIU v Format Painter Merge & Center V $ % Clipboard Font Alignment Num J4 M G H I J K L Your will be writing your formulas in the blue area. Write once and copy down. N O P 1 2 Net Profit Margin 3 Current Ratio Quick Ratio ROA ROE 4 5 Quick Ratio 2.59 1.51 0.95 1.08 0.95 Gross Profit Function Margin Count Average Max Min Median Mode 6 7 8 9 10 11 12 0.74 13 1.13 2.17 0.96 0.95 0.78 2.37 0.40 14 15 16 Calibri 12 == ab Wrap Text Number X Cut [G Copy & Format Painter Paste BIU A. Merge & Center $%8-09 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Fy Alignment 5 Number 38 1.67714437932872 D E F G H J K Current Ratios: Combined Comparison Year Company A 2000 1.64 2001 1.86 2002 1.92 2003 1.34 2004 1.68 Industry 2.00 1.80 1.76 1.81 1.81 Build a two series line chart from the data on the left Place year on the horizontal (x) axis Place values on the vertical (y) axis Link the chart title to cell A1 Adjust the chart so that the dates are show horizontally on the pool 99 K A B. C D E F G H 1. In column H create an IF function to show "High ROA" for all stocks whose ROA is above 20% and "Low ROA" for all others. 2. In column I use an OR function to show "True" all stocks that has ROA above 20% or net profit margin above 17.5%. 3. In column I create an AND function to show "True" all stocks gross profit margin above 52.5% and net profit margin above 17.5. 4. In column K combine the IF and AND functions to find all stock hose current ratio is above 1.78 and quick ratio above 0.67. For companies that meet the criteria (is true) have the function te "High Liquidity".For companies that do not meet the criteria (is false), print nothing. To make nothing appear, use consecutive double quotes (""). IF OR AND IF AND Gross Profit Net Profit Stock ID Margin Margin ROA 82298 39.2% 15.1% 11.4% 23819 14.6% 7.1% 17.1% 80926 80.9% 22.3% 23.1% 80912 37.6% 15.9% 71.3% 62341 28.4% 13.3% 20.0% 79915 85.1% 14.5% 31.9% 34833 51.1% 34.9% 31.3% 79857 42.3% 18.2% 44.6% 61815 77.1% 28.8% 24.1% 79444 78.9% 22.6% 26.1% 79066 -30.9% -35.6% -5.8% 59089 25.4% 10.4% 11.9% 78877 59.0% 18.3% 25.0% 78841 86.5% 36.4% 93.9% 15069 11.3% 3.9% 20.7% 58975 25.0% 5.8% 18.4% 32707 25.0% 0.7% 9.9% Logical Statistical LineChart ROE Current Ratio Quick Ratio 8.1% 2.70 2.59 38.7% 1.68 1.51 15.6% 0.95 0.95 163.4% 1.18 1.08 20.5% 0.98 0.95 9.9% 0.77 0.74 38.4% 1.29 1.13 23.5% 2.27 2.17 23.7% 0.99 0.96 13.3% 0.95 0.95 -59.1% 0.37 0.78 12.5% 3.71 2.37 19.5% 0.58 0.40 59.5% 3.17 3.12 21.4% 1.34 0.93 11.8% 1.72 1.45 0.4% 4.10 3.76 View Help X Cut [Copy Times New Roman 12 a Wrap Text ' a. A. Custom Paste BIU v Format Painter Merge & Center V $ % Clipboard Font Alignment Num J4 M G H I J K L Your will be writing your formulas in the blue area. Write once and copy down. N O P 1 2 Net Profit Margin 3 Current Ratio Quick Ratio ROA ROE 4 5 Quick Ratio 2.59 1.51 0.95 1.08 0.95 Gross Profit Function Margin Count Average Max Min Median Mode 6 7 8 9 10 11 12 0.74 13 1.13 2.17 0.96 0.95 0.78 2.37 0.40 14 15 16 Calibri 12 == ab Wrap Text Number X Cut [G Copy & Format Painter Paste BIU A. Merge & Center $%8-09 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Fy Alignment 5 Number 38 1.67714437932872 D E F G H J K Current Ratios: Combined Comparison Year Company A 2000 1.64 2001 1.86 2002 1.92 2003 1.34 2004 1.68 Industry 2.00 1.80 1.76 1.81 1.81 Build a two series line chart from the data on the left Place year on the horizontal (x) axis Place values on the vertical (y) axis Link the chart title to cell A1 Adjust the chart so that the dates are show horizontally on the

Answer & Explanation Solved by verified expert

See Answer