1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 DATE ACCT Saturday, January 1, 2022 Accounts Receivable Tuesday, February 1, 2022 Cash Tuesday, March 1, 2022 Cash JOURNAL Sunday, May 1, 2022 Cash Revenue Notes Payable Friday, April 1, 2022 Trucks Accounts Receivable Cash Wednesday, June 1, 2022 Expenses Cash Friday, July 1, 2022 Dividends Cash Revenue DR 275 250 275 400 225 300 60 CR 275 250 275 400 225 300 60 INSTRUCTIONS 1 Use a formula to show the number of transactions (use the "date" column) =number of transactions 2 The May transaction has account titles that are right-aligned. Make them left aligned (like the others) 3 Change the dates to be "short date" 4 Go to the Ledger sheet and continue to follow the instructions/n1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Beg 1-Jan Beg 1-Jun LEDGER Accounts Receivable 0 275 Common Stock Expenses ol 300 275 300 1-Mar 40 Beg 40 Beg 1-Apr Trucks 100 400 500 Retained Earnings Revenues 100 Beg 100 0 Beg 275 225 500 1-Jan 1-May INSTRUCTIONS CONTINUED 5 Type a formula in the highlighted cell (C13) to pull from the 2/1 entry on the Journal sheet. 6 Highlight all debit normal balance account titles in GREEN 7 Put a border around the Ledger title at the top of this sheet. 8 Total Assets is calculated below. Type a formula for Debt to Assets Ratio. 580 total assets =debt to assets ratio 9 Insert a text box below this. Type your name in the text box.

Fig: 1

Fig: 2