An introduction to Victoria Additives and the model we need to build.

We start to create the first sheet in the financial model, the Input Sheet.

An introduction to Name Ranges-the advantages of using them in financial models and how to add them to cells.

We add Name Ranges to the Input Sheet for the Victoria Additives model.

We start to build the Calculation Sheet for Victoria Additives.

An introduction to capital expenditure and depreciation calculations, and adding them into the calculation sheet of the model.

An introduction to how equity calculations are included in financial models.

We build the equity calculations into the calculation sheet.

An introduction to working capital and an explanation of the calculations we include in a financial model.

We build the balance sheet in our financial model.

An introduction to cash flows and the main calculations around working capital.

We build the cash flow for the Victoria Additives model.

We look at how to audit formulas, the most common spreadsheet errors and how to detect and fix errors.

I give you the challenge of balancing the balance sheet, and then go through the calculations and steps to do so.

We create the Output Sheet for the Financial Model.

I challenge you to create a summary balance sheet and cash flow statement and then go through the steps.

An introduction to financial ratio analysis typically used in financial models. We also go over debt covenant ratios.

We go through adding the financial ratios to our financial model.

Dividend calculations overview and adding dividend calculations to the Victoria Additives model.

Weighted average cost of capital calculations are explained, and we then add WACC calculations to the Victoria Additives financial model.

An explanation of share buy backs and how they can be included in a financial model.

We add share buy back calculations to the financial model.

I challenge you to create a WACC table and then I go through the steps with you.