Please finish the worksheet, post closing entries, working capital ratio¤t ratio, statement of retained earnings(show formulas)

The following items should be considered in adjusting the accounts for financial statement preparation: 1. On February 1, 2017 a 12-month insurance policy was purchased. No expense has been recoginized for 2017. 2. Signed a one year lease for rental space on March 1, 2017. By paying for the entire year, the landlord offered a reduced rate 3. The physical inventory count of Merchandise Inventory indicated an amount of $173,880. 4. Supplies on hand at December 31, 2017 total $2,051 5. Store Equipment is depreciated on a straight-line basis; residual value is $10,000 with service life of 10 years. The assets were held the entire year On August 1, issued Carter Supplies a six-month note receivable at a 5% annual interest rate. Management estimates 2.5% of its gross accounts receivable to be uncollectible. 8 On September 1, 2017 borrowed funds. The note bears 4.8 % annual interest. 9. Salaries & Wages of $6,862 are accrued and unpaid at December 31, 2017 10 Accrued utilities totaled $798