What you'll learn:
- Refresh your understanding of percentages, ratios, decimals, fractions and exponents
- Develop and/or strengthen your Excel skills using formulas and templates
- Learn time value of money concepts and calculations using real-world examples
- Understand the difference between simple and compound interest and the associated calculations
- Learn 3 ROI (Return on Investment) calculations and their importance
- Become familiar with income statements, balance sheets and financial ratio analysis
- Appreciate the importance of budgets, forecasts and perform variance analysis
- Examine the math typically used in market research & risk management activities, including statistical analysis
- Learn data analysis techniques & formulas, unleashing the power of Excel
- Calculate internal rate of return (IRR) using Excel and understand its importance in the leasing industry
- How to calculate simple and complex probability and place a monetary value on an uncertain outcome
- Perform breakeven analysis for both units and dollars
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!
