Question: do the answar using excel and send the excel file to my email Jasmin Gardening Services ended its fiscal year on December 31, 2021. The


do the answar using excel and send the excel file to my email
Jasmin Gardening Services ended its fiscal year on December 31, 2021. The company's adjusted trial balance as of the end of its fiscal year is as follows. Instructions: Prepare the following using an Excel file. (a) An income statement and a retained earnings statement for the year ended December 31, 2021. (b) A classified statement of financial position at December 31, 2021. (c) Closing entries at December 31, 2021. (d) A post-closing trial balance at December 31, 2021. Note that the Excel file should include 4 sheets (with linked cells and proper formula) Sheet 1- Group members (name and ID) Sheet 2- Financial statements (income statement, retained earnings statement, statement financial position) Sheet 3- Closing entries Sheet 4- Post-closing trial balance
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
