emtec hfm validation.pdf

37 

Full text

(1)

Things to

Things to

Consider-Designing Cash Flow Process in HFM

Designing Cash Flow Process in HFM

Russ Rogers & Jeff Pitts May 8,

(2)

Purpose and Definitions

Purpose and Definitions

Purpose

Purpose

 –

 –Provide an overview of everything to consider when automating a statement of Provide an overview of everything to consider when automating a statement of cash flows in HFMcash flows in HFM

 –

 –Not teach you all detailed steps surrounding buildiNot teach you all detailed steps surrounding building of metadata, artifacts and business rules. ng of metadata, artifacts and business rules. ThisThis

would simply take too much time.

would simply take too much time.

 –

 –Provide some explanation and thought process behind the metadata, artifacts and rules included inProvide some explanation and thought process behind the metadata, artifacts and rules included in

this presentation

this presentation

 –

 –There is no such thing as There is no such thing as a statement of cash flows a statement of cash flows that is 100% automated. Some manualthat is 100% automated. Some manual

intervention will always be required

intervention will always be required

Definitions

Definitions

 –

 –MetadataMetadata – – Members and structures defined in HFM Metadata Manager used for the purpose of Members and structures defined in HFM Metadata Manager used for the purpose of

storing data that is both

storing data that is both submitted and calculated (i.e.submitted and calculated (i.e. – – scenarios, years, accounts and customs 1-4 scenarios, years, accounts and customs 1-4

 –

 –Business RulesBusiness Rules – – A  A form of Visual Basic defined in HFM Rules Editor used for form of Visual Basic defined in HFM Rules Editor used for the purpose ofthe purpose of

calculating results

calculating results

 –

 – Artifacts Artifacts – – Data Forms, Data Grids and Reports defined in  Data Forms, Data Grids and Reports defined in HFM Web used for submission andHFM Web used for submission and

validation of data and reporting of results

(3)

Metadata

Metadata

Consideration

Consideration

 –

 –

 Create a

 Create a

Custom Dimension Struct

Custom Dimension Struct

ure for Balance Sheet

ure for Balance Sheet

Custom Dimension

Custom Dimension

 –

 –TTo be used o be used for all for all Balance Sheet roll forward activityBalance Sheet roll forward activity

 –

 –Dimension members include: Beg Dimension members include: Beg Balance, Additions, Retirements, TransfersBalance, Additions, Retirements, Transfers

 –

 –TTop member of Custom Dimension structure is op member of Custom Dimension structure is assigned to all Balance Sheet assigned to all Balance Sheet accountsaccounts

 –

(4)

Business Rule

Business Rule

Consideratio

Consideratio

n

n

 –

 –

 Calculate Beg Balance on all

 Calculate Beg Balance on all

Balance Sheet Accou

Balance Sheet Accou

nts

nts

Beginning Balance Rule

Beginning Balance Rule

 –

 –Calculates the Beginning Balance on each Balance Sheet accountCalculates the Beginning Balance on each Balance Sheet account

 –

(5)

Process (Artifact)

Process (Artifact)

Consideration

Consideration

 –

 –

 Collect Supplemental Roll Forward Data by

 Collect Supplemental Roll Forward Data by

Location

Location

Task List of Web Data Forms by Location

Task List of Web Data Forms by Location

 –

 –Data forms to capture supplemental information not included in source ERP systemData forms to capture supplemental information not included in source ERP system

 –

 –Data forms include: Beg Balances (calculatedData forms include: Beg Balances (calculated), ), Additions, Retirements, Additions, Retirements, TransfersTransfers

 –

(6)

Process Monitor Traffic Light

Process Monitor Traffic Light

 –

 –

 Validate Supplemental Roll Forward Data in Total

 Validate Supplemental Roll Forward Data in Total

Task List of Web Data Forms by Location

Task List of Web Data Forms by Location

 –

 –VVery same validation checks in each data form is ery same validation checks in each data form is contained on reportcontained on report

 –

 –Cells in green confirm all supplemental data is properly submittedCells in green confirm all supplemental data is properly submitted

 –

(7)

Metadata Consideration

Metadata Consideration

 –

 –

Create a “Changes in

Create a “Changes in

Balance Sheet” Accoun

Balance Sheet” Accoun

t Structure

t Structure

 Account Dimension

 Account Dimension

 –

 – All accounts are defined  All accounts are defined as “Expense” typeas “Expense” type

 –

 –Purpose is to capture changes on all Purpose is to capture changes on all Balance Sheet accountsBalance Sheet accounts

 –

 –TTotal number of accounts in this structure otal number of accounts in this structure is less than the number of is less than the number of accounts in the Balance Sheetaccounts in the Balance Sheet

structure

structure

 –

 –Lowest level base accounts only go down as far as changes that need to be capturedLowest level base accounts only go down as far as changes that need to be captured

 –

(8)

Metadata Consideration

Metadata Consideration

 –

 –

 Create a

 Create a

Custom Dimension Structure to Capture Changes

Custom Dimension Structure to Capture Changes

Custom Dimension

Custom Dimension

 –

 –Includes members for changes in Beg Balances, changes in End Balances and changes in Activity forIncludes members for changes in Beg Balances, changes in End Balances and changes in Activity for

3 key levels of

3 key levels of value dimension (<Entity Currency>, <Pavalue dimension (<Entity Currency>, <Parent Currency>, [Elimination])rent Currency>, [Elimination])

 –

 – Assigned as top mem Assigned as top member for all “Changes iber for all “Changes in Balance Sheet” accountsn Balance Sheet” accounts

 –

 –Can be in same Custom Dimension used to capture Balance Sheet roll forward activityCan be in same Custom Dimension used to capture Balance Sheet roll forward activity

 –

(9)

Business Rule

Business Rule

Consideratio

Consideratio

n

n

 –

 –

 Calculate Cash

 Calculate Cash

Flow Beginning and Ending Balances

Flow Beginning and Ending Balances

Rule <Entity Currency>

Rule <Entity Currency>

 –

 –Rule populates beginning and ending balances on <Entity Rule populates beginning and ending balances on <Entity Currency>Currency>

 –

(10)

Business Rule

Business Rule

Consideration

Consideration

 –

 –

 Calculate Cash Flow Beg and

 Calculate Cash Flow Beg and

End Balances

End Balances

(Continued)

(Continued)

Rule [Elimination]

Rule [Elimination]

 –

 –Rule populates beginning and ending balances on [Elimination]Rule populates beginning and ending balances on [Elimination]

 –

(11)

Business Rule

Business Rule

Consideration

Consideration

 –

 –

 Calculate Cash Flow Beg and

 Calculate Cash Flow Beg and

End Balances

End Balances

(Continued)

(Continued)

Rule <Parent Currency> is USD

Rule <Parent Currency> is USD

 –

 –Rule populates beginning and ending balances on <Parent Rule populates beginning and ending balances on <Parent Currency>Currency>

 –

(12)

Business Rule Consideration

Business Rule Consideration

 –

 –

 Calculate Cash

 Calculate Cash

Flow Activity

Flow Activity

Rule

Rule

 –

 –Rule calculates on 3 Rule calculates on 3 levels of value levels of value dimension (<Entity Currency>, [Elimination], <Parent Currency>)dimension (<Entity Currency>, [Elimination], <Parent Currency>)

 –

 –Rule uses conditional statements to Rule uses conditional statements to populate ECCH activity, ELCH activitypopulate ECCH activity, ELCH activity, and PCCH activity, and PCCH activity

 –

(13)

Process (Artifact)

Process (Artifact)

Consideration

Consideration

 –

 –

 Create Data Grid to Validate ECCH_Activity Rule

 Create Data Grid to Validate ECCH_Activity Rule

Data Grid –

Data Grid

 – Confirms <Entity Currency> net to 0

 Confirms <Entity Currency> net to 0

 –

 –Displays POV: A#CH_BalanceSheet, V#<Entity Displays POV: A#CH_BalanceSheet, V#<Entity Currency>, C2#EC_CashflowCurrency>, C2#EC_Cashflow,,

 –

 –Displays Row: E#[Base Entities]Displays Row: E#[Base Entities]

 –

(14)

Process (Artifact)

Process (Artifact)

Consideration

Consideration

 –

 –

 Create Data Grid to Validate PCCH_Activity Rule

 Create Data Grid to Validate PCCH_Activity Rule

Data Grid - Confirms <Parent Currency> net to 0

Data Grid - Confirms <Parent Currency> net to 0

 –

 –Displays POV: A#CH_BalanceSheet, V#<Parent Displays POV: A#CH_BalanceSheet, V#<Parent Currency>, C2#EC_CashflowCurrency>, C2#EC_Cashflow,,

 –

 –Displays Row: E#[Base Entities]Displays Row: E#[Base Entities]

 –

(15)

Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.

Process

Process

(Artifact) Consideration

(Artifact) Consideration

 –

 –

 Create Data Grid to Validate ELCH_Activity Rule

 Create Data Grid to Validate ELCH_Activity Rule

15 15

Data Grid - Confirms [Elimination] net to 0

Data Grid - Confirms [Elimination] net to 0

 –

 –Displays POV: A#CH_BalanceSheet, V#[Elimination], C2#EC_Cashflow,Displays POV: A#CH_BalanceSheet, V#[Elimination], C2#EC_Cashflow,

 –

 –Displays Row: E#[Base Entities]Displays Row: E#[Base Entities]

 –

(16)

Metadata Consideration

Metadata Consideration

 –

 –

 Create Cash

 Create Cash

Flow Statement Reporting Accounts

Flow Statement Reporting Accounts

 Account Dimension

 Account Dimension

 –

 – Accounts used for “presentation”  Accounts used for “presentation” andand

calculation of each line item that appears on

calculation of each line item that appears on

the St. of Cash Flows

the St. of Cash Flows

 –

 – All accounts are defined  All accounts are defined as “Expense” typeas “Expense” type

 –

 –The hierarchy of the account structureThe hierarchy of the account structure

models how the report should be displayed

models how the report should be displayed

(i.e.

(i.e. – – Operating, Financing and Investing Operating, Financing and Investing

sections).

(17)

Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.

Metadata Consideration

Metadata Consideration – – Expand “Changes in Balance Expand “Changes in Balance Sheet” Custom DimensionSheet” Custom Dimension

•Custom DimensionCustom Dimension

 –

 –Includes members for Includes members for CFS_TCFS_Total, CFS_Calc otal, CFS_Calc and CFS_Inputand CFS_Input

 –

 – Assigned as top mem Assigned as top member for all Cash Flow ber for all Cash Flow Statement reporting accountsStatement reporting accounts

 –

 –CFS_Calc member used for calculations and CFS_Input used for input adjustments (i.e.CFS_Calc member used for calculations and CFS_Input used for input adjustments (i.e. – – manual manual

input for off Balance Sheet item)

input for off Balance Sheet item)

17 17

(18)

Process (Artifact) Consideration

Process (Artifact) Consideration

 –

 –

 Create St. of Cash Flow Data Form

 Create St. of Cash Flow Data Form

Data Form- St. of Cash Flows

Data Form- St. of Cash Flows

 –

 –Column 1 (CFS_Calc) represents the line item calculations (not yet discussed)Column 1 (CFS_Calc) represents the line item calculations (not yet discussed)

 –

 –Column 2 (CFS_Input) represents the line item input (i.e.Column 2 (CFS_Input) represents the line item input (i.e. – – manual input for off Balance Sheet items) manual input for off Balance Sheet items)

 –

 –Colum 3 (CFS_TColum 3 (CFS_Total) is the otal) is the parent member that sums the parent member that sums the calculations and inputs to calculations and inputs to the line items andthe line items and

is the member to be used for reporting

(19)

Business Rule

Business Rule

Consideratio

Consideratio

n

n

 –

 –

 Calculate

 Calculate

Cash Flow Statement Reporting Accounts

Cash Flow Statement Reporting Accounts

Rules for <Entity Currency>

Rules for <Entity Currency>

 –

(20)

Business Rule

Business Rule

Consideratio

Consideratio

n

n

 –

 –

 Calculate

 Calculate

Cash Flow Statement Reporting Accounts

Cash Flow Statement Reporting Accounts

Rules for [Elimination]

Rules for [Elimination]

 –

 –Conditional statemenConditional statement used to calculate reporting t used to calculate reporting accounts accounts that use Intercompany accthat use Intercompany accounts that areounts that are

eliminated during consolidation process (i.e.

(21)

Business Rule

Business Rule

Consideratio

Consideratio

n

n

 –

 –

 Calculate

 Calculate

Cash Flow Statement Reporting Accounts

Cash Flow Statement Reporting Accounts

Rules for Net Income

Rules for Net Income and Dollar Overrides

and Dollar Overrides

 –

 –Conditional statement is used to calculate Net Income and other reporting accounts that Conditional statement is used to calculate Net Income and other reporting accounts that are calculatedare calculated

using dollar overrides (i.e.

using dollar overrides (i.e. – – Investment in Subs, Dividends) Investment in Subs, Dividends)

 –

(22)

Metadata & Rule

Metadata & Rule

Consideratio

Consideratio

n

n

 –

 –

 Create and calculate a YTD EOM AVG rate account

 Create and calculate a YTD EOM AVG rate account

 Account Dimension

 Account Dimension

 –

 –The St. of Cash The St. of Cash Flow reporting line items that doFlow reporting line items that do

translate (i.e.

translate (i.e. – – not calculated after currency not calculated after currency

translation) will use

translation) will use the EOM_YTDAthe EOM_YTDAVG rateVG rate

account (or end of month YTD average)

account (or end of month YTD average)

 –

 –Rule uses a Rule uses a special Aspecial Average function thatverage function that

calculates this rate as the

calculates this rate as the sum of each period’ssum of each period’s

EOM rate / number of periods in

EOM rate / number of periods in year (akayear (aka – – a a

straight line average)

(23)

Business Rule Consideration

Business Rule Consideration

 –

 –

 Translate Cash Flow Reporting Accounts

 Translate Cash Flow Reporting Accounts

Rules for Translation

Rules for Translation

 –

 –Translate Cash Flow reporting accounts Translate Cash Flow reporting accounts using EOM_YTDAusing EOM_YTDAVG exchange rVG exchange rate accountate account

 –

 –Calculated in the Sub Translate() subroutineCalculated in the Sub Translate() subroutine

 –

 –Uses HS.Trans function to override application default translation method used Uses HS.Trans function to override application default translation method used for expense typefor expense type

accounts, which includes cash flow

(24)

Business Rule Consideration

Business Rule Consideration

 –

 –

 Calculate Beginning and Ending Cash

 Calculate Beginning and Ending Cash

Rules for Cash

Rules for Cash

 –

 –Used at bottom of St. Used at bottom of St. of Cash Flows below Financing sectionof Cash Flows below Financing section

 –

(25)

Business Rule Consideration

Business Rule Consideration

 –

 –

 Calculate Cash Proof and FX Effect on Cash

 Calculate Cash Proof and FX Effect on Cash

Rules for Cash Flow Proof and FX Effect (Plug)

Rules for Cash Flow Proof and FX Effect (Plug)

 –

 –Purpose 1: Calculate cash flow prPurpose 1: Calculate cash flow proof oof (befor(before currency translatioe currency translation) is in balance (i.e. = n) is in balance (i.e. = 0)0)

 –

 –Purpose 2: Calculate effect of FX on cash Purpose 2: Calculate effect of FX on cash (after currency translatio(after currency translation)n)

 –

 –Cash flow proof is: Beg. Cash + Op. Act. + Cash flow proof is: Beg. Cash + Op. Act. + InvInv. Act. + Fin. . Act. + Fin. Act.Act. – – End. Cash End. Cash

 –

(26)

Process (Artifact) Consideration

Process (Artifact) Consideration

 –

 –

 Update St. of Cash Flow Data Form

 Update St. of Cash Flow Data Form

Data Form- St. of Cash Flows

Data Form- St. of Cash Flows

 –

(27)

Metadata Consideration

Metadata Consideration

 –

 –

 Prove the FX Plug

 Prove the FX Plug

Custom Dimension

Custom Dimension

 –

 –The total FX effect (calculated in previous rule)The total FX effect (calculated in previous rule)

could be a fairly large number that is

could be a fairly large number that is initiallyinitially

calculated as a “plug”

calculated as a “plug”

 –

 – Auditors often want to know w Auditors often want to know what makes up thishat makes up this

“plug”

“plug”

 –

 –It is possible to use HFM to prove this “plug”It is possible to use HFM to prove this “plug”

 –

 –Define metadata by expanding the cash flowDefine metadata by expanding the cash flow

structure in custom dimension to include a

structure in custom dimension to include a

FX_Cashflow roll up that includes: FX_BB (FX

FX_Cashflow roll up that includes: FX_BB (FX

effect of beginning balance at

effect of beginning balance at <Parent Currency><Parent Currency>

and FX_ACT (FX Effect of activity at <Parent

and FX_ACT (FX Effect of activity at <Parent

Currency>)

(28)

Business Rules Consideration

Business Rules Consideration

 –Prove FX Effect “Plug” on Cash

 –Prove FX Effect “Plug” on Cash

Rules to Prove FX Effect (Plug)

Rules to Prove FX Effect (Plug)

 –

 –Create special translation rules to calculate total FX effect on Create special translation rules to calculate total FX effect on beginning cash as well as each sectionbeginning cash as well as each section

(operating, investing, financing) on statement of cash flows.

(operating, investing, financing) on statement of cash flows.

 –

 –FX effect on beginning cash is calculated as the difference between translating at current EOM ratFX effect on beginning cash is calculated as the difference between translating at current EOM ratee

vs. prior year P12 EOM rate.

vs. prior year P12 EOM rate.

 –

 –FX effect on operating activities (in total) is FX effect on operating activities (in total) is calculated as the difference between translating at currentcalculated as the difference between translating at current

EOM rate vs. translated balances reported (due to different method used to

EOM rate vs. translated balances reported (due to different method used to translate Net Income).translate Net Income).

 –

 –FX effect on each line making up the FX effect on each line making up the investing and financing activities must either be calculated byinvesting and financing activities must either be calculated by

taking the difference between translating at EOM rate vs. EOM_YTDA

taking the difference between translating at EOM rate vs. EOM_YTDAVG rate or by VG rate or by taking thetaking the

difference between translating at EOM rate vs. translated balances reported (due to different method

difference between translating at EOM rate vs. translated balances reported (due to different method

used on items with dollare overrides).

(29)

Metadata & Rule

Metadata & Rule

Consideratio

Consideratio

n

n

 –

 –

 Create and calculate a PR EOM rate account

 Create and calculate a PR EOM rate account

 Account Dimension

 Account Dimension

 –

 –Used for cash flow purposesUsed for cash flow purposes

 –

 –Used to copy Used to copy prior year EOM and Aprior year EOM and AVG rates toVG rates to

current year

(30)

Metadata Consideration

Metadata Consideration

 –

 –

 Create FX Proof Account roll up

 Create FX Proof Account roll up

 Account Dimension

 Account Dimension

 –

 –Used for cash flow purposesUsed for cash flow purposes

 –

 –Used to store calculated FX effect inUsed to store calculated FX effect in

specific CFS accounts used on St.

specific CFS accounts used on St.

of Cash Flow

(31)

Business Rules Consideration

Business Rules Consideration

 –

 –

Prove FX Effect on Beginning Cash

Prove FX Effect on Beginning Cash

Rules to Prove FX Effect (Plug for Beginning Cash)

Rules to Prove FX Effect (Plug for Beginning Cash)

 –

 –FX effect on beginning cash is calculated as the difference between translating at current EOM ratFX effect on beginning cash is calculated as the difference between translating at current EOM ratee

vs. prior year P12 EOM rate.

vs. prior year P12 EOM rate.

 –

(32)

Business Rules Consideration

Business Rules Consideration

 –

 –

Prove FX Effect on

Prove FX Effect on

Operating Activities

Operating Activities

Rules to Prove FX Effect (Plug for Operating Activities)

Rules to Prove FX

Effect (Plug for Operating Activities)

 –

 –FX effect on FX effect on operating activities cannot be calculated simply by operating activities cannot be calculated simply by using HS.Trans function in Translate()using HS.Trans function in Translate()

subroutine

subroutine to determine translation to determine translation difference between difference between EOM rate (used for BS accts) aEOM rate (used for BS accts) andnd

EOM_YTDA

EOM_YTDAVG (used for VG (used for changes on BS changes on BS accts)accts)

 –

 –The actual difference must be The actual difference must be calculated by using a calculated by using a combination of Translate(combination of Translate() and Calculate()) and Calculate()

subroutines

(33)

Business Rules Consideration

Business Rules Consideration

 –

 –

Prove FX Effect on

Prove FX Effect on

Investing Activities

Investing Activities

Rules to Prove FX Effect (Plug for Investing Activities)

Rules to Prove FX

Effect (Plug for Investing Activities)

 –

 –FX effect on FX effect on investing activities cannot be calculated simply by investing activities cannot be calculated simply by using HS.Trans function in Translate()using HS.Trans function in Translate()

subroutine

subroutine to determine translation to determine translation difference between difference between EOM rate (used for BS accts) aEOM rate (used for BS accts) andnd

EOM_YTDA

EOM_YTDAVG (used for VG (used for changes on BS changes on BS accts)accts)

 –

 –The actual difference must be The actual difference must be calculated by using a calculated by using a combination of Translate(combination of Translate() and Calculate()) and Calculate()

subroutines

(34)

Business Rules Consideration

Business Rules Consideration

 –

 –

Prove FX Effect on

Prove FX Effect on

Financing Activities

Financing Activities

Rules to Prove FX Effect (Plug for Financing Activities)

Rules to Prove FX

Effect (Plug for Financing Activities)

 –

 –FX effect on FX effect on financing activities cannot be calculated simply by financing activities cannot be calculated simply by using HS.Trans function in Translate()using HS.Trans function in Translate()

subroutine

subroutine to determine translation to determine translation difference between difference between EOM rate (used for BS accts) aEOM rate (used for BS accts) andnd

EOM_YTDA

EOM_YTDAVG (used for VG (used for changes on BS changes on BS accts)accts)

 –

 –The actual difference must be The actual difference must be calculated by using a calculated by using a combination of Translate(combination of Translate() and Calculate()) and Calculate()

subroutines

(35)

Process (Artifact) Consideration

Process (Artifact) Consideration

 –

 –

 Update St. of Cash Flow Data Form

 Update St. of Cash Flow Data Form

Data Form- St. of Cash Flows

Data Form- St. of Cash Flows

 –

(36)

Summary of Considerations

Summary of Considerations

 –

 –

 Metadata, Bus. Rules, Process(Artifacts)

 Metadata, Bus. Rules, Process(Artifacts)

M

METADATAETADATA •• Custom roll up for BS Roll ForwardsCustom roll up for BS Roll Forwards ••  Acct roll up for CH Balance Sheet Acct roll up for CH Balance Sheet

•• Custom roll up to calc. changes at EC, ELIM & PCCustom roll up to calc. changes at EC, ELIM & PC ••  Acct roll up of CFS reporting accts Acct roll up of CFS reporting accts

•• Custom roll up for CFS Calc. and InputCustom roll up for CFS Calc. and Input •• Custom roll up for BB_FX & ACT_FXCustom roll up for BB_FX & ACT_FX ••  Acct for EOM YTD AVG Acct for EOM YTD AVG

••  Acct for PR EOM Acct for PR EOM ••  Acct roll up for FX Proof Acct roll up for FX Proof

P

PROCESSROCESS (A (ARTIFACTSRTIFACTS))

B

BUSINESSUSINESS RULESRULES

•• Calc. Beg. Bal. on Balance Sheet accounts (for RF WDEFs)Calc. Beg. Bal. on Balance Sheet accounts (for RF WDEFs) •• Calc. Beg. And End. Balances on all Assets & Liabilities usingCalc. Beg. And End. Balances on all Assets & Liabilities using

proper signage for EC, ELIM & PC proper signage for EC, ELIM & PC

•• Calc. activity on all Assets & Liabilities for EC, ELIM & PCCalc. activity on all Assets & Liabilities for EC, ELIM & PC •• CFS “presCFS “presentatientation” accoon” account rulunt rules for EC, ELIM & PCes for EC, ELIM & PC •• Calc. YTD EOM AVG exchange rateCalc. YTD EOM AVG exchange rate

•• Calc. PR EOM exchange rateCalc. PR EOM exchange rate

•• TranslTranslate CFS “prate CFS “presentaesentation” ution” using EOsing EOM YTD AVGM YTD AVG •• Calc. Beg. And End. CashCalc. Beg. And End. Cash

•• Calc. Cash Proof and FX PlugCalc. Cash Proof and FX Plug

•• Calc. Proof on FX plug for Beginning CashCalc. Proof on FX plug for Beginning Cash •• Calc. Proof on FX plug for Operating ActivitiesCalc. Proof on FX plug for Operating Activities •• Calc. Proof on FX plug for Investing ActivitiesCalc. Proof on FX plug for Investing Activities •• Calc. Proof on FX plug for Financing ActivitiesCalc. Proof on FX plug for Financing Activities

•• Data Forms to collect roll forwards by locationData Forms to collect roll forwards by location •• Process Monitor Traffic Light reports by locationProcess Monitor Traffic Light reports by location

•• Data Grids to prove CH Balance Sheet = 0 for ECData Grids to prove CH Balance Sheet = 0 for EC , ELIM &, ELIM & PC

PC

•• Data ForData Form for CFS “Prm for CFS “Presentaesentation” ation” accounccountsts ••  Addition to CFS Data Form for FX Proof Addition to CFS Data Form for FX Proof

(37)

THANK YOU FOR YOUR TIME

THANK YOU FOR YOUR TIME

Please visit us online at

Please visit us online at www.emtecinc.com

www.emtecinc.com

Presenter Contact Information:

Presenter Contact Information:

Figure

Updating...

References

Updating...

Related subjects :