Accounting 11
Finance Unit
-
Investment Unit
-
Company Books – Spreadsheet – use template
Final Project – Landscaping/Spa – company Books
You are the bookkeeper for a new landscaping company or Spa
Set up spreadsheets – Journal, T-Accounts, Balance Sheets, Income Statement (profit/loss)
30 days with 20+ transactions – done in Excel
Set an hourly rate ($50-75)
You have one or two employees
Starting Balance Sheet
T-Accounts
Asset (5+) Bank, A/R, Truck, Equipment, Supplies
Liabilities (3+) 2 A/P’s, Truck Loan
Revenue
Expenses (6+) Truck expense, Insurance, Repairs, Rent, Wages, Advertising
Income Statement
Ending balance Sheet
SRQ – Section Review Questions
SE – Section Exercises
CE – Chapter Exercises
Chapter 5 – Exercises
Page 131-133 – 5.1 SE (1-2)
Page 140 5.2 SRQ 1-13
Page 140-143 – 5.2 SE (1,2,5,6)
Page 154-157 – CE 1-7 – set up the spreadsheet, T-accounts, Transactions, Trial Balance, Income Statement
Chapter 6 – Exercises (Use GST – 5%, PST – 7% )
Page 211-214 – CE (5-7)
Chapter 7
Page 252 – CE 7
BONUS
Page 171-175 – SE (1-6)
Page 186-190 – SE (1-5)
Page 194 – SE (1,2)
Page 203/204 – SE (1,2)
Page 255 – CE #8
Final Project – Landscaping company Books
You are the bookkeeper for a new landscaping company
Set up spreadsheets – Journal, T-Accounts, Balance Sheets, Income Statement (profit/loss)
30 days with 20+ transactions – done in Excel
Set an hourly rate ($50-75)
You have one or two employees
Starting Balance Sheet
T-Accounts
Asset (5+) Bank, A/R, Truck, Equipment, Supplies
Liabilities (3+) 2 A/P’s, Truck Loan
Revenue
Expenses (6+) Truck expense, Insurance, Repairs, Rent, Wages, Advertising
Income Statement
Ending balance Sheet
Chapter 3 – Exercises
Page 54-59 1-7 Transactions (Metropolitan Movers)
Page 60-62 – SE (1-2)
Page 65-67 – SE (1-3)
Page 73-75 – CE (1, 2, 6)
Chapter 4 – Exercises
Page 85/86 – SE (1-3)
Page 94/95 – SE (1-3)
Page 99/100 – SE (1-3)
Page 105/106 – SE (1-3)
Page 114-117 – CE (5 & 6)