Stott’s Pty Ltd Case Study Critically Analyzing The Financial Management

Task : Project Instructions For this assessment you are required to: Complete Project Tasks One/Two P reject - Task One - Part A Read and analyze the case study information (including business plan summary and previous financial data) in Appendices 1–3 and complete the following tasks: · Develop a sales budget, profit budget, cash flow budget and debtor ageing summary by using electronic spreadsheets (as separate worksheets) making sure each budget is divided into quarterly periods and that you use previous financial data to determine allocations for resources. ( You can use the templates as designed in the Project ) Ensure each budget you prepare complies with the organizational policies and procedures as provided. · Develop budget notes that include: I. identification of reasons for previous profits and losses ii. your comment on the effectiveness of existing financial management approaches iii. all assumptions and bases that have been made or used to form budgets iv. any relevant notes regarding implementation and monitoring of budget expenditure v. an explanation of the required legislative requirements of financial management (and outline statutory requirements of ATO, GST, company tax, PAYG) vi. review of two types of digital technology that can be used for financial management. Make a recommendation in the budget notes as to which you would suggest using for the case study. Evidence Required to Submit 1. A completed annual budget in a single spread sheet (MS-Office Excel) with a separate sheet for each budget component (use the templates supplied) 2. All budget notes and assumptions Project - Task One – Part B Communicate information regarding the budget and answer a series of eight questions (see Appendix 3) in written form as agreed with your assessor Evidence Required to Submit 8 question answers in a written format (Appendix 3) Project – Task Two You will need to review the provided current case study information and compare it to the budget you established in Part A. After evaluating these you will need to report on the following: Significant issues Variances from budget Comparative performances Recommendations for ongoing financial viability Evaluation of financial management processes. Follow the Procedures below: 1. Read the case study provided in this task. 2. Develop an actual to budget variance report based on the format and template provided by Stott’s. 3. Complete a cash flow analysis on the average length of time it takes Stott’s to collect funds from its debtors to determine the trend based on the financial reports in Project (Section A). 4. Examine the sales budget, profit budget, cash flow budget and debtor ageing summary to identify the following in a report: a. Issues: I. Identify, describe and prioritize significant issues that are evidenced in Stott’s College Pty Ltd information and describe reasons or causes of these issues. Include in this issue of financial probability that you have identified or considered when monitoring these budgets. b. Variances: I. Complete an actual-to-budget variance report, using the template provided in the case study. ii. Identify variances by comparing actual results with the established budget and provide reasons why these variances may have occurred. c. Performance: I. Compare financial performance of the organization (according to financial information provided) to industry benchmarks for this organization in line with the retail trade sector. ii. Respond to the performance questions provided by the CEO, as provided by the board of Stott’s, iii. Determine a trend of the average debtor days and the impact to the cash flow of Stott’s. d. Recommendations: I. Outline your recommendations for ongoing financial viability for the organization, based on your assessment of the issues, reasons for variances and organizational performance you have identified (Steps 1–3). ii. Include in this section your plans for a revised budget, effectively managing contingencies and issues that have been identified in feedback and monitoring of the budgets. e. Evaluation: I. Provide a summary review of the financial management processes in place for the organization, in light of your assessment of the issues, reasons for variances and organizational performance you have identified. Include in this section any recommendations you have for modifying management processes. ii. analyze the effectiveness of existing financial management approaches including reviewing financial management software, managing risks of misappropriation of funds, ensuring systems are in place to record all transactions, maintaining an audit trail and complying with due diligence Evidence Required to Submit · a complete actual-to-budget variance report detailing the issues, variances, performance, recommendations and evaluations identified from the financial information for Stott’s Pty Ltd. (1500 - 2000Words)

Subject Name: Finance

Level: Undergraduate

If you want the solution to this assignment or want to discuss any other assignment or course you may contact us directly at order@bestacademicexperts.org or message us on Whatsapp or Viber at +91-9303607402 (http://api.whatsapp.com/send?phone=919303607402&text=Hello%20 )