Тёмный

How to make financial projections for a business plan using Excel by Paul Borosky, MBA. 

Quality Business Consultant by Paul Borosky, MBA
Подписаться 9 тыс.
Просмотров 88 тыс.
50% 1

Quality Business Plan's business plan writer offers a tutorial to show how to create a 12 month profit/loss statement and financial projection for a business plan in Excel using daily sales and monthly expenses. Great for start up businesses.
For part 2 of the series, 5 year annual projections, click the link below.
• How to make financial ...
To purchase a completed Financial Projection Template in Excel, follow the link below:
qualitybusines...
For more help with a business plan, check out my new book: How to write a business plan in ten steps.
www.amazon.com...
Author of: Complete Small Business Guide to Fund Raising in 2019
www.amazon.com...
qualitybusines...
------Other Videos about Financial Projections------
Why Quality Business Plan has Industry leading ProForma Financial Projections?
• Financial Projections ...
How to create financial projections for a business plan: Part 1
• How to make financial ...
How to create financial projections for a business plan: Part 2
• How to make financial ...
How to create financial projections for a business plan: Part 3
• How to make financial ...
Basic Financial Projections by Paul Borosky, MBA.
• Basic Financial Projec...
Advanced Financial Projections by Paul Borosky, MBA.
• Advanced Financial Pro...
Complete Proforma Financial Projections by Paul Borosky, MBA.
• Complete Financial Pro...
#financialstatements #excel #proforma

