Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
190x Filetype XLSX File size 0.03 MB Source: www.kpu.ca
Sheet 1: TravelBudget
| Insert Project Title Here | Start by entering the "Total Budget" for your trip. Then enter your expenses to see if you'll have extra money or if you'll need to cut back. | ||||||||||
| My Budget & Expenses | Breakdown of Expenses | ||||||||||
| Total Budget | ← See an overview of your total expenses. | ||||||||||
| $2,750.00 | Transportation | 41% | 1,068 | ||||||||
| Total Expenses | Lodging | 23% | 600 | $2,613 | |||||||
| $2,612.70 | Food | 22% | 585 | ||||||||
| Difference | Entertainment | 4% | 110 | ||||||||
| $137.30 | Other | 10% | 250 | ← Other includes everything that is not one of the other 4 categories | |||||||
| http://www.vertex42.com/ExcelTemplates/travel-budget-worksheet.html | © 2014 Vertex42 LLC | ||||||||||
| What are my expenses? | |||||||||||
| description | category | quantity | unit cost | amount | |||||||
| Flights | Transportation | 2 | 400.00 | 800.00 | ← Enter expenses using the Quantity and Unit Cost columns | ||||||
| Taxi & Bus | Transportation | 5 | 30.00 | 150.00 | |||||||
| Driving (miles, cost/mile) | Transportation | 50 | 0.56 | 28.00 | |||||||
| Parking (days, cost/day) | Transportation | 6 | 14.95 | 89.70 | |||||||
| Hotel (nights, cost/night) | Lodging | 5 | 120.00 | 600.00 | |||||||
| Breakfast | Food | 5 | 12.00 | 60.00 | |||||||
| Lunch | Food | 5 | 45.00 | 225.00 | |||||||
| Dinners | Food | 5 | 50.00 | 250.00 | |||||||
| Snacks and Drinks | Food | 5 | 10.00 | 50.00 | |||||||
| Museum Tickets | Entertainment | 2 | 20.00 | 40.00 | |||||||
| Live Show Tickets | Entertainment | 2 | 35.00 | 70.00 | |||||||
| Maps and Guidebooks | Other | 1 | 50.00 | 50.00 | |||||||
| Souvenirs and Gifts | Other | 1 | 200.00 | 200.00 | |||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | |||||||||||
| - | ← Insert new rows ABOVE this line | ||||||||||
| Total Expenses | $2,612.70 | ||||||||||
| HELP | ||
| http://www.vertex42.com/ExcelTemplates/travel-budget-worksheet.html | © 2014 Vertex42 LLC | |
| Getting Started | ||
| Enter the total budget for your trip in cell C4. | ||
| Enter all of your trip expenses in the section titled "What are my expenses?" Make sure to enter the expense category as one of the following: Transportation, Lodging, Food, Entertainment, or Other. | ||
| The "Where are my expenses going?" section is populated automatically based on the total budget and expenses you enter. | ||
| You can change a category label in cells F4:F7. For example, you could change the label "Entertainment" in cell C7 to "Activities." | ||
| The "Other" category will include everything that is not one of the other four categories. Do not change the name of the "Other" category. | ||
| Cell C8 shows the difference between the Total Budget and the Total Expenses, so you can easily see if you are over or under budget. | ||
| For other types of budgeting spreadsheets, visit Vertex42.com. | ||
| Additional Help | ||
| The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template. | ||
| TEMPLATE | Vertex42.com: Money Management Template | |
| TEMPLATE | Vertex42.com: Family Budget Planner | |
| TIPS | Vertex42.com: Spreadsheet Tips Workbook | |
| ARTICLE | Vertex42.com: How to Make a Budget with a Spreadsheet | |
| ARTICLE | Vertex42.com: Budgeting Tips | |
no reviews yet
Please Login to review.
