Financial Training

finances_banner.jpg

Twin Computer Training, Inc. has developed a custom Financial Modeling Training Program designed for the banking and financial industries. This training program is a well-balanced combination of Excel topics, workbook exercises designed with a specific Financial Institution's modeling practices, and "Roaming Trainer"™ support. 
Our goal is to teach the development of the Financial Modeling from start to finish using Excel. To that end, the Financial Modeling class has been customized to utilize specific Financial methodology and includes financial topics such as; Creating Balance Sheet, Income Statement, Ratios, Cash Flow, Forecasted Cash Flows, Debt Calculations and Reconciliation worksheets.

The training covers the following financial topics with an emphasis on reinforcing Excel functions.

  • Creating an Income Statement (Data entry and navigation shortcuts)
  • Creating a Balance Sheet (Formulas)
  • Cash Flow Modeling (Linking)
  • Developing Ratios (Advanced formatting)
  • Income Statement Historical Reference (Conditional testing)
  • Income Statement Forecast Assumptions (Absolute vs. relative cell addressing)
  • Balance Sheet Projections (Range names)
  • Forecast Assumptions for Balance Sheet (Errors and Auditing)
  • Create Forecasted Cash Flow (Screen and window manipulation)
  • Debt Calculation on Balance Sheet (Existing Debt and New Debt)
  • Income Statement Interest Expense (Existing Debt and New Debt)
  • What if Analysis (Scenario Manager and Goal Seek)
  • Printing (View Manager and Report Manager)