read everything I but it pleases
please help me and don't bot this last pic because it's not correct I need financial projections (spreadsheet) for this information and I need Writing an explanation of the end of expectations by a practical method of expectations and A is 18 /b is 1 / c is 20 
this pic is not correct
It is your responsibility to ensure the electronic versions of your answers to Sections 1 and 2 are submitted via the link on Canvas by the submission date. Late submission of the files will incur penalties in line with the department policy. Information provided by Emma: Please note that each student will be working with a slightly different set of information. There is a unique set of the three parameters A, B and C for each student. You can find your particular values on Canvas. Look in the parameters file in the Excel Coursework Assignment folder. 1. The first quarter's sales are expected to be 3,000 doubling every quarter during the year. 2. The gross profit margin on sales is expected to be 40%. 3. Of each quarter's sales, A% are cash sales. 4. Bad debts are on credit sales, and are anticipated to be B% each quarter. 5. 50% of the credit sales are paid in the quarter in which the sale is made. The remaining debtors, after bad debts, are collected in the following quarter. 6. Sufficient stock is purchased to cover the next quarter's sales e.g. the stock for the sales in the fourth quarter are purchased in the third quarter. In the first quarter assume the first two quarter's purchases are made and assume the final quarter's purchases are 30,000 (the sales for the first quarter of 2023 are unknown). 7. Purchases are paid for in the quarter bought (ie. There are no trade creditors). 2 sales for the first quarter of 2023 are unknown). 7. Purchases are paid for in the quarter bought (i.e. there are no trade creditors). 2 8. Gross staff salaries are 2,100 per quarter and paid in the quarter incurred. 9. Distribution costs are 10% of sales and are paid in the quarter of the sale. 10. Bank interest charged is 2% per quarter calculated on the balance at the end of the previous quarter. It is payable in the following quarter i.e. the quarter in which it is charged. No interest is receivable on credit (positive) balances. 11. The company buys machinery costing 10,000 in the first quarter. 12. A van costing 8,000 is purchased in the third quarter. 13. The company depreciation policy is to depreciate assets at 0% per annum on a straight-line basis. 14. The company incurs a quarterly telephone bill of 525, which is usually paid in the quarter it is incurred. However, the fourth quarter's bill is 600 and will not be paid until January 2023. 15. Ignore the effect of corporation tax, VAT, PAYE and inflation. 16. Include any other expenses Emma has obviously omitted from the above information. 14. The company incurs a quarterly telephone bill of 525, which is usually paid in the quarter it is incurred. However, the fourth quarter's bill is 600 and will not be paid until January 2023. 15. Ignore the effect of corporation tax, VAT, PAYE and inflation. 16. Include any other expenses Emma has obviously omitted from the above information. Technical hint: The level of knowledge of double-entry bookkeeping required to answer this question is fairly basic and is not designed to 'trip you up'. Remember that Cost of Sales - Opening Stock + Purchases - Closing Stock XYZ LIMITED RATIO ANALYSIS FOR YEAR 2022 PROJECTIONS Q1 Q2 Q3 24 TOTAL Explanation shows profitability before indirect expenses. The GP has consistantly improved over the 60% year. Gross profit ratio 5596 58% 60% 64% shows profitability after all expenses. The NP has consistantly improved over the 50% year. Net profit ratio 429 46% 51961 5696 Shows a very healthy return on 20479 cpital. Return on capital shows a very healthy funds 8.87 management and good liquidity. Current ratio Shows very healthy position and means that the shareholder funds are 11.85 times the 10.74 borrowings Capital gearing ratio It is your responsibility to ensure the electronic versions of your answers to Sections 1 and 2 are submitted via the link on Canvas by the submission date. Late submission of the files will incur penalties in line with the department policy. Information provided by Emma: Please note that each student will be working with a slightly different set of information. There is a unique set of the three parameters A, B and C for each student. You can find your particular values on Canvas. Look in the parameters file in the Excel Coursework Assignment folder. 1. The first quarter's sales are expected to be 3,000 doubling every quarter during the year. 2. The gross profit margin on sales is expected to be 40%. 3. Of each quarter's sales, A% are cash sales. 4. Bad debts are on credit sales, and are anticipated to be B% each quarter. 5. 50% of the credit sales are paid in the quarter in which the sale is made. The remaining debtors, after bad debts, are collected in the following quarter. 6. Sufficient stock is purchased to cover the next quarter's sales e.g. the stock for the sales in the fourth quarter are purchased in the third quarter. In the first quarter assume the first two quarter's purchases are made and assume the final quarter's purchases are 30,000 (the sales for the first quarter of 2023 are unknown). 7. Purchases are paid for in the quarter bought (ie. There are no trade creditors). 2 sales for the first quarter of 2023 are unknown). 7. Purchases are paid for in the quarter bought (i.e. there are no trade creditors). 2 8. Gross staff salaries are 2,100 per quarter and paid in the quarter incurred. 9. Distribution costs are 10% of sales and are paid in the quarter of the sale. 10. Bank interest charged is 2% per quarter calculated on the balance at the end of the previous quarter. It is payable in the following quarter i.e. the quarter in which it is charged. No interest is receivable on credit (positive) balances. 11. The company buys machinery costing 10,000 in the first quarter. 12. A van costing 8,000 is purchased in the third quarter. 13. The company depreciation policy is to depreciate assets at 0% per annum on a straight-line basis. 14. The company incurs a quarterly telephone bill of 525, which is usually paid in the quarter it is incurred. However, the fourth quarter's bill is 600 and will not be paid until January 2023. 15. Ignore the effect of corporation tax, VAT, PAYE and inflation. 16. Include any other expenses Emma has obviously omitted from the above information. 14. The company incurs a quarterly telephone bill of 525, which is usually paid in the quarter it is incurred. However, the fourth quarter's bill is 600 and will not be paid until January 2023. 15. Ignore the effect of corporation tax, VAT, PAYE and inflation. 16. Include any other expenses Emma has obviously omitted from the above information. Technical hint: The level of knowledge of double-entry bookkeeping required to answer this question is fairly basic and is not designed to 'trip you up'. Remember that Cost of Sales - Opening Stock + Purchases - Closing Stock XYZ LIMITED RATIO ANALYSIS FOR YEAR 2022 PROJECTIONS Q1 Q2 Q3 24 TOTAL Explanation shows profitability before indirect expenses. The GP has consistantly improved over the 60% year. Gross profit ratio 5596 58% 60% 64% shows profitability after all expenses. The NP has consistantly improved over the 50% year. Net profit ratio 429 46% 51961 5696 Shows a very healthy return on 20479 cpital. Return on capital shows a very healthy funds 8.87 management and good liquidity. Current ratio Shows very healthy position and means that the shareholder funds are 11.85 times the 10.74 borrowings Capital gearing ratio
