19 Student Excel File (version 1)- Excel Amre O Cash Aats owate owene or ou Mrke nuas am 230 28 9300 ad aERKE 620 3750 uates taonet wamdud r n e 90000 tok wamind reguton d 2486 63000 20000 197300 laesPa UNtR Pa Paro Tesnrat erer Pble 42 00o 30300 7MT 8005 e Ta Paer saale hot Payahe long 21n06 aod Paybleet CommonStak, St o. E000 labres ed and auteg 41 000 230000 ueaed Comvens Thmry5td 58.000 30000 an trsryas Retnedta 133 100 Cot of oods i Congematon te e235 24000 51000 Selatemum 34400 Aene Epn 2780 8790 Pard Tate 22000 Avertng Eapen inoraaten SauEpense oeca ee 46700 44014 6000 acessute Exe 600 2500 Macirco smm 12400 Inerat Esnw 10504 one Ta Expena 1000 1,000 unvad dah shoe 316 251 d52514 1302600 133.000 20953 200 53 bow Agount Tite Dr Cr De Ca Ameaail 0 AwfDokdAgees Matebl hwal eaecs Svn A a gr Tak 26 Acut Padl s4eteuls 420m EmPiles ends l wolePele No P g nd ee w G Sd,Slee. Kalym dd l u Go arac ANC Tery Sod Cacel Mekitam sLaw AerisEafe A nig wal.m ser Compute the Ratio Compute the following Current Ratio Acid Ratio Debt to Equity Inventory Turnover Accounts Receivable Turnover At least 5 other Ratios of your chossing Multistep income Statement Sales 1331100 Cost of Goods Sold 622379 Gross Profit 708721 Less: Operating Expense Compensation Expense Salaries Expense 24000 51000 Rent Expense 34400 Bad Debt Expense 27880 Payroll Tax Expense Advertising Expense 9790 22000 46750 Insurance Expense Supplies Expense Depreciation Expense 3150 44014 Amortization Expense Utilities Expense 5000 6000 Misc. Expense Total Operating Expense 2500 276484 432237 Income from Operations Less Interest Expense -12399.7 Add: Unrealized gain 1500 -1000 Less: Realized losses 420337.3 Income before Tax -105084 Income Tax Expense 315253.3 Net income 19 Student Excel File (version 1)- Excel Amre O Cash Aats owate owene or ou Mrke nuas am 230 28 9300 ad aERKE 620 3750 uates taonet wamdud r n e 90000 tok wamind reguton d 2486 63000 20000 197300 laesPa UNtR Pa Paro Tesnrat erer Pble 42 00o 30300 7MT 8005 e Ta Paer saale hot Payahe long 21n06 aod Paybleet CommonStak, St o. E000 labres ed and auteg 41 000 230000 ueaed Comvens Thmry5td 58.000 30000 an trsryas Retnedta 133 100 Cot of oods i Congematon te e235 24000 51000 Selatemum 34400 Aene Epn 2780 8790 Pard Tate 22000 Avertng Eapen inoraaten SauEpense oeca ee 46700 44014 6000 acessute Exe 600 2500 Macirco smm 12400 Inerat Esnw 10504 one Ta Expena 1000 1,000 unvad dah shoe 316 251 d52514 1302600 133.000 20953 200 53 bow Agount Tite Dr Cr De Ca Ameaail 0 AwfDokdAgees Matebl hwal eaecs Svn A a gr Tak 26 Acut Padl s4eteuls 420m EmPiles ends l wolePele No P g nd ee w G Sd,Slee. Kalym dd l u Go arac ANC Tery Sod Cacel Mekitam sLaw AerisEafe A nig wal.m ser Compute the Ratio Compute the following Current Ratio Acid Ratio Debt to Equity Inventory Turnover Accounts Receivable Turnover At least 5 other Ratios of your chossing Multistep income Statement Sales 1331100 Cost of Goods Sold 622379 Gross Profit 708721 Less: Operating Expense Compensation Expense Salaries Expense 24000 51000 Rent Expense 34400 Bad Debt Expense 27880 Payroll Tax Expense Advertising Expense 9790 22000 46750 Insurance Expense Supplies Expense Depreciation Expense 3150 44014 Amortization Expense Utilities Expense 5000 6000 Misc. Expense Total Operating Expense 2500 276484 432237 Income from Operations Less Interest Expense -12399.7 Add: Unrealized gain 1500 -1000 Less: Realized losses 420337.3 Income before Tax -105084 Income Tax Expense 315253.3 Net income