Skip to main content
IFRS Academy

CERTYNEX IFRS ACADEMY

Search the Academy

Home
My learning path
Exercises & quizzes
Cases
Workpapers
Exams
My progress

Workpapers

Workpaper template

WorkpaperIAS 7 — Statement of Cash FlowsL1 · L2 · L3 · L4

Analysis of cash and cash equivalents

7 missions8 sections to document40 min
Prepared by
AI-assisted draft
Reviewed by
Not reviewed — human review required
Status
Published

Objective of the workpaper

From the bank statements and confirmations, the features of the investments and the overdraft agreements, qualify each balance (cash, cash equivalent, excluded investment, overdraft that is part of cash management or financing), determine closing cash and cash equivalents, compute the effect of exchange rate changes, reconcile opening and closing cash with the net change in the statement, identify balances that are not available for use and prepare the note on the components.

8 sections · 31 blocks · 4 calculations · 0 entries

  • IAS 7 §6
  • IAS 7 §7
  • IAS 7 §8
  • IAS 7 §9
  • IAS 7 §48
  • IAS 7 §49
  • IAS 7 §25
  • IAS 7 §26
  • IAS 7 §27
  • IAS 7 §28
  • IAS 7 §45
  • IAS 7 §46
  • IAS 7 §47
  • IAS 7 §50

Work this workpaper as a mission

Each case that uses this template opens in the mission workspace: data, analysis, calculation, entries, conclusion and review, with your progress saved.

7 instances from the cases: the calculations and entries below are run by the calculation engine.

File and entity
Investments, overdraft and cash trapped abroad: composition and reconciliation of cash
Case tasks documented here
  • Qualify each balance: cash, cash equivalent, excluded investment or financing.
  • Is the overdraft part of cash management? Are the subsidiary's balances available?
  • Determine the qualifying and excluded investments and closing cash.
  • Compute the effect of exchange rate changes on cash.
  • Reconcile opening and closing cash.
  • Prepare the note: components, reconciliation with the statement of financial position, policy, unavailable balances.
1

Inputs

Inputs
  • Balances examined at the reporting date (bank, nature, maturity when acquired, terms)

    TextRequired

    SOLVANNE_GROUP_BALANCES_31_DECEMBER_20X8

  • Cash on hand

    NumberRequired

    6,000

  • Demand deposits (including translated foreign currency accounts)

    NumberRequired

    842,000

  • Investments qualifying as cash equivalents

    Number

    420,000

    Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.

  • Investments excluded from cash equivalents

    Number

    430,000

  • Bank overdrafts repayable on demand that are part of cash management

    Number

    95,000

  • Other short-term bank borrowings (financing)

    Number

    200,000

  • Balances not available for use by the group (included in the components)

    Number

    210,000

  • Cash and cash equivalents at the beginning of the period (prior period statement)

    Number

    905,000

  • Net increase in cash per the statement

    Number

    236,000

  • Net decrease in cash per the statement

    Number

  • Foreign currency cash at the end of the period, translated at the closing rate

    Number

    210,000

  • Foreign currency cash at the beginning of the period, translated at the opening rate

    Number

    150,000

  • Foreign currency receipts translated at the rates at the dates of the cash flows

    Number

    28,000

    Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).

  • Foreign currency payments translated at the rates at the dates of the cash flows

    Number

2

Supporting evidence

Evidence
  • Evidence obtained and referenced (category, document reference)

    EvidenceRequired

3

Qualification of the balances

Analysis

IAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9

  • Points reviewed

    ChecklistRequired

    • Short-term, highly liquid investment, known amount, insignificant risk of changes in value
    • Maturity of three months or less from the date of acquisition
    • Equity investments excluded, unless cash equivalents in substance
    • Overdrafts repayable on demand that are part of cash management (fluctuating balance)
    • Movements between components: not cash flows
4

Composition, exchange effect and reconciliation

Calculations

IAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45

  • Closing cash and cash equivalents

    Calculation

    1,173,000

    Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management

  • Effect of exchange rate changes on cash

    Calculation

    32,000

    Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows

  • Closing cash rebuilt (opening + net change + exchange effect)

    Calculation

    1,173,000

    Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents

  • Difference: composition − rebuilt cash

    Calculation

    0

    Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents

5

Judgements on composition and availability

Judgment

IAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49

  • Qualification of the investment examined

    JudgmentRequired

    Cash equivalent

    Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument

  • Rationale: facts relied on, analysis, alternative rejected

    TextRequired

  • Bank overdraft

    JudgmentRequired

    Part of cash management: deducted from cash

    Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft

    Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).

  • Rationale: facts relied on, analysis, alternative rejected

    TextRequired

  • Balances not available for use by the group

    JudgmentRequired

    Significant: amount and management commentary

    Significant: amount and management commentary / Not significant / No balance unavailable

    Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).

  • Rationale: facts relied on, analysis, alternative rejected

    TextRequired

6

Disclosure

Disclosure

IAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50

  • Items of the note

    ChecklistRequired

    • Components of cash and cash equivalents
    • Reconciliation with the line items of the statement of financial position
    • Policy used to determine the composition (wording applicable from 2027)
    • Change in the composition policy dealt with under IAS 8
    • Significant balances not available, with management commentary
    • Encouraged disclosures (undrawn facilities…), not required
  • Draft note on cash

    Text

7

Conclusion

Conclusion
  • Cash finalised, reconciliation, unavailable balances and points submitted to the reviewer

    ConclusionRequired

8

Normative references

References
  • Paragraphs cited in this workpaper (verification status shown from the register)

    References

9

Checks and financial statement impact

  • Qualification documentedPass
  • Composition = rebuilt cashPass
Assets
0
Liabilities
0
Profit or loss
0
OCI
0
Equity
0