Hire an AI vehicle replacement cash flow modeler

Everything it can hand back

Your task sets the actual outputs. The specialist picks the methods that cover them.

• Cash earned per loaded trip after fuel, driver, tolls and maintenance
• Yearly trip cash cost at the same workload, using your documented trip count
• Replacement cash by year: purchase less old sale, yearly differences and end-of-horizon difference
• Totals with and without discounting, kept apart
• Gaps for downtime, tax and financing, and checks that could not run

How it does the job well

• Reconcile to source documents, such as bank statements, ledgers and invoices, before reporting.
• Show the calculation, inputs and period for every figure.
• Label actuals, estimates and forecasts clearly.
• Send tax, legal and regulatory questions to a qualified professional.

Mistakes it avoids

• Mixing cash and accrual figures, or different periods, in one comparison.
• Rounding or formula errors that do not tie back to totals.
• Giving personal investment advice.

What a good result looks like

An example, not your task: A dealer quote for a new truck lands and you want to know if replacing beats keeping the old one.

• TRIP BASELINE. Cash earned per loaded trip after fuel, driver, tolls and maintenance, and the yearly trip cash cost.
• REPLACEMENT. Year-by-year cash of replacing against keeping, with totals before and after discounting.
• SOURCES. Each input with its source, date, currency and scale.
• GAPS. Downtime, tax and financing items you did not give, listed rather than guessed.
• MISSING and CHECKS MISSED. Each gap and the line it stops, and every check that failed or could not run.

How the work is checked

• Both vehicle cases carry the same workload; actual trip cost changes support annual savings; vehicle capital is not deducted twice. The end-of-period sale difference is replace minus keep, and the old truck's end-of-period sale value is not left out.
• Trace each material input to its source, date, currency, scale, sign and reporting period. Retain unresolved MISSING: lines.
• Use a discount rate that matches the cash flows: before loan payments or after them, not a mix.
• Keep hardcoded inputs separate from live formulas. Inspect changed inputs, actual recalculation, exported formulas and saved-file reopening.
• States which checks passed, failed or could not run, and names missing inputs.

These checks have not been run against a model yet. Your AI uses them to check its own work.

Capabilities

• Freight trip contribution builder. Reconciles loaded and empty distance from trip records, prices measured fuel and maintenance, adds driver and toll cash once, and compares with earned receipts. Hands step 2 cash per trip and the annual trip count. Check before moving on: each cost appears once.
• Fleet replacement cash comparer. Puts replacement purchase less the old vehicle's sale at time zero. Adds yearly differences and, at the horizon, new-vehicle sale minus the old vehicle's foregone sale. Discounts at your approved rate. Never uses trip contribution as a saving.

How the role works

1. Checks your task, context and available tools.
2. Picks the methods needed and prepares a work plan.
3. Carries out supported tasks, with each method's limits and review gates.
4. Checks the real deliverables and corrects supported faults.
5. Hands back files, evidence and unresolved gaps.

Your specialist's working setup

Download the base specialist without a task form or account. README.md and SETUP.md explain how to use the folder. SOUL.md defines its scope. INTAKE.md asks missing questions inside your AI. PLAYBOOK.md, SKILLS.md, BEST_PRACTICES.md, CHECKS.md and HANDOFF.md guide the work and its checked deliverables.

Complete associated skills, supporting files and licences are included. Choose only the methods needed for the actual task. Keep context, working files and accepted feedback in your AI project.

Use this specialist through MCP or the API

Call prepare_specialist with role_id compare-transport-cash-and-fleet-replacement only. No task is required to load it. Your AI asks what job you need done, what you want back and which relevant context it can use.

For task-led hiring, call find_specialist, explain the suggested specialists and let the user accept or change the team.

Complete ZIP: Download base specialist. API: GET /api/v1/specialists/compare-transport-cash-and-fleet-replacement/pack. The host AI supplies its own model, tools and execution; a pack does not connect accounts or run a task.

Inputs and helpful context

The specialist starts from the task brief. Only active methods require their inputs.

For the primary method, when used

• Loaded and empty kilometers for comparable trips (from trip logs)
• Measured fuel use per kilometer, diesel price, driver pay, tolls and maintenance cash (from fuel cards, payroll and invoices)
• The earned receipts for those trips, and the yearly trip count (from invoices and your records)
• The replacement quote and the old vehicle's sale evidence today (from dealer quotes or listings)
• The value of each choice at the end of the horizon: sale of the new vehicle, and sale of the old one if kept (from dealer quotes)
• The yearly operating savings you expect from replacing, with their source, and the discount rate your finance approver uses

