University | Singapore Management University (SMU) |
Subject | Financial Accounting Assignment, |
Financial Accounting Assignment, SMU, Singapore: fill in the effect of transactions during 2022 in columns E & F, and complete the trial balance
Requirement 1: Complete the Appendices
Required:
- Appendix A: fill in the effect of transactions during 2022 in columns E & F, and complete the trial balance at the end of 2022 (after adjusting but before closing entries) in columns H & I.
- Appendix C: fill in the unearned revenue for each residential client in column J.
- Appendix D: fill in each expense for 2022 in the boxes in column D.
Note: You should not alter the tables provided by Jag and Elk, e.g., by adding your own accounts to the trial balance, or by creating new data about purchases and payments on top of what they provided. But you can use other cells in the Excel sheets for your own workings
Requirement 2: Prepare the Financial Statements
Required: Prepare the Balance Sheet, Income Statement, and Statement of Cash Flows for the year ended 31 December 2022 by filling in the templates provided in the “Financial Statements” tab.
Note: Please use formulas throughout your solutions, and not type in numbers manually, so that you can trace where you made mistakes, and so that I can trace your work (see “Assessment”).
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Requirement 3: Analyze the Business and Communicate Your Findings
Required: Review the company’s financial results for 2022 by filling in the templates provided at the “Ratios” tab. Write a short memo (200 words maximum) about the financial health of the company by analyzing its financial ratios and comparing them with the closest competitor’s ratios.
Assessment
Grading will be based on the accuracy of your solutions. If you made errors in Requirement 1, I would attempt to carry errors forward to Requirements 2 and 3 by replacing your solutions with the correct answers. Hence it is essential to always use formulas throughout the spreadsheet, and not to alter the order or layout of Jag and Elk’s tables in the appendices.
Some helpful tips!
I recommend starting with Appendices B and C by computing the commercial and residential revenue, and then Accounts Receivable and Unearned Revenue. After that, you can work through Appendix D to calculate expenses. Along the way as you calculate the transactions during the year, you can steadily complete the middle columns of Appendix A, and then the trial balance at the end of the year. Out of fairness to all students, for the individual assignment, I will only answer clarifying questions on Google Docs so all students can see the answer.
Finally…
This is an individual assignment, so out of fairness to all students, copying another student’s work (e.g., virtually identical spreadsheets) will be taken very seriously and will result in no credit being given. Do note that there are many different possible ways of doing the workings and formulas.
Buy Custom Answer of This Assessment & Raise Your Grades
Calling all SMU students in Singapore to tackle the Financial Accounting Assignment! We've got the perfect solution for you. Our team of experts specializes in TMA, and individual assignments, and offers the best online exam help Singapore has to offer. Struggling to fill in the effect of transactions or complete the trial balance for 2022? Worry not! With our professional assignment helper service, you can pay our experts to ensure your course success. Don't let academic pressure hold you back – excel with our support.
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT