accounting
almajd.255
2 years ago
20
files (3)LO4.xlsx
LO3.xlsx
- LO2.XLSX
LO4.xlsx
T1-cash collection
| Prepare Scheduled of expected cash collection as follows: | ||||||
| Month | 1 | 2 | 3 | 4 | Total | |
| Budgeted revenue | £ 110,000 | £ 230,000 | £ 140,000 | £ 270,000 | £ 750,000 | |
| company collection policy | on the month of sale | 70% | ||||
| the following month | 30% | |||||
| 1 | 2 | 3 | 4 | Total | ||
| Beg.Account receivables | £ - 0 | |||||
| January | £ - 0 | |||||
| February | £ - 0 | |||||
| March | £ - 0 | |||||
| April | £ - 0 | |||||
| Total | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 | |
T2-cash disbursement
| Prepare Scheduled of expectedcash disbursement as follows: | ||||||
| Month | 1 | 2 | 3 | 4 | Total | |
| Budgeted Purchases | £ 580,000 | £ 110,000 | £ 65,000 | £ 150,000 | £ 905,000 | |
| company collection policy | on the month of sale | 50% | ||||
| the following month | 50% | |||||
| 1 | 2 | 3 | 4 | Total | ||
| Beg.Account payable | £ - 0 | |||||
| January | £ - 0 | |||||
| February | £ - 0 | |||||
| March | £ - 0 | |||||
| April | £ - 0 | |||||
| Total | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 | |
cash Budget
| Preparing the cash budget | ||||||
| 1 | 2 | 3 | 4 | Total | ||
| Beginning,cash balance | £ - 0 | |||||
| Add(+) cash receipts : | ||||||
| Total cash collection (T1) | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 | |
| A | Total cash available | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 |
| Less(-) cash disbursement : | ||||||
| Total cash disbursement (2) | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 | |
| Administrative expenses | £ - 0 | |||||
| Cash dividends | £ - 0 | |||||
| Equipment purchases | £ - 0 | |||||
| B | Total cash disbursement | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 |
| A-B = | Excess ( deficiency ) of cash available for disbursements | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 |
| Financing | £ 70,000 | |||||
| Ending,cash balance | £ - 0 | £ - 0 | £ - 0 | £ - 0 | £ - 0 |
LO3.xlsx
Sheet2
| Omega Bookshop | Omega company | |||||||||||
| Income Statement-comparative statements | Financial position- Years ended December 31,2021 and 2022 | |||||||||||
| December 31.2021 | December 31.2022 | Item | 2021 | 2022 | Ratio | 2021 | 2022 | Compare (2021&2022) | Interpretation | |||
| Net Sales | 36400 | 49900 | Assets | Liquidity | ||||||||
| Cost of goods sold | 1920 | 2640 | Current Assets | Net working capital صافي راس المال العامل | 3500 | 8040 | 4540 | |||||
| Gross profit | 34480 | 47260 | Cash & Cash equivalent | 500 | 2720 | current ratio نسبة التداول | - 0 | |||||
| Operating expenses (OPEX): | Accounts Receivable | 1800 | 1900 | Quick ratio نسبة السيولة السريعة | - 0 | |||||||
| Salaries and wages expenses | 900 | 1150 | Merchandising inventory | 2500 | 4125 | cash ratioنسبة النقد | - 0 | |||||
| Supplies expenses | 200 | 300 | Prepaid expense’s | 100 | 180 | Profitability Ratio | ||||||
| Rent expenses | 300 | 400 | Total current Assets | 4900 | 8925 | |||||||
| Utilities expenses | 200 | 300 | Long term investment | 2000 | 1800 | Net Profit Marginنسبة هامش صافي الربح | 0% | |||||
| Total operating expenses | 1600 | 2150 | Property plant & equipment (PP&E) | 9000 | 1400 | Gross Margin Ratioهامش الربح الاجمالي | 0% | |||||
| Income before interest and tax | 32880 | 45110 | Total Assets | 15900 | 12125 | Efficiency | ||||||
| Interest expenses | 850 | 0 | Liabilities | Accounts Receivable Turnover Ratio | - 0 | |||||||
| Income before tax | 32030 | 45110 | Accounts payable | 900 | 235 | Accounts Receivable Days | - 0 | |||||
| Tax (16%) | 5124.8 | 7217.6 | salaries payable | 250 | 300 | Inventory Turnover Ratio | - 0 | |||||
| Net Income (Net loss) | 26905.2 | 37892.4 | Tax payable | 250 | 350 | Inventory Turnover Days | - 0 | |||||
| Total current liabilities | 1400 | 885 | investment ratios | |||||||||
| Long term Liabilities | 2500 | 2500 | Earnings per share | - 0 | ||||||||
| Total liabilities | 3900 | 3385 | price-to-earnings (P/E) ratio | - 0 | ||||||||
| Stockholders’ Equity | ||||||||||||
| Common stock | 9000 | 1050 | ||||||||||
| Retained earning | 3000 | 1840 | ||||||||||
| Total stockholders’ Equity | 12000 | 2890 | ||||||||||
| Total Equity & Liabilities | 15900 | 6275 |
Sheet3
| 2022 | 2023 | Industry Average | ||
| Current ratio | 1.4 | 1.2 | 2 | |
| Quick ratio | 0.9 | 1 | 1.25 | |
| Inventory turnover | 1 | 0.9 | 1.6 | |
| average collection period | 85 | 75 | 64 | |
| Profit margin | 2.00% | 2.80% | 5.20% | |
| Return on assets | 5.00% | 7.00% | 1.10% | |
| Return on equity | 7.00% | 8.50% | 2.60% | |
| 2021 | 2022 | Year to year comparison | ||
| Current ratio | 1.4 | 1.2 | ||
| Interpretation | ||||
| Acid ratio | 0.9 | 1 | ||
| Interpretation | ||||
| Inventory turnover | 1 | 0.9 | ||
| Interpretation | ||||
| Average collection period | 85 | 75 | ||
| Interpretation | ||||
| Profit margin | 2.00% | 2.80% | ||
| Interpretation | ||||
| Return on assets | 5.00% | 7.00% | ||
| Interpretation | ||||
| Return on equity | 7.00% | 9% | ||
| Interpretation |
LO2.XLSX
This file is too large to display.View in new window
other Questions(10)
