How to Build a Basic Financial Model in Excel

Share this & earn $10
Eric Andrews
Published at : 10 Nov 2020
460476 views
5816
144

Here is a quick lesson on how to build a basic financial model in Excel. In this financial modeling video, we focus on the P&L, or income statement.

RESOURCES & LINKS:
____________________________________________
My Courses:
► Become an Excel Power User in 2.5 Hours (81% discount): http://bit.ly/pwrusr10-20
► Master Excel Keyboard Shortcuts (85% discount): http://bit.ly/shrtcts10-20

Related Financial Modeling Videos:
► How to Build a 3 Statement Financial Model: https://youtu.be/xlXDZyZ9azk
► Discounted Cash Flow Model: https://youtu.be/Gm0Xn_MidZ8
► Demystifying the Cash Flow Statement: https://youtu.be/BS6_RsuqzwE
► Sensitivity Analysis in Excel: https://youtu.be/N924D6tGOG8

► Subscribe for more finance videos: https://bit.ly/EricAndrewsSubscribe
____________________________________________

In this tutorial, we learn how to build a basic financial model, specifically an income statement for a simple furniture company.

I created this video as a financial modeling guide & template for beginners. All financial modeling follows the same process - whether the model is complex or simple, so if you can understand the construction of this model, you can learn to build more complex financial models as well.

STEP 1: DEVELOP ASSUMPTIONS
First, you establish assumptions. In this case, we develop the assumptions for our revenue model (price, units sold, etc), and then the assumptions around the costs & expenses.

STEP 2: BUILD THE MODEL & FORMULAS
Once we've built the assumptions, we need to calculate the results (the total revenues, expenses, etc). This requires us to create formulas that multiply the assumptions and add / subtract different pieces of the model so we can calculate metrics like gross profit, net income, etc.

DON'T FORGET: FORMATTING!
One important piece which we do throughout the process of financial modeling is formatting. Some formats are standard across business, and so are good practice to follow (things like color coding). Other formats just make the model easier to scan and review (like dollar signs, decimal places, etc).

By the end of this video, you should have a good understanding of the financial modeling process in Excel, whether it is a basic model or a more advanced one.

I hope this content is valuable - please take a look at my other videos / courses (above) if you want to keep learning about Excel and finance.

► Subscribe for more finance videos: https://bit.ly/EricAndrewsSubscribe
Financial ModelingFinancial Model Excel ExampleFinancial Model Excel Youtube

Eutectic TeroDyn 2000 Thermal Spray Equipment, Mount & First Use

Eutectic TeroDyn 2000 Thermal Spray Equipment, Mount & First Use

A diferença entre: I prefer x I'd rather

A diferença entre: I prefer x I'd rather

The Illusion Only Some Can See

The Illusion Only Some Can See

Drivers that struck & killed three teen pedestrians 'appeared to be racing,' according to witness

Drivers that struck & killed three teen pedestrians 'appeared to be racing,' according to witness

Diploma Final year Result 2020 | Diploma Final Semester Result 2020

Diploma Final year Result 2020 | Diploma Final Semester Result 2020

3 Facebook Ad Metrics To FIX If Your Ads Are Failing!

3 Facebook Ad Metrics To FIX If Your Ads Are Failing!

[ 500th VIDEO ] Until Dawn [P1] - IT WILL BE SIGNIFICANT!

[ 500th VIDEO ] Until Dawn [P1] - IT WILL BE SIGNIFICANT!

Which Power Source Is Most Efficient?

Which Power Source Is Most Efficient?

The Love We Had (Stays On My Mind)

The Love We Had (Stays On My Mind)

Keak Da Sneak ft. Prodigy & The Alchemist - That Go

Keak Da Sneak ft. Prodigy & The Alchemist - That Go

Guns n' Roses - You Could Be Mine.  Клип Terminator 2  SkyNet

Guns n' Roses - You Could Be Mine. Клип Terminator 2 SkyNet

What Was the Council of Fifty?

What Was the Council of Fifty?

The Kulture Study: K/DA 'MORE' (ft. Madison Beer, GI DLE, Lexie Liu, Jaira Burns, Seraphine)

The Kulture Study: K/DA 'MORE' (ft. Madison Beer, GI DLE, Lexie Liu, Jaira Burns, Seraphine)

TikTok Glow Up Compilation that makes my Jaw drop

TikTok Glow Up Compilation that makes my Jaw drop

تعريف و شرح مفصل للباك تراك 5 (BackTrack 5)

تعريف و شرح مفصل للباك تراك 5 (BackTrack 5)

The Penalty Kick that Defied Physics

The Penalty Kick that Defied Physics

HOW MEN TEST YOU TO SEE HOW THEY'RE GOING TO TREAT YOU: (TEACHING YALL THE GAME)

HOW MEN TEST YOU TO SEE HOW THEY'RE GOING TO TREAT YOU: (TEACHING YALL THE GAME)

Red Table Talk: Ellen Pompeo Opens Up About Raising Biracial Children

Red Table Talk: Ellen Pompeo Opens Up About Raising Biracial Children

Cat Dealers & JRDN - Like It (Original Mix)

Cat Dealers & JRDN - Like It (Original Mix)

Most Popular TV Series 1986 - 2019

Most Popular TV Series 1986 - 2019

Meaning Of Adolescence (1953)

Meaning Of Adolescence (1953)

Chris Brown - Look At Me Now (Clean Version) ft. Lil Wayne, Busta Rhymes

Chris Brown - Look At Me Now (Clean Version) ft. Lil Wayne, Busta Rhymes

Why You Need A Home Based Business... No You Don't.

Why You Need A Home Based Business... No You Don't.

Let GOD Make Your Enemies Your Footstool And Focus On The Finish

Let GOD Make Your Enemies Your Footstool And Focus On The Finish

Now's the Time by Charlie Parker/arr. Paul Murtha

Now's the Time by Charlie Parker/arr. Paul Murtha

TrueJS 19. Метод reduce и reduceRight

TrueJS 19. Метод reduce и reduceRight

John Coltrane - Resolution

John Coltrane - Resolution

Selena Gomez // Her Story

Selena Gomez // Her Story

Simon Morin - Come With Me Now (Cover Kongos)

Simon Morin - Come With Me Now (Cover Kongos)

[KPOP IN PUBLIC PARIS] JENNIE - SOLO Dance cover

[KPOP IN PUBLIC PARIS] JENNIE - SOLO Dance cover

Joel Klatt's new Top 10: Georgia ahead of Cincinnati | Breaking the Huddle w/Joel Klatt | CFB ON FOX

Joel Klatt's new Top 10: Georgia ahead of Cincinnati | Breaking the Huddle w/Joel Klatt | CFB ON FOX

Enrique Iglesias - Ring my bells (v. 3.0, HD)

Enrique Iglesias - Ring my bells (v. 3.0, HD)

A DAUNTING SEPTEMBER TBR!

A DAUNTING SEPTEMBER TBR!

Now THAT'S VARIETY! | Britain's Got Talent

Now THAT'S VARIETY! | Britain's Got Talent

How to Get in to BC ~ My Transfer Experience ~ Transferring Mid-Year

How to Get in to BC ~ My Transfer Experience ~ Transferring Mid-Year

Understanding Business Revenue

Understanding Business Revenue

Allmo$t performs "Miracle Nights" LIVE on Wish 107.5 Bus

Allmo$t performs "Miracle Nights" LIVE on Wish 107.5 Bus

Why Mexican President Won't Yet Congratulate Biden

Why Mexican President Won't Yet Congratulate Biden

Everything You Want to Know About Modern Monetary Theory

Everything You Want to Know About Modern Monetary Theory

Top 9 Best Drawing Tablets 2020

Top 9 Best Drawing Tablets 2020

The anaesthetic which is administered by unjection is

The anaesthetic which is administered by unjection is

Ava Max - Anyone But You (Lyrics)

Ava Max - Anyone But You (Lyrics)

Issues - King Of Amarillo (Official Lyric Video)

Issues - King Of Amarillo (Official Lyric Video)

Goals and Objectives - Identifying the Difference

Goals and Objectives - Identifying the Difference

2 NOOBS TRY TO BREAK INTO WORLDS SAFEST LEGO HOUSE!

2 NOOBS TRY TO BREAK INTO WORLDS SAFEST LEGO HOUSE!

The Double Kill Part 2 - Pinks Revenge | (Among Us Comic Dub)

The Double Kill Part 2 - Pinks Revenge | (Among Us Comic Dub)

how i take notes & essentials: math (+study with me)

how i take notes & essentials: math (+study with me)

Friendship | Finally

Friendship | Finally

Destroyed Phone Restoration - Restore Samsung Galaxy A50 Cracked | Rebuild Broken Phone

Destroyed Phone Restoration - Restore Samsung Galaxy A50 Cracked | Rebuild Broken Phone