Franchisee profitability calculator: Scenarios

The Scenarios below test the change in the profitability of your Franchisee as water sales increase. Scenario I reflects what you entered on the previous page.

However, if you provide more families with water, you will have significantly higher returns and shorter cost recovery periods – as shown in Scenarios II to IV.

If you would like to adjust your original estimate, please change the inputs listed on the right.

How many families will you serve per day?
  households
Will you hire an Operator to run your RO unit?
 
Will you deliver bottles to your customers?
 
What does electricity cost(per megawatt hour)?
  rupees

 

Franchisee Earnings
Scenario I
Scenario II
Scenario III
Scenario IV
 
Volume
# Families served per day
Monthly water volume
 
Revenue
Total
Per Bottle
Total
Per Bottle
Total
Per Bottle
Total
Per Bottle
Monthly water revenue
Monthly delivery revenue
Total monthly revenue
 
Expenses
Sarvajal service & marketing support fee
Monthly operator salary
Bonus for water volume sold
Monthly driver salary
Bonus for water volume sold
Monthly delivery vehicle payments
Monthly diesel cost
Monthly electricity cost
Service tax
Total monthly expenses
 
Monthly net profit
Monthly profit margin
 
Upfront Costs
Franchisee upfront fee + Tax
Delivery vehicle down payment
Cost for bottles
Total upfront costs
Months to recover upfront costs