Опубликовано:

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 215   
@shuclasenceneba6838
@shuclasenceneba6838 Год назад
Saved my life. Can't believe I just finished my plan in no time. Thank you very much!
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Most excellent!
@chisom8970
@chisom8970 2 года назад
Paul, I just want to thank you! I have been having trouble creating my financial projections, and this video helped my tremendously. May God continue to bless you!
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thank you!! Best of luck!
@boilkingshorts6517
@boilkingshorts6517 2 года назад
Took the words right out of my mouth !! 👏🏾
@michelleslater1408
@michelleslater1408 Месяц назад
This is very simple. Its not a little tutorial it's an easily explained and made simple tutorial. Thank you
@QualityBusinessConsultant
@QualityBusinessConsultant Месяц назад
Glad it was helpful!
@boilkingshorts6517
@boilkingshorts6517 2 года назад
I’ve been struggling for months with financial projections and I was looking for so many videos till I came across yours I’m literally smiling ear to ear! God bless thank you so much !!! 🙏🏾🙏🏾
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Glad it was helpful!
@danielleadepoju1226
@danielleadepoju1226 3 года назад
This was awesome!! I tried so many videos and I just completed my financial in under an hour. You are very thorough and straight to the point!! I especially love at the end where we highlighted the changeable data!! 👌🏾
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Wonderful!
@rosasebili6738
@rosasebili6738 3 месяца назад
I am so much in love with this video. Thumbs up Sir
@QualityBusinessConsultant
@QualityBusinessConsultant 3 месяца назад
Thank you!!
@sylveriachukwuma7227
@sylveriachukwuma7227 Год назад
Thanks for this. You simplified financial projection . I have watched many videos on financial projection but yours is exceptional, I am already feeling like a pro with this simplified video of yours
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Glad it was helpful!
@sandracicek
@sandracicek 4 года назад
Thank Paul - you are a genius. Your manner of explaining is so simple and I followed your tutor step by step - I now have a Profit and Loss Account and I know exactly what figures from from where. Excellent! I will certainly sign up with you! Excellent!!!!!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Love it! Glad I could help.
@FinanceHubb_
@FinanceHubb_ 3 года назад
Made it so simple what a man
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Sweet!
@vinaynagaonkar8592
@vinaynagaonkar8592 3 года назад
Wonderful and So swiftly it is done, I am loving it Paul Sir. Its worth watching you videos, God Bless You
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Many thanks Vinay!!
@ihitashrishandilya9867
@ihitashrishandilya9867 Год назад
This is such an easy approach to understand financial projections. Thanks Paul!! You are a gem.
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
My pleasure!
@jean-cluadelosilonipyo8626
@jean-cluadelosilonipyo8626 9 месяцев назад
it was such a hard thing for me to understand or even out together a restaurant financial projects, you made so easy for me to understand and make my own financial projects , thank you so much!!! Jean-Claude from South africa
@QualityBusinessConsultant
@QualityBusinessConsultant 9 месяцев назад
Most welcome!
@itsianlol
@itsianlol Год назад
This was exactly what I required to get a basic understanding of the concepts. Thank you so much for the help.
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Most excellent!
@leenorlisa
@leenorlisa 10 месяцев назад
This is fantastic. Straight to the point, easy to understand and to carry out. Thank you.
@QualityBusinessConsultant
@QualityBusinessConsultant 10 месяцев назад
Thanks!
@TheJleeHuddleston
@TheJleeHuddleston 4 года назад
This was the best video I've seen so far to help a business student like myself! Thank you!
@marlalee
@marlalee 4 года назад
same here!
@abhishekvishwakarma6348
@abhishekvishwakarma6348 5 лет назад
Oh I love it, the way you explain, I understand everything thing. Thank you
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
You are most welcome. If you need more help with writing a business plan, check out my new book just published. www.amazon.com/dp/B07WGXJ1FK
@naveenKumar-rk8wo
@naveenKumar-rk8wo 4 года назад
Paul, I watched this video at around 5.50am, and this video made my rest of my life so worry free of calculation of so many thing. I am very weak in math, you have taught me a lesson of my life, which I had all through my 10 business years had to rely on my friend for this kind of calculation. I am thrilled about this video. Loved the way you explain the process is awesome. Now because of this covid I am out of business and cashless, am preparing my business plan to submit to the bank, and have no cash to even pay my rent and bill, I was so hesitating to ask my friend to do this calculation for me as usual, since past four day I have gone through many many videos on you tube, nothing like your video I found, I repeat nothing like your video. I am broke now, if I had cash I would have definitely would have made a payment worth of a course to you. No issue I have saved this video in my account on youtube. I would definitely make the payment once I have enough cash in hand. Thank you once again, from now no more relying on others to make this kind of calculations and making my morning so thrilled, to start the day.
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Thank you so much!! Stories like yours are a driving reason why I do the videos. Paul
@shakerasimpson6491
@shakerasimpson6491 3 года назад
This video is the best I have ever seen . I plan on start my small business and was extremely worried about the financial plan section of my business plan but thanks to you I no longer have to worry . You are amazing and am grateful to that you share your video with us without monetarizing it . So So Soooo grateful . Thank You . Such a easy to understand video , literally fool-proof.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Best of luck Shakera!
@DonPierreHalfaway
@DonPierreHalfaway 2 года назад
Grateful for you putting the time into this. I followed it all the way to the end and learned what common sizing is, and how projections are done with percentages using the valuable formulas on your tutorial. I pray you continue doing videos as it is a service to the public.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Glad it was helpful!
@spiritualmakarand6468
@spiritualmakarand6468 3 года назад
Good evening Mr.Paul. Thank you so much for this beautiful Video. I am sure that this video will definitely help me make my business plan for next few years.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
You are very welcome
@jendymcdonald9934
@jendymcdonald9934 2 года назад
You are an excellent teacher
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thank you! 😃
@egaildr
@egaildr 2 года назад
I am super glad that I found this gem. Great explanation. Easy to understand. Very doable. Format is impressively comprehensive. Saved me from any more financial frustrations. More so, fear of losing. All in all, an absolutely great video!
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thank you! Best of luck!
@egaildr
@egaildr 2 года назад
@@QualityBusinessConsultant I really appreciate your gift of teaching, sir. Not everyone can successfully transfer the knowledge. I will be learning more from your videos. Blessings!
@robbolivar6537
@robbolivar6537 2 года назад
Thank you so much for this. It helps me a lot for my business plan. Love from PH 🇵🇭✨
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
You're so welcome! Best of luck!!
@suleimanbabatundeshittu4141
@suleimanbabatundeshittu4141 2 года назад
This is the best video I have come across regarding this topic. Thumb up. It's so great. However, Iwish you can make another video for Balance sheet, and income statement for business plan. Thank you
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thanks Suleiman, the other statements videos are in the works!!
@edwinawasel4927
@edwinawasel4927 2 года назад
Hello thank you so much for this great teaching sir
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most welcome!
@tiffanyderamus1194
@tiffanyderamus1194 5 лет назад
Thank you so much!!! I have never been good with numbers and I have been trying to figure out how to do a financial projection. This was such an easy lesson and it was also a refresher for me on how to use Excel.
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most excellent!
@MariaPerez-be8st
@MariaPerez-be8st 5 лет назад
Thank you!!! This was the last piece of my business plan that I was trying to configure. I had all the information you listed but the profit and loss part. Omg thank you, thank you!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome!!
@wayneseymour1
@wayneseymour1 5 лет назад
@@QualityBusinessConsultant how can I turn this into a graph for presentation?
@angelfrederick1850
@angelfrederick1850 4 года назад
Me too!!! He did great on explaining!!!!
@ann-ciliaskerrettskerrett6963
@ann-ciliaskerrettskerrett6963 2 года назад
Thank you so much for this tutorial. I had no idea what I was doing. this was clear and to the point. So easy to understand.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
You're very welcome!
@adv.feroza.shaikh2316
@adv.feroza.shaikh2316 2 года назад
Many thanks Paul for posting the video. Highly worth the time and efforts. I am able to create my own statements confidently.Quality video. Regards. Feroz.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most excellent and best of luck!
@sharonmoman7639
@sharonmoman7639 2 года назад
awesome tutorial thank you Paul!!!
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most welcome!!
@ryansevern8828
@ryansevern8828 Год назад
Amazing video Paul, many many thanks! one consideration I would like to ask you about is how to make the 12 month forecast more accurate for a small business that only has labour for 5 days a week excluding weekends in each given month. I have used this video and template to forecast but found that the maths became much more tricky once you try to factor in the actual days in a month, and then total labour days per month too. It raises the question that maybe i'm trying to be too accurate for a projection or not. . ? many thanks !
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Hi, Thanks for the kudos! Correct, it does get exponentially harder for each variable added. I would recommend checking out any one of my 100+ business plan templates, which includes a financial model. Here is the link... qualitybusinessplan.com/business-plan-templates/ Hope this helps. Paul
@kelly_browning
@kelly_browning 3 года назад
This is INSANELY helpful!! Thank you so much @Business Plan! What a wonderful gift.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Most welcome!
@kessastevenslake9732
@kessastevenslake9732 3 года назад
Thank you so much for explaining this! You made it so easy! Now I can complete my financial projections with confidence!
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Wonderful!
@dr.wezisunkutumd8745
@dr.wezisunkutumd8745 2 года назад
Best video ever! I salute Paul. Now, on the P&L, why didn't u total the P/L for the 12month period? Didn't see that column.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Dr. Sunkutu, Thank you for the kudos!! As for the p/l for 12 months, I did not expand upon it because of the growth rates needed for each line item, season changes to month to month revenues, etc. Kinda wanted to keep is relatively short and sweet. However, hopefully, I will have time soon to do a follow-up video. Paul
@cfarrow2708
@cfarrow2708 2 года назад
This was great! Thank you so much for breaking it down now I don’t feel intimidated doing this part of my biz plan.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Glad it was helpful!
@yvonnekkibe
@yvonnekkibe 2 года назад
This is amazing.Thaank you
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most welcome!!
@anub200213
@anub200213 2 года назад
Hi Paul, I wanted to ask how would I project what my daily sales would actually be if I have not started the business yet? Loved the video
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Hey Anu, Good question and I get asked that alot. Its actually quite simple... You can't. Consider this, two convenience stores are located on opposite sides of the street... Its a fact that one will make more daily revenues than the other, even if they sell identical products with no differences in price... Often times much more. Variables that may impact sales could be management team, customer service, brand name (Wawa or Circle K), or ease of entry/exit. From this, use projections based on how many customer you THINK you can service, on average daily. Then use your projections as benchmarks. I hope this helps. Paul
@anub200213
@anub200213 2 года назад
@@QualityBusinessConsultant wow thank you so so much Paul this was a great help. And such a quick response. You've gained a subscriber!!❤️
@debraeddington4326
@debraeddington4326 4 года назад
This was very helpful when creating a profit/loss projection statement for my business plan. Thank you so much Mr. Paul Borosky.
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Glad it was helpful!
@dianavanessa1775
@dianavanessa1775 4 года назад
Thank you for your video! Helped me finish my business plan. Well done!!!!!!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Most excellent! Check out my "How to start a business in Ten Steps" if you are starting one.
@marucoppola1868
@marucoppola1868 3 года назад
Thank you for such a well-explained video!!
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
You're very welcome!
@ShowYourselfApproved-j3z
@ShowYourselfApproved-j3z Год назад
Thank you very much for this video!!!
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
You're very welcome!
@vinita_twl
@vinita_twl 4 года назад
Clean and simple. Very Helpful. Thank You.
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Sweet! Check out some of my books on Amazon too. www.amazon.com/author/paulborosky
@Sheppesh
@Sheppesh 5 лет назад
Very helpful and elementary for a visual artist to understand. Thanks!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome.
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Thank you!! Check out some of my books at: www.amazon.com/author/paulborosky
@d.ravichandran323
@d.ravichandran323 3 года назад
Hello Paul, Many Thanks for the tutorial .... it was very much understandable and simple with most of the info needed .... Thank you again - DRC.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Glad it was helpful!
@elsasturges9410
@elsasturges9410 3 года назад
Thank you so much!!! It was really helpful.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Glad it helped!
@vipinpk917
@vipinpk917 3 года назад
Thank you soo much... This was great and helpful!!! Thank you♥️
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
You are so welcome!
@eloomicafe3188
@eloomicafe3188 4 года назад
Thank you sooo much!! This was sooo great and sooo helpful!! Thank you!!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
You are most welcome. Check out some of my books on Amazon too.
@terrencefumba2732
@terrencefumba2732 2 года назад
Amazing, it helped me much
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Glad it helped!
@josephokello5513
@josephokello5513 5 лет назад
simple wins all the time - thanks a lot
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome.
@ayesha3945
@ayesha3945 2 месяца назад
Great 👍
@QualityBusinessConsultant
@QualityBusinessConsultant 2 месяца назад
Thanks!
@adv.feroza.shaikh2316
@adv.feroza.shaikh2316 2 года назад
Hi Paul, your this post is highly incisive. I have finished 5 year projection based on your video. High indebted. However, requesting clarification please.In 12 month projection, Month 2, C33, shouldn't it also be multiplied by 30 days. Or, If I change in month to 20 days in C31, the result would be different. Not sure though. This is the only part I couldn't figure out. Requesting you to please suggest.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Hi Feroz, Thanks for the message. At minute 17:02, I show growth rates added for revenues. So, no need to multiply by 30 (days) after month 1 is complete. Hope this help. Paul
@adv.feroza.shaikh2316
@adv.feroza.shaikh2316 2 года назад
@@QualityBusinessConsultant Many thanks Paul for taking time out to consider my question and reply. If I understand correctly, "Month 2" to "Month 12" is not required. Calculations for entire year is based on "Month 1" i.e. 30 days. Therefore, I can delete 30 days from "Month 2" to "Month 12". Regards Feroz.
@caseyjaekle3189
@caseyjaekle3189 2 года назад
Excellent video!
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thank you very much!
@caseyjaekle3189
@caseyjaekle3189 2 года назад
@@QualityBusinessConsultant I noticed you have business plan videos on a variety of businesses, could you do one for home care?
@angelfrederick1850
@angelfrederick1850 4 года назад
This was very tutorial!!!! You're AWESOME!!!! THANK YOUUUUUUUUUU!!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Glad it was helpful!
@shaleen9099
@shaleen9099 3 года назад
thank you this video was helpful
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Glad it was helpful!
@liquidvamp29
@liquidvamp29 3 года назад
I would like to ask, Is it possible to include the initial investments in equipment and its depreciation cost for this format? If so where should I put it? Thank you.
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Hi, Thanks for the message. Sorry, the initial investments are more aligned with the balance sheet whereas this video is focused on income statement items (I know, depreciation is also on the income statement, I am going more for simplicity in the video though). However, I will be doing a video soon focused on this topic. Paul
@liquidvamp29
@liquidvamp29 3 года назад
@@QualityBusinessConsultant thank you so much for your response. May I ask one more time? What if the business is more on service type? Like a travel agency. How can they input their daily sales? What can you suggest about this? Thank you so much! You have been very helpful.
@brownsugar-wl7vn
@brownsugar-wl7vn 4 месяца назад
Thank you Paul
@QualityBusinessConsultant
@QualityBusinessConsultant 4 месяца назад
Most welcome!
@TannelG
@TannelG 4 года назад
Thank you soo much. This was a great help for me.
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Most welcome!
@omarabud4564
@omarabud4564 3 года назад
Thank you, this was great help! Why didn't you include federal and state taxes in the "profit and loss" statement? Should I include those?
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Hi Omar, You can add an additional line to include taxes. But then you would also need to include amortization and depreciation. I just wanted to kinda keep it simple. Best of luck!! Paul
@omarabud4564
@omarabud4564 3 года назад
Thank you.
@khyyambao385
@khyyambao385 3 года назад
This Helped me so much, THANK YOU SO SO SO SO MUCH❤️
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Glad it helped!
@muhammadairlanggarahmadi7301
@muhammadairlanggarahmadi7301 6 лет назад
Thank you so much, this is the simple way to do financial projection!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome!!
@Lauren.Taylor
@Lauren.Taylor 2 года назад
Great video! A few questions...does this video translate to service/coaching based business? As i began to input the information i realised it might change in terms of daily sales, would it still apply or would I Change it to monthly sales or weekly sales? Also there are various services offered with different prices do i still put the information as normal or would that format change too? sorry for all the questions but i really like this video and what to know if it can still be used.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Hi Lauren, All great questions. I do use a version of this model explained for business consultants. So, it would need to be modified, but it is possible to use. As for services, you can either structure it by service or average customer sales price. Hope this helps. Paul
@belindabrown9680
@belindabrown9680 Год назад
This is awesome and very helpful. I would like to set up a zoom call to introduce myself. I will reach out through your website. Thanks Belinda
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Glad it was helpful!
@igiveujoy
@igiveujoy 5 лет назад
Amazing video! Very helpful!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Very welcome. Glad I could help.
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Thank you!! Check out some of my books at: www.amazon.com/author/paulborosky
@Majitravel
@Majitravel 10 месяцев назад
Very good video
@QualityBusinessConsultant
@QualityBusinessConsultant 10 месяцев назад
Thanks
@thapelogregoryshirinda6188
@thapelogregoryshirinda6188 2 года назад
Number one 💯💪
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Thanks!
@oscaralmaguer6670
@oscaralmaguer6670 Год назад
AMAZING!!
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Thanks!
@matthewchuang6707
@matthewchuang6707 4 года назад
Extremely helpful!! Thank you!!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Excellent!
@urushachitrakar9757
@urushachitrakar9757 5 лет назад
Hi, it was really helpful. Could you please make a 3 year financial projection for a startup and how to pitch it. Thanks
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
That will be coming in a new video, which I will be releasing soon. In the mean time, check out my how to write a business plan book. www.amazon.com/dp/B07WGXJ1FK
@surakshapatil803
@surakshapatil803 4 года назад
@@QualityBusinessConsultant how can i get this in Qatar Please help me
@girisukumar
@girisukumar 5 лет назад
Thank you sir for your video
@nkosimkhwanazi6223
@nkosimkhwanazi6223 4 года назад
So, since you included labour costs, I'm assuming this is likely for manufacturing business, right? If you paid only salaries to normal employees, not management or labourers, then the cost of such would be added to salaries as well,bright?
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Labor costs would be the same as employee pay. Just a different name. You could also add employee costs to salary as well. The model is flexible.
@adrianaortega8713
@adrianaortega8713 5 лет назад
Awesome video. Thank you.
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome!! Check out some of my books at: www.amazon.com/author/paulborosky
@jendymcdonald9934
@jendymcdonald9934 2 года назад
Hi Paul, Is this information all you need to take to the bank to obtain a loan, as a startup business? Or are there other financial docs you need to bring? The business has not started generating sales.
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Hi Jendy, It all depends on the lender. Its a good start though.
@jendymcdonald9934
@jendymcdonald9934 2 года назад
@@QualityBusinessConsultant Great! Thanks!
@sthembisowcele1867
@sthembisowcele1867 3 года назад
Thank u so much sir....
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Most welcome
@surakshapatil803
@surakshapatil803 4 года назад
Thanks its very nice
@Goudystyle25
@Goudystyle25 Год назад
THANK YOU!
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
Most welcome!
@ronzmartorres
@ronzmartorres 4 года назад
Thank you so much
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
You're most welcome
@bobbygovier
@bobbygovier 4 года назад
Thankyou, very useful!
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Most excellent!
@christianlesanque1174
@christianlesanque1174 5 лет назад
Thank you so much It helps a lot.
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome!! Check out some of my books at: www.amazon.com/author/paulborosky
@liquidvamp29
@liquidvamp29 3 года назад
I just want to know why is electric part of your fixed cost? Should be part of Variable Cost right?
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Hi. Good observation. In some schools of thought, electric may be part of the variable costs. The more you sell, the higher the electric cost. A variable component, which leads to a variable cost. However, in other schools of thought, which I would tend to agree with, would be that electric is a fixed cost. To support this, I would argue that the electric bill needs to be paid monthly, regardless if you have no sales. Thus, a fixed a cost. I hope this helps. Paul
@liquidvamp29
@liquidvamp29 3 года назад
@@QualityBusinessConsultant Thanks for responding. I just want you to know that this video helped my students create their own financial projection for their Business Plan. Very informative Channel.
@liz-hn1qm
@liz-hn1qm 5 лет назад
thanks so much!! this was amazing
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome!!
@exceleratelearning4529
@exceleratelearning4529 6 лет назад
Nice video Paul!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Thank you!! Check out some of my books at: www.amazon.com/author/paulborosky
@inlandb.villos1872
@inlandb.villos1872 3 года назад
thank you so much
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
You're welcome!
@clairemmbaya3026
@clairemmbaya3026 5 лет назад
This is amazing
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Thank you!
@captainubi
@captainubi 3 года назад
THANK YOU
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Most welcome
@serahmichelle2567
@serahmichelle2567 6 лет назад
I must have did something wrong in the steps. Every time I change the Numbers in Product 1 and 2 from 1 to 100, the Total row for the Total Cost and Profit gets this hashtag ######### symbol. What am I doing wrong?
@serahmichelle2567
@serahmichelle2567 6 лет назад
Nvm, I figured it out. I didn’t have my columns wide enough.
@mountainstory7371
@mountainstory7371 5 лет назад
if the column width is smaller than your number, Excel shows ####, pull the right corner of the column to increase width, or double click to automatically adjust. Hope this helps
@frankiemack20
@frankiemack20 2 года назад
What would the Revenue*growth formula look like with variable running days each month?
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Hi Frank, I am not understanding your question... for the growth formula, it would be [revenues*(1+growth rate)]. Variable costs would then be a fixed percentage of the new revenue.
@frankiemack20
@frankiemack20 2 года назад
@@QualityBusinessConsultant wouldn’t that be assuming that every month has an equal amount of days? Since the month one revenue was based on the amount of days in that month, but all future months are based off 5% growth based on that specific number. Guess my question is, what would a formula for 5% growth look like if working days were reduced to 25?
@serahmichelle2567
@serahmichelle2567 6 лет назад
How do you turn this into yearly data?
@binxy9180
@binxy9180 4 года назад
He linked it in the bio ~
@ohpam625
@ohpam625 5 лет назад
thank you so much !
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most welcome.
@roshankhadka5346
@roshankhadka5346 Год назад
What about Balance Sheet?
@martinebowen6790
@martinebowen6790 3 года назад
Content Suggestion: How to make financial plan for a business plan using excel.
@riskyrahmatfadhillah
@riskyrahmatfadhillah 3 года назад
Mantap sir
@QualityBusinessConsultant
@QualityBusinessConsultant 3 года назад
Thank you!
@Callusmindset
@Callusmindset 4 года назад
hey everyone and @Business Plan, how do you change "Days in Month" it only work for "Month 1"" but when i tried to edit for other month it wont work, please help ASAP
@wayneseymour1
@wayneseymour1 5 лет назад
How can I create a graph from this?
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
That will be coming in a new video, which I will be releasing soon. In the mean time, check out my how to write a business plan book. www.amazon.com/dp/B07WGXJ1FK
@damion20312
@damion20312 4 года назад
Can anyone tell me if the total revenue number includes sales tax?
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
It does not.
@Silvertestrun
@Silvertestrun 2 года назад
Ty
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most welcome!
@belindagordon9941
@belindagordon9941 5 лет назад
This was great,toom me an hour but it was good Sir thank you!
@QualityBusinessConsultant
@QualityBusinessConsultant 5 лет назад
Most excellent!
@juangs1168
@juangs1168 2 года назад
This was awesome!!
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
Most excellent!!
@jeandagante2396
@jeandagante2396 2 года назад
Highly recommended! Thank you so much sir Paul..🤍
@QualityBusinessConsultant
@QualityBusinessConsultant 2 года назад
My pleasure!
@brandis5679
@brandis5679 4 года назад
Thank you thank you!! This was a great help
@QualityBusinessConsultant
@QualityBusinessConsultant 4 года назад
Sweet! Best of luck.
@shalisaperoonline
@shalisaperoonline Год назад
Thank you!
@QualityBusinessConsultant
@QualityBusinessConsultant Год назад
You're welcome!
Далее
How to Build a Basic Financial Model in Excel
10:10
Просмотров 791 тыс.
When Khabib dropped Conor McGregor 👀 #nocommentary
00:59
小丑调戏黑天使的后果#short #angel #clown
00:16
Financial Modeling Fundamentals - Financial Statements
58:39
How to Write a Business Plan - Entrepreneurship 101
11:31
What investors ACTUALLY want to see in your PITCH DECK.
13:18
3 Statement Financial Model | Building From Scratch
37:59
Build a Dynamic Financial Model in Just 15 Minutes
15:22