I need to prepare a trial balance with this format for my class! Please help me!

Jack Tupp Auto Repair Company Trial Balance Spreadsheet Account Titles Cash Inventory Equipment Accounts Payable Common Stock Unearned Revenue Sales Revenue Cost Of Goods Sold Mortgage Payable Accounts Recievable Buildings Service Revenue Discount on Bonds Payable Bonds Payable Interest Expense Dividends Dividends Payable Loss on Bonds Redemption Prepaid Expense Expenses Totals Sales Returns and Allowances Sales Discounts Depreciation Expense - Equipment Accumulated Depreciation Depreciation Expense - Buildings Bad Debt Expense Allowances for Doubtful Accounts Totals Net Income/Loss Totals Trial Balance Dr. Cr. - - Debits equal credits Group No.: 11 - Adjustments Dr. Cr. Adjusted Trial Balance Dr. - - - Debits equal credits Debits equal credits ed Trial Balance Cr. - equal credits Income Statement Dr. - Cr. - Balance Sheet Dr. - Cr. - JACK TUPP AUTO REPAIR Jack Tupp Auto Repair opened on September 1, 2016. The following account balances existed: Cash $ Carburetor Inventory (210 units @ $65/unit) Equipment Accounts payable (Great Wattage) Common stock (100,000 shares) 85,192 13,650 52,500 19,000 100,000 The following events and transactions occurred through December 31, 2016. 9/2 9/3 9/4 9/7 9/9 9/10 9/15 9/16 9/17 9/29 10/2 11/13 11/17 12/1 12/28 12/29 12/30 12/31 Signed a 9-month contract to repair delivery vans owned by Walter Melon Grocery for $72,000, which was paid immediately. Work is to be performed equally each month. Sold 25 carburetors to Phil Rupp Fuel for $160.00 each. Phil Rupp Fuel paid cash. Purchased 250 additional carburetors for its inventory, on account, from Pep Boys for $22,500. Terms were 3/10, n/20. Phil Rupp Fuel returned 10 damaged carburetors, and received a refund. Paid the correct amount on the invoice related to the 9/4 transaction. Sold 70 carburetors to Tim Burr Logging for $6,400, terms of 3/10, n/30. Paid the accounts payable balance due to Great Wattage of $19,000 in full. Received a check from Tim Burr Logging for the correct amount related to the 9/10 sale. Sold 165 carburetors to Iona Carr Autohaus for its new dealership for $31,500, on account. Payment terms were 5/10, n/20. Received a check from Iona Carr Autohaus for the correct amount related to the 9/17 sale. Issued 250 5% $1,000 face-value 5-year bonds to new investors at 98. The bonds pay interest semi-annually on January 1 and July 1. Purchased a building for $338,800. The building was purchased with a 30-year mortgage from the Eighth Mono Bank, bearing interest at 4% per annum. A previous month's accrued interest is due and payable on the first day of the next month. Make sure to prorate any interest due for November 2016 based on a 12-month year. (Hint: it's 17 days of interest). Principal payments of $18,500 are to be paid on the last day of each year. Sold 105 carburetors to Phil Rupp Fuel for $180.00 each, terms 5/10, net 30. Pays the Eighth Mono Bank for November 2016 interest owed on the mortgage from 11/13. Declared $1,000 of dividends to shareholders, payable on 1/2/2017. Redeemed all of the bonds issued on 10/2 at 102. Assume 3 months of interest were paid at this time on these redeemed bonds. Wrote a check to the Monocle for six months of future advertising for $2,400. Incurred the following expenses at year-end which are not due and payable until 1/30/17: Telephone Fuel $ 466 849 Utilities Postage $ 955 120 1 2017 Machiavelli Chao | Unauthorized use, dissemination or duplication of this material is strictly prohibited Other additional information: 1) Don't forget to journalize the opening balances as of September 1, 2016. However, when doing the Statement of Cash Flows, the beginning balance as of January 1, 2016, for all accounts is zero. 2) Presume the same unit costs apply to all items of inventory when calculating cost of goods sold. Jack Tupp Auto Repair uses the periodic inventory system and the average cost method. 3) Don't forget to accrue the mortgage interest owed for December 2016, and to record the principal payment made at the end of the year. 4) Don't forget to post adjusting entries for any necessary items, including bond interest. 5) Allowance for doubtful accounts is calculated using the percentage of sales method. As of December 31, 2016, the percentage of sales estimated to be uncollectible is 2.5%. 6) All common stock is owned by Jack Tupp. Par value is $1.00 per share. 7) For all equipment, depreciation is calculated using units-of-activity method, with a total estimated useful life of 6,000 units. 1,200 units were used in 2016. (Equipment owned on September 1, 2016 of $52,500 has a salvage value is $1,500.) 8) For the building, depreciation is calculated using double-declining balance with a 20-year useful life. Estimated salvage value is $28,800. (For 2016, calculate depreciation for 1 months) 9) Don't forget to allocate liabilities between current liabilities and long-term liabilities. 10) Other than the transactions listed in the facts, assume no other cash or check transactions have occurred. There are no outstanding checks nor deposits in transit at year-end. 11) Round all amounts to the nearest dollar. Instructions: 1) 2) 3) Using the General Journal, journalize all transactions which occurred in 2016. (Don't forget to journalize the beginning balances, too.) Post all journal entries to the Trial Balance. Complete the: a. Balance Sheet as of December 31, 2016 b. Income Statement for the year ending December 31, 2016 c. Statement of Cash Flows for the year ending December 31, 2016 2 2017 Machiavelli Chao | Unauthorized use, dissemination or duplication of this material is strictly prohibited