Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Financial Forecasting Tools - Using Excel and Financial Ratios to Build a Forecast (Course Id 456)

QAS / Registry
  Add to Cart 
Author : Patricia McCarthy, MBA
Course Length : Pages: 29 ||| Review Questions: 12 ||| Final Exam Questions: 8
CPE Credits : 1.5
IRS Credits : 0
Price : $13.45
Passing Score : 70%
Course Type: NASBA QAS - Text - Technical - NASBA Registry
Primary Subject-Field Of Study:

Specialized Knowledge - Specialized Knowledge for Course Id 456

Description :

Financial forecasting is an estimate of financial performance for a future period. Essentially, it's an educated guess of the composition of future financial statements. It's a guess as no one, no matter how good they are, can accurately predict the future. However, it's an educated guess because one can use historical factors and adjust them for known current events and future plans to arrive at the forecasts. There is a difference between forecasting and planning. Forecasting is much faster and involves significant uses of estimates whereas planning entails the aggregation of a much greater level of detail to support the end result and to use as a comparison to actual results. This course will not cover planning nor a detail "build" of data. The intent is to use overall data to create summary forecasts of financial performance so that lenders may be timely informed of covenant issues, cash and debt needs may be anticipated and other issues may be addressed on a timely basis. There will not be supporting detail. However, the results will be explainable to shareholders, owners, potential investors or lenders and, more importantly, will make sense from an overall standpoint.

Usage Rank : 0
Release : 2018
Version : 1.0
Prerequisites : None.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None.
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 01-Jun-2021
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - Text - Technical - NASBA Registry - 456

Keywords : Specialized Knowledge and Applications, Financial, Forecasting, Tools, Using, Excel, Financial, Ratios, Build, Forecast, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

Upon completion of this course, you should be able to:
  • Identify historical trends and apply these trends to forecasts
  • Appreciate the need to discuss current events and future plans with other parties and apply the results of these discussions to a forecasted amount
  • Use the Forecast function in Excel
  • Understand and use the Correlate function in Excel
  • Understand financial ratios and their use in forecasting
  • Create a financial statement forecast
Course Contents :

Chapter 1 - Financial Forecasting Tools - Using Excel and Financial Ratios to Build a Forecast

Financial Forecasting Overview

Forecasting Sales

Forecasting Gross Margin

Forecasting General and Administrative Expenses

Review Questions


Other Expenses

Forecasting the Balance Sheet


Review Questions



Excel Course 456 Home: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?