Question

Some recent financial statements for Smolira Golf, Inc., follow. points eBook SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners' Equity Current assets Current liabilities Cash $ 3,211 $ 3,307 Accounts payable $ 2,153 $ 2,600 Accounts receivable 4,767 5,781 Notes payable 1,750 2,116 Inventory 12,478 13,782 Other 90 107 Total $20,456 $22,870 Total $ 3,993 $ 4,823 Long-term debt $ 13,400 $ 16,160 Owners' equity Common stock and paid-in surplus Accumulated retained Fixed assets earnings 15.654 39,112 Print References $38,000 $ 38,000 Net plant and equipment $ 50,591 $75,225 Total $53,654 $ 77,112 Total assets $ 71,047 $98,095 Total liabilities and owners' equity $ 71,047 $ 98,095

Financial statements and necessary information is above.

Find the following financial ratios for Somolira Golf(use year-end figures rather than average values where appropriate): (Do not round internediate calculations and tound your answer to 2 decimal places e.g., 32.16. Enter the profitability ratios as a percent.

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ACCOUNTS latest Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Trace Precedents Show Formulas fx Define Name Calculate Now Trace Dependents Error Checking PUse in Formula Calculation Calculate Sheet AutoSum Recently Financial Logical Used Insert Тext Date & Lookup & Time Reference & Trig Functions Manager Create from Selection Math More Name Watch Remove Arrows Evaluate Formula Function Window Options Function Library Defined Names Formula Auditing Calculation fox DM157 DQ DIZ DM DN DO DP DR DS DT DU DV 157 158 159 SHORT TERM SOLVENCY RATIOS 2018 2019 20456 160 CURRENT ASSETS 22870 CURRENT LIABILITIES 161 3993 4823 CASH & MARKETABLE SECURITIES 162 3211 3307 12478 163 INVENTORY 13782 164 CURRENT RATIO CURRENT ASSETS/CURRENT LIABILITIES 165 a 5.12 4.74 166 167 QUICK RATIO = (CURRENT ASSETS - INVENTORY)/CURRENT LIABILITIES 168 b 2.00 1.88 169 170 CASH RATIO CASH & MARKETABLE SECURITIES/CURRENT LIABILITIES 171 c 0.80 0.69 172 173 174 175 budget BEP, OL FL ratios DETROIT SALES BUDGET CASH BUDGET 45 days VARIANCE float B-S profit loss DIFF ANALYSIS EE cycle ove ROE, BV MV ratio dupont FIFO erences 130% WA 02:11 ENG 27-11-2019

ACCOUNTS latest Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Trace Precedents Show Formulas fx Define Name Calculate Now Trace Dependents Error Checking PUse in Formula AutoSum Recently Financial Logical Used Calculation Options a Calculate Sheet Insert Тext Date & Lookup & Time Reference & Trig Functions Manager Create from Selection Math More Name Watch Remove Arrows Evaluate Formula Window Function Defined Names Formula Auditing Calculation Function Library fox DP102 DQ DIZ DM DN DO DP DR DT DU DV 102 103 ASSET UTILISATION RATIOS 104 105 TOTAL ASSETS 98095 106 SALES 187370 107 COGS 126203 108 INVENTORY 13782 109 RECEIVABLE 5781 110 2019 SALES/TOTAL ASSETS 111 TOTAL ASSETS TURNOVER 112 TOTAL ASSETS TURNOVER 1.91 113 COGS/INVENTORY INVENTORY TURNOVER 114 e 115 INVENTORY TURNOVER 9.16 116 SALES/RECEIVABLE f 117 RECEIVABLES TURNOVER 118 RECEIVABLES TURNOVER 32.41 119 budget SALES BUDGET CASH BUDGET 45 days VARIANCE BEP, OL FL float B-S profit loss DIFF ANALYSIS ove 130 % cycle FIFO ROE, BV MV ratio dupont ratios DETROIT EE erences WA 02:13 ENG 27-11-2019

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Trace Precedents Show Formulas fx aDefine Name Calculate Now Trace Dependents Error Checking Use in Formula AutoSum Recently Financial Logical Calculation Options a Calculate Sheet Insert Text Date & Lookup & Time Reference & Trig Functions Manager Math More Name Watch Remove Arrows Evaluate Formula Window Create from Selection Function Used Formula Auditing Calculation Function Library Defined Names DR123 DQ DIZ DM DN DO DP DR DS DT DU DV 123 124 125 LONG TERM SOLVENCY RATIOS 126 127 2018 2019 71047 98095 128 A TOTAL ASSETS = TOTAL EQUITY 53654 129 В 77112 TOTAL DEBT 130 А-В 17393 20983 131 TOTAL DEBT RATIO = (TOTAL ASSETS - TOTAL EQUITY)/TOTAL ASSETS 132 133 TOTAL DEBT RATIO = 0.24 0.21 g 134 DEBT EQUITY RATIO = TOTAL DEBT/TOTAL EQUITY 135 136 DEBT EQUITY RATIO = 0.32 0.27 137 EQUITY MULTIPLIER = 1 DEBT EQUITY RATIO 138 EQUITY MULTIPLIER = 139 1.32 1.27 140 141 B-S profit loss budget 45 days SALES BUDGET VARIANCE BEP, OL FL float DIFF ANALYSIS cycle ove ROE, BV MV ratio dupont FIFO CASH BUDGET ratios DETROIT (- erences 130% WA 02:14 ENG 27-11-2019

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Trace Precedents Show Formulas fx aDefine Name Calculate Now Trace Dependents Error Checking PUse in Formula Calculation Calculate Sheet Options AutoSum Recently Financial Logical Used Insert Тext Date & Lookup & Time Reference & Trig Functions Manager Create from Selection Math More Name Watch Remove Arrows Evaluate Formula Window Function Calculation Function Library Formula Auditing Defined Names fox DT140 DQ DIZ DM DN DO DP DR DS DT DU DV 140 141 142 EBIT 55834 2019 INTEREST 1430 143 DEPRECIATION 144 5333 TIMES INTEREST EARNED RATIO = EBIT /INTEREST j 145 39.04 CASH COVERAGE RATIO = (EBIT DEPRECIATION)/ INTEREST k 146 42.77 147 148 PROFITABILITY RATIOS 149 NET INCOME 35363 TOTAL ASSETS 98095 SALES EQUITY 150 187370 77112 151 PROFIT MARGIN = NET INCOME/SALES *100 152 18.87% 153 RETURN ON ASSETS= NET INCOME/TOTAL ASSETS*100 36.05% 154 155 RETURN ON EQUITY = NET INCOME/EQUITY 100 156 45.86% 157 158 budget VARIANCE BEP, OL FL ratios DETROIT SALES BUDGET DIFF ANALYSIS CASH BUDGET 45 days float B-S profit loss cycle ονε! FIFO ROE, BV MV ratio dupont 130% erences WA 02:14 ENG 27-11-2019