Question

Spreadsheet+Assignment+1+-++Fin+3100+-+s10 a- Search Sheet Home Insert Page Layout Formulas Dta Review View CutC Copy Format Share ^ AutoSum Calibri (Body) 11A A Wrap Text φ| Filly B IU . I 1-1을 들| 恒 .. Merge & Center, $ % , ' 시 conditional asonable Styles Paste Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & Filter Clear Calculate the ratios below given the financial data presented to your left Meesures ef Short term Liauid ty 3,000 14,800 quick rato recevatles turnover days to colleet reeevebles neantary turcvar rate 11 Foced Asset 35 darbDate 14 Total Assets e Credi Risk batal aets operating han. / a1tud interest-apet&# 17 Accouns payable Wagspuya 5.000 Profi Mangn totl assets tod equity 21 Bonds paratle 5000 9,000 retum en equity 14 000 5,400 19,0 27 Tolal blitie Equity income Statemet gross prot Oparatius 12,300 Sheet1+ Enter 囲ロー 81%

Answer 1

C2 $ 2,500 1,900 $12,000 cash accounts receivable invento total current assets fixed assets pro total assets current ratio quick ratio receivable turnover ratio days to collect receivable11.558 inventory turnover rate 2.05 0.55 31.579 $16,400 6 2.917 $20,000 $36,400 lant & equipment debt ratico times interest earned 0.467 28.333 5,000 $ 3,000 accounts payable wages payable total current liabilites long term liabilities bonds payable equi common stock retained earnings total liabilites equit 10 profit margin return on assets return on equit 20.50% 33.79% 63.40% 8,000 12 13 14 15 16 17 18 9,000 $14,000 5,400 $19,400 $36,400 net sales cogs gross profit operating expenses operating income interest expense tax expense net income $60,000 $35,000 $25,000 8,000 $17,000 $ 600 4,100 $12,300 20 21 27

for calculations, refer to the next image -