Tuesday, March 22, 2011

New Unit Financials - Excel Template with indicative numbers

This is perhaps the most valuable piece of information on this blog. The attached link will open a spreadsheet that details out the various financial components of a restaurant - The Initial Investment, The Operating Costs and Staffing Costs. I have used a standard 1000-1500 sft (about a 40 seater) Indian restaurant serving food at reasonable prices (Rs. 100-150 per person per meal) as an example. You can play around with the data to suit your specific business idea.

Disclaimer: Please note that the numbers are indicative and based on information I know. So kindly validate the figures for yourself. The spreadsheet needs to be used more as a template than as an actual financial planning document.

https://spreadsheets.google.com/ccc?key=0ArRHiZ3ki5n9dG1Kclk3NHFQZzloWjBfVURSXzJKSWc&hl=en&authkey=CPqU_ekG#gid=0

Posted by at
Labels: ,

53 comments:

  1. UnknownJune 14, 2011 at 7:57 AM

    This is a very helpful resource. Many a thanks for sharing it :)

    ReplyDelete
  2. Niraj JhaMarch 15, 2012 at 10:35 AM

    thanks dear. May God bring your dreams to reality..

    ReplyDelete
  3. DeepakJune 25, 2012 at 4:33 AM

    Dear All,
    Can pls anyone mail me this spreadsheet link or file itself as this link is not working now.

    Thanks ,
    Deepak
    email:deepaksays.hi@gmail.com

    ReplyDelete
  4. Immanvel JohnsonFebruary 17, 2013 at 9:58 PM

    Thank you so much boss..

    ReplyDelete
  5. ramatneethiFebruary 18, 2013 at 11:49 AM

    Thanks Mr. Jayanth. The information you shared is really valuable and I appreciate.

    ReplyDelete
  6. Shikhar VermaMarch 16, 2013 at 5:56 PM

    Thanks for the template. It is a great starting point. Really appreciate it.

    ReplyDelete
  7. UnknownApril 1, 2013 at 10:06 PM

    Thanks for sharing such valuable information. God bless you in you're endeavor

    ReplyDelete
  8. Ajay GiridharanApril 20, 2013 at 6:29 PM

    Dear Jayanth,
    Thanks so very much for sharing this.

    ReplyDelete
  9. AnonymousMay 12, 2013 at 9:37 AM

    Dear Jayanth,

    The spreadsheet isn't working. Would be absolutely great if you could mail me the spreadsheet on my email id dhavaldama@gmail.com. Thanks in advance.

    Dhaval.

    ReplyDelete
  10. AnonymousMay 22, 2013 at 1:12 AM

    Thank You Jayanth.

    ReplyDelete
  11. Zameer MammyMay 23, 2013 at 4:44 AM

    can you please email the spreadsheet to zameerma@gmail.com

    ReplyDelete
  12. Thetopofindia.comJuly 9, 2013 at 8:27 AM

    Thank you very much for sharing this valuable information.

    ReplyDelete
  13. AnonymousJuly 18, 2013 at 8:46 AM

    Please mail me the xls with the embedded formula to arghyahere@gmail.com

    ReplyDelete
  14. UnknownSeptember 16, 2013 at 10:08 PM

    please can you email it to me at aayush13@gmail.com

    ReplyDelete
  15. UnknownSeptember 17, 2013 at 4:15 AM

    Hi, can you please email this to me at er.chetanbhardwaj@gmail.com .. Thanks

    ReplyDelete
  16. AnonymousOctober 11, 2013 at 4:18 AM

    Nice Post!!! If you are thinking about investing in the restaurant business, you need to stay on top of new trends and - restaurant investment opportunities of restaurantindia.in.

    ReplyDelete
  17. UnknownOctober 29, 2013 at 11:11 PM

    Hi

    Is it possible to share your contact number so that I can call you to discuss certain things to move forward

    Thanks
    Noor
    +919962529391

    ReplyDelete
  18. AnonymousJanuary 4, 2014 at 1:54 AM

    The spreadsheet isn't working. Would be absolutely great if you could mail me the spreadsheet on my email id amitbansal0810@gmail.com. Thanks in advance.

    ReplyDelete
  19. PravWritesApril 21, 2014 at 5:47 AM

    Hi Guys,

    I am planning to open a fast food outlet [Only delivery] having key offerings as Pizza, Rolls and Sandwiches in Navi Mumbai. Could you guys please help me with estimated product costing and distribution model.

    Please mail same @ pravindaud@gmail.com

    ReplyDelete
  20. UnknownJuly 8, 2014 at 9:49 PM

    Hi all...
    I am palnning to open an restaurent/fast foof center in goa. Can any one mail me aal the information regarding license,permits etc and also the cost of licences and permits..
    Email me on dicto.b@gmail.com

    ReplyDelete
  21. otr214426August 12, 2014 at 9:23 PM

    LIVE Entry – 1 (March-21-2014)

    Problem: HP Printer not connecting to my laptop.

    I had an issue while connecting my 2 year old HP printer to my brother's laptop that I had borrowed for starting my own business. I used a quick google search to fix the problem but that did not help me.

    I then decided to get professional help to solve my problem. After having received many quotations from various companies, i decided to go ahead with Online Tech Repair (www.onlinetechrepairs.com).

    Reasons I chose them over the others:
    1) They were extremely friendly and patient with me during my initial discussions and responded promptly to my request.
    2) Their prices were extremely reasonable.
    3) They were ready and willing to walk me through the entire process step by step and were on call with me till i got it fixed.

    How did they do it
    1) They first asked me to state my problem clearly and asked me a few questions. This was done to detect any physical connectivity issues with the printer.
    2) After having answered this, they confirmed that the printer and the laptop were functioning correctly.
    3) They then, asked me if they could access my laptop remotely to troubleshoot the problem and fix it. I agreed.
    4) One of the tech support executives accessed my laptop and started troubleshooting.
    5) I sat back and watched as the tech support executive was navigating my laptop to spot the issue. The issue was fixed.
    6) I was told that it was due to an older version of the driver that had been installed.

    My Experience
    I loved the entire friendly conversation that took place with them. They understood my needs clearly and acted upon the solution immediately. Being a technical noob, i sometimes find it difficult to communicate with tech support teams. It was a very different experience with the guys at Online Tech Repairs. You can check out their website www.onlinetechrepairs.com or call them on 1-914-613-3786.
    Would definitely recommend this service to anyone who needs help fixing their computers.
    Thanks a ton guys. Great Job....!!

    ReplyDelete
  22. UnknownSeptember 29, 2014 at 10:16 PM

    Bargain Online for the best hotels at MyDeals247.com
    For more please watch the video..http://www.youtube.com/watch?v=UWigWICKsII

    ReplyDelete
  23. AnonymousJanuary 8, 2015 at 2:49 AM

    Thanks for the valuable informations. What if the location falls under panchayat area

    ReplyDelete
  24. SidharthaJanuary 28, 2015 at 4:18 AM

    Thanks for this spreadsheet. Helps a lot!

    ReplyDelete
  25. UnknownJune 4, 2015 at 3:15 AM

    The catering staff of two trains have been fined Rs.50,000 each for overcharging passengers for food items following a surprise check here. To know more visit catering services in chennai

    ReplyDelete
  26. UnknownJune 26, 2015 at 6:46 AM

    We are the Mumbai Based consultant for various government registration like FSSAI Registration (food safety standard authority of india),FDA Registration ,NSIC Registration,MSME Registration etc for more info contact us : Mr.raj #9930962213

    ReplyDelete
  27. UnknownJuly 4, 2015 at 2:10 AM

    Organic product are best for living healthy & safe life.
    Buy certified organic products at reasonable price from www.organikart.in
    To link your organic products with our store send email to info@organikart.in with subject "Supplier Inquiry"

    ReplyDelete
  28. ARJuly 6, 2015 at 12:56 AM

    Can you please email the spreadsheet, the link appears not be be working. Email: ajit.rajput@gmail.com

    ReplyDelete
  29. UnknownAugust 7, 2015 at 4:15 AM

    Catering Companies Cape Town Out of this planet catering offer inspired food for all types of functions and parties. In addition to tasty cuisine a complete co-ordination service is available including bar service dedicated service staffing and quality hiring requirements of all gear to run a professional event. Interesting and exclusive venues are also at hand for those special functions. Please make contact to discuss your queries and put your mind at rest.

    ReplyDelete
  30. UnknownOctober 1, 2015 at 9:15 PM

    indian chef looking job abroad from india i have very good experience about indian food if somebody looking indian chef you can contect me i have experience from hotel and restaurant+abroad you can massage me at> dinesh_singh2015@outlook.com mobile no +91 8126377296
    thanks
    total experience 15 year north indian and tandoor
    chef dinesh
    from india

    ReplyDelete
  31. UnknownOctober 1, 2015 at 9:16 PM

    indian chef looking job abroad from india i have very good experience about indian food if somebody looking indian chef you can contect me i have experience from hotel and restaurant+abroad you can massage me at> dinesh_singh2015@outlook.com mobile no +91 8126377296
    thanks
    total experience 15 year north indian and tandoor
    chef dinesh
    from india

    ReplyDelete
  32. UnknownFebruary 17, 2016 at 3:18 AM

    Every one wants to avail the service that is reliable most convenient for him. ipad application development

    ReplyDelete
  33. UnknownMarch 2, 2016 at 8:45 PM

    Thanks for this spreadsheet. Helps a lot!
    Could you please email this to me at azarfj@hotmail.com
    Thanks in Advance.

    ReplyDelete
  34. http://debashishbramha.blogspot.com/June 28, 2017 at 2:59 AM

    Great Post.

    ReplyDelete
  35. debashish BrahmaJune 29, 2017 at 4:04 AM

    You did a great job, I can suggest that one mistake you have not taken Interest on loan. The loan component is to be taken. If you tale a loan of 40 Lacks , the interest will be around 12% ( approx) Rs 4.8 Lacks per annuly.

    ReplyDelete
  36. AnonymousMarch 17, 2018 at 5:43 AM

    can you please send excel to bbasera@gmail.com

    ReplyDelete
  37. ciitnoidaApril 14, 2018 at 2:28 AM

    CIITN is the best SAP training and placement Institute in noida. Contestant will analyze in keeping with modern-day enterprise trends by way of certified and industry experts & SAP training Institute in Noida. They provide a 100% placement help with the best training of IT cousrses.

    If you are looking best sap training in Noida then you can join CIITN. One of the premier training and development institute for SAP Training Program in Noida. The company provides 6 weeks/ 6 Months Training for SAP. They provide training in all SAP Modules like SAP HANA,SAP B1, SAP FICO etc. Just come for free demo class and then join SAP and move up in your career .

    SAP Training Institute in Noida
    sap training in noida
    sap institute in noida
    sap course in noida
    best sap training institute in noida

    ReplyDelete
  38. eFinancial ModelsMay 7, 2018 at 12:19 AM

    That's is really very nice post its all information is really helpful. Please Visit:

    learn financial modeling
    auto repair shop business plan
    finance excel template

    ReplyDelete
  39. Charlie LordJune 4, 2018 at 2:12 AM

    Nice post. online ordering system for takeaway I read your blog, its best and useful information. You have done a good work.

    ReplyDelete
  40. UnknownJune 11, 2018 at 3:21 AM

    We give all sort of Restaurant supplies. We supply a thorough cluster of Hospitality products suppliers that are fabricated by a specialist group of expert team.

    ReplyDelete
  41. AhmedJuly 21, 2018 at 1:20 AM

    Nice post, thanks for sharing hope to see more in future.

    VAT Return in UAE
    No VAT Charges on Gold

    ReplyDelete
  42. Canara DockliftsJuly 23, 2018 at 12:17 AM

    I really appreciate your effort..Thanks for sharing this on.
    Goods Lift Manufacturers in Bangalore | Hydraulic Goods Lift Manufacturers in Bangalore


    ReplyDelete
  43. eFinancial ModelsOctober 3, 2018 at 7:00 AM

    That's is really very nice post its all information is really helpful.

    excel financial model template
    hospital financial model xls
    Mining Valuation Model

    ReplyDelete
  44. POS Billing Software India | Retail & GST Software | Easy Retail Software - Er4uOctober 23, 2018 at 4:55 AM

    That was really valuable piece of information.

    retail invoice software
    Billing software India
    Small Business POS India

    ReplyDelete
  45. Easy Restaurant for YouJanuary 31, 2019 at 12:17 AM

    Therefore, it is really imperative for you to be able to figure out latest ways beat restaurant competition without lowering your revenue.
    Restaurant pos software India
    Restaurant pos system India
    Restaurant billing software
    billing software for restaurant

    ReplyDelete
  46. Binoy ChackoJune 2, 2019 at 10:09 PM

    Very Good Information.
    Also to read about the process and requirements for Company Registration Bangalore.
    Company Registration in Bangalore is completely online.
    Registrar of Companies, Ministry of Corporate Affairs MCA administers the Process How to Register a Company In India

    ReplyDelete
  47. teddybearJuly 18, 2019 at 10:53 PM

    Thanks for sharing such a wonderful information.....!!!!
    plug & play office space in Bangalore
    commercial space for rent

    ReplyDelete
  48. meerakrishnaSeptember 3, 2019 at 9:40 PM

    It offers a more precise payment on a periodic basis for the ongoing service and products. It’s not like a discrete and one time transaction for a certain thing.
    Billing Software in Chennai
    Retail Billing Software in Chennai
    Pos Software in Chennai
    Restaurant Billing Software in Chennai

    ReplyDelete
  49. Arshad AliOctober 19, 2019 at 12:10 AM

    Hi,this is really very nice blog.I have learned a lot of good and informative stuff from your blog.Thank you so much for sharing this wonderful post. Keep posting such valuable contents.
    We are also into the Digital Marketing space.
    Please visit our website by clicking the links given below.

    Best Digital Marketing Training Course in Kolkata
    Best Digital Marketing Training Centre in Kolkata
    Best Digital Marketing Training Center in Kolkata
    Best Digital Marketing Training Institute in Kolkata
    Best SEO/Search Engine Optimization Training Centre in Kolkata
    Best SEO/Search Engine Optimization Training Center in Kolkata
    Best SEO/Search Engine Optimization Training Course in Kolkata
    Best SEO/Search Engine Optimization Training Institute in Kolkata
    Best Digital Marketing SEO Internship in Kolkata
    Best Digital Marketing SEO Agency in Kolkata
    Best Digital Marketing SEO Jobs in Kolkata
    Digital Marketing Course Fees in Kolkata
    Digital Marketing Course Online in Kolkata
    Digital Marketing Expert Abuzar Shah Qureshi in Kolkata
    Digital Marketing Expert in Kolkata
    Best Digital Marketing Company in Kolkata
    Best SEO Company in Kolkata
    Best SEO Services in Kolkata
    Digital Marketing Jobs for Fresher in Kolkata
    Best SEO Jobs for Fresher in Kolkata

    ReplyDelete
  50. Yogesh.MMay 9, 2020 at 8:30 AM

    The article is very good and informative. Thank you for the author.

    For best billing software for retail please click below link.
    Retail Billing Software in Bangalore

    ReplyDelete
  51. Update TechnologyJuly 27, 2020 at 1:50 AM

    This comment has been removed by the author.

    ReplyDelete
  52. Elizabeth J. NealMay 12, 2021 at 3:48 AM

    Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks. Ottawa Accountant

    ReplyDelete
  53. Kasikannu CateringAugust 23, 2021 at 1:05 AM

    Thanks for sharing this information with us and it was a nice blog. Are you searching for Wedding Catering Service in Chennai
    Best Brahmin Catering services in Chennai

    ReplyDelete

Subscribe to: Post Comments (Atom)