Location

Community Services & Continuing Education - Cairo

Objectives

• Financial modeling plays an essential role in business decision making, as designers communicate key transactions and critical business decisions

Outcomes

This course explains the basic principles of financial modeling and uses the Excel program to perform modern and creative techniques for modeling. Real-world case studies, individual workshops and group presentations by participants

Course Contents

Building a financial model• main section in each form • front end • cover page • executive summary • headers and footers • entries and assumptions • assumptions documentation methods • custom formatting • data validation revenue• Build Engine• Scenarios • Scenarios • Sensitivities and what-if analysis • Building scenarios (model application)• Revenue schedule • Revenue schedule preparation • Revenue schedule completionCost of Goods Sold (COGS)• All different types of costs • Operating costs • Cost schedule • Operating leverage • Semi-variable costs• Repeat, build and link approachesDepreciation in Financial Modelling• Why we need a depreciation schedule? • Forecasting a company’s depreciation expense • Building the Depreciation Schedule • Capex with HLOOKUP • Automating HLOOKUP • Capex with SUMIF • Capex with TRANSPOSE • Depreciation Schedule Waterfall • Fully Depreciating Assets • Declining Balance Method • Including PP&E: Converting depreciation schedule into a Fixed Assets Schedu