A:18 . B:1 .C:20

please help

DUE DATE: 11 am Friday 29th October 2021 One of your friends, Emma, has found out you are studying accountancy and that you have acquired basic spreadsheet skills. She has decided to start a business of printing bespoke lages on to tennis recquets but needs to produce a business plan for the bank manager in order to raise loon Emma has already formed a private limited company and has introduced 5,000 in to the business bank account of this 5.000, 1,000 is to be the initial share capital and the balance of 4,000 is a short-term interest free loan from her. It is her intention to start trading es from 1 January 2022 You have agreed to produce the financial projections for her based on the information provided by Emma REQUIREDI LUsing Excel, construct a concise financial model that includes, as a minimum, the projected cash flow, profit and loss and balance sheet figures for the first year of Trading ie until 31 December 2022. The statements should show quarterly figures with cu totals, where appropriate (60 marks) (Markt will be awarded for the use of spreadsheet logic presentation and layout of the projections and ease of use) 2. Using either Word or Excel, write a short report to Emma to include the following .. Using your model produce financial ratios, which may be useful to Enma bearing in mind the reason for the projections. The report should explain why you have Selected these rates and the relevance of the trends to Emma. Include any other comments you consider would be relevant to Emma Emme has expressed on interest in using the model to see the financial impact of charging some of the assumptions. Write a concise user guide report) on how she would use the model to see the impact of changing the gross margin and other assumptions Do remember Emma has limited Excel knowledge Explain to Emme the advantages and disadvantages of using Excel to produce the financial projections as compared to producing them morally using pen and in (40 marks) (Total: 100 marks) (In addition to the technical content marks will be awarded for presentation) Submission Instructions 1 Using the links provided on Canvas submit the final version of your financial projections (spreadsheet) in a suitable format to enable Emme to show them to her bork manager Section 1. Include your workings as part of this file and clearly label them so as to differentiate them from the main financial projections. To ensure correct identification of your file, ensure your registration number is on the file heading and is on each worksheet 2. Using the links provided on Canvas submit the final version of your report to Enna as required in Section 2 To ensure correct identification of your file ensure your registration number is on the file heading and is clearly visible in the report 3. Retoine copy of your final version of your financial projections (spreadsheet) and your report on a USB and on your computer/university hard drive. It is ESSENTIAL that This version is the same as the one submitted to Canvas and that it has a 'dote modified date that is before the date you submitted your work to Canvas. In the unlikely event there is an issue with your submitted version these file(s) will be required to be graded The date modified date will be used to determine whether or not any late Submission penalty is to be applied. It is your responsibility to ensure this date is not subsequently overridden In addition to the technical content marks will be orded for presentation) Submission Instructions: 1 Using the links provided on Conves submit the final version of your financial projections (spreadsheet) in a suitable formette ble Emme to show them to her bank manager Section 1. Include your workings as part of this file and clearly label them so as to differentiate them from the main financial projections. To ensure correct identification of your file, ensure your registration number is on the file heading and is on each worksheet 2. Using the links provided on Canvas Submit the fine version of your report to Emmas required in Section 2 To ensure correct identification of your file, ensure your registration number is on the file heading and is clearly visible in the report 3. Retsin a copy of your final version of your financial projections (spreadsheet) and your report on a USB and on your computer/university hard drive. It is ESSENTIAL that this version is the same as the one submitted to Cones and that it has a dete modified date that is before the date you submitted your work te Canvas Is the unlikely event there is an issue with your submitted version these files) will be required to be graded The 'dete modified date will be used to determine whether or not any late submission penalty is to be applied. It is your responsity to ensure this date is not subsequently everridden It is your responsibility to ensure the clectronic 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 slightly different set of information There is a unique set of the three parameters A $ and for each student. You can find your particular values on Canvas. Look in the poremeters 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 quorter's sales. Al are cash sales 4. Bod debts are on credit soles, and are anticipated to be Beach quorter 5 50% of the credit scles are poid in the quarter in which the sole is made. The remaining debtors, after bad debts are collected in the following quarter. 6. Sufficient stock is purchased to cover the next Quorter's soles eg. the stock for the sales in the fourth quarter are purchased in the third quarter. In the first quarter assume the first twe quarter's purchases are made and assume the find 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 fie there are te trade creditors) 2 Information provided by Emme: 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 pereneters 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 soles, A% are cash sales 4 Bad debts ere on credit sales, and are anticipated tebe 32 each quarter. 5. 50% of the credit sales are paid in the quarter in which the sole is made. The remaining debtors, after bad debts are collected in the following quarter 6. Sufficient stock is purchased to cover the next querter's sales eg 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 ne trade creditors). & Gross staff salaries are 2,100 per quarter and paid in 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 2per quarter calculated on the balance at the end of the previous quarter. It is payable in the following quarter ie the quarter in which it is charged. No interest is receivable on credit (positive) balonces 11. The company buys machinery costing 10,000 is the first quarter. 12. A von costing 8,000 is purchased in the third quarter 13. The company depreciation policy is to depreciate assets at Caper arnum on a straight-line basis 14. The company incurs a quarterly telephone of 525, which is usually paid in the quarter it is incurred. However, the fourth quarter's bill is 500 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 hos obviously cmitted 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 - Clesing Stock