Building a Financial Model Institute of Chartered Accountants of Ireland
السعر: 503 درهم
  • مدة الدورة التدريبية: 5 Hours

تفاصيل الدورة

Every financial model is built on the same foundations: an understanding of its purpose, who it is for, and its scope. This course explains how to set up the Excel spreadsheet and complete the initial steps of building a financial model, structuring calculations, and looking into costs and revenues, time periods, cash balances and reporting.

This course will enable you to:

  • Set up and build a comprehensive financial model
  • Calculate costs and revenues
  • Decide which time periods you need to use and when and where to use flags
  • Create understandable and useful reports

Learning Outcomes

Setting up a Financial Model

  • Who uses a financial model?
  • How should I set up a financial model?
  • What are the MS Excel settings for financial model build?
  • What should be included in a template?
  • How should I incorporate FAST principles?

Costs and Revenues

  • What are the different ingredients required to calculate the operating costs?
  • What would the concept diagram look like?
  • How do I build a calculation that I can use to quickly model the operating costs?
  • What would be different in the calculation on the revenue?
  • How do I build a calculation to quickly model the revenue?

Time Periods

  • What time periods should I use?
  • What do I need to know about flags?
  • Which ingredients are required to calculate the forecast period flag?

Cash Balances

  • Why is the cash balance particularly important?
  • What is a “balance corkscrew”?
  • What should I know about interest?
  • How is interest calculated?

Reporting

  • What will the recipient want from the summary report?
  • Should I use the same rules for building output sheets?
تحديث بتاريخ 08 November, 2015

نبذة عن معهد Institute of Chartered Accountants of Ireland

Chartered Accountants Ireland (The Institute) is a membership body representing 23,000 influential members throughout the globe. their role is to educate, represent and support their members. their members work in senior positions in practice and industry. they are committed to restoring confidence at every level of the economy. they work with governments and businesses to raise awareness of the importance of sound financial advice.
Chartered Accountants Ireland was established as the Institute of Chartered Accountants in Ireland by Royal Charter in 1888. Its activities and those of its members are governed by its Bye-Laws and by Rules relating to professional and ethical conduct. These provisions are contained in the Handbook which is available to all members.
Chartered Accountants Ireland is governed by a Council and it is responsible for determining policy and monitoring its implementation. Council is lead by the Officer Group and supported by the Management Team and staff. A number of committees with voluntary member involvement also play a key role.
عرض الجميع دورات Institute of Chartered Accountants of Ireland
Are you from Institute of Chartered Accountants of Ireland ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Accounting ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

أو