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

52 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. Thanks for the valuable informations. What if the location falls under panchayat area

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

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

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

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

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

    ReplyDelete
  32. 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
  33. This comment has been removed by the author.

    ReplyDelete
  34. 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