Equipment Rental Business Financial Model

Job ID: 40268743

Budget: $250 – $750 CAD

Scope of Work

Financial Model Build – Equipment Rental Business (Excel Only)

Overview

We are launching an equipment rental business and require a professional, institutional-quality financial model built in Microsoft Excel.

We have an existing template that has been partially customized, but it is clunky and not scalable. We are seeking a finance-trained modeler to rebuild and professionalize the model for internal use and capital raising.

This model will be used for:

Raising equity funding

Applying for bank/SBA financing

Internal planning and budgeting

Objectives

Build a clean, scalable, investor-ready financial model that:

Is structured with a centralized Settings/Input tab

Allows simple addition/removal of:

Unit categories

Individual equipment units

Operating expenses

Personnel

Automatically flows into:

Revenue projections

Expense schedules

Capex & debt schedules

Depreciation

Integrated financial statements

Dashboard outputs

The model must be intuitive for non-Excel-expert partners.

Core Requirements
1. Architecture

Clear separation of Inputs, Calculations, and Outputs

Structured tables (no fragile row references)

No unnecessary VBA

No hardcoded cross-sheet values

Clean sign conventions

Scalable timeline

2. Financing Logic

Dropdown-driven financing classification:

Rent to Own / Operating Lease → Operating Expense

Capital Lease / Purchase → Capex + Debt + Depreciation

Must automatically flow through the model.

3. Financial Statements

Fully integrated:

Income Statement

Cash Flow Statement

Balance Sheet
Must balance and reconcile properly.

4. Key Metrics

Model must support:

EBITDA

Cash flow

DSCR

IRR / ROI

WACC

Break-even

Utilization metrics

5. Dashboard

Professional presentation-quality dashboard suitable for:

Investors

Lenders

Internal meetings

Technical Requirements

We are specifically looking for someone with:

Corporate finance / investment banking / FP&A / PE background

Advanced Excel modeling skills

Strong accounting understanding

Experience building capital-intensive business models

Please provide:

1–3 examples of similar financial models you have built

Brief description of your role in those projects

Timeline

Engagement begins immediately

Initial completed draft due Wednesday

Revision window for changes on Thursday

Final delivery end of day Thursday