Financial Analysis & Modeling

Learn best practices to create dynamic, interactive charts. Understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria. Price:$150.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link - https://www.onlinecompliancepanel.com/webinar/Advanced-Excel-Charting-Skills-Using-Spinners-Sliders-Check-Boxes-Other-ActiveX-Tools-That-Turn-You-Into-a-Guru-504477/FEBRUARY-2019-ES-TRAININGREGISTRY

It is imperative that practices and facilities know the "audit risks" and what the Office of Inspector is looking for in regard to safeguarding federal dollars and protecting the Medicare trust fund. Discussion of what the audits have uncovered so far in 2018 and how you can protect your practice in the future. Easy to understand guidance and layout of the items that the OIG is watching. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/2018-OIG-Work-Plan-for-Coding-Billing-Reimbursement-505323/AUGUST-2018-ES-TRAININGREGISTRY

This training program will explore the vital world of advanced financial statement analysis. This session will include a review of the four financial statements and a five-step analysis model including liquidity, activity, leverage, operating performance, and cash flow. It will also review the Z-score (bankruptcy predictor) and the sustainable growth models. The webinar is a must for all commercial lenders and credit administrators.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Advanced-Financial-Statement-Analysis-Liquidity-Activity-Leverage-Operating-Performance-Cash-Flow-Z-Score-and-Case-Studies-506503/AUGUST-2018-ES-TRAININGREGISTRY

Learn when and how you must compensate employees for travel time. Ensure you comply with the requirements under the Portal Act. Get an update on IRS travel expense documentation requirements. Clearly define when employee meals are 100% deductible and when they are only 50% deductible. Learn about the impact of the Tax Credits and Jobs Act on deductibility of meal, entertainment and gift expenses. Understand the limitations when personal and business travel and entertainment are mixed. Ensure your records will stand the scrutiny of a compensation or tax audit. Learn about employer liability for accidents of traveling employees.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Travel-Pay-T-E-Reimbursements-Vicarious-Liability-504280/AUGUST-2018-ES-TRAININGREGISTRY

This webinar provides introductory information for banks and credit unions to work toward meeting the regulator's appraisal program requirements. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Commercial-Appraisal-Review-Focus-on-the-Tough-Ones-507165/AUGUST-2018-ES-TRAININGREGISTRY

In this webinar, attendees will learn the risks and responsibilities for maintaining a correspondent banking relationship in 2018. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/AML-Risks-in-Correspondent-Banking-What-You-Need-to-Know-for-2018-508270/JUNE-2018-ES-TRAININGREGISTRY

Get a thorough knowledge on Loan Documentation Process for Loan Administration. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Loan-Documentation-for-Loan-Administration-507726/JUNE-2018-ES-TRAININGREGISTRY

Attend this webcast and learn how the CPA should calculate and interpret the Cash Conversion Cycle formula and how it directly impacts a company's liquidity. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Analyzing-the-Company-s-Liquidity-Using-the-Cash-Conversion-Cycle-507465/JUNE-2018-ES-TRAININGREGISTRY

In this training session any user of Excel who wants to learn how to create form-driven applications and spreadsheets can attend this webinar at discounted price. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Building-and-Designing-Data-Input-Forms-in-Excel-504850/MAY-2018-ES-TRAININGREGISTRY

Get trained on the various laws affecting travel expense reimbursements and learn how to comply with federal regulations. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Travel-Pay-Best-Practices-to-Comply-with-Federal-Regulations-506090/MAY-2018-ES-TRAININGREGISTRY

This Excel training program will illustrate how best to use Excel's special tools and functions to spot fraud red flags. It will also review SAS No. 56 Analytics and related dashboard KPIs and offer insight into Benford's law and limitations. Attendees will learn how to set up a worksheet to help automate Benford's law analysis. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/How-to-Use-Excel-to-Detect-Fraud-509892/MARCH-2018-ES-TRAININGREGISTRY

This Excel training program will help attendees create interactive, dynamic Excel Charts helpful for financial modeling and dashboards. It will also help build Excel Charts to save time and eliminate manual input. Attendees will learn Excel Lookup functions, understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria, learn how to use Excel dynamic named ranges with tables for chart automation, and more. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Advanced-Excel-Charting-Skills-Using-Spinners-Sliders-Check-Boxes-Other-ActiveX-Tools-That-Turn-You-Into-a-Guru-508950/MARCH-2018-ES-TRAININGREGISTRY

