diff_months: 11

MAA104-Financial Literacy

Flat 50% Off Order New Solution
Added on: 2024-11-27 04:00:26
Order Code:
Question Task Id: 484221

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



  1. This assignment is to be submitted ONLINE ONLY (You are NOT required to submit a hard copy).
  2. 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).
  3. The completed assignment must be submitted into the submission folder in the Assessment Tile. (Assessments -> Assignments)
  4. This is an individual submission and covers topics 5-8.
  5. You are not required to upload an Assignment Cover Sheet. You will complete a Plagiarism declaration when you access the Submission Folder.
  6. Once submitted you cannot take your assignment back BUT you CAN SUBMIT another version. The most recent version submitted will be marked.
  7. Please refer to the rubric for guidance on the marking
  8. 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:



  1. 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)



  1. 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

  • Uploaded By : Akshita
  • Posted on : November 27th, 2024
  • Downloads : 0
  • Views : 63

Order New Solution

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more