How to Build a Basic Financial Model in Excel finance modelling

by alsaCEMusic



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:
____________________________________________
► Basic Financial Model Download:

🚨 Join my Finance for Startups training program (with personalized support, livestreams, and more):

Join my Communities:
► Subscribe to my email newsletter:
► Discord:

My Excel Courses:
► Become an Excel Power User in 2.5 Hours (85% discount):
► Master Excel Keyboard Shortcuts (85% discount):

Related Financial Modeling Videos:
► How to Build a 3 Statement Financial Model:
► Solving a Finance Case Study | Interview Prep:
► Basic eCommerce Financial Model:
► Understand Cost Per Conversion Marketing:
____________________________________________

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:

#financialmodel #excel #financialmodelbeginners .

Images related to the topic finance modelling

How to Build a Basic Financial Model in Excel

How to Build a Basic Financial Model in Excel

Search related to the topic How to Build a Basic Financial Model in Excel

#Build #Basic #Financial #Model #Excel
How to Build a Basic Financial Model in Excel
finance modelling
You can see more ways to make money here: see more here
You can see more ways to make money here: see more here

Related Posts

40 comments

Eric Andrews 24/12/2021 - 5:58 Chiều

Looking to start a career in finance? Check out my new finance interview questions prep video for entry-level roles ► https://youtu.be/aVenjYqVses, with pdf study guide included!

Reply
Yearly Man 24/12/2021 - 5:58 Chiều

Dude you move WAY TO FAST! URGHHHHH

Reply
David Tulip 24/12/2021 - 5:58 Chiều

Great, clear video. I might actually get your Udemy course.

Reply
Ridwan Islam 24/12/2021 - 5:58 Chiều

Best one. Easy and simple. Thanks bro

Reply
Nsh G ahmed 24/12/2021 - 5:58 Chiều

You are great Eric. Love from Pakistan. I got so much from your videos

Reply
free juice 24/12/2021 - 5:58 Chiều

no wonder why everything is made in china lol

Reply
Eric Andrews 24/12/2021 - 5:58 Chiều

🚨 Who's interested in being a part of my Finance for Startups program? There will be limited space. Join the early-bird waitlist to get access before the general public here: https://bit.ly/finance_for_startups

Reply
Yusuf Pasha 24/12/2021 - 5:58 Chiều

very helpful, please make a video on buisness plan for any pvt ltd company

Reply
Pandurangan Satish 24/12/2021 - 5:58 Chiều

Hi Eric ,
Very useful, I looking to make one for a new start up, is there any extra items to be considered . Thanks in advance

Reply
Pandurangan Satish 24/12/2021 - 5:58 Chiều

Very nice , if startup what about machinery cost ?

Reply
Lâm Thị Thảo 24/12/2021 - 5:58 Chiều

Thank you so much!!!!

Reply
Andres Almonte 24/12/2021 - 5:58 Chiều

Great. Would love to see you build more. All the best

Reply
Jaynee Tolle 24/12/2021 - 5:58 Chiều

This is a great example of financial modeling and very easy to understand.

Reply
VanzyPub G? 24/12/2021 - 5:58 Chiều

This was pretty great. Pretty simple, but couldn't you have used an If statement for the tax expense? Bcz what if you're gonna go for more than 3 years? It's gonna at some point became kinda tedious having to manually check if your income is positive and then putting in a formula. Don't ya think .?

Reply
Shaun Diz 24/12/2021 - 5:58 Chiều

Bro how are you so fast? You're like an Excel wizard knowing all the keyboard shortcuts. It's pretty cool. Idk why I'm even looking this up. I'm just importing my yearly spending into excel but then was like "wonder what a financial model looks like in excel"

Reply
Raffy P 24/12/2021 - 5:58 Chiều

nice

Reply
Maria Lemon 24/12/2021 - 5:58 Chiều

Thanks for the video! 🙂 I am currently preparing for an interview for an entry position as a project financial analyst and it's really helpful

Reply
QTags 24/12/2021 - 5:58 Chiều

This video is still a banger in 2021!

Reply
Atul Kumar 24/12/2021 - 5:58 Chiều

Thanks

Reply
R Theos 24/12/2021 - 5:58 Chiều

U made a lawyer understand how these work!!!!!! Amazing!

Reply
Nitya Chaudhary 24/12/2021 - 5:58 Chiều

Amazing !!! Just wanted to know that is the concept and way same in india ?

Reply
suitcasedarling 24/12/2021 - 5:58 Chiều

I love this! Eric, what if there’s no inventory (dropshipping)? 🥴

Reply
Soma Ansa 24/12/2021 - 5:58 Chiều

Excellent! Thanks for sharing.

Reply
Dekass 24/12/2021 - 5:58 Chiều

You are the best!

Reply
ZKBeatz07 24/12/2021 - 5:58 Chiều

This channel is a gold mine… please don't stop making these videos my man!! you're bringing out so much value to the community and I hope you're going to be as successful as possible in what you're doing. Just finished my bachelor's degree in business administration here in Germany with a major in marketing and entrepreneurship and I want to start working / build my own company + support our family business. I came to the realisation that I've learned a lot about the theoretical stuff on marketing and product development and so on, but have a lack in financial knowledge – which is the key for starting a successful business. Even though I was good at accounting, I've forgot almost everything and don't want anything too complex to learn, I just want to understand the fundamental KPI's and their relationship and you're providing this simplicity in your videos!! also watched you video on digital marketing KPI's, awesome stuff man. Keep going, you're doing a great job!

Reply
Greetings Channel 24/12/2021 - 5:58 Chiều

Thanks much Eric!

Reply
Yau Michelle 24/12/2021 - 5:58 Chiều

Brilliant. I love your presentation, simple and easy to understand. Thank you so much. Eric.

Reply
Karolina Bielak 24/12/2021 - 5:58 Chiều

Fab vid, thank you so much

Reply
Erik Nelson 24/12/2021 - 5:58 Chiều

The dryer sure making a lot of noise in the background…. 🙂

Reply
Most Likely 24/12/2021 - 5:58 Chiều

Thank you Sir

Reply
Ryan Aument 24/12/2021 - 5:58 Chiều

Control + C, Alt+E+S+T if you want to copy formats without having to retype your numbers

Reply
Javier Martin P. 24/12/2021 - 5:58 Chiều

Very helpful and simple to understand

Reply
Alex Buskey 24/12/2021 - 5:58 Chiều

Great work on these! Do you plan on covering compound annual growth rate?

Reply
Patricia Aguilar Monge 24/12/2021 - 5:58 Chiều

THANK YOU! It took me forever to find a direct-to-the-point basic lesson on financial modeling

Reply
Benson Rwagi 24/12/2021 - 5:58 Chiều

Interesting tutorials. very helpful

Reply
John Watson, CPA 24/12/2021 - 5:58 Chiều

you are a neanderthal

Reply
Hagi OutnLoud 24/12/2021 - 5:58 Chiều

omgg, ur gonna save me, im having a test tmr ab thiss 😭😭😭😭

Reply
meteora8888 24/12/2021 - 5:58 Chiều

hmm…i wouldnt even call this a "model" to be honest unfortunately.

Reply
Seeking my life 24/12/2021 - 5:58 Chiều Reply
geniusfollower 24/12/2021 - 5:58 Chiều

Thank you so much for posting this simple and easy to understand guide. I have 12 hours to go for a case interview that suddenly needs financial modeling so this was a life saver.

Reply

Leave a Comment