Old MathJax webview

please mention the excel formulas like (D6/D3*G1).

M N 2019 o P 0 Current Ratio Quick Ratio 1) What is the final 2021 Cash Balance ? 2) What is the final 2021 Accounts Payable ? 3) What is the final 2021 Accounts Receivable ? 4) List any months that have a negative cash flow: Gross Margin Profit Margin Budget: 17 Marks Ratos: 5 Marks Q1, 02, 03, 04:8 Marks Debt to Equity Return on Assets Return on Equity Interest Coverage EBIT Interest Debt Coverage EBIT + Leases + Current LTD Interest + Current LTD + Leases Avg, Collection Period Accounts Receivable Average Daily Credit Sales days F22+Income!D14-Income!D15 Styles Cells Filter Select Editing dea D E F G H K M N 2019 2018 $ B 1 Elvish Cloaks and Breeches 2 Balance Sheet 3 4 Current assets 5 Cash 6 Accounts receivable (net) 7 Inventory 8 Total current assets 9 Net Property 10 Net Equipment 11 Total assets 12 13 Current liabilities 14 Accounts payable 15 Current Portion of LTD 16 Notes payable 17 Total current liabilities 18 Long-term liabilities 19 Long-Term Debt 20 Total Long-Term liabilities 21 Common stock 22 Retained earings 23 Total liabilities and shareholders' equity 24 9,528 25,000 75,304 109,832 48,000 17,202 175,034 5.4% $ 14.3% 43.0% 62.7% 27.4% 9.8% 100.0% $ 8,856 22,500 67,000 98,356 50.000 22,000 170,356 5.2% 13.2% 39.3% 57.7% 29.4% 12.9% 100.0% $ Project a receivables and payables cash budget for 2020 Asume purchases and labour for 2020 w remain the same percentages of sales as 2019 $ $ 19,000 5,000 10,000 34,000 10.9% $ 2.9% $ 5.7% 9.4% 24,000 5,000 16,000 45,000 14.1% 2.9% 9.4% 26.4% 30,000 30,000 25,000 86,034 175,034 17.1% 35,000 17.1% 35,000 14.3% 25,000 49.2% 65,356 100.0% $ 170,356 20.5% 20.5% 14.7% 38.4% 100.0% $ 25 26 27 M N 2019 o P 0 Current Ratio Quick Ratio 1) What is the final 2021 Cash Balance ? 2) What is the final 2021 Accounts Payable ? 3) What is the final 2021 Accounts Receivable ? 4) List any months that have a negative cash flow: Gross Margin Profit Margin Budget: 17 Marks Ratos: 5 Marks Q1, 02, 03, 04:8 Marks Debt to Equity Return on Assets Return on Equity Interest Coverage EBIT Interest Debt Coverage EBIT + Leases + Current LTD Interest + Current LTD + Leases Avg, Collection Period Accounts Receivable Average Daily Credit Sales days F22+Income!D14-Income!D15 Styles Cells Filter Select Editing dea D E F G H K M N 2019 2018 $ B 1 Elvish Cloaks and Breeches 2 Balance Sheet 3 4 Current assets 5 Cash 6 Accounts receivable (net) 7 Inventory 8 Total current assets 9 Net Property 10 Net Equipment 11 Total assets 12 13 Current liabilities 14 Accounts payable 15 Current Portion of LTD 16 Notes payable 17 Total current liabilities 18 Long-term liabilities 19 Long-Term Debt 20 Total Long-Term liabilities 21 Common stock 22 Retained earings 23 Total liabilities and shareholders' equity 24 9,528 25,000 75,304 109,832 48,000 17,202 175,034 5.4% $ 14.3% 43.0% 62.7% 27.4% 9.8% 100.0% $ 8,856 22,500 67,000 98,356 50.000 22,000 170,356 5.2% 13.2% 39.3% 57.7% 29.4% 12.9% 100.0% $ Project a receivables and payables cash budget for 2020 Asume purchases and labour for 2020 w remain the same percentages of sales as 2019 $ $ 19,000 5,000 10,000 34,000 10.9% $ 2.9% $ 5.7% 9.4% 24,000 5,000 16,000 45,000 14.1% 2.9% 9.4% 26.4% 30,000 30,000 25,000 86,034 175,034 17.1% 35,000 17.1% 35,000 14.3% 25,000 49.2% 65,356 100.0% $ 170,356 20.5% 20.5% 14.7% 38.4% 100.0% $ 25 26 27