Financial Budgeting and Forecasting In Excel Complete Course

Chris Benjamin expands on the introduction to the course, talking more about the specific process used in the course and the content which will be created.

An introduction and overview of the financial model process we will be going through in the course.

Summary worksheet to use with this section, includes terminology, sections for questions and notes of the student, and 3 questions related to the section.

Chris Benjamin gives an overview of Excel basic functions and formulas needed to be successful in the course.

An overview of all Excel functions and formatting tools, as well as navigation within Excel, that is commonly used in financial modeling.

Chris Benjamin talks about the importance of Assumptions, the general process for determining your assumptions and how they then factor into subsequent financial statements.

The beginning of creating our Assumptions tab. We start with modeling the Revenue assumptions. Cover revenue drivers, revenue per item, and the process used to create the assumptions and properly lay them out in Excel.

A continuation of the revenue driver assumptions, the proper lay out in Excel, and a discussion of how this will feed into the financial statements.

Continuing with the assumptions, we now work on the cost of good solids assumptions. The various methods which can be used are discussed.

Salaries typically are the largest expense for a new startup company. This video covers how to set up salary assumptions, the various alternatives you have, and creates a set of assumptions to be used in the model.

General and Administrative costs typically found in a company are modeled in this video.

Sales and marketing expenses are broken out into their own category and modeled in this video. Various alternatives for how to create expense drivers are discussed as well.

Assumptions related to the balance sheet are included in this video. Later on fixed asset assumptions are additionally added to this section.

Chris Benjamin discusses the profit and loss statement and the approach to now beginning building the financial statements using the assumptions created previously.

The profit and loss statement is created with headers, row titles and general formatting.

Expanding on the formatting, in this video formulas are put in place for all totals both vertical and horizontal.

The revenue section of the Profit and Loss statement is modeled by linking to the assumptions created earlier.

The cost of goods sold section of the Profit and Loss statement is modeled here using the linking technique back to the assumptions tab.

Chris Benjamin discusses the Balance Sheet and how it is tied to other financials.

The Balance Sheet is established, with headers and row titles, along with overall formatting.

Formulas are put in place to start to establish the balance sheet.

The Balance Sheet formula creation is continued, linking the assumptions and other inputs to line by line.

The Balance Sheet originally did not include an inventory line item. This video shows how to go about adding a new line item.

An introduction to the statement of cash flows and its place within the financial model.

The Cash Flow financial statement is started. This video focuses on the set up of the titles, columns and formatting.

Formulas for totals both horizontal and vertical are put into the Cash Flow statement.

The beginning of placing in formulas to link the Cash Flow statement to the assumptions and other financial statements is started.

Continuation of the populating of the Cash Flow statement with formulas in order to bring the data needed into the financial statement.

Finalization of the formulas needed in the Cash Flow statement.

Summary worksheet to use with this section, includes terminology, sections for questions and notes of the student, and 3 questions related to the section.

Chris Benjamin discusses the importance of an inventory planning worksheet. This section applies only to businesses who sell goods.

Building the Inventory worksheet and start of some formuas

Now that the Inventory sheet is established, this video begins the process of writing formulas to link the Assumptions to the Inventory tab so we can establish a plan for inventory purchases.

In this video we continue adding formulas to finish the Inventory worksheet. As well a discussion of inventory planning and how to approach minimum inventory amounts.

Chris Benjamin discusses the process of now tying out the model, making sure everything is in balance and linked correctly. As well how to look at the model from a feasibility of the business standpoint is discussed.

In this video, now that the financial model is essentially done, we check for errors by starting with the balance sheet. A discussion of methods used to identify errors is included.

Now that the model has been error checked and in balance, before proceeding we take a step back and review the results to see if it makes sense from a 10,000 foot level. Assumptions are adjusted and a discussion of profitability and business feasibility are provided.

Chris Benjamin discusses the purpose of having a best case/worst case (aka Variance Analysis) worksheet.

The Variance Analysis tab is created and general formatting done as with prior tabs added.

The Variance Analysis tab is now populated with formulas, linking the Assumptions about the variances along with the Profit and Loss results. The purpose and best business practices of the Variance Analysis are discussed.

Chris Benjamin discusses the final worksheet created in the financial model, a summary which brings in the highlights of each of the financial statements.

The final tab, Financial Summary, is established and formatting done to prepare the tab.

The formulas are inserted to create the financial summary. A discussion of the overall purpose and uses for the financial summary are also included.

In the course conclusion, we review the goals originally set in the course preview to make sure we accomplished them. As well I discuss the additional courses I have available, provide a coupon/promo code for you to use for a discount on any course of mine, and lastly provide my contact information.