Faste 84 A Call For AA Wap Text Merge & Center % 2 Conditional Format Formatting as Tale Styles xfx Save the file as an Excel file (xlsx) using the naming pattern: YourLast Name ACCT 201-YourClassTime and Day-Spring 2022 B 1 2 REQUIRED: ACCT 201 Project 1 Instructions 3 1 Type your 800 number and your last name in the yellow input boxes at the top of the Facts tab. 4 2 5 6 3 7 4 B 5 9 6 10 11 Save the file as an Excel file (.xlsx) using the naming pattern: YourLast Name - ACCT 201 - YourClassTime and Day - Spring 2022 Example: Smith- ACCT 201-315 TR-Spring 2022 Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustments in yellow boxes on the "Facts" tab (using formulas) Post adjustments to the Ledger for the corresponding year (using formulas) Prepare the following financial statements (using formulas) for the corresponding year. (a) Balance Sheet (b) Income Statement 12 (c) Statement of Stockholders' Equity 13 14 15 16 17 Your project must be completed in Excel. Handwritten projects will NOT be accepted. Submit an electronic copy of your project on Canvas or in Connect as instructed on or before the due date. Late submissions will receive a 10% penalty for each day past the due date, for three days, after which none will be accepted FILE-SHARING OF ANY KIND IS STRICTLY PROHIBITED 18 19 20 Notes: All your work calculating adjusting entries must be entered in the yellow input cells on the "Facts" tab. 21 22 All cell entries must contain a formula; even if it is a just simple formula which references information from another cell. 23 24 If possible, use SUM formulas to add rather than strings of cell additions. Example: Use -SUM(B3:B7) rather than -B3+B4+B5+B6+B7 25 26 While it is normally bad form to include typed numbers in a formula, for purposes of this project you may do that in your adjustment formulas. 27 28 Make sure that all of your results are reasonable! C