I need this data placed in an excel spreadsheet.

Here is the full ask:

1. Record the following entries for year 1:

1. The corporation sells $55,000 of stock (1,000 shares).
2. The corporation pays $6,000 for a six-year lease.
3. The corporation purchases $1,700 of supplies for cash.
4. The corporation buys $10,600 of inventory on account.
5. The corporation buys $5,000 of equipment for $3,000 cash and $2,000 notes payable.
6. The corporation pays the vendor bill in (d).
7. The corporation buys $4,500 of inventory on account again.
8. The corporation pays the stockholders $3,000 for dividends.
9. The corporation has cash sales of $18,000 and credit sales of $2,000. The inventory cost is $9,000.
10. The corporation pays $200 for consulting expense.
11. The corporation pays $300 for advertising expense.
12. The corporation pays $2,200 for salaries expense.
13. The corporation pays $250 for utilities expense.
14. The corporation has $700 of supplies left.
15. The corporation used one year of the lease.
16. The equipment wore out by $500.
17. The corporation owes (hasnt paid yet) interest of $100 for the notes payable.
18. The company is in a 10% tax bracket and accrues now for taxes it will pay later.

2. Prepare the financial statements for year 1. Include a Trial balance. Remember to carry the beginning balances forward in the permanent accounts as the first Year 2 transaction before you begin the year 2 transactions below.

3. Record the following entries for year 2:

1. The corporation pays the accounts payable balance from year 1.
2. The corporation pays the interest payable from year 1.
3. The corporation pays the income tax payable from year 1.
4. The corporation receives the accounts receivable balance from year 1.
5. The corporation buys additional inventory for $8,000 on account.
6. The corporation has cash sales of $25,000. The inventory cost is $11,000.
7. The corporation pays $250 for consulting expense.
8. The corporation pays $325 for advertising expense.
9. The corporation pays $2,500 for salaries expense.
10. The corporation pays $275 for utilities expense.
11. The corporation has $100 of supplies left.
12. The corporation used one year of the lease.
13. The equipment wore out by $500.
14. The corporation owes (hasnt paid yet) interest of $100 for the notes payable.
15. The company is in a 10% tax bracket and will pay the income taxes later.

4. Prepare the financial statements for year 2. Include a trial balance.

5. Prepare a vertical and horizontal analysis of the income statement and balance sheet for both years.

6. For each analysis prepared in #5, discuss significant changes that have occurred.

7. Calculate the following ratios for year 2 ONLY:
   1. Current ratio
   2. Total Asset Turnover
   3. Net Profit Margin (Return on Sales)
   4. Return on Equity
   5. Return on Assets
   6. Inventory Turnover
   7. Debt to Equity Ratio
   8. Times Interest Earned (Interest Coverage ratio)
8. Use the Mergent data from Target (example in class) to explain how the ratio results in #7 are doing compared to the industry averages (peer mean). Be sure to attach a copy of the industry guide ratios you printed from Mergent.

This view was provided as an OPTION - but there is autonomy to us Excel to create a manual view.

Assets Liabilities Accounts Payable Owner's Equity Stock Cash Pre-Paid Rent Utilities Expense Depreciation Exp Inventory Supplies Interest Payable Dividends Consulting Expenses Supplies Expense Accum Depreciation Accounts Receivable Income Tax Payable Sales Advertising Expenses Interest Expense Equipment Notes Payable COGS Salaries Expense Income Tax Expense Rent Expense