Helpful context (optional)

• Fuel-card exports for the same trips as your logs.
• A written dealer quote and a second used-vehicle valuation for the old vehicle.
• A named reviewer who knows how the fleet is used.

Tools and access

• A spreadsheet engine and file-capable AI: Builds a workbook with inputs, formulas and a checks tab you can click into. In plain chat it returns the same tables as text and says no workbook was made.
• A spreadsheet engine and file-capable AI: Create, recalculate, render and reopen the requested native workbook.
• Node.js 20 or later: Run the bundled dependency-free reference calculation against explicit numeric inputs. Without it, the AI does the sums in chat.
• Node.js 20 or later: Run the bundled dependency-free reference calculation against explicit numeric inputs.

Functions and deliverables

• Vehicle replacement cash flow modeler: Review current trip costs, then compare the extra cash costs and savings from replacing a vehicle on the same workload.
  • Cash earned per loaded trip after fuel, driver, tolls and maintenance
  • Yearly trip cash cost at the same workload, using your documented trip count
  • Replacement cash by year: purchase less old sale, yearly differences and end-of-horizon difference
  • Totals with and without discounting, kept apart
  • Gaps for downtime, tax and financing, and checks that could not run
• Freight trip cash margin calculator: Share loaded and empty miles, fuel and trip costs. Get fuel totals, cash cost and contribution before overhead.
  • Total kilometers and total fuel in liters for the trip
  • Fuel cost, maintenance cost and total trip cash cost
  • The contribution of the trip: receipts less total cash cost
  • A check that loaded plus empty equals total kilometers
  • A list of figures that were missing, and the result each one held back
• Vehicle replacement cost analyst: Share replacement costs, sale values and savings. Compare the cash effect of replacing a vehicle or keeping it.
  • A cash schedule for time zero, years 1 to 3 and the end of term.
  • The present value of that extra cash, and the net benefit.
  • An editable workbook with inputs, formulas and test cases.
  • A list of missing inputs and checks that did not run.
• Toll road revenue cash modeller: Share billable traffic, tolls and collection assumptions. Get three years of receipts and cash after operating costs.
  • Billed receipts, cash receipts and operating cash for each of the three years.
  • An editable workbook of the toll revenue model, with its inputs, formulas and test cases to rerun.
  • A tie-out of chargeable passages, receipts and operating cash, the inputs still missing and the checks that ran.
• me.md builder: Answer a few questions, or let your AI use what it remembers. Get one private file that tells any AI who you are.
  • One me.md file with up to ten dated sections
  • A list of facts taken from memory, for you to check
  • A short note of what it removed for privacy
  • The two next steps, to save it and set it up

Tasks you can use it for

• A dealer quote for a new truck lands and you want to know if replacing beats keeping the old one.
• You want to know what one loaded trip earns after fuel, driver, tolls and maintenance.
• Your lender or partner asks for the cash case behind a fleet replacement.
• Fuel use on the old vehicle looks high and you want to put a number on what it costs per year.

Limits to check before starting

• You only want to know if one route or trip pays. Use the Freight trip cash margin calculator on its own.
• You are choosing between purchases against a cash limit. Use the Purchase total-cost comparison analyst workflow.
• You have no trip logs, or no sale value for the old vehicle at the end of the horizon. Gather those first, because the comparison cannot run on a guess.
• You want advice on routes, driver hours, safety or carrier licensing. None of that is covered.

Best way to use this role

Give it one clear outcome, the actual files and a definition of done. Keep the work in one AI project so it can reuse checked context and earlier files.

• Download the workflow pack and give it to an AI that can read files, such as Claude, ChatGPT or Gemini. Use one that can make spreadsheets if you want a workbook.
• Attach your trip logs, fuel and maintenance records, the replacement quote and the old vehicle's sale evidence. Say the yearly trip count and the horizon in years.
• After step 1, check the loaded and empty kilometers match your logs and that each cost appears once.
• After step 2, check both cases carry the same workload, the old vehicle's end-of-horizon sale is not left out, and no vehicle cost is taken twice.
• Fill every MISSING line before anyone relies on the result. Nothing is bought, sold or signed. A person who knows your fleet should review the savings figures.

Read it as data

Read the complete role setup as JSON. Connect your AI to the AI Blocks MCP library and read aiblocks://roles/compare-transport-cash-and-fleet-replacement for its role instructions and pinned sources.

This is a prepared AI role. No task has run. Your AI carries out authorized work using its available tools and reports the actual deliverables and checks.