Financial Accounting Assignment, SMU, Singapore: fill in the effect of transactions during 2022 in columns E & F, and complete the trial balance
University | Singapore Management University (SMU) |
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.
- The Impact of AI and Machine Learning on Data Privacy in the Era of Big Data Essay : Com302 Web Analytics Murdoch Singapore
- Biomedical Device Innovation Need Statement Assignment
- BPM213 TMA01 January 2025 Presentation
- FCS A2 -Fundamentals of Computer Systems Individual Assignment PdF (KHEA) Singapore
- A2359C AY2024 Term 4 – Project Assignment
- BUS356 TMA Jan 2025 Semester-Negotiation Strategies and Approaches: A Case Study, Singapore
- BUS363 TMA01:Enhancing Operations and Service Quality in Ride-Hail Services| January 2025 Semester, Singapore
- HFS105 TMA01: Secularization Trends and Religious Resilience in Contemporary Society| January 2025, Singapore
- HFS105 TMA01:Critique of Sociotechnical Systems Contexts in Accident Analysis, Jan 2025 Singapore
- MTH316 TMA01:Analysis of Continuity, Derivatives, and Gradient Functions – Singapore Assignment Jan 2025
UP TO 15 % DISCOUNT