P & L Forecast
Field Services Example
Operating Expenses
COGS
Gross Profit
$78,335
$940,020
$940,020
Earnings Before Taxes
$60,171
$722,053
$722,053
Net Earnings
$42,120
$505,437
$505,437
Revenue
Year 1
Year 3
Year 2
Assumptions
Direct Labor Costs
$33,575
$402,900
$402,900
Direct Operations Costs
$13,725
$164,700
$164,700
Direct Other Costs
$1,625
$19,500
$19,500
Total COGS
$48,925
$587,100
$587,100
Income Assumptions
Expense Assumptions
Tool Rental Income
48,500
$582,000
$582,000
Service Calls
$28,750
$345,000
$345,000
Tool Repair Income
$1,635
$19,620
$19,620
Parts Sales
$12,375
$148,500
$148,500
Other Operating Income
$36,000
$432,000
$432,000
Total Revenue
$127,260
$1,527,120
$1,527,120
Tool 1 Rental assumes
Tool 2 averages
days per month per tool at
Part Sales & Tool Repair income based on historical data
$/day and delivery fee of
per tool per month
per tool per month
Service Calls based on historical data plus Tool 1 delivery fee above
•
Payroll based on historical data + 3% raises + additional personnel added based on increased capacity needs
Direct Ops Cost based on historical data +
Tool 1 Battery Cost is
per pack- 1 pack lasts 30 days of use
Monthly Inputs
All other expenses based on historical data +
% increase
% year over increase + cost for tool 1 maintenance (mostly batteries)
Depreciation & Amortization
$36,000
$432,000
$432,000
Payroll Expenses
$12,500
$150,000
$150,000
Telephone & Comms
$180
$2,160
$2,160
Rent and Utilities
$600
$7,200
$7,200
Marketing & Advertising
$600
$7,200
$7,200
R & D
$975
$11,700
$11,700
Office Supplies
$250
$3,000
$3,000
Truck Payments
$1,909
$22,907
$22,907
Meals & Travel
$7,834
$94,002
$94,002
Building Maintenance
$7,834
$94,002
$94,002
Liability Insurance
$7,834
$94,002
$94,002
Dues & Subscriptions
$7,834
$94,002
$94,002
Donations
$7,834
$94,002
$94,002
Accounting & Legal
$7,834
$94,002
$94,002
Computer
$7,834
$94,002
$94,002
Interest
$7,834
$94,002
$94,002
Taxes
$18,051
$216,616
$216,616
Total Expense
$18,164
$217,967
$217,967