Company Cash A/R Office Supplies Equipment Furniture Exercise 1-3: The following financial data shows the unadjusted trial balance of the Star as of December 31, 1998: Star Company Worksheet Dec. 31, 1998 Dr. Cr. Account Titles 15000 7100 3700 Prepaid Rent 4500 Inventory 1/1/1997 5200 13000 Accum. Depr.- Equipment 4050 9700 Accum. Depr. - Furniture 3300 11500 15600 6690 9000 6500 20000 I 1500 4800 45750 3000 1500 5380 12700 Land Building Accum. Depr. - Building A/P Notes Payable (Short-term) Common Stock Retained Earnings Dividends distribution Sales Sales Returns Sales Discount Rental Income Purchases 3500 Purchases Returns Purchases Discount 2400 Freight-in 1200 Salaries Expense 2000 Insurance Expense 3200 Utilities Expense 1320 Administration Expenses 3050 Totals 118070 118070 If you know the following additional information: 1. Office supplies on hand equal JD1500. 2. Expired rent equals JD3250. 3. Ending inventory on Dec. 31, 1998 equals JD3700. 4. Estimated depreciation on equipment, JD2300; furniture, JD1200; and building, JD2610. 5. Interest expense on notes payable, JD450 for December is accrued, but it is not paid yet. 6. Utilities expenses, JD350 are not paid and not recorded yet. Required: Prepare the worksheet by using the Microsoft Excel program