Financial Modelling
by Tony de Jonker
Introduction
Excel is used by many finance professionals such as accountants, controllers and analysts to prepare a diversity of financial reports. Such reports include the Balance Sheet, the Profit & Loss Statement and the Cash Flow Forecast. They must be reported in a specific prescribed fashion as dictated by management and / or by law which prevent the use of PivotTables as a report layout.
Data is normally stored in an Enterprise Resource Planning (ERP) system (a book-keeping system, say) to record the historical details. Descriptions such as “budget” and “forecast” are future-oriented data and are usually administered at an aggregated level. Typically, the budget is set at the beginning of the year ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access