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

44 comments:

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

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

    ReplyDelete
  3. 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. Thanks Mr. Jayanth. The information you shared is really valuable and I appreciate.

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

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

    ReplyDelete
  7. Dear Jayanth,
    Thanks so very much for sharing this.

    ReplyDelete
  8. 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
  9. Thank You Jayanth.

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

    ReplyDelete
  11. Thank you very much for sharing this valuable information.

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

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

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

    ReplyDelete
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. Bargain Online for the best hotels at MyDeals247.com
    For more please watch the video..http://www.youtube.com/watch?v=UWigWICKsII

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

    ReplyDelete
  23. Thanks for this spreadsheet. Helps a lot!

    ReplyDelete
  24. 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
  25. 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
  26. 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
  27. Can you please email the spreadsheet, the link appears not be be working. Email: ajit.rajput@gmail.com

    ReplyDelete
  28. 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
  29. 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
  30. 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. Every one wants to avail the service that is reliable most convenient for him. ipad application development

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

    ReplyDelete
  33. 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
  34. can you please send excel to bbasera@gmail.com

    ReplyDelete
  35. 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
  36. 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
  37. Nice post. online ordering system for takeaway I read your blog, its best and useful information. You have done a good work.

    ReplyDelete
  38. 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
  39. Nice post, thanks for sharing hope to see more in future.

    VAT Return in UAE
    No VAT Charges on Gold

    ReplyDelete