
Meet your instructor and review his qualifications.
Review learning objectives and how the course material is organized.
Review the underlying mathematical concepts that are the foundation for the course.
Learn the theory behind present value calculations and the associated Excel formula.
Calculate simple & compound interest.
Discover 3 ways to calculate ROI and where each is applicable.
An introduction to the Income Statement and a calculation called "basis points".
Introduction to the Balance Sheet and its relationship to the Income Statement.
Explanation of the key financial ratios using a real company as an example.
Exploring fixed & variable costs using breakeven analysis.
Reinforce what we learned in the previous lecture on cost analysis by using an Excel template.
Explore the goals of budgeting, best practices, forecasting and run rates.
Reinforcing our learnings about budgeting math using Excel techniques.
Calculate the rate of change, critical for reporting results and adjusting forecasts.
Learn how statistics are used in business to guide decision making and quantify uncertainty.
Reinforcing our knowledge of business statistics using Excel formulas to present the data.
Basic and multiple event probability formulas made simple. Learn how companies quantify uncertainty.
Review 5 key takeaways from the course
Does the idea of learning business math make you break into a cold sweat? In about 3 hours we can overcome those fears and break down the complexity into easy to remember techniques that will have you interpreting the numbers and making fact-based decisions with confidence. Maybe you're an entrepreneur who wants to better understand how to analyze your financial data. Or perhaps you work for a company in a non-financial capacity and you want to make greater contributions by broadening your understanding of finance concepts. If so, this course is for you. Here is the approach we will take:
Refresh our understanding of math basics, including percentages, fractions, decimals, ratios and exponents
Warm up our Excel skills with some statistical functions, formulas and budget templates
Walk through time value of money concepts
Learn the difference between simple and compound interest, along with Excel formulas to make it simple
Understand return-on-investment and analyze internal rate of return using Excel
Analyze an income statement and become familiar with the key metrics
Monitor costs and efficiency while identifying the breakeven point for your business using Excel
Become conversant in statistical concepts such as mean, median, and standard deviation using Excel
Analyze a balance sheet and calculate the key ratios
Calculate probability for simple and complex scenarios and put a monetary value on uncertain outcomes
We will learn everything described above using nothing more than the 4 basic math operations (addition, subtraction, multiplication, division). Some lectures are reinforced with Excel demos - strengthening your Excel skills as we progress.
Change your mindset from "I am not a math person" to "I understand business math" and take charge of the numbers and your career!