This course prepares participants to make more accurate financial forecasts in standard generally accepted accounting principles (GAAP) format financial statements by using business intelligence (BI). Particular focus is placed on the difference between conventional financial forecasts based on simple growth assumptions, and financial forecasts using growth rates derived from data. The course is intended as an applied primer in forecasting using new techniques resulting from the growth in Big Data and BI techniques.

***Please download and open all supporting materials before starting the course videos.***

SKU *: crs-1652663
Sell price $: 36.00
Course Author: Michael McDonald
Authored on: 2018-06-23 01:19:55 -0700
Course Preview:

<iframe src="//player.vimeo.com/video/901388360?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>

Course Short Description:

This course explains how to create a more accurate forecast from statistical results like regressions, and how to evaluate that forecast.

credit Hours: 0
CPE Credits Awarded *: 1
Approval Status: - None -
Course is for: ** Main Course Library **
Course Duration: 1
Complexity of Content: Foundational
Suppress in lists: No
Last Updated/Reviewed Date: March 15, 2024
Prerequisitses:

Viewers should be familiar with basic financial and accounting concepts. At this point, participants in this course should be comfortable with gathering data, building databases, and running analyses.

Suggested Prior Coursework: 

Business Intelligence (BI) - The fundamentals of BI; What it does and why it's so essential

Business Intelligence – Collecting, Cleaning, and Merging Data

Business Intelligence - Structuring Data for Business Analysis

Business Intelligence – Fundamentals of Data Analysis

Business Intelligence – Using Data Analysis

Learning Objective:
  • Discover how to create a basic set of income statement, cash flow, and balance sheet forecasts
  • Recognize the linkages between different items across the financial statements
  • Identify how changes in growth assumptions impact financial forecasts
  • Explore how to use regression analysis to determine forecast growth rates using outside variables (e.g. Gross Domestic Product (GDP) and inflation)
Learning Tags:

Budgeting & Forecasting, Data Analysis, Financial Analysis, Premium

Course Type: CPE Course
Format: On Demand
Audit & Accounting: No
Careers: No
Ethics (NASBA): No
Excel: No
Finance: Yes
Human Resources (HR): No
Internal Audit: No
Leadership & Management: No
Marketing: No
Operations: No
Productivity & Tech: No
Risk Management: No
Sales: No
Tax: No
Field of Study: Specialized Knowledge
Other: No
CPA: Yes
CPD-IES7: No
CPD-IES8: Yes
CMA: Yes
CFE: Yes
Yellow Book: No
CGFM: Yes
CIA: Yes
CRMA: Yes
CPP: No
FPC: No
CTP: No
FP&A: No
CISM: No
CRISC: No
CISA: No
CIST: No
CRFS: No
SHRM-CP: No
SHRM-SCP: No
PHR: No
SPHR: No
GPHR: No
aPHR: No
PHRca: No
PHRi: No
SPHRi: No
Enable/Disable: Yes
CPE Credits: 1
Field of Study: Finance
CPE Delivery Method: QAS Self-Study
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: No
Program Location:

Online

Enable/Disable: Yes
Hours: 1
Field of Study: Finance
CPE Delivery Method: QAS Self-Study
Program Location:

Online

Enable/Disable: Yes
CPE Credits: 1
Field of Study: Finance
CPE Delivery Method: QAS Self-Study
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: Yes
CPE Credits: 1
Field of Study: Finance
CPE Delivery Method: QAS Self-Study
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: Yes
CPE Credits: 1
Field of Study: Financial Planning Or Analysis
CPE Delivery Method: QAS Self-Study
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: No
Program Location:

Online

Enable/Disable: Yes
Field of Study: Specific business topics such as finance and others
CPE Delivery Method: QAS Self-Study
CPE Credits: 1
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: Yes
CPE Credits: 1
Field of Study: Other activities contributing to professional competence
CPE Delivery Method: QAS Self-Study
Program Location:

Online

*Program Level: Basic
*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/certifications/APA-generic-RCH-updated-annually.png" width="80" height="80" alt="Approved by APA"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> &nbsp; has been approved for &nbsp;1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at &nbsp; <a href="http://www.americanpayroll.org/certification/recertification/">www.americanpayroll.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/certifications/APA-generic-RCH-updated-annually.png" width="80" height="80" alt="Approved by APA"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> &nbsp; has been approved for &nbsp;1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at &nbsp; <a href="http://www.americanpayroll.org/certification/recertification/">www.americanpayroll.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
Program Location:

On Demand/Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: No
Program Location:

On Demand/Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

Enable/Disable: No
Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/IRS_CE_Provider_Logo_Color.jpg" width="150" height="39" alt="pre-approved by IRS"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### CPE credit hours toward IRS Enrolled Agent (EA) continuing education requirements. In accordance with the standards set forth in Circular 230 section 10.6, CE credits have been granted based on a 50-minute hour. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
Program Location:

Online

Enable/Disable: No
Program Location:

Online

Enable/Disable: No
Program Location:

Online

Enable/Disable: No
Program Location:

Online

Enable/Disable: No
Program Location:

Online

Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at &nbsp; <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at &nbsp; <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
*Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

~Credit Details:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tbody>
        <tr>
            <td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
            <td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at &nbsp; <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
        </tr>
    </tbody>
</table>
Enable/Disable: No
Hours: 1.0
Free Marketing Course: No