Financial Forecasting Tools

Price: $23.49

CPE Credits: 2.5

Category: , ,

Course Number: FMCFFTEX

financial forecasting

Description:
Certificate will read 1.0  Hr . Computer Science and 1.5 Hrs. Finance. 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. Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Prerequisites:  Knowledge of basic computer and Excel skills: opening and closing files. Have an understanding of how Excel formulas work.

Advanced Preparation: Need Excel 2007 or higher

AuthorMill Creek Publishing LLC

Publication: April 2014
Updated: February 2017
Reviewed: January 2018

Format: PDF and Excel workbook

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:

  • 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 functionin Excel
  • Understand and use the Correlate function in Excel
  • Understand financial ratiosand their use in forecasting
  • Create a financial statement forecast

 

” I really liked this course.  I thought it was very easy to follow the text and the excel clips within the text helped me understand the development of the forecast line by line.  I also really like receiving a small started spreadsheet with which to build the formulas. Saves time overall but still permits the development of the formulas and functions. ‘ D.Wilson  11/2017
5 Star CPE Rating

Description:
Certificate will read 1.0  Hr . Computer Science and 1.5 Hrs. Finance. 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. Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Prerequisites:  Knowledge of basic computer and Excel skills: opening and closing files. Have an understanding of how Excel formulas work.

Advanced Preparation: Need Excel 2007 or higher

AuthorMill Creek Publishing LLC

Publication: April 2014
Updated: February 2017
Reviewed: January 2018

Format: PDF and Excel workbook

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:

  • 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 functionin Excel
  • Understand and use the Correlate function in Excel
  • Understand financial ratiosand their use in forecasting
  • Create a financial statement forecast

 

” I really liked this course.  I thought it was very easy to follow the text and the excel clips within the text helped me understand the development of the forecast line by line.  I also really like receiving a small started spreadsheet with which to build the formulas. Saves time overall but still permits the development of the formulas and functions. ‘ D.Wilson  11/2017
5 Star CPE Rating

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

    - Janet

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.

  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course