How to make a Pro Forma Balance Sheet with Excel
Вставка
- Опубліковано 24 лип 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 Balance Sheet from scratch. A Pro Forma Balance Sheet is basically just an estimated Balance Statement.
Learn the components that go into assets, liabilities, and equity. Things like accounts receivable, cash, depreciation, wages payable, interest payable, retained earnings, etc. are explained in depth.
This tutorial will also help you understand how to read and understand how Balance Sheet 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.
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.
Looks like I need to renew my Microsoft Office!
Are you open to being contacted directly (email) and if so what is the best way for me t o get in touch with ... I have been asked to set up a Proforma and would like to discuss my specific needs.
@@faqmd2532 If you go to the about page of my channel, scroll down to details and you can find this channels email
@@CalonHeindel I did send you an email the other day ... looking forward to your response.
@@faqmd2532 Just sent you one back. Let me know how I can help
Makes sense. Your numbers all add up. Thanks!
Thanks for double checking my work lol
This is great. Thank you
Appreciate the support!
thanks alot man
Glad you found this video helpful
I was about to fall asleep during your video until you got to the part about how to determine cash. I have been wrestling with that for a business plan I'm writing. Your explanation was really helpful, and I'm glad I was able to stay awake to watch it. Thanks for your really helpful video.
Haha not the most exciting stuff, but glad this video could help.
It's extremely bad practice to put in hard coded numbers like that, please don't take advice from this video for your real business plan (not to mention that this guy doesn't even know how to copy-paste values w/ CTRL+C and Alt+H+V+V but did each month independently lol).
You want to build a cash flow statement to properly link the income statement and balance sheet item changes to cash balances. If you don't know what this means, contact a financial advisor.
@@mrroo9658 I don't need your advice dude. I've already finished the business plan months ago and was paid well for my work.
Omg, it was hell but I did it… big thanks
how about statement of cashflow vid follow on? also would like to see a little more build out on the capital structure (debt, paid in capital, maybe multiple equity holders, etc.)
Thanks for the feedback! Hopefully I can get a cash flow video out for everyone soon. Also, provide another balance sheet video with more detail on the items you mentioned
I love you so much
Haha thanks!
Do you have a video or recommend one on business projections? Thank you!
What sort of business projections are you looking for? Profit growth? Sales forecasts?
This is super cool 😎 👌
Haha glad you thought so!
@@CalonHeindel 😊
Any chance you could make a cash flow statement? Please?? To tie the income and balance sheet together.
I have had a few requests on this. Hopefully I can get a cash flow video out there for everyone soon
Why is the Paid in Capital zero?
Paid-in Capital is the amount shareholders have given in turn for stock in the company. In this example we assumed this wouldn't apply, just to keep it simple
What if there is no inventory?
This pro forma is more going through a product business. If you are looking for a service business pro forma this still has similarities. You would simply not record any inventory to answer your specific question
what if the business bought a machine worth 800k and then it'll last for about 3-5 yrs, how do you deal with this thing?
To show the full depreciation you would have to extend the model from 12months to 3-5 years. Essentially it would be $22,222 each month if its useful life was 3 years.
@@CalonHeindel will it be in a different account title, not in PP&E but in "Machinery"? and then I'll not gonna be depreciating the PP&E and just the same value every month only the Machinery, did I understood it right?
@@luvwo.o9334 You can still put this under PP&E if you want. Then from the time you bought it, that value will be carried out. Accumulated depreciation needs to reflect that "machinery" because it needs to be depreciated. Make sense?
@@CalonHeindel yes, thank u so much!!
@@luvwo.o9334 No Problem!
Your Rent payment doesn't make sense. If it is 1K a month why did you compound them to be 78K for the year? Same on the A/R, if 5 day turn then you should be able to have 5/6 of the payments for the month but that doesn't add up
Nevermind, saw it fixed later. Thanks
@@westleybrin7055 Was your question answered completely?
You don’t have cash flow sheets???😂😂😂