CREATING A MICROSOFT EXCEL SPREADSHEET $-$ PROJECT PART $2$

The following accounts and related December $31,2023,$ balances of Bright Light, Inc., are in no

particular order:

Requirements:

Open a new Excel worksheet, and in the input area, enter the information shown in the chart

listed above.

Create the adjusted trial balance.

Create an output section of the spreadsheet, including Bright Light's $2023$ multi$-$step income

statement, statement of retained earnings, and classified balance sheet. The output area of

your spreadsheet must contain Excel formulas for all cells containing account names, account

balances, sub$-$total amounts, and total amounts.

List expenses in decreasing order on the income statement, using Excel commands. Please

complete a Google or YouTube search, if you are unsure of what commands to use. Please do

not cut and paste.

Skip down a few rows from your classified balance, and use formulas to calculate the

following financial ratios:

a$.$ Current Ratio

b$.$ Debt Ratio

c$.$ Earnings Per Share

d$.$ Sales Profit Margin

e$.$ Inventory Turnover $(2022$ Inventory balance, $$65,000)$