Financial Modelling (tutorial 1hr 19mins)

Description

In this tutorial we will cover:

• • Based on 6 subsidiaries and Holdings Company
  • Fully reconciled and formulated P&L, Balance Sheet and Cashflow ( individual entities and consolidated) - included historical and 2 years of projections
  • Covenants projection including statutory P& an proforma ( outside of statutory period) - interest cover, net debt / EBITDA , Net assets

 

• Quarterly summary with covenants testing for the current year
• Built in reconciliation to statutory accounts and proforma P&L
• FX rates conversion for foreign subsidiaries presentation  - by business and by key financial statements headings
• Gross Profit margins and operating profit margin summaries
• Fully formulated working capital assumptions and impact on cashflow
• Simplified acquisition  accounting template
• Interco loan summary and reconciliation
• Management recharges
• Loan withdrawals forecast and loan interest payments forecast
• Cal Option liability forecast
• IFRS 16 overlay