Students Name: Student Number: Qualification: Graduate Diploma of Management (Learning)
Students Name: Student Number: Qualification: Graduate Diploma of Management (Learning)
Subject: A60018 Financial & Accounting Strategies
UoC: BSBFIN801 Lead Financial Strategy Development
Assessment #: Assessment Task 4
Submission Checklist: File 1: This Word document with your answers
(It is acceptable if you submit this document in PDF)
File 2: PowerPoint file of your presentation
Part A: Individual Assessment
Answer all the questions:
Category A
1 2 3 4 5 Category B
1 2 Category C
1 2 Part B: Pair Presentation
In pairs, make a 15-minute presentation to cover the following topics:
Any 2 questions under Category A; and
Any 1 question under Category B; and
Both questions (Question 1 & 2) under Category C
Students Name: Student Number: Qualification: Graduate Diploma of Management (Learning)
Subject: A60018 Financial & Accounting Strategies
UoC: BSBFIN801 Lead Financial Strategy Development
Assessment #: Assessment Task 3
Submission Checklist: File 1: This Word document with your answers
(It is acceptable if you submit this document in PDF)
File 2: Excel spreadsheet with Template E & F (Not in PDF)
Question 1:
Complete the Excel (Template E) to calculate the variance between the actual and budgeted financial information in $ and %, and determine if they are favourable (F) or unfavourable (U).
What is the most significant variance from your results? Explain the possible reasons.
Propose a specific action plan to remedy this significant variance.
Question 2:
Use the following table to calculate the variances and determine if they are favourable (F) or unfavourable (U) in your answer:
Variances Formula Working Your Answer
1 Direct material price variance 2 Direct materials efficiency variance 3 Direct labour price variance 4 Direct labour efficiency variance Explain the possible reasons, and recommend whether some of them should be investigated further.
Question 3:
Do you agree with John? Why or why not?
Complete the Excel (Template F) to create a new budget variance analysis.
Based on the new schedule, briefly explain the business performance on making and selling the new laptop, XYZ-123.
Propose an action plan to deal with the variance, including the stakeholders you may consult to support your decision.
Students Name: Student Number: Qualification: Graduate Diploma of Management (Learning)
Subject: A60018 Financial & Accounting Strategies
UoC: BSBFIN801 Lead Financial Strategy Development
Assessment #: Assessment Task 2
Submission Checklist: File 1: This Word document with your answers
(It is acceptable if you submit this document in PDF)
File 2: Excel spreadsheet with Template B & D (Not in PDF)
Question 1:
Complete the Excel (Template B) to prepare the forecast of Income Statement and Balance Sheet for the next 3 years.
Provide the assumptions to support your forecast.
Assumptions:
{Please list all the assumptions in the Excel (Template B) tab.}
Advise if the company needs to raise additional funds in total financing over the next 3 years, and how much?
Question 2:
Based on your ratio calculation in Assessment Task 1 and understanding of the company, use Template C (on the next page) to prepare the Risk Management Plan. You are required to:
identify 3 different company risks that APC Computer & Technology may face
consider their likelihood/consequence
outline the actions to mitigate these risks, and
explain how to perform continual measurement and evaluation of risks.
Question 2 (Template C):
Risk Management Plan
No Hazard Risk Likelihood Consequences Responsibility Proposed Action/Strategy Monitoring
1 2 3 Question 3:
Complete the Excel (Template D) to calculate NPV.
Your decision: Should the company lease or buy the equipment? (Reason required)
Discuss what other information you may need to support your proposal.
Students Name: Student Number: Qualification: Graduate Diploma of Management (Learning)
Subject: A60018 Financial & Accounting Strategies
UoC: BSBFIN801 Lead Financial Strategy Development
Assessment #: Assessment Task 1
Submission Checklist: File 1: This Word document with your answers
(It is acceptable if you submit this document in PDF)
Question 1:
Use the following table to calculate the key financial ratios for FY2020:
Key Ratios (FY2020) Formula Working Your Answers
1 Current ratio 2 Days in inventory 3 Gross profit percentage 4 Accounts receivable turnover 5 Debt ratio 6 Debt to equity 7 Profit margin Question 2 (Template A):
This report is prepared by <insert your name here> to the CEO of APC Computer & Technology. The purpose of this report is to <insert the purpose of the report here>.
I have reviewed the companys financial statements (including Balance Sheet and Income Statement) for the years ended 30 June 2019 and 2020, and compared the key ratios with the industry benchmark.
Red flags in the financial statement analysis
The first part of this report shows whether or not any of the following red flags apply to APC Computer & Technology.
Red flags Analysis (with reasons)
1 Movement of sales, inventory and receivables 2 Earnings problems 3 Decreased cash flow 4 Too much debt 5 Inability to collect receivables 6 Build-up of inventories Risk Analysis
<Write a short paragraph to advise what financial status of APC Computer & Technology revealed in the financial statements. Is it too risky, strong or growing, etc.>
Outlook for Future
<Will APC Computer & Technology continue to grow?>
<Write a short paragraph (based on your understanding of the financial statements and the above analysis) about the strategies or plans for future business growth>
Business Goals
Based on the above analysis, APC Computer & Technology needs to achieve the following goals:
Short-term goals
Long-term goal
Checklist for Assessing Business Systems
Requirements (Checklist Questions) Explanation
1 Does the business system require the user ID and password when logging in? (Example only) This requirement addresses the need for a business system to provide access to authorised users only. (Example only)
2 3 4
