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: ,

44 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. AnonymousJanuary 8, 2015 at 2:49 AM

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

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

    Thanks for this spreadsheet. Helps a lot!

    ReplyDelete
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. 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
  31. http://debashishbramha.blogspot.com/June 28, 2017 at 2:59 AM

    Great Post.

    ReplyDelete
  32. 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
  33. AnonymousMarch 17, 2018 at 5:43 AM

    can you please send excel to bbasera@gmail.com

    ReplyDelete
  34. 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
  35. 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
  36. 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
  37. 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
  38. 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
  39. 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
  40. 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
  41. 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
  42. Update TechnologyJuly 27, 2020 at 1:50 AM

    This comment has been removed by the author.

    ReplyDelete
  43. 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
  44. cenneys hotelOctober 28, 2021 at 1:36 AM

    The awesome Wedding Hall in Salem are available in luxurious form. So, book now at hotelcenneys online.

    ReplyDelete

Subscribe to: Post Comments (Atom)