Financial Modeling Tutorial
Originally published: 08/10/2020 06:42
Last version published: 19/10/2020 20:27
Publication number: ELQ-96856-3
View all versions & Certificate
certified

Financial Modeling Tutorial

Get the most out of Excel when building a financial model

Description
This three-module tutorial is meant for the Excel user who wants:
1. A deeper understanding of corporate finance
2. An understanding of Excel's financial functions
3. A best-practices tutorial on how to build a world-class financial model
4. A fully-functioning financial model incorporating all of the above

Module 1: Finance Overview
A corporate finance course in a single workbook.
Learn using in-workbook examples of:
• financial statements
• financial ratios
• forecasting
• stock & bond valuation
• cost of capital
• annuity functions

Module 2: Excel Tutorial
A best-practices guide to how to put Excel's tool to use to create a world-class financial model
In 5 steps, we guide you through the considerations:
• Determine your needs
• Structure the data
• Analyze the data
• Present the data
• Address the user

Module 3: Financial Model
A sample financial model using all the tools from Modules 1 and 2.
Worksheets include:
• 10-Q input sheet for company and 3 comps
• Business drivers input sheet for 3 fiscal years
• P&L, Balance Sheet, and Cash Flow Statements
• Financial Ratios & Analysis
• Debt schedule
• Summary tab presentation of the model's findings
...You can even customize the model to suit a business design of your own.

This Best Practice includes
1 zipped folder with 3 Excel files

Acquire business license for $119.00

Add to cart

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...