I could use help creating a flexible financial statement package (8 items below) via Excel and cell referencing, using the data and information provided. Thank you!

The financial statement package should include the following;

• a data entry sheet (the first sheet in your workbook with the above information)
• an adjusted trial balance,
• a single-step income statement,
• a multi-step income statement,
• a statement of retained earnings,
• a classified balance sheet, and
• a post-close trial balance
• data visual of total assets

The ledger of Company X. contained the following balances after adjustment, but before closing, on December 31, 2023, the end of the current year. This means the below account balances are normal balances:

Accounts payable	80000
Accounts receivable	115580
Sales returns and allowances	20000
Accumulated depreciation - equipment	27540
Depreciation expense	800
Interest revenue	1100
Unearned sales revenue	2000
Cash	75670
Common stock (10,000 shares outstanding)	100000
Sales discounts	12000
Cost of goods sold	632100
Dividends declared	18100
Equipment	140600
Insurance expense	4500
Dividends payable	2000
Allowance for doubtful accounts	9500
General expenses	114250
Interest expense	4600
Merchandise inventory	154250
Prepaid insurance	12325
Retained earnings	?
Marketable securities	10100
Dividend revenue	10000
Treasury stock	1000
Salaries payable	18660
Sales	1018200
Selling expenses	140210

Additional Information:

Assign each account an appropriate account number in your data sheet. Carry your account numbers into your adjusted trial balance but NOT your financial statements. For your account numbers, assets should start with a 1 or 2 (current and noncurrent), liabilities a 3 or 4 (current and noncurrent), equity a 5, revenue a 6, and expenses a 7. You should have at least 3 digits for your account number (most companies have 5-6-digit account numbers, however you only need 3).

Use the financial information above as input for your statements. Only formulas/cell references should appear on all sheets except your data entry sheet (except titles and dates; dates and titles should be placed at the top of each sheet; do not use headers).

Each statement must be on one sheet in the file and each statement's print view must be adjusted so your statements will not be split vertically - your statement can flow to a second page, however the accounts along with all numbers should be visible on the same page. When you look at a print preview you will be able to check that your statement is not split. Your file should allow the financial statements to be prepared quickly by entering account balances in the appropriate cells on the first sheet of the file (book) - data entry sheet.

Ignore taxes in this project - this is an academic exercise in this regard.

The selling expense and general expense categories above are a combination of numerous accounts not needed to be listed separately (they are mainly composed of senior executives' salaries and other compensation items). If you do not know if a discretely listed account is a selling or a general/admin. account, then split the dollar amount 50/50 between the 2 categories. However, there are accounts listed that are in neither category and should be listed as "other." This only matters in the preparation of the multi-step income statement.

Include percentages in the Income Statement (vertical analysis) i.e., gross profit percentage, % of selling expenses to sales, etc.

The file must contain documentation with comments. Use the comment feature in Excel - in the functionality ribbon, click review, then new comment.

Arriving at the correct solution using appropriate formulas and the correct format for financial statements is key.Use capitals consistently and check your spelling. Make sure your print formatting is correct so as not to split your statements (see above). The presentation of the financials (i.e., underlining, bold, font, commas, color etc.; use of capitals; print formatting) will potentially enable extra credit.