 ## Forecasting Using Linear Regression

Forecasting using linear regression takes driver-based forecasting a step forward using statistical analysis. Let’s walk through this powerful tool to take historical data points and turn them into a forecast. ## Variance Analysis Using Rate and Volume

Variance analysis using rate and volume is a method of breaking down business results into component parts. Let’s walk through the rate formula, the volume formula, and an example to put it into practice. ## How to Create a Profit and Loss Statement in Excel

A Profit and Loss statement (or P&L) is one of the three major financial statements and an important part of reporting and forecasting. Let’s walk through how to create a profit and loss statement in Excel. ## Forecasting Using Rate and Volume

Forecasting using rate and volume is a simple but reliable method to develop projections. You can take inputs that your business already has on hand, run them through a spreadsheet with basic formulas, and deliver insights. ## Easily Calculate Internal Rate of Return in Excel

Internal Rate of Return (or IRR) is a tool to compare multiple projects against each other. Usually, calculating IRR requires a series of trial and error to back into the answer. Fortunately, Excel will do the heavy lift for us. ## Calculate Net Present Value In Excel – The Easy Way

Net Present Value is the basis of Finance, but the formula can be hard to work with. Excel to the rescue! Let’s walk through how to calculate Net Present Value (NPV) in Excel.