MAA104-Financial Literacy
- Subject Code :
MAA104
- University :
Deakin University Exam Question Bank is not sponsored or endorsed by this college or university.
- Country :
Australia
MAA104-Financial Literacy
Trimester 3, 2022
Problem-based Assignment
DUE DATE:
Friday 13th January 2023 11.59pm
PERCENTAGE OF FINAL GRADE: 10%
WORD LIMIT: 1500 words
Learning Outcome Details
Unit Learning Outcome (ULO) |
Graduate Learning Outcome (GLO) |
ULO1 Explain the key elements that impact financial, resourcing and investment decision making in business. |
GLO1: Discipline-specific knowledge and capabilities GLO2: Communication GLO5: Problem solving |
ULO2 Explain the key elements that influence personal finance decisions. |
GLO1: Discipline-specific knowledge and capabilities GLO2: Communication GLO5: Problem solving |
ULO3 Recognise, create and use key financial and non- financial reports that are relevant to financing, resourcing and investment decisions in business for decision making. |
GLO1: Discipline-specific knowledge and capabilities GLO2: Communication GLO5: Problem solving |
Assessment Feedback:
Students who submit their work by the due date will receive their marks and feedback within 15 days of submission
Submission Instructions
- This assignment is to be submitted ONLINE ONLY (You are NOT required to submit a hard copy).
- You must submit your report in Word format with your surname and student id as the file name (for example: docx; Please convert your .pages file to a .docx/.doc file if you are using pages on Mac).
- The completed assignment must be submitted into the submission folder in the Assessment Tile. (Assessments -> Assignments)
- This is an individual submission and covers topics 5-8.
- You are not required to upload an Assignment Cover Sheet. You will complete a Plagiarism declaration when you access the Submission Folder.
- Once submitted you cannot take your assignment back BUT you CAN SUBMIT another version. The most recent version submitted will be marked.
- Please refer to the rubric for guidance on the marking
- Harvard Referencing is
A note on plagiarism and collusion
Plagiarism and collusion are forms of cheating and is considered a serious academic misconduct, and severe penalties are associated with them. Please refer to the MAA104 unit outline for your responsibilities with regards to plagiarism and other academic offences.
You must keep a backup copy of every assignment you submit, until the marked assignment has been returned to you. In the unlikely event that one of your assignments is misplaced, you will need to submit your backup copy.
Any work you submit may be checked by electronic or other means for the purposes of detecting collusion and/or plagiarism. You should check that you can see your assignment in the Assignment Submission folder after upload.
Notes
- Penalties for late submission: The following marking penalties will apply if you submit an assessment task after the due date without an approved extension: 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five days after the due date will not be marked. You will receive 0% for the task. 'Day' means working day for paper submissions and calendar day for electronic submissions. The Unit Coordinator may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date.
- For more information about academic misconduct, special consideration, extensions, and assessment feedback, please refer to the document Your rights and responsibilities as astudent in this Unit in the subject Unit Outline.
Question
Tanya had recently taken over her aunts business selling pots and ceramic wares after she graduated from Deakin University with a Bachelor of Business in 2019. Now she wants you to do some financial analysis for the business. Tanya has provided you with the following financial statements for 2020/2021 and 2021/2022 fiscal years. Please ignore any taxation related matters in this question.
Income Statement
2021 |
2022 |
|||
$ |
$ |
$ |
$ |
|
Income |
||||
Sales |
151,000 |
170,500 |
||
Less Cost of Goods Sold |
(25,150) |
(33,050) |
||
Gross Profit |
125,850 |
|
137,450 |
|
Less Expenses: |
||||
Selling Expenses |
||||
Salaries sales staff |
8,500 |
14,500 |
||
Advertising |
750 |
1,450 |
||
Delivery |
995 |
1,400 |
||
Sales Commissions |
1,250 |
(11,495) |
1,550 |
(18,900) |
General & Admin. Expenses |
||||
Office expenses |
3,250 |
3,350 |
||
Salaries General staff |
16,100 |
16,650 |
||
Interest |
2,850 |
(22,200) |
3,950 |
(23,950) |
Total operating expense |
(33,695) |
(42,850) |
||
Net Profit / (Loss) |
92,155 |
|
94,600 |
Balance Sheet as at 30th June
2020 |
2021 |
2020 |
2021 |
||
Assets |
$ |
$ |
Liabilities |
$ |
$ |
Current Assets |
Current Liabilities |
||||
Cash at bank |
10,750 |
11,850 |
Accounts Payable |
15,885 |
16,955 |
Inventory |
30,400 |
34,850 |
|||
Accounts Receivable |
15,500 |
17,550 |
Non-current |
||
Petty Cash |
1,650 |
1,900 |
|||
Total Current Assets |
58,300 |
66,150 |
Bank Loan |
19,870 |
22,245 |
Total Liabilities |
35,755 |
39,200 |
|||
Non-current Assets |
Owners Equity |
||||
Land and Buildings |
205,110 |
202,550 |
Capital - Tanya |
150,000 |
150,000 |
Motor Vehicle |
- |
50,000 |
|||
Office fittings |
14,500 |
15,100 |
Retained Earnings |
92,155 |
144,600 |
219,610 |
267,650 |
Total Equities |
242,155 |
294,600 |
|
TOTAL ASSETS |
277,910 |
333,800 |
TOTAL EQUITIES |
277,910 |
333,800 |
She has also provided you with the following account balances for her business as at the fiscal end of 2023.
Accounts |
End Balance $ |
Capital Tanya |
150,000 |
Drawings |
25,500 |
Cash at Bank |
36,300 |
Inventory on hand (as at 30 June 2023) |
60,650 |
Land and buildings |
195,485 |
Motor Vehicle |
40,000 |
Shelving |
24,600 |
Office fittings |
36,000 |
Sales revenue |
206,500 |
Cost of Goods Sold |
45,550 |
Accounts Receivable |
52,000 |
Accounts Payable |
21,625 |
Office expenses |
3,600 |
Salaries - Sales staff |
25,500 |
Salaries - Office staff |
17,550 |
Advertising expense |
2,000 |
Bank Loan |
56,000 |
Delivery expense |
2,190 |
Petty cash on hand |
2,050 |
Sales commissions paid |
4,150 |
Interest expense |
5,600 |
Net Profit for the year |
? |
Retained earnings (as at start of fiscal year) |
144,600 |
She has also made the following forecasts for her business in 2024.
Quarters |
Sales Revenue |
Purchases |
Q3 2023 (Actual) |
50,000 |
9,750 |
Q4 2023 (Actual) |
55,000 |
10,000 |
Q1 2024 |
75,000 |
12,500 |
Q2 2024 |
60,000 |
10,500 |
Q3 2024 |
65,000 |
11,000 |
Q4 2024 |
60,000 |
10,000 |
Cash collections 70% of Tanyas quarterly sales are cash sales and the remaining 30% are credit sales. Cash collections from credit customers are:
80% of credit sales are collected in the quarter following the sale.
20% of credit sales are collected in the second quarter following the sale.
80% of all purchases are paid for in the quarter they are purchased, with the remaining 20% paid for in the following quarter.
The business also plans to take out a small business loan of $50,000 at the end of Quarter 1 2024 and will be repaying it back in Quarter 1 of 2025. Equipment costing $70,000 is expected to be bought in Q2 2023 following the receipt of the business loan.
The selling expenses are $15,000 each quarter. Administrative expenses are $12,000 per quarter, excluding depreciation expense. Expenses are paid in the quarter they are incurred.
Tanya also predicts a cash at hand amounting to $16,300 as at 30th June 2023.
Required:
- From the information above, prepare properly classified Income Statement for the 2022/2023 fiscal year. (5 marks)
2. From the information above, prepare Balance Sheet as at the fiscal end of 2023.(5 marks)
3. Prepare a schedule of cash collections, a schedule of purchase payments, and a cash budget for all the four quarters in 2024. (5 marks)
4. Tanyas aunt had started the business as a sole-proprietorship upon commencement of the business. She remains a major owner of the business whilst Tanya is in charge of the financial and operating matters of the business. Should the ownership structure of the business be converted from sole trader to a partnership or a private limited company? Please provide three justifications. (5 marks)
- Tanya was approached by her friend who works as a Funds Manager to invest in a project that promises her 5.65% p.a. compounding annually for three years. Her initial investment required is $100,000. She is aware that the interest rates paid by the banks on term-deposits are currently around 4.9% for a 36-months term.
- How much can Tanya expect to receive at the end of the investment project should she invest at 5.65%?
- What are the advantages and disadvantages of placing this amount in a term-deposit? Suggest any other investment options which she could consider to earn a higher return on investment. (5 marks)
Please prepare a report addressing the above questions. To answer those questions, you can make your own assumptions if necessary. There is no format requirement for this report other than those listed in Submission Instructions.
Total 30 marks