create a ledger and financial statements for both years 1 and 2. please provide formulas used

Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustments in yellow boxes (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 (c) Statement of Stockholders' Equity Your project must be completed in Excel. Handwritten projects will NOT be accepted. Instructions Year 1 - Ledger Year 2. Ledger Year 2 - Financials Facts Year 1 - Financials A B Year 1 9 Given Information $ 697,544 153,460 10 6,801 13 1-Jan Issued common stock in exchange for cash 1-Feb Borrowed money from the bank by signing a one-year note, at a rate of 10% 10-Mar Paid for advertisements to be run during the month 1-Apr Paid in advance for a one-year insurance policy 15-May Purchased supplies on account 1-Jun Landscaping equipment is purchased for cash 18-Jul Performed lawn mowing services for cash 15,346 30,552 14 558,035 15 127,651 16 17 10,202 1-Aug Paid for maintenance on the lawn mowers in cash 99,051 18 38,365 19 20-Aug Performed landscaping services on account 1-Oct Paid in advance for two years of rent on a storage facility 30-Nov Received cash payment from a customer for future services (not yet performed) 15-Dec Paid new employees for nne month nt work navday is always on the 15th.nt the month Instructions Facts Year 1 - Ledger Year 1 - Financials B0 218 20 31.389 Year 2 - Ledger December 31st Adjustments: a Eleven months of interest has accrued on the note (to be paid in cash on Feb 1 next year) b C d Nine months have lapsed on the one-year insurance policy A physical count of supplies at the end of the year reveals half of the supplies were used The equipment is estimated to have a useful life of five years with no salvage value; depreciation must be recorded. The rented storage facility has been used for three months Employees have worked for half a month (December 16 - December 31) in the current year but won't be paid until January 15. e f Year 2 15-Jan Given Information $ 31,389 Paid employees for one month of work 168,806 40,109 1-Feb Paid back the note payable in full, plus interest, at a rate of 10% 15-Mar Performed half of the services for customer who paid in advance 20-Jun issued additional common stock in exchange for cash 26-Jul Collected cash from customers for services previously performed 16,663 89,146 16-Aug Performed services for cash 312,745 20-Sep Performed services on account 242,675 8-Oct 40,109 Performed remaining services for customer who paid in advance Paid for maintenance on equipment in cash 7-Nov 24,994 15-Dec 345,279 30-Dec Paid employee salaries Paid a cash dividend to owners of the business Instructions Facts Year - Ledger 5,580 Year 2 - Ledge Year 1 - Financials December 31st Adjustments: a b Remaining three months of one-year insurance policy were used up A physical count of supplies at the end of the year reveals all remaining supplies were used The equipment is estimated to have a useful life of five years with no salvage value; depreciation must be recorded. The rented storage facility has been used for twelve months Employees have worked for half a month in the current year but won't be paid until January 15. d CD