A trip budget has two parts. The first is costs that scale with people and days, such as food, local transport and activities. The second is shared costs that do not, such as the stay, a car and a guide. The formula is: total = (people × days × daily cost per person) + shared costs. A four-person, five-day example below shows how it works, with invented numbers.
Which costs go in which bucket?
- Per person per day: food, local transport such as autos and metro, activities and entry tickets, small cash.
- Shared: rooms or the stay, a hired car and driver, a guide, anything priced once for the group.
- Per person, once: flights or train tickets, visas, insurance. Treat these as a third bucket, or add them to the per-person total.
A four-person, five-day example
Say the daily cost per person is ₹1,500 for food, ₹400 for local transport and ₹600 for activities, which is ₹2,500 in all. These are guesses for arithmetic, not prices.
| Line | Working | Amount (₹) |
|---|---|---|
| Per person per day costs | 4 people × 5 days × 2,500 | 50,000 |
| Stay | 2 rooms × 4 nights × 3,500 | 28,000 |
| Car with driver | 5 days × 3,000 | 15,000 |
| Guide | One-time | 4,000 |
| Shared costs | 28,000 + 15,000 + 4,000 | 47,000 |
| Total | 50,000 + 47,000 | 97,000 |
Per person, that is 97,000 divided by 4, or ₹24,250. Per person per day, it is 24,250 divided by 5, or ₹4,850.
How do I build this in a sheet?
Put people in B1, days in B2 and the daily cost per person in B3. Then:
- =B1*B2*B3 for the per-person-per-day bucket.
- =SUM(B6:B8) for the shared costs, if those three costs are in B6 to B8.
- =B4+B9 for the total, with the first formula in B4 and the shared total in B9.
- =B10/B1 for the cost per person and =B10/B1/B2 for per person per day.
Change the number of people or days, and the total follows. That is the point of the formula.
What happens if one more person joins?
Run the same formula with 5 people. The per person per day bucket becomes 5 × 5 × 2,500 = ₹62,500. The group now needs a third room, so the stay is 3 rooms × 4 nights × 3,500 = ₹42,000, while the car (₹15,000) and guide (₹4,000) stay as they were. Shared costs are 42,000 + 15,000 + 4,000 = ₹61,000, and the total is 62,500 + 61,000 = ₹1,23,500. That is ₹24,700 a head, a little more than before. Shared costs only get cheaper per head if the extra person fits into what you already booked.
Why are nights and days different?
A five-day trip usually has four nights. In the example the stay uses 4 nights while food and activities use 5 days. Decide whether your trip has arrival and departure days that count as half days, and apply the same rule everywhere.
How should shared costs be divided among travellers?
Dividing the ₹47,000 equally gives ₹11,750 each, which is simple and usually fine for friends. If two couples share rooms and one couple wants a pricier room, split the stay by room instead: each couple pays for its own room (₹14,000 for the cheaper one at 4 nights × 3,500) and the car and guide are shared four ways. Whichever rule you choose, agree it before booking, not after the bill arrives.
What should I do about one-time costs?
Flights, visas and insurance sit outside the formula, so list them above it. Include them in the total, but be careful when comparing trips by cost per day, since a fixed airfare weighs more heavily on a short trip.
Before you finalise
- Ask each traveller to check the per-day figure against what they usually spend on a holiday day.
- Confirm what the stay price includes, such as breakfast, so the food line is not counted twice.
- Decide who pays shared costs and how you will settle.
- Add a buffer, based on past trips if you have them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

