|
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)
|
|
