support@edupristine.com1800 200 5835Request a Call
Call Me

## Start learning Financial Modeling in 10 Easy Steps

Unlike most of the other businesses, all finance professionals have to continuously work with large amount of numbers. Almost everyone uses MS Excel to create financial models to analyse and project financial statements. A mastery over financial modeling will give all the professionals an edge over others as they can do their work faster and with more accuracy.

Number crunching is one the most important aspects of any job in the world of finance. Unlike other businesses, professionals in the finance industry have to work with large amounts of numbers. There is thus a need for people who have a good knowledge of MS Excel to create financial projections, analyze competition and markets and make financial models.

A mastery over Excel is actually a way to excel in the finance world, as it ensures accuracy, speed and can give you that edge over your peers. The EduPristine Financial Modeling course will teach you the basic of MS Excel all the way to creating successful Financial Models. By the end of the course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

## Start your free tutorial now!

Chapter

1

### Financial Modeling for Facebook Valuation

Learn the art of financial modeling. Creating the models and making them open source is a general process followed, so here we will discuss the step by step procedure to be followed for creating the Facebook financial model and review the financial value.

Chapter

2

### Modeling the Historical Profit and Loss of Facebook

Understand the process of getting profit and loss data from the S1 Filing. After getting the data, you can easily proceed with creating the model.

Chapter

3

### Balance Sheet

Learn about the base rule and the process of creating the balance sheet.

Chapter

4

### Cash Flow Statement

Cash Flow Statement is the only true statement in all the financial statements. It speaks about the real cash which flowed in and out. Start creating and understanding the cash flow statements.

Chapter

5

### Modeling balance sheet differences as cash

Create balance sheet and understand how changes in the sheet can be used to estimate the amount of cash consumed/ released from the business.

Chapter

6

### Cash as Balancing Figure

Implement the basic knowledge now and find the real cash at the end of the year and ensure that it balances with the cash on the balance sheet.

Chapter

7

### Drivers and assumptions

Start modeling the historical drivers of the business and project the future based on past performance & growth of the company & analysts view about the company and overall economy’s condition.

Chapter

8

### Projecting the statement

Create the models for Profit/Loss, Balance Sheet and Cash Flow Statement of Facebook. Once we have the projected future and the cash, it will be easy to estimate the value that the organization will have!

Chapter

9

### Ratio Analysis

Understand the Performance Measurement part of the model. Start performing Ratio Analysis to see what has happened and what could happen in future!

Chapter

10

### Valuation

Analyse and check how much money something should be exchanged for today by considering future benefits.

##### Disclaimer

GARP does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine of GARP Exam related information, nor does it endorse any pass rates that may be claimed by the Exam Prep Provider. Further, GARP is not responsible for any fees or costs paid by the user to EduPristine nor is GARP responsible for any fees or costs of any person or entity providing any services to EduPristine. ERP®, FRM®, GARP® and Global Association of Risk Professionals™ are trademarks owned by the Global Association of Risk Professionals, Inc.

CFA® Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA® Institute, CFA® Program, CFA® Institute Investment Foundations and Chartered Financial Analyst® are trademarks owned by CFA® Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.