ACCT305: Accounting Information Systems - Accounting and Finance Assignment Help

Assignment Task:

Task:

Context
Microsoft Excel is a common spreadsheet software for small business. Small business starting up can take full advantage of Excel until they are able to afford bookkeeping software.
 

Fitness Dance Studio
Fitness Dance Studio (FDS) is one of the new Melbourne’s dance studios located in the CBD. It will start the business in June 2021. It runs adult beginner and advance dance classes for individuals or groups. It also sells dancing clothes to their students and hire their studio for rehearsals and auditions.
FDS is owned by two people, Mary Craig and Jenny McCarthy. They are equal shareholders and directors of the Studio. They plan to hire five dancing teachers when their business operates in June. Mary’s first degree is Bachelor of Accounting and Finance. She decides to use Microsoft Excel for the accounts of their Studio. They will use accounting software when the business of the Studio has grown in future.
 

Required:
Prepare an Excel workbook and on each worksheet for recording and tracking business data.
1. Accounts Receivable Ledger for recording the invoices a business issues to customers who have accounts with FDS.
2. Accounts Payable Ledger for keeping a record of the purchase invoices due for payment.
3. Inventory for keeping a track of all items purchased and sold, having a record of the costs and prices, the quantities, and suppliers.
4. Receipt for students who pay the dancing class fees and dancing clothes.
5. Invoice for hiring the studio.
6. Statement of Account for reminding the hirers of the studio that you sent them a certain number of invoices during the month and if they do not pay on time you might incur some additional charge.
7. Cash Flow Statement for current cash flow, entering the coming up bills with their due dates
8. Income statement
9. Balance Sheet
10. Briefly describe the business of FDS and briefly explain the differences (if there are) the workbook from the local and international perspective. Explain functions and formulae used in the Excel workbook. in NOT more than 500 words
11. Submit your Excel workbook (Tasks 1-9) and word document listed in Task 10 above to LEO Turnitin.

This ACCT305 Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.