The course provides a concise overview of leading Internet security resources and strategies that can be used by accountants to step up their security posture from an individual front-line perspective and enterprise standpoint. While perfect security is not possible in a world where threat actors are always finding new and creative ways to exploit users and technology, attendees will walk away knowing how to better manage digital risks, prioritize security issues, and develop controls that improve protection of corporate data and networks. Find out how to encrypt smartphone communications, boost your Wi-Fi security, protect your mobile devices, avoid social engineering scams and more. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Internet-Security-Tools-for-Accountants-504916/FEBRUARY-2018-ES-TRAININGREGISTRY

Forms come in many varieties. The forms we will build are created within Word and are intended for online use. We will create forms used for collecting data built with legacy fields. We will demonstrate collecting that data and importing it into Excel for analysis. We will also examine Content Control fields and how a user can benefit by including them in a "form type" document. An overview of general Word fields will be presented to help with further automating any Word file. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/MASTERING-FORMS-IN-MICROSOFT-WORD-505509/NOVEMBER-2017-ES-TRAININGREGISTRY

In many organizations, operationally responsible managers have been made accountable for the financial performance of their divisions. This means that these managers need to have a firm grip on using a wide range of financial reports and information - making understanding finance, accounts and budgets extremely important for them. In the webinar, the speaker will aim to make non-financial managers comfortable will using the information provided by their accounting departments to make the correct management decisions.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/FINANCE-FOR-NON-FINANCIAL-MANAGERS-504635/OCTOBER-2017-ES-TRAININGREGISTRY

This webinar will help attendees understand the way accounting "rules" are made by the FASB in the private sector, focus on the general principles underlining GAAP "rules," appreciate unique peculiarities of bank accounting, comprehend the intricacies of bank financial statements and master the complete set of financial statements and related schedules and reports. The webinar also focuses on the recent accounting trends that emphasize: Balance sheet over income statement, current values over historical costs and full disclosure over detailed schedules.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/UNIQUE-BANK-ACCOUNTING-GAAP-ISSUES-504283/OCTOBER-2017-ES-TRAININGREGISTRY

Financial Statement information at times appears to be overwhelming. Directors, managers, officers, auditors, reviewers, investors, controllers, regulators and others often try to focus on financial statements to pinpoint bank areas of concern.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/FINANCIAL-STATEMENT-ANALYTICAL-PROCEDURES-502996/SEPTEMBER-2017-ES-TRAININGREGISTRY

This anti-money laundering training will describe the reasons and methods of money laundering in financial institutions. This will help attendees to protect themselves from regulatory risk by establishing an effective anti-money laundering system within their financial institution.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/MONEY-LAUNDERING-PREVENTION-509252/AUGUST-2017-ES-TRAININGREGISTRY

OVERVIEW This AML compliance webinar will look at the use of financial statements as a tool to commit fraud upon the financial sector and investors and common tricks used by fraudsters, as well as identifying “red flags” for potential problems. WHY SHOULD YOU ATTEND Many companies have started addressing financial statement fraud due to the financial losses suffered and collapse of their well established brand identity. This webinar will discuss some of the ways in which one relying on such financial information may take steps to prevent falling victim to fraud. AREAS COVERED Financial Statement Fraud – what is it and some examples of its use Often-used tricks to commit fraud in financial statements How to verify financial statement information. For more detail please click on this below link: http://bit.ly/2tae2Tj Email: referrals@complianceglobal.us Toll Free: +1-844-746-4244 Tel: +1-516-900-5515 Fax: +1-516-900-5510

OVERVIEW Under the leadership of the Consumer Financial Protection Bureau the rules change significantly in 2017, 2018, and for large institutions again in 2020. There will be changes reducing the number of financial institutions must report, the types of loans subject to reporting, the data which will have to be reported, and the methods and IT reporting requirements. WHY SHOULD YOU ATTEND Everyone in the value chain of making mortgage decisions and fulfilling HMDA reporting requirements will need to be working in compliance with the new rules. If data isn’t captured early enough, from the right transactions, and completely enough, costs of reporting may become higher than necessary and potentially, penalties may be incurred. For more detail please click on this below link: http://bit.ly/2uxA8CB Email: referrals@complianceglobal.us Toll Free: +1-844-746-4244 Tel: +1-516-900-5515 Fax: +1-516-900-5510