Financial Modeling Techniques

Financial modeling in Excel is extremely useful to forecast and make key business decisions for your company. Learn this career-boosting skill in this Excel financial modeling course online, through proven methodologies and tools to help you construct a financial model step by step. The training covers financial statement theory and how they link together, building on the best practices and Excel functions covered in the Financial Modeling Basics course. Examples are provided throughout so that you can apply the practical knowledge you learn through hands-on application in Excel.

Highlights:

• 59 practical tutorials.
• Understand the different financial statement types and their key line items.
• Link the three financial statements together and add them to the model.
• Recognize the importance control accounts play in balancing the model.
• How to add the checks worksheet system to keep your model error-free.
• How to model revenue and working capital adjustments.
• Highlight the differences between the four different input methods.
• How to input COGS, OPEX and CAPEX into the financial statement.
• Calculate the control account for debt and interest payable.
• How to calculate tax components including tax expense, depreciation and losses.
• How to calculate Net Operating Cashflow using the Indirect Cashflow method.

Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.