English
Log In
Financial Spreadsheets With Google Sheets
Colleen Smith
Average rating:
5.0
Number of reviews:(326)
Rising Star
Over 5-weeks, learners will learn about business balance sheets, income statements, cash flows and budgets, while practicing using Google Sheets. Using templates, learners will get a hands-on introduction to accounting terms and formulas.
Class Experience
US Grade 9 - 12
Beginner - Intermediate Level
During this five-week course, students will learn about basic financial statements, including a personal budget and a company's balance sheet, income statement, and cash flow. Students will use Google Sheets on their laptop or computer in-order to create each financial statement during class. In order to benefit from this course, students do not have to have used Google Sheets before but should be proficient in using their mouse and keyboard. 𝗪𝗲𝗲𝗸 𝟭: We will begin by creating a basic...
5 lessons//5 Weeks
Week 1Lesson 1Personal BudgetWe will begin by creating a basic personal budget. I will define "static" and "cell reference" formulas and then we will discuss the benefits of cell reference formulas. We will then use a budget template and practice using and updating the template. We will discuss what the average American spends in a month.Week 2Lesson 2Balance SheetWe will discuss assets, liabilities, and equity. We will discuss the uses of a balance sheet and create a balance sheet using a mock company as an example.Week 3Lesson 3Income StatementWe will create a revenue and expense tracker. We will discuss how this information is used to create a company's income statement. We will practice linking two spread sheets with formulas.Week 4Lesson 4Cash FlowWe will look at an income statement and cash flow and discuss the differences and what each tells us. We will use the cash flow statement to create graphs that show changes over multiple years.Week 5Lesson 5Real ExamplesWe'll review and look at real company's examples of the different types of financial statements.
- Learners will be able to calculate profit and net worth / equity.
- Learners will be able to state the purpose of a balance sheet, income statement, cash flow and budget.
- Learners will be able to communicate the reasons financials statements are important for individuals and businesses to create and update.
- Learners will be able to identify examples of assets, liabilities, income/revenue and expenses.
Over the last three years, I have virtually tutored over 1,300 young learners on the Outschool platform. Prior to that, I enjoyed a thirteen-year corporate career, where I used financial statements regularly to make decisions. I hold a Bachelor of Science in Business Administration from Bucknell University.
0 - 1 hours per week outside of class
Homework
Frequency: 3-6 throughout the classFeedback: as neededDetails: I will provide optional homework to help reinforce terms used during class. I will also provide a one-page notes page for learners and/or parents to review after class.Grading
Frequency: includedDetails: Please let me know if you need specific grading for this class.
A learner does not need financial or Google Sheet experience for this class. However, they should have basic knowledge of using a computer, such as opening a file and using a mouse.
In addition to the Outschool classroom, this class uses:
Students use Google Sheets for this class. If students use Google Sheets, they will need to access an external website to access Google Sheets: https://docs.google.com/spreadsheets/u/0/?tgif=d Google Suite is on Outschool's approved list of resources for all learners.
Joined September, 2021
5.0
326reviews
Rising Star
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
𝗛𝗲𝗹𝗹𝗼! My name is Colleen, or Miss Colleen, and I am excited to work with your student in my online classroom! I have been teaching on Outschool since September 2021 and am thrilled to continue this journey. My Outschool offerings encompass...
Reviews
Group Class
$80
for 5 classes1x per week, 5 weeks
50 min
Completed by 7 learners
Live video meetings
Ages: 14-18
3-8 learners per class
