Using the attached spreadsheet,determine the effect each of the journal entries would have on the attached ratios.

Mail- AHAe WP Grade WP eText WSJ Searc Aol. AOLI UPDA _ Cours WSJ A Gui Bb Home Bb A X Bb Bus 1 3 Acc 2 W Bus 1 * DEPA A G how t + X C bbhosted.cuny.edu/bbcswebdav/pid-48107537-dt-content-rid-410534060_1/courses/CS101_ACC_218_D001_1209_1/Acc%20218%20Homework%20Assign... X Acc 218 Homework Assignment.xIsx Download Share File Edit Insert Format Help Q Q Calibri 14 . BIUSA. fx B DE H K M IN R S V W Z AA AB AC AD Entry Entry a Entry Entry a Entry a Entry Entry Page 1 Ratio Formula for Computation Beginning Ratio Calculations Effect on Calculations Calculations Calculations Calculations Calculations Calculations Cash Ratio Entry b Entry c Entry d Entry e Entry Entr Bonds Payable LIQUIDITY issued bonds Working Capital Current assees-Current Liabilities 9 Increase Current ratio Current assets/Current liabilities 2 5 Increase Inventory turnover Cost of goods sold Average inventory Stay same Interest Expense 2 Days In inventory 365/Inventory Turnover Stay same 10 Interest Payable Accounts receivable turnover Net credit sales//werage net accounts receivable Stay same 13 Average collection period 365/Accounts receivable turnover Stay same 12 (Cash+Short-term investments+Accounts receivable (net)) Current liabilitie 1.5 Interest Payable Quick of acid test ratio 2 33 Increase 13 Cash Current cash debt To be coverage Net cash provided by operating activities//werage current liabilities determine 14 15 Bonds Payable SOLVENCY 16 Cash Debt to assets ratio Total liabilities/Total assets 17 Times interest earned (Interest Coverage) (Net Income+Interest expense+ Income tax expense)Interest expense 18 Free cash flow Net cash provided by operating activities-Capital expenditures.Cash To be Interest Payable dividends determine 19 Cast 20 PROFITABILITY 21 (Net income-Preferred dividends )Weighted-average common shares Stock Investments-Trading Securities Earnings per share outstanding 22 Cash Price earnings ratio Market price per share Eamings per share 23 Gross profit rate Gross Profit Net sales 24 Cash Profit margin on sales Net income Net sales 25 Interest Revenue Return on assets Net income/Average total assets 26 Asset turnover Net sales/Average total assets 27 Payout ratio Cash dividends Declared on Common Stock/Net income 28 Return on common stockholders' equity (Net income-Preferred dividends )Average cor mon stockholders equity Book value per share mon stockholders' equity Outstanding common shares Sample entries 9 US 8 7 19:32