Overview

Travel expenses make up an important and material part of a company’s budget. This template built on the highest professional financial modeling standards will help you calculate future travel expenses.

The calculations include:

  • An intuitive and convenient input section. You just need to enter destination name, costs of tickets per trip, accommodation, meal, taxi, out-of-pocket expense allowance and planned numbers of trips to every destination by month
  • A summary grouping the costs by type (fares, accommodation, meals etc.)
  • A summary grouping the costs by destination
  • Additional travel statistics (total number of trips, total days travelled, number of destinations travelled to).

The budget is made on a monthly basis but there is a separate section grouping the numbers by years.


The template is very flexible and can be adjusted to your requirements quickly:


  • You can change the total period covered by the budget (currently three years) and the interval (currently one month).
  • You can add as many destinations as needed. You can also include the same destination several times depending on the class of travel.
  • You can also include other relevant types of travel expenses

The template can be used on a stand-alone basis (to make just a travel budget) or as part of a larger budgeting package. It can also be incorporated into investment analysis models.

 

The template is accompanied by a text guide with detailed explanations.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Loan Schedule
243
2
This template will help you calculate loan and interest balances, accrued interest at any point in time on loans granted or issued.…
Capex Budget
485
1
 Any company which uses fixed assets in its operations needs to know:   Investment cash flow related to new fixed…
Payroll Budget
751
0
Payroll expenses and employee costs in general form an important and material part of a company’s budget. This template built on the highest…
HR Analytics and Dashboard
1,361
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
2,139
184
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cap Table with Investor Returns, Derivative Instruments and Charts
2,149
5
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
See All