What you’ll learn

Building Financial Formulas

• Working with Interest Rates
• Calculating the Future Value
• Calculating the Present Value
• Calculating Net Present Value
• Discounting Cash Flows
• Calculating the Payback Period

Using Excel's Business-Modeling Tools

• Using What-If Analysis
• Working with Goal Seek
• Working with Scenarios

Financial Statement Analysis Tools

• Ratio Analysis
• Analyzing Liquidity Ratios
• Analyzing Profitability Ratios
• Leverage Ratios
• Activity Ratios

Time Value of Money

• Single Cash Flow
• Annuity
• NPV Using Constant Discounting
• NPV Using General Discounting
• Loan Amortization
• Sensitivity Analysis

Forecasting with Moving Average and Chart

• Using Moving Average Add-In
• Creating Moving Average Forecasts with Excel’s Charts
• Analyzing Trends Using Best-Fit Lines
• Plotting a Best-Fit Trendlines

Forcasting on Linear Data

• Understanding the Regression Equation
• Understanding R² - coefficient of determination
• Making Linear Forecasts: The TREND and LINEST Function

Forcasting on Nonlinear Data

• Working with an Exponential Trend
• Working with a LogarithmicTrend
• Making Nonlinear Forecasts: The GROWTH Function
• Working with a PowerTrend
• Using Polynomial Regression Analysis
• Using Mulitple Regression Analysis

Building Capital Budgeting Models

• Forecasting Cash Flows
• Working Capital
• Sensitivity Analysis
• Break-Even Analysis on accounting profit
• Break-Even Analysis on NPV