Latest Updates: monthly and annual three statement model added as well as a capitalization table.
Video Tutorial:
This is a 10-year annual forecasting template. I tried to make the most simple and easy to use financial model in regards to starting and operating a food truck. This should be straightforward enough for the average Excel user to get value from without worrying about missing anything or breaking anything.
Starting your own food truck is just like any other business. You will likely have some startup costs and those will be financed by your own cash and/or with debt. This entire financial model is only 4 tabs plus an instructions tab.
The user will start on the ‘Assumptions’ tab where all revenue, expense, and startup costs are entered as well as any percentage of startup costs that are funded by debt. Inputs are very simple. You have 3 input slots representing up to 3 time frames i.e. year 1-3, 4-6, 7-10 or what have you. Within each slot, the user can configure the following:
Average Daily Sales
Average Sale $ amount
Average working days per month
Those are multiplied together and applied to the given year ranges to get top line revenue. Operating expenses work by entering a percentage for the following:
Food Costs (COGS)
Labor Costs
Other Costs (Gas/Licenses/Insurance/etc..)
These will change as revenue changes each year. Default startup costs are:
Food Truck + Wrap & Equipment
Initial Product Inventory
Permits and Licenses
Website
Facebook / Twitter
Register / POS
Uniforms / T-Shirts
Paper Products (Plates / Napkins, etc.)
Misc. Expenses (Like a Chalk Menu)
Smallwares: Pots, Pans, etc.
Fire Extinguisher
The assumptions drive a 10-year pro forma, which drills down to operating cash flow per year and operating cash flow per year after debt service. A return summary tab shows:
IRR
Net ROI
Net Total ROI %
Leveraged Total ROI
Annual Cash Flow AVG
NPV Cash Flows / DCF Analysis
Discount Rate.
