I built this template for a scenario that comes up whenever I’m booking a rental house with friends. How much is each person responsible for? What if people are staying for different lengths of time?
The following calculator assumes that the total cost of the rental is evenly split across nights, but evaluates each night separately, so you can adjust for guests who aren’t staying the full time!
1. Enter Trip Details
Enter Trip Dates 👇
February 24-27, 2022
Enter Rental Cost 👇
2000
# of Nights:
3
Total Cost / Night: $
666.67
2. Add Guests
1
2
3
Name
Name
Person A
Person B
Person C
There are no rows in this table
3. Press Button
Show Costs
To start over:
Clear Calendar
4. Review Nights and Adjust Guests
Remove or add guests based on their arrival / departure dates!
Night
Guests
Cost Per Person
Night
Guests
Cost Per Person
There are no rows in this table
Review Costs Per Person
Name
Total Cost
Name
Total Cost
1
Person A
$0.00
2
Person B
$0.00
3
Person C
$0.00
There are no rows in this table
$0.00
Sum
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (