Advanced modelling week (digital) – 上級財務モデリングスキル強化ウィーク(デジタル開催)

Forvis Mazarsでは、APAC地域のクライアント向けに、上級財務モデリングのスキルを強化するための特別な1週間のプログラムを開催いたします。

4つの独立したデジタル・モデリングワークショップから構成されており、目的や習熟度に応じて自由に選択いただけます。
各3時間のセッションでは、主要な財務ストラクチャリングの概念や、その実務的な活用方法について理解を深めることを目的として設計されています。財務モデルおよび関連トランザクションでの実践に直結するスキル向上を支援します。

*本プログラムは英語のみでの開催となります。

Session 1:  Master financial modelling of shareholder loans and cash sweeps

2 February, 11:00 - 14:00 JST

  • Expand your modelling toolkit with shareholder loans during the construction phase and learn how to update financial statements and calculations for project and equity returns
  • Explore cash sweep calculation to forecast interest and principal repayment to give you the ability to fully evaluate downside scenarios for credit
  • Learn about topics around shareholder loans, including withholding tax, thin capitalisation rules, and structures to avoid trapped cash

Session 2: Expand debt modelling with Mezzanine and Subordinated loans

3 February, 11:00 - 14:00 JST

  • For a full toolbox in debt modelling, you need to master mezzanine and subordinated loans, and the associated flow on impact to financial statements and returns calculations
  • Learn how to analyse credit ratios with both sculpted and cash sweep repayment
  •  Explore how and when subordinated facilities may be required and how to add multiple tranches to reflect varying levels of repayment priorities

Session 3: Manage multiple currencies with robust FX modelling

4 February, 11:00 - 14:00 JST

  • Understand how to manage cashflows in different currencies, like construction, revenue, and debt with dynamic financial modelling techniques
  • Learn how to update the financial model to consider foreign exchange for both construction spend and drawn debt, with relevant flow on impact to financial statements
  • Develop an understanding relating to the impact of periodic movements in exchange rates to the balance sheet through the translation reserve account

Session 4: Analyse annual dividend calculations in a monthly / quarterly model

5 February, 11:00 - 14:00 JST

  • Learn how to analyse and structure annual metrics, in a monthly or quarterly model
  • Applications demonstrated for trailing and forward looking DSCR, in addition to the Debt to EBITDA ratio
  • Examples of how to structure the model for annual release of cash to equity based on (annual) terms
  • Discussion around net asset test as an additional sizing mechanism to calculate cash distributions