Financial Forecasting and Modeling

Price: $47.50

CPE Credits: 5.0

Category:

Course Number: FIFORMSB

financial forecasting

Description:
The ability to construct a reliable financial model that projects future performance is essential for the forward-looking business professional. This course provides the essential knowledge needed to become proficient at forecasting and modeling. It does so by discussing the different types of forecasting methodologies, the situations in which they should be used, and how to construct them. The course also examines the layout and formulation of a financial model, and addresses specific issues within such a model, including the treatment of depreciation, debt, equity, and working capital. Further, the course describes the construction of short-term and longer-term cash forecasts, and concludes with a review of the Excel functions that can be used for financial forecasting and modeling.  Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Prerequisites: A basic knowledge of Excel functionality.

Advanced Preparation: None

AuthorSteven Bragg, CPA

Publication: October 2015; Updated: September 2018
Pages: 115

Format: PDF

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • Recognize the characteristics of the Delphi method.
  • Identify the best uses of the different forecasting methods.
  • Specify the situations in which a smoothing constant can be used.
  • Recognize the different types of leading and lagging indicators.
  • State which report makes use of the accounting equation.
  • Specify how an income statement is used.
  • Identify the key inputs to a financial model.
  • Recognize the complications caused by the use of a plug within a financial model.
  • Specify the circumstances under which a business could fund its own growth.
  • Recognize the cases in which an expansion of a financial model might be warranted.
  • Specify the sources of the receipts and disbursements method.
  • Identify the duration periods for the different types of forecasts.
  • Specify why the results of an automated cash forecasting system may be incorrect.
  • Recognize the reliability levels of the different types of cash forecast information.
  • State the reasoning behind the use of a cash forecast reconciliation.
  • Specify which Excel functions will fit straight and curved lines to the data.
  • Identify the types of information provided by the different Excel functions relating to forecasting.
  • Recognize the inputs required for the different Excel functions relating to forecasting.

Description:
The ability to construct a reliable financial model that projects future performance is essential for the forward-looking business professional. This course provides the essential knowledge needed to become proficient at forecasting and modeling. It does so by discussing the different types of forecasting methodologies, the situations in which they should be used, and how to construct them. The course also examines the layout and formulation of a financial model, and addresses specific issues within such a model, including the treatment of depreciation, debt, equity, and working capital. Further, the course describes the construction of short-term and longer-term cash forecasts, and concludes with a review of the Excel functions that can be used for financial forecasting and modeling.  Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Prerequisites: A basic knowledge of Excel functionality.

Advanced Preparation: None

AuthorSteven Bragg, CPA

Publication: October 2015; Updated: September 2018
Pages: 115

Format: PDF

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • Recognize the characteristics of the Delphi method.
  • Identify the best uses of the different forecasting methods.
  • Specify the situations in which a smoothing constant can be used.
  • Recognize the different types of leading and lagging indicators.
  • State which report makes use of the accounting equation.
  • Specify how an income statement is used.
  • Identify the key inputs to a financial model.
  • Recognize the complications caused by the use of a plug within a financial model.
  • Specify the circumstances under which a business could fund its own growth.
  • Recognize the cases in which an expansion of a financial model might be warranted.
  • Specify the sources of the receipts and disbursements method.
  • Identify the duration periods for the different types of forecasts.
  • Specify why the results of an automated cash forecasting system may be incorrect.
  • Recognize the reliability levels of the different types of cash forecast information.
  • State the reasoning behind the use of a cash forecast reconciliation.
  • Specify which Excel functions will fit straight and curved lines to the data.
  • Identify the types of information provided by the different Excel functions relating to forecasting.
  • Recognize the inputs required for the different Excel functions relating to forecasting.
  • Thank you for providing very informative CPEs. I have enjoyed your courses for years now. Yours is truly my go-to CPE sources.

    - Lily

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

  • “It is rare that i can actually say that I enjoyed a CPE course but I found this one informative and very interesting, relying more on the author’s examples and not just quoting tax code!  [Healthcare Reform: The affordable Care Act Tax Provisions]

    - Thomas