Accounting exercises

Download an exercise in Python or Excel

Each exercise includes the same accounting problem in 2 file types. The Python script installs its required packages when you run it. The Excel workbook shows the formula in each calculated cell. The worked example explains the facts and answers for both files.

Find an exercise

Format

37 exercises. 37 in Python, 37 in Excel, across 321 learning objectives.

  1. From transactions to financial statements

    One working-capital difference, three liquidity views

    Classify current balances, compute working capital and current ratios, trace a payable payment, and challenge metric only liquidity conclusions.

    Method
    Working-capital analysis
    Units
    USD; current ratios are unitless
    Objectives
    12 learning objectives
    Learning objectives for this exercise
  2. Accounting changes, error corrections, and comparative reconstruction

    Quantify Granite Harbor's accumulated accrual error two ways

    Trace four years of omitted accruals, compute rollover and iron curtain amounts, test a current catch up, and derive a balanced current ledger entry without deciding materiality.

    Method
    Accounting changes, estimate revisions, and error corrections
    Units
    US dollars
    Objectives
    23 learning objectives
    Learning objectives for this exercise
  3. Accounting changes, error corrections, and comparative reconstruction

    Reconstruct Cedar Trail's voluntary principle change

    Build a supported pre period opening equity effect and two comparative pretax, tax, after tax, and EPS bridges without treating retained earnings as a plug.

    Method
    Accounting changes, estimate revisions, and error corrections
    Units
    US dollars and shares
    Objectives
    23 learning objectives
    Learning objectives for this exercise
  4. Accounting changes, error corrections, and comparative reconstruction

    Separate Linden Peak's estimate revision from an error

    Use two evidence timelines and a prospective carrying amount schedule to show why identical revised inputs can have different reporting routes.

    Method
    Accounting changes, estimate revisions, and error corrections
    Units
    US dollars and annual periods
    Objectives
    9 learning objectives
    Learning objectives for this exercise
  5. Advanced statement of cash flows and liquidity controls

    Reconcile Cedar Trail's restricted cash and exchange-rate effect

    Build a multi location population, eliminate an internal transfer, derive the separate exchange rate effect, and evaluate release controls.

    Method
    Advanced statement of cash flows and liquidity controls
    Units
    US dollars
    Objectives
    7 learning objectives
    Learning objectives for this exercise
  6. Advanced statement of cash flows and liquidity controls

    Reconstruct Cedar Trail's direct and indirect operating cash flow

    Build gross operating classes and a cause coded indirect bridge that agree without a plug, then articulate them through the full cash population.

    Method
    Advanced statement of cash flows and liquidity controls
    Units
    US dollars
    Objectives
    7 learning objectives
    Learning objectives for this exercise
  7. Current liabilities, refinancing, and contingencies

    Route Cedar Trail's legal matters and debt classification

    Apply supplied condition, probability, range, refinancing, callable, and issuance facts while keeping proposed guidance, gains, and later conditions outside current recognition.

    Method
    Current liability, warranty, contingency, and debt classification analysis
    Units
    US dollars and calendar dates
    Objectives
    8 learning objectives
    Learning objectives for this exercise
  8. Debt issuance, effective interest, and extinguishment

    Control Cedar Trail's note patterns and early retirement

    Apply effective interest to a zero coupon note and a level payment note, separate between date interest from debt basis, and measure a supplied extinguishment without using face amount…

    Method
    Debt pricing, effective interest, and extinguishment
    Units
    US dollars and annual periods
    Objectives
    8 learning objectives
    Learning objectives for this exercise
  9. Debt issuance, effective interest, and extinguishment

    Price and roll forward Cedar Trail's bond issue

    Map a fixed rate bond's cash flows, price the issue, separate qualifying issuance costs, solve the cost adjusted effective yield, and carry the net liability to face without a final…

    Method
    Debt pricing, effective interest, and extinguishment
    Units
    US dollars and nominal annual rates with semiannual compounding
    Objectives
    8 learning objectives
    Learning objectives for this exercise
  10. Intangibles, R&D, software, and goodwill

    Reconcile Linden Peak's intangible, goodwill, and impairment close

    Defend finite and indefinite life, compute finite life amortization, build a supplied acquisition allocation, measure bounded impairment effects, and preserve the class rollforward.

    Method
    Intangible asset, software, goodwill, and impairment analysis
    Units
    US dollars and months
    Objectives
    11 learning objectives
    Learning objectives for this exercise
  11. Intangibles, R&D, software, and goodwill

    Route Linden Peak's research, internal software, hosting, and product costs

    Use purpose, scope, period, adoption status, activity, feasibility, and availability evidence to reconcile four different cost clocks without turning the project folder into one asset.

    Method
    Intangible asset, software, goodwill, and impairment analysis
    Units
    US dollars and calendar dates
    Objectives
    9 learning objectives
    Learning objectives for this exercise
  12. Inventory ownership, cost flow, and measurement

    Price Cedar Trail's layers, measurement adjustments, and inventory estimates

    Reconcile one dated unit stream under periodic and perpetual FIFO, average, and LIFO; apply the US GAAP measurement fork; estimate two missing balances; and trace an error across periods.

    Method
    Inventory cost flow and measurement
    Units
    Inventory units, US dollars, and decimal rates
    Objectives
    11 learning objectives
    Learning objectives for this exercise
  13. Lease identification, lessee, lessor, and sale-leaseback

    Keep the lessor's three reporting lanes separate

    Compare sales type commencement profit, direct financing deferred profit and residual support, and operating retained asset income with explicit net investment controls.

    Method
    Lease liability, ROU asset, net investment, and remeasurement
    Units
    US dollars and annual periods
    Objectives
    6 learning objectives
    Learning objectives for this exercise
  14. Pensions and other postretirement benefits

    Build Linden Peak's pension cost, OCI, AOCI, and employer entry

    Separate service cost, other periodic cost components, actual versus expected return, prior service cost, actuarial loss, reclassification, and funded status.

    Method
    Pension and other postretirement benefit accounting
    Units
    US dollars and one annual measurement period
    Objectives
    22 learning objectives
    Learning objectives for this exercise
  15. Pensions and other postretirement benefits

    Reconcile Cedar Trail's PBO, plan assets, and funded status

    Keep the obligation, trust assets, sponsor contribution, benefit payments, and recognized funded status liability on separate rails before joining them.

    Method
    Pension and other postretirement benefit accounting
    Units
    US dollars and one annual measurement period
    Objectives
    18 learning objectives
    Learning objectives for this exercise
  16. Professional extensions: derivatives, currency, combinations, consolidation, and digital reporting

    Reconcile Cedar Trail's full professional-extension bridge

    Carry the supplied hedge, currency, translation, acquisition, consolidation, and XBRL schedules through one controlled release file.

    Method
    Derivatives, foreign currency, combinations, consolidation, and XBRL bridge
    Units
    US dollars, foreign-currency units, and XBRL contexts as labeled
    Objectives
    2 learning objectives
    Learning objectives for this exercise
  17. Professional extensions: derivatives, currency, combinations, consolidation, and digital reporting

    Route a forecast-purchase hedge through AOCI and inventory

    A supplied cash flow hedge illustrates fair value recognition, current OCI, basis adjustment, and ending AOCI.

    Method
    Derivatives, foreign currency, combinations, consolidation, and XBRL bridge
    Units
    US dollars, foreign-currency units, and XBRL contexts as labeled
    Objectives
    2 learning objectives
    Learning objectives for this exercise
  18. Shareholders' equity, share-based compensation, and EPS

    Attribute Linden Peak's award cost and tax effects

    Separate equity and liability awards, graded vesting, market and performance conditions, incremental modification value, unrecognized cost, and deferred tax.

    Method
    Share-based award measurement, attribution, classification, and tax
    Units
    US dollars, award units, and fractions of requisite service
    Objectives
    11 learning objectives
    Learning objectives for this exercise
  19. Shareholders' equity, share-based compensation, and EPS

    Build Linden Peak's basic and diluted EPS

    Retroactively adjust a split, weight dated common shares, allocate earnings to a participating award, order potential common shares, and exclude antidilution.

    Method
    Basic and diluted earnings per share
    Units
    US dollars, shares, days, and dollars per share
    Objectives
    14 learning objectives
    Learning objectives for this exercise
  20. Shareholders' equity, share-based compensation, and EPS

    Close Cedar Trail's equity register and rollforward

    Reconcile authorization, issues, treasury share transactions, a two for one split, preferred and common dividends, and every shareholders' equity component.

    Method
    Share register, contributed capital, distributions, and equity rollforward
    Units
    US dollars, shares, and one annual reporting period
    Objectives
    17 learning objectives
    Learning objectives for this exercise
  21. Tangible asset acquisition, capitalization, and resource obligations

    Control Linden Peak's acquisition, bundle, and construction schedules

    Separate qualifying asset cost from period cost, allocate a bundled price, and apply dated expenditure weights and the actual interest ceiling to a self constructed asset.

    Method
    Capitalized asset cost and interest
    Units
    US dollars, decimal annual rates, and fractions of one calendar year
    Objectives
    12 learning objectives
    Learning objectives for this exercise
  22. Tangible asset acquisition, capitalization, and resource obligations

    Reconcile Linden Peak's resource, depletion, and retirement obligation

    Measure a stipulated legal retirement obligation, add the associated retirement cost to a resource asset, and reconcile current extraction between inventory and expense.

    Method
    Depletion and retirement obligation
    Units
    US dollars, resource units, years, probabilities, and a decimal annual rate
    Objectives
    8 learning objectives
    Learning objectives for this exercise