How to make a Pro Forma Income Statement with Excel
Вставка
- Опубліковано 19 лип 2024
- Excel Templates: calonheindel.etsy.com/
Start a Print On Demand Etsy Store with Printful:
www.printful.com/a/8269674:5b...
Looking to make money as a freelancer? Sign up and use Fiverr:
go.fiverr.com/visit/?bta=7370...
Standing Desk:
amzn.to/3AOe32H
Book that changed my life:
amzn.to/3Q4peME
Great book on business:
amzn.to/48QOs9U
Royalty Free Music:
share.epidemicsound.com/64td0d
Learn how to make a Pro Forma Income Statement from scratch. A Pro Forma Income Statement is basically just an estimated Income Statement. Learn what assumptions are needed in order to estimate future or possible revenues, costs, expenses, profit, net income, etc.
This tutorial will also help you understand how to read and understand how income statements work. These are extremely valuable skills to have in the business world, no matter the profession. Pro Formas can be used for existing businesses or new entrepreneurial ventures.
This video even shows how to properly calculate sales tax on a particular product, which is commonly miscalculated.
Disclaimer & Full Disclosure: We are a a participant in the Amazon Associates Program, So If you purchase something from our affiliate links will get a small commission with no extra cost to you. This makes it possible for us to keep producing VIDEOS!
°We NEVER collect, store, use, or have access to any data about you.
I talk a little slow. Speed up to 1.5X speed!
Great video Calon! I've been trying to put together a pro forma for bringing on a new Physician for an ASC (Ambulatory Surgery Center).
You saved my life! SO knowledgeable I love how you get to the point and make it simple. New subscriber!
Appreciate the kind words. Thanks for subscribing!
THANK YOU SO MUCH. It took me 2 days to get through this 25 min video but I did it
Haha it’s a lot of information. Nice work! Glad this video was helpful.
Haven’t performed excel in 20 years.. now off to balance sheets
You explain this better than my teachers
Glad this is easy to follow along to!
I had to submit a Proforma Income Statement for a class and this SAVED ME! thank you so much. I learned a lot about formulas and the statement itself
Glad this video could help! Haha UA-cam academy!
Thank you for starting from scratching and breaking it all the way down. Super helpful!
Glad I could help. Thanks for the support!
Thank You so much for providing this video. I had no idea how to create this form and your video was very easy to follow and very thorough. I will be checking out more of your videos! 😊
Appreciate the support! Thanks!
literally a lifesaver - I'm working on a project and this video was so helpful. Thank you so much!
Love to hear that. Glad this was helpful!
Thank you! I need to make a few adjustments to this because i am not a sock salesman. But this is a great START!!
Hahaha fair enough! Thanks for the watch!
@@CalonHeindel Can you help with making some adjustments to my current Pro Forma?
This really helps me understand how to read income statements better
They can be confusing, glad me could help.
Thank you! I needed this for a college assignment
Glad this could help!
I love you to the nth level. you saved my 2nd year college life !!!!
Love to hear that! Thanks for the comment!
So I glad I found this video, thanks for the help!
Happy to Help!
Working through problem sets for class there seems to be so many variations difficult to keep straight. Your approach is very helpful.
Thank you! Its a lot to take in and understand, but hopefully this helped you out.
I sincerely appreciate the video
Glad this video was helpful. I appreciate it!
This was a very helpful and interesting video. I was able to follow along and create my own pro forma income statement with excel. I look forward to watching and learning from your other videos. Thanks for sharing your knowledge with this gen Xer trying to learn new stuff!
Glad this was helpful! Love to hear it!
This made doing my cost structure very easy! Thank you
Happy to hear that!
Wow! You are superb and really made simple. Very easy and clear to understand. Thanks so much
Thanks for the feedback, appreciate it!
Excellent, thanks and the speed was perfect for me.
Glad to hear that! Thanks for watching!
Hey Calon, Thank you so much this video. I definitely have liked and subscribed!
That’s awesome appreciate the support!
Thank you! Helped so much!
Glad to hear that!
Love this! Thank you!!
Really really good!! I never comment but WOW! thanks for the help.
Glad to hear that! Thanks!
Very well detailed and easy to follow along!
Thank you!
Thank you! That was very helpful
Glad this video could help!
Super helpful and well done. Thank you!
Thanks!
Very helpful! Thank you!
Thanks for the support!
Thank you very much. Really understood everything. very very helpful, for a first time business woman like me.Thanks!!
Glad you found this helpful!
Thank you. Very helpful.
Glad this was helpful for you!
Great video! Why are there so many video out there that explain tax calculation incorrectly. Why does your method of tax calculation work?
Great question! The answer to that can be a little confusing. Simply put the dollars collected already have sales tax calculated into what was paid. So the tax isn’t calculated off the money you received after the fact. Hopefully that makes a little sense
This was GREAT! Thank you!
Glad this was helpful!
Explained at a good pace.
Thank you!
Protip - F4 will let you cycle through the various cell reference locking options so you don't have to click around and manually add the $
Great callout!
sweet tutorial. thanks!
Thanks appreciate the feedback!
Awesome!! Thank you!
Appreciate the support!
hey calon thank you so much!!
Glad this was helpful!
Awesome this channel is super helpful
Glad to hear that!
Thanks for the video! Do I need to do this calculation for every single product or can I just estimate it based on product categories (when there are many products)
Thank you! This has been extremely helpful!! I need to create 3 years of Pro Forma statements so I initially did it on 3 separate sheets, would it be better to just drag 1 sheet out for 36 months? Also, if we have an initial loan amount of $250,000 in long-term debt, how do I account for it being paid off over the three years (which would lessen the available cash, right?)
Yeah you can adjust it to fit 36 months. They are pro-formas so whatever makes the most sense for you.
Lots of good information here
Thank you!
This is perfect
Thanks!
Nice one... Hope you will cover more similar contents
Appreciate the support! New videos at least once a week
Very helpful 👍
Thanks for the feedback!
"I hope you are still here." Me: "yes, I have to!" 😅
Hahaha not the most exciting topic! Glad you could watch till the end.
@@CalonHeindel I think this stuff is relaxing and satisfying as long as I'm doing it right.
Hello, i'm not seeing the other tutorial on making a pro forma balance sheet! Have you removed it? That's a helpful video too.
Hello, Yes I am re creating that video. Looking back I saw one small error. I will hopefully upload that this week. I want to make sure the video is fully accurate.
Great video - I thoroughly enjoyed it and was engaged. The audio, however, could use improvement. I had the volume all the way up and it was still a little hard to hear. Thanks for sharing.
Thanks for the support! Yeah unfortunately the audio wasn’t great with my videos early on. The audio has definitely been improved since then
Great video!
Thanks! Glad you enjoyed it!
This video is very help full to understood the financial statement awareness!!! So, can we Provide (submitted) to the other companies to calculate there financial performance as an Accountant????
Well this isn’t financial advise. You wouldn’t be able to submit this officially without a license to do so.
@@CalonHeindel Greeting from Tigistu, from Addis Ababa, Ethiopia.... I asked a question yesterday, but with a license Can I offer to them ''This video is very help full to understood the financial statement awareness!!! So, can we Provide (submitted) to the other companies to calculate there financial performance as an Accountant????""
Thanks for this detailed video. Is there a way to convert it into a 2 year projection after getting the 12 month projection ready?
Yes you can keep copying the formulas over (horizontally) to add more months
🤩
Where does your variable information come from? How did you decide the estimated units of 1000 for product 1?
This was just a rough estimate. There are lots of different ways to create forecast or predict demand. This video more covers the basics of a pro forma income statement rather than go into depth on forecasting. In the future I hope to provide videos specifically for forecasting.
How do you account for one time costs in a pro forma?
The only issue I'm having is seeing what you type in for math part and locking. Anyway you could sent what you type in sir and thank you for your video
Amazing video! Extremely helpful. Is there a way I can get a 10 minute call with you and I will pay you for your time of course? I need some directions because I have started a new unique business and it’s too much to put into text. Please let me know if you have a moment. Thank you.
Appreciate the feedback! Send me an email found at this Channel's about page. Just provide a little more detail and I would love to help out the best I can.
I need to create a Pro Forma Balance sheet for a startup business but it has to have three years. Can I use what you have shown here to do so? Its for an Entrepreneurship class I have to take.
Yeah you should be able to
is the 200k net income how much you make every 12 months?
Great question! Yes so the $200k is how much the business has made in net income total over those 12 months