The template will take your unique inputs and assumptions to automatically calculate and build your Income Statement (Profit & Loss), Balance Sheet, and Cash Flow statement. Any change you make on the input tabs will automatically be calculated and updated on your financial statements making for easy changes and experimentation. The financial statements are easily exported or printed for lenders.

Financial Statements Included:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown

The At-A-Glance tab serves up a comprehensive financial snapshot. Visualize your data with key financial ratios, startup cost estimations, and break-even points. Infographics, charts, and summaries will enhance your presentations, making them compelling for stakeholders, lenders, or investors.

Tables, charts, graphs and dashboards include:

• Hot Shot Trucking profit and loss
• Hot Shot Trucking startup cost graph
• Key Hot Shot trucking industry ratios ​​
• Cash flow from operations graph
• 5 years of monthly and annual profit and loss, cash flow and balance sheet forecasts

The revenue model has two categories of revenue: dedicated routes and over-the-road / spot freight which can be used for standard hot shot trucking startups. The model helps you determine potential revenue by estimating your number of drivers and number of miles per day per driver. From there, you can set your revenue per mile for each type of route, and you can also set your costs per mile (driver pay, fuel, etc). The model will project revenue and direct expenses for you for five years. The predicted values will be automatically carried to the financial statements.

You will be asked to input monthly expenses into the spreadsheet, which already includes some industry standard expenses and dollar amounts to help you get started. The hot shot trucking business operating expenses will flow through to the financial statements for you. You can enter your monthly expenses as fixed amounts or you can set them on a per driver or per mile basis. The first three months of the model are broken out separately so that you can enter start-up expenses.

The salaries tab helps calculate monthly expenses for salaried employees, drivers and office staff, including employer taxes and benefits.

The general assumptions spreadsheet tab will help you enter your predicted asset purchase timeline. For each asset (truck, trailer, equipment, etc), you can enter the purchase date, purchase price, and individual financing assumptions such as down payment, loan amount, payment period, etc. Our model will calculate the cash flows for you, as well as interest expense and depreciation. After you enter some basic assumptions the spreadsheet will do the heavy lifting calculations for you and make sure your balance sheet always balances.