Fractional CFO Library

Fractional CFO Library: 50 industry financial models, 128 Excel tools, 20 cash-flow and liquidity workbooks, and 14 AI and playbook packs. $499 USD one-time. Official FinModelsLab logo.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fractional CFO Library: 50 industry financial models, 128 Excel tools, 20 cash-flow and liquidity workbooks, and 14 AI and playbook packs. $499 USD one-time. Official FinModelsLab logo.
Fractional CFO Library workflow: select a business model, review Excel performance reports, plan cash timing, and use Claude resources to structure analysis.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

A finance library for your next client question.

Fifty industry financial models, a broad Excel reference collection and fourteen AI and playbook packs for planning, reporting and review.

Keep a range of operating formats available for the next business plan or client review. Match the company to a financial model, then choose the supporting reports, cash tools and procedures needed for the work.

50
Industry financial models
128
Excel tools and dashboards
20
Cash-flow and liquidity workbooks
14
AI, skills and playbook packs

Explore the library by operating sector

50 financial models

The 50-model library includes the FP&A selection and extends into healthcare, hospitality, manufacturing, energy, farming, asset rental and local operations. Each entry identifies its own illustrative business case. Open a model’s product page to inspect its scope before selecting your starting point.

Professional & business services10 models

  1. Professional & business services

    Accounting Firm financial model

    The Accounting Firm Financial Model is an Excel template for building five-year financial projections for an outsourced accounting practice. It converts accountant capacity, billable utilization, service mix, and hourly rates into revenue, then links staffing and operating costs to projected earnings.

  2. Professional & business services

    Consulting Firm financial model

    The Consulting Firm Financial Model is an Excel-based planning template for projecting a boutique management consulting practice from 2026 through 2030. It calculates service revenue from available consulting hours, billable utilization, the mix of five consulting services, and realized hourly fees.

  3. Professional & business services

    Digital Marketing Agency financial model

    The Digital Marketing Agency Financial Model is an Excel planning template for a remote US agency selling SEO, paid media management, social content, email campaigns, and analytics strategy. It connects billable capacity and realized service rates to monthly revenue, operating costs, staffing, and financial projections for 2026 through 2030.

  4. Professional & business services

    Web Design Agency financial model

    The Web Design Agency Financial Model is an Excel template for a remote U.S. agency billing small and midsize clients by the hour. Monthly calculations connect production capacity, service mix, rates, staffing, and expenses to projections for 2026–2030.

  5. Professional & business services

    Software Development financial model

    This Software Development Financial Model is an Excel template for forecasting a remote-first custom software studio in Richmond, Virginia. It converts delivery hours, billable utilization, five service rates, staffing, and operating costs into monthly financial projections for 2026–2030.

  6. Professional & business services

    AI Consulting financial model

    The AI Consulting Financial Model is an Excel financial planning template for a US boutique advisory firm selling AI strategy, data readiness, workflow prototyping, governance, and team training. It connects consultant capacity, billable utilization, service mix, and realized hourly fees to a monthly revenue forecast and related financial reports.

  7. Professional & business services

    Engineering Consulting Firm financial model

    The Engineering Consulting Firm Financial Model is an Excel template that builds monthly and annual financial projections from engineering staff capacity, billable utilization, service mix, and hourly fees. It connects the revenue forecast to direct costs, operating expenses, payroll, capital spending, financing, and financial reports.

  8. Professional & business services

    Architectural Firm financial model

    The Architectural Firm Financial Model is an Excel financial model for planning an independent US architecture studio. It converts scheduled professional hours, billable utilization, service mix, and realized hourly rates into a monthly revenue forecast and five-year operating projections for 2026–2030.

  9. Professional & business services

    Advertising Agency financial model

    The Advertising Agency Financial Model is an Excel template for building a five-year financial forecast for a US independent agency. It translates staff delivery capacity, billable utilization, service mix, and hourly fees into revenue, then connects the resulting costs to operating profitability.

  10. Professional & business services

    Cleaning Service financial model

    The Cleaning Service Financial Model is an Excel template linking subcontracted cleaning capacity, utilization, service mix, and hourly prices to monthly revenue and five-year financial projections.

SaaS, e-commerce & recurring revenue5 models

  1. SaaS, e-commerce & recurring revenue

    SaaS Startup financial model

    This five-year SaaS Startup Financial Model is an Excel template for a remote U.S. B2B workflow-automation software company serving small and midsize businesses. It projects paying accounts and subscription revenue from qualified trials, trial-to-paid conversion, monthly churn, account mix and monthly plan prices.

  2. SaaS, e-commerce & recurring revenue

    Subscription Box financial model

    The Subscription Box Financial Model is an Excel template projecting a Dallas-based direct-to-consumer lifestyle box service shipping across the contiguous United States. It connects subscriber acquisition, cancellations, theme pricing, fulfillment costs, staffing and startup funding across 2026–2030.

  3. SaaS, e-commerce & recurring revenue

    Print On Demand Store financial model

    The Print-on-Demand Store Financial Model is an Excel template for forecasting a U.S. direct-to-consumer gift store selling original designs through Shopify. It converts qualified store sessions, accepted-order conversion, category mix and selling prices into monthly sales and 2026–2030 financial projections.

  4. SaaS, e-commerce & recurring revenue

    Online Grocery Store financial model

    The Online Grocery Store Financial Model is an Excel template for an Indianapolis retailer that owns grocery inventory and delivers five curated basket formats. Buying households, order frequency, basket selection, and inclusive checkout prices drive monthly and annual financial projections.

  5. SaaS, e-commerce & recurring revenue

    Coworking Space financial model

    The Coworking Space Financial Model is an Excel planning template for a single independent, 100-workpoint coworking location in Columbus, Ohio. It turns membership capacity, occupancy, membership mix, and monthly realized prices into a 2026–2030 revenue forecast and connects those sales to staffing and operating expenses.

Consumer services & education5 models

  1. Consumer services & education

    Gym financial model

    The Gym Financial Model is an Excel template that connects paid memberships, inclusive package prices, operating expenses and staffing to financial projections. Its illustrative 2026–2030 operating case shows how a growing member base changes revenue and EBITDA.

  2. Consumer services & education

    Beauty Salon financial model

    The Beauty Salon Financial Model is an Excel planning template for a salon offering hair, color, facials, nails and waxing. It converts provider capacity, utilization, hourly pricing and service mix into monthly sales and a five-year operating forecast.

  3. Consumer services & education

    Daycare Center financial model

    The Daycare Center Financial Model is an Excel template for planning tuition, staffing, operating expenses, startup investment, and financial projections. It connects enrollment capacity and age-group tuition rates to monthly calculations and reports.

  4. Consumer services & education

    Dental Clinic financial model

    The Dental Clinic Financial Model is an Excel financial planning template for projecting a general dental practice from patient-service capacity, realized fees, direct clinical costs, staffing, and startup investment. It converts editable operating assumptions into monthly calculations and annual financial projections for 2026 through 2030.

  5. Consumer services & education

    Tutoring Center financial model

    The Tutoring Center Financial Model is an Excel template for building monthly financial projections for a one-to-one academic tutoring business. It connects tutor-hour capacity, student bookings, subject prices, staffing, operating costs, startup investment, and financing assumptions to revenue and financial reports.

Food & retail5 models

  1. Food & retail

    Restaurant financial model

    This Excel Restaurant Financial Model forecasts 2026–2030 sales for a 64-seat casual restaurant using seats, daily turns, service days, utilization, and five realized guest-ticket prices.

  2. Food & retail

    Coffee Shop financial model

    The Coffee Shop Financial Model is an Excel planning template that builds five-year financial projections for a counter-service coffee shop from daily drink demand, menu prices, beverage mix, operating costs, staffing, and startup investment. Monthly operating calculations feed the workbook’s financial statements and management reports.

  3. Food & retail

    Bakery financial model

    The Bakery Financial Model is an Excel planning template for an independent neighborhood retail bakery with on-site production and a staffed sales counter. It links daily baking capacity, the mix of products sold, menu prices, operating expenses, and staffing to monthly financial projections and annual reports.

  4. Food & retail

    Food Truck financial model

    The Food Truck Financial Model projects an owner-operated Austin grill truck’s meal orders, revenue, and operating results for 2026–2030. Sales are driven by capacity, utilization, seasonality, meal prices, and menu mix.

  5. Food & retail

    Grocery Store financial model

    The Grocery Store Financial Model is an Excel template for building financial projections from checkout transactions, items purchased, departmental prices, operating expenses, and staffing. Its illustrative operating case covers 2026 through 2030 and shows how these assumptions determine revenue and EBITDA.

Property, transport & production5 models

  1. Property, transport & production

    Property Management financial model

    This Property Management Financial Model is an Excel template for planning fee revenue, staffing, operating costs, and funding at an independent US residential manager. Its demand-based forecast converts managed-unit counts and monthly fees into financial projections for 2026–2030.

  2. Property, transport & production

    Real Estate Brokerage financial model

    This Real Estate Brokerage Financial Model projects qualified leads, completed transaction sides, negotiated fees, operating expenses, and EBITDA for an independent US brokerage over 2026–2030.

  3. Property, transport & production

    Construction Company financial model

    The Construction Company Financial Model is an Excel template for US contractors handling residential renovations, home additions, and small commercial fit-outs. It links active projects and earned-work prices to revenue, job costs, staffing, and financial reports.

  4. Property, transport & production

    Trucking Service financial model

    The Trucking Service Financial Model is an Excel template for planning freight revenue, operating costs, staffing, startup investment, and financial statements for a regional dry-van carrier. Its revenue forecast links available driving capacity to sold loaded miles and the realized price of each freight service.

  5. Property, transport & production

    Food Manufacturing financial model

    The Food Manufacturing Financial Model is an Excel template for planning a regional granola production business from pouch capacity and wholesale pricing through operating expenses, staffing, EBITDA, and financial reporting. It links editable operating assumptions to monthly calculations and annual projections.

Healthcare & care5 models

  1. Healthcare & care

    Dermatology Clinic financial model

    The Dermatology Clinic Financial Model is an Excel planning template for an independent outpatient practice. It connects one dermatologist’s scheduled clinical hours, procedure mix, realized professional fees, staffing, operating expenses, and opening investment to monthly calculations and financial reports.

  2. Healthcare & care

    Medical Spa financial model

    This Medical Spa Financial Model is an Excel template for a physician-owned, three-treatment-room clinical spa in Raleigh, North Carolina. It projects 2026 through 2030 from clinician-hour capacity, utilization, treatment mix, realized hourly pricing, operating costs, staffing, startup investment, and working-capital assumptions.

  3. Healthcare & care

    Home Health Care financial model

    The Home Health Care Agency Financial Model is an Excel template for a small, licensed, private-pay skilled home health agency in Columbus, Ohio. It connects visit capacity, utilization, service mix, realized prices, clinical purchasing, and management staffing to financial projections for 2026–2030.

  4. Healthcare & care

    Physiotherapy financial model

    This Physiotherapy Clinic Financial Model is an Excel template for projecting visits, service revenue, expenses, staffing, and EBITDA from 2026 through 2030. It calculates cash-pay outpatient revenue from appointment capacity and utilization, rather than a separate demand estimate.

  5. Healthcare & care

    Assisted Living Facility financial model

    The Assisted Living Facility Financial Model is an Excel template for forecasting resident revenue, expenses, staffing, investment, and financial statements. Occupied places and five all-inclusive care packages drive revenue without billing residents repeatedly for services.

Hospitality & recreation5 models

  1. Hospitality & recreation

    Hotel financial model

    The Hotel Financial Model is a five-year Excel template for planning room revenue, operating costs, and staffing for a 40-room independent select-service hotel. It converts available room nights, occupancy, seasonality, room mix, and realized nightly prices into financial projections.

  2. Hospitality & recreation

    Boutique Hotel financial model

    The Boutique Hotel Financial Model is an Excel template for forecasting room-night revenue, operating costs, staffing, and startup investment for a leased 30-room hotel. It connects room occupancy and tariffs to monthly calculations and financial reports for 2026–2030.

  3. Hospitality & recreation

    Bed and Breakfast financial model

    The Bed and Breakfast Financial Model is an Excel template for projecting lodging revenue, costs, staffing, and funding. Its capacity-based monthly forecast converts room availability, occupancy, seasonality, and room rates into sales.

  4. Hospitality & recreation

    Event Venue financial model

    The Event Venue Financial Model is an Excel planning template for estimating bookings, rental revenue, operating expenses, staffing, and EBITDA for an independent event hall. It converts editable dates, utilization, seasonal demand, event mix, and rental rates into monthly calculations and a five-year forecast.

  5. Hospitality & recreation

    Wedding Venue financial model

    This Wedding Venue Financial Model is an Excel planning template for projecting event bookings, package revenue, operating expenses, staffing, and EBITDA from 2026 through 2030. It connects editable assumptions to monthly calculations and management reports so owners can test the economics of a single venue.

Manufacturing, energy & farming5 models

  1. Manufacturing, energy & farming

    Chemical Manufacturing financial model

    This chemical manufacturing financial model forecasts revenue, costs, staffing, equipment and financial statements for a U.S. producer of water-based industrial cleaning liquids from 2026–2030.

  2. Manufacturing, energy & farming

    Solar Panel Manufacturing financial model

    This Solar Panel Manufacturing Financial Model is an Excel template for a U.S. solar-module assembly plant. It connects qualified line production and sales by module type to projected costs, staff, financial statements and investment reports.

  3. Manufacturing, energy & farming

    Solar Panel Installation financial model

    The Solar Panel Installation Financial Model is an Excel template for building 2026–2030 financial projections for a local residential rooftop solar and battery contractor. It turns homeowner inquiries, completed-project conversion, five installation packages, and contract prices into a monthly revenue forecast.

  4. Manufacturing, energy & farming

    Greenhouse Farming financial model

    The Greenhouse Farming Financial Model is an Excel template for planning a heated deep water culture greenhouse in Missouri. It connects growing capacity, saleable lettuce output, wholesale prices, operating costs, and staffing to financial projections.

  5. Manufacturing, energy & farming

    Poultry Farm financial model

    The Poultry Farming Financial Model is an Excel template for forecasting pasture-raised broiler production, direct sales, operating expenses, and funding from 2026 through 2030. It connects bird output and prices to revenue and EBITDA.

Assets, logistics & local operations5 models

  1. Assets, logistics & local operations

    Car Rental financial model

    This Excel car rental financial model translates fleet capacity, rental prices, utilization, and seasonality into monthly revenue, expenses, and illustrative five-year projections.

  2. Assets, logistics & local operations

    Construction Equipment Rental financial model

    This construction equipment rental financial model is an Excel planning template for forecasting machine-day rentals, operating expenses, startup investment, and financial performance. It connects fleet utilization, seasonality, and realized daily hire rates to monthly calculations and a five-year annual projection.

  3. Assets, logistics & local operations

    Car Wash financial model

    The Car Wash Financial Model is an Excel planning template for an attended, four-bay hand wash operating in a leased facility. It turns available bay hours, vehicle throughput, utilization, seasonality, and service-package prices into monthly sales and a 2026–2030 operating forecast.

  4. Assets, logistics & local operations

    Landscaping Company financial model

    The Landscaping Company Financial Model is an Excel template for projecting a suburban Raleigh, North Carolina landscaping business over 2026–2030. It converts one shared production-hour pool, service allocations and hourly prices into revenue, then deducts direct costs, operating expenses and payroll to calculate EBITDA.

  5. Assets, logistics & local operations

    Auto Parts Store financial model

    The Auto Parts Store Financial Model is an Excel template for planning sales, costs, staffing, startup investment, and financial statements for one independent parts retailer. It builds monthly calculations and a 2026–2030 forecast from editable assumptions.

A broad Excel collection, organised by the question

128 Excel tools

Choose a reporting or analysis workbook that fits the decision you are reviewing. Inspect its sample data, definitions, units and input structure, then adapt it to the business.

Reporting, planning and financial schedules18 tools

  • Monthly P&L Excel Dashboard

    Review monthly profit, budget variance and fiscal year-to-date results with an editable P&L dashboard and report.

  • 12-Month Rolling Forecast Excel Dashboard

    Keep the next 12 months of revenue, profit and cash in view as the latest closed month changes.

  • Expense Accrual Rollforward Excel Dashboard

    Follow opening accruals, additions and releases, then investigate differences against the ledger.

  • Revenue Recognition Schedule Excel Dashboard

    Schedule earned revenue across the relevant service or performance periods.

  • Actual vs Budget Excel Template

    Compare your budget with actual results in one Excel workbook, from the latest month to the year so far.

  • Annual Balance Sheet

    Organize year-end assets, liabilities, and equity in one structured Excel workbook, then review how the company’s financial position changes across annual periods.

  • Annual Financial Performance Dashboard

    Turn monthly financial actuals into a concise annual management view that compares the current year with the previous year across revenue, margins, operating costs, EBITDA, and net profit.

  • Annual Financial Statements

    Build a connected view of profitability, financial position, and cash movement across a five-year reporting period, then use the resulting statement summaries and charts to review how the business changes over time.

  • Annual Income Statement

    Turn annual revenue and expense figures into a structured profit-and-loss view that shows how sales move through gross margin, operating profit, and net profit.

  • Balance Sheet Template

    Organize a full year of monthly balance-sheet figures in one structured Excel view, then review how assets, liabilities, net working capital, and equity change from January through December.

  • Budget Template Excel

    Turn a scattered list of regular and time-limited costs into a structured expense forecast with clear dates, payment timing, and growth assumptions.

  • Financial Dashboard

    Turn monthly operating and balance-sheet data into a concise view of financial efficiency, liquidity, profitability, and performance against budget.

  • Financial Statements In Excel Format

    Build a connected 12-month view of profitability, cash movement, and financial position from one structured Excel workbook.

  • Monthly Income Statement

    Organize a full year of monthly profit-and-loss data in one Excel view, following revenue through gross margin, operating costs, EBITDA, EBIT, and net profit.

  • Performance Dashboard

    Turn monthly financial actuals into a structured current-versus-prior-year performance review, with the key income-statement metrics, variances, and trend charts visible in one workbook.

  • Scorecard Excel Template

    Turn strategy into a structured set of measurable key performance indicators, then compare actual performance with targets across Financial, Customer, Internal Process, and Learning & Growth perspectives.

  • Top Expenses Calculator

    Turn a long expense list into a focused view of the cost categories that have the greatest effect on total spending.

  • Top Revenues Calculator

    Turn a long list of revenue streams into a focused view of the categories that contribute most to total revenue and explain how those contributions change over time.

Customers, recurring revenue and sales24 tools

  • Sales Pipeline Coverage Excel Dashboard

    Review stage-weighted pipeline value and its relationship to the sales target.

  • Sales Funnel Economics Excel Dashboard

    Investigate conversion-stage economics and the constraint on the next incremental sale.

  • Marketing Contribution After Ad Spend Excel Dashboard

    Review how much attributable contribution remains after media spend.

  • Subscription Renewal Pipeline Excel Dashboard

    Review upcoming subscription renewals, their timing and the assumptions behind the renewal pipeline.

  • Realized Cohort Contribution Excel Dashboard

    Compare the contribution recovered per original customer across cohorts.

  • Customer Acquisition Payback Excel Dashboard

    Follow the recovery of acquisition spending through the contribution earned by a customer cohort.

  • Historical Cohort Retention Excel Dashboard

    Review customer and recurring-revenue retention by cohort, particularly for subscription formats.

  • SaaS MRR Bridge Excel Dashboard

    Explain the movement in monthly recurring revenue through its expansion, contraction and customer-change components.

  • Annual Churn Rate Calculator

    Measure customer and revenue churn in one structured Excel workbook, then review how retention performance changes from month to month across a 24-month reporting view.

  • CAC Payback

    Turn monthly acquisition spending, new-customer volume, and revenue per customer into a clear view of customer acquisition cost and the time required to recover it.

  • CAC To LTV Ratio Calculator

    Evaluate whether the value generated by a customer is proportionate to the cost of acquiring that customer, using a structured Excel workbook that brings CAC, lifetime value, payback time, and the LTV-to-CAC ratio into one monthly view.

  • Cohort Analysis

    Analyze how monthly recurring revenue develops after each acquisition month, so you can separate strong cohorts from revenue that fades quickly.

  • Cohort Customers Analysis

    Turn monthly customer activity into cohort-level retention and churn views, so you can see how groups acquired at different times behave as they progress through the customer lifecycle.

  • Daily Activity Report Template Excel

    Turn day-by-day sales activity into a structured view of performance against targets, with reporting by salesperson and clear daily, monthly, and year-to-date summaries.

  • LTV Calculator

    Estimate how monthly customer churn affects expected customer lifetime and revenue-based customer lifetime value, then review the movement of those metrics across a 24-month period.

  • Real Estate Sales Funnel Template

    Turn monthly real estate sales activity into a structured funnel view so you can see where prospects progress, where volume falls away, and how activity connects to contracts and closings.

  • Rule Of 40 In SaaS

    Turn a five-year SaaS profit-and-loss history into a focused view of the trade-off between revenue growth and operating profitability.

  • SaaS Company'S Magic Number

    Measure how efficiently recurring-revenue growth is being generated from marketing investment, using a focused Excel workbook that converts monthly operating data into a clear SaaS Magic Number.

  • SaaS Dashboard

    Bring customer acquisition, recurring revenue, unit economics, and cash runway into one monthly SaaS performance view.

  • SaaS Quick Ratio

    Evaluate whether recurring-revenue growth is strong enough to offset revenue lost through churn and contraction, rather than judging performance from net growth alone.

  • Sales Funnel Calculator

    Turn monthly visitor volume into a structured view of sales opportunities, engaged opportunities, and deals while accounting for the conversion assumptions and timing delays between stages.

  • Sales Tracker Excel Template

    Turn monthly sales activity into a focused dashboard that connects traffic, orders, customers, revenue, and conversion performance in one workbook.

  • Social Media Dashboard

    Bring paid-media efficiency and social-channel activity into one monthly reporting view, so you can see what marketing spend is producing and where performance is changing.

  • Subscription Revenue

    Turn subscription bookings into a structured monthly view of earned revenue and deferred revenue, so you can see when contracted value becomes recognizable revenue rather than treating every booking as immediate income.

People, capacity and compensation11 tools

  • Overtime or Outsourcing Excel Dashboard

    Compare available capacity and incremental costs when choosing overtime or outside support.

  • Sales Commission Economics Excel Dashboard

    Review commission payouts as eligible bookings move against the selected quota.

  • 9 Box Model

    Turn employee performance and potential assessments into a structured nine-box talent view that supports succession, development, and workforce review discussions.

  • Compensation Plan

    Structure roles, salary bands, employee positions, and promotion history in one workbook so compensation decisions can be reviewed against a consistent internal framework.

  • Excel Payroll Calculator

    Plan headcount and compensation in one structured Excel workbook, then review how hiring dates, work arrangements, salary assumptions, bonuses, taxes, and wage increases shape total payroll cost.

  • HR Dashboard

    Bring monthly recruiting activity into one structured Excel view so you can follow hiring volume, funnel movement, placement results, hiring speed, and recruiting-channel signals without rebuilding charts for each review.

  • HR Metrics Dashboard

    Turn monthly workforce data into a structured view of headcount, compensation, turnover, absenteeism, and employee movement so HR decisions are based on the same set of operating metrics.

  • Payroll Time Calculator

    Track each employee's worked and unworked days for a selected month, apply the daily rate tied to that employee's position, and review the resulting monthly pay in one structured Excel workflow.

  • Return On Employee EBITDA (ROEE) Ratio

    Measure how much EBITDA the business generates for each unit of employee-related spending, then review how that return changes as workforce costs and staffing levels move through the year.

  • Return On Saas Employees Or The Rose Metric

    This Excel workbook converts monthly recurring revenue and SaaS employee costs into the Return on SaaS Employees (ROSE) ratio, showing how much recurring revenue the company produces for each unit of employee-related expense.

  • Sales Tracking Spreadsheet

    Forecast sales-team hiring, ramped capacity, bookings and supporting roles where that sales structure applies.

Planning, projects and organisation18 tools

  • Fixed Asset Depreciation Excel Dashboard

    Review the depreciation schedule and the period in which each asset stops contributing depreciation.

  • Returns & Reverse Logistics Excel Dashboard

    Trace the effect of returned goods and reverse-logistics costs on contribution per unit shipped.

  • Customer Concentration Stress Excel Dashboard

    Stress the exposure to major customers and review the resulting effect on the business.

  • Bill Organizer Template

    Keep issued invoices, payment progress, outstanding balances, and overdue items in one structured Excel tracker instead of piecing the same information together across separate records.

  • Boston Consulting Group Matrix

    Turn a product or service portfolio into a clear BCG view based on two strategic dimensions: market growth and market share. The workbook organizes each item into Stars, Cash Cows, Question Marks, or Dogs so you can see where the portfolio is concentrated and where management attention may be needed.

  • Contact List Template

    Keep business or personal contact records in one structured spreadsheet, with configurable categories and a consistent set of fields for names, relationships, companies, phone numbers, email addresses, and social IDs.

  • Decision Matrix Template

    Compare competing choices with a structured weighted decision matrix instead of relying on an unranked list of pros and cons. The workbook turns criteria, importance weights, and option ratings into comparable weighted scores so you can see which alternative ranks highest.

  • Excel Calendar Template

    Plan a full year in one editable spreadsheet, then work month by month with space for events, tasks, holidays, and notes.

  • Excel Timeline Template

    Turn a list of activities into a visual project schedule that shows when work is planned, when it actually starts, how long it runs, and how much has been completed.

  • Goal List Template

    Turn a scattered set of tasks into three clearly separated lists, give each item a goal date, and keep the supporting notes beside the work instead of in a separate document.

  • Home Budget

    Plan a monthly household budget, record what actually happened, and see where income or spending moved away from the amounts you expected.

  • Hotel Booking Template

    Organize rooms, guest records, reservations, availability, charges, and booking performance in one Excel-based hotel operations workbook.

  • Household Budget Templates for Excel

    Bring household income, day-to-day spending, and cash balances into one structured monthly view so you can see where money is coming from, where it is going, and how each month changes your available cash.

  • Kanban In Excel

    Turn project work into a visible Excel workflow that shows what is waiting, what the team is working on, what needs verification, and what has been completed.

  • Monthly Recurring Revenue Excel Template

    Turn customer additions, churn, and recurring revenue assumptions into a structured monthly waterfall that shows how the subscriber base and active revenue change over time.

  • OKR Template Excel

    Turn quarterly Objectives and Key Results (OKRs) into a structured Excel tracking process that connects company-level goals with department-level execution and measurable progress.

  • Real Estate Investing Calculator

    Evaluate a rental-property purchase by connecting rent, vacancy, operating costs, capitalization rate, purchase price, and loan terms in one scenario-based workbook.

  • SWOT Analysis Template

    Turn a SWOT workshop or planning review into a structured set of priorities, strategy combinations, and follow-up actions instead of leaving the analysis as four disconnected lists.

Profitability, pricing and operating costs13 tools

  • Project Profitability Excel Dashboard

    Compare project contribution and the delivery capacity supporting the portfolio.

  • Customer Profitability After Service Costs Excel Dashboard

    Compare account profitability after the service activities and delivery costs used by each customer.

  • Product Contribution Portfolio Excel Dashboard

    Investigate which products drive contribution and why a SKU can sell more units while earning less.

  • Discount Approval & Margin Floor Excel Dashboard

    Compare proposed discounts with the margin floor and remaining discount headroom.

  • Target Profit Pricing Excel Dashboard

    Review price and volume assumptions against a defined operating-profit target.

  • Break-Even & Margin of Safety Excel Dashboard

    Examine the sales level needed to cover costs and the headroom above break-even.

  • E-commerce Contribution per Order Excel Dashboard

    Reconcile net sales, variable costs and contribution per fulfilled order.

  • Average Cost Of Service

    Measure the average operating cost required to serve an active customer, month by month, and see how changes in service spending or customer volume affect unit economics.

  • Break Even Analysis

    Turn fixed costs, variable costs, selling price, and a target profit into clear break-even requirements for your business, product, service, or proposed project.

  • Financial Profitability Ratios Calculator

    The Financial Profitability Ratios Calculator turns company financial figures into a structured set of margins, returns, per-share measures, and earnings-based valuation context. It helps business leaders and analysts see how effectively revenue becomes profit and how productively the company uses its financial resources.

  • Financial Return Ratios

    Evaluate how effectively a company turns its asset base, shareholders’ equity, and employed capital into earnings with a structured monthly return-ratio worksheet.

  • Operating Performance Ratios

    Turn financial-statement and operating data into practical efficiency measures that show how effectively the business uses assets, people, inventory, receivables, and supplier credit.

  • Price Volume Mix (PVM) Excel Dashboard

    Explain the movement between planned and actual revenue through product quantities, selling prices and mix.

Inventory, production and purchasing14 tools

  • Energy Cost Intensity Excel Dashboard

    Reconcile energy spending and review cost intensity against the chosen operating unit.

  • Cost of Quality Excel Dashboard

    Review the distribution of quality-related costs and the components driving the total.

  • Freight and Landed Cost Excel Dashboard

    Compare supplier and freight costs on a landed-cost basis per usable unit.

  • Inventory Reorder and Safety Stock Excel Dashboard

    Review stock cover, reorder triggers and safety-stock assumptions by SKU.

  • Procurement Savings Realization Excel Dashboard

    Bridge negotiated purchasing savings to the savings realised in the operating result.

  • Special Order Bid Floor Excel Dashboard

    Review the minimum economically supportable bid for an order using available idle capacity.

  • Make or Buy Decision Excel Dashboard

    Compare the relevant costs of internal production and external purchasing at different demand levels.

  • Bottleneck Capacity and Contribution Excel Dashboard

    Prioritise constrained capacity using contribution per bottleneck hour and demand limits.

  • Manufacturing Unit Cost Excel Dashboard

    Review manufacturing unit costs and the cost transferred from work in process.

  • Yield and Scrap Economics Excel Dashboard

    Trace physical output through production stages and review the economics of yield and scrap.

  • Supplier Discount Decision Excel Dashboard

    Evaluate the trade-off between taking an early-payment discount and retaining cash.

  • Inventory Efficiency & GMROI Excel Dashboard

    Compare gross profit earned against the capital held in inventory.

  • Comparison Spreadsheet

    Compare vendor or supplier offers in one structured Excel workbook, combining item-level prices and quantities with source totals so purchasing decisions are based on the same set of inputs.

  • Safety Stock Calculator

    Turn inventory timing and safety-stock assumptions into a month-by-month schedule for stock balances, purchase orders, supplier payments, and working-capital review.

Cash, funding and investment30 tools

  • Investment Appraisal Excel Dashboard

    Review the price an investor can pay when future receipts and investment assumptions change.

  • Prepaid Expense Release Excel Dashboard

    Schedule the release of upfront payments into the expense periods they support.

  • FX Exposure & Hedge Coverage Excel Dashboard

    Review uncovered currency exposure by currency and settlement month alongside hedge coverage.

  • Interest Rate Exposure Excel Dashboard

    Compare repricing buckets and the effect of higher rates on interest expense.

  • Debt Covenant Headroom Excel Dashboard

    Review covenant headroom and the agreement-based test limiting additional borrowing.

  • Revolver Borrowing Base Excel Dashboard

    Review borrowing availability after eligibility exclusions, reserves and existing drawings.

  • Loan Amortization Schedule Excel Dashboard

    Follow monthly principal, interest and outstanding balances for the selected loan.

  • Debt Service Coverage Excel Dashboard

    Compare available operating cash earnings with principal and interest commitments.

  • Lease Liability Schedule Excel Dashboard

    Follow lease cash commitments and the scheduled liability across future periods.

  • Customer Credit Limit Monitor Excel Dashboard

    Review credit exposure and orders that need release approval before shipment.

  • Startup Burn Multiple Excel Dashboard

    Compare cash burn with the recurring-revenue growth achieved during the selected period.

  • Accounts Payable Analysis

    Turn planned cost of goods sold and operating expenses into a structured accounts payable schedule so you can see when trade-credit obligations become cash payments and how the payable balance changes over time.

  • Accounts Payable Dashboard

    Turn monthly accounts payable data into a compact operating view of what is owed, what is overdue, how invoices are distributed, and how payables compare with available cash.

  • Accounts Receivable Dashboard

    Turn monthly receivables data into a focused view of outstanding balances, overdue exposure, invoice status, aging, and the relationship between accounts receivable and cash.

  • Accounts Receivable Turnover Formula

    This accounts receivable calculator turns sales timing and collection assumptions into a period-by-period schedule that shows when cash is collected and how the receivables balance changes.

  • Burn Rate Calculator

    Measure how quickly operating cash outflows consume available cash and translate that relationship into an estimated cash runway expressed in months.

  • Calculating Your Cash Runway Ratio

    Turn monthly cash balances, inflows, and outflows into a clear view of how long available cash may support the business.

  • CAPEX And OPEX Budget Template

    Plan major asset purchases with a structured capital expenditure schedule that connects spending timing to depreciation and the closing net book value of fixed assets.

  • Capitalization Table Excel

    Organize founder and investor ownership across successive funding rounds, then see how new share issuances change each holder’s percentage of the company.

  • Cash Flow Dashboard

    Turn monthly cash receipts and payments into a clear view of net cash movement and the closing balance available to the business.

  • Cash Flow Dashboard

    Turn monthly cash receipts and payments into a structured view of net cash movement and closing cash balance, so you can see where cash is coming from, where it is being used, and how the balance changes through the year.

  • Cash Flow Ratios Calculator

    Turn monthly cash-flow figures into focused operating and coverage ratios that show how effectively the business converts sales into cash and supports near-term financial commitments.

  • DCF Calculator

    Build a discounted cash flow valuation from operating assumptions, capital structure inputs, and projected free cash flow, then bring those figures back to a present-value estimate for a company or investment.

  • Excel Loan Payment Template

    Build a monthly repayment view for as many as three loan instruments and see how each borrowing affects principal payments, interest expense, and the outstanding debt balance over its term.

  • Financial Debt Ratios Calculator

    Turn monthly balance-sheet, earnings, interest, and operating cash-flow figures into a clear view of leverage and debt-servicing capacity.

  • Financial Liquidity Ratios Calculator

    Turn monthly balance-sheet inputs into a focused view of short-term financial capacity, so you can see whether current resources are keeping pace with obligations due in the near term.

  • Financial Valuation Ratios

    Turn share-price, earnings, sales, cash-flow, equity, growth, and dividend figures into a focused view of how the market values a company.

  • Investor Negotiation Calculator

    Model the economics of an equity negotiation by connecting an expected exit value, an investor’s required return, the timing of each investment round, and the ownership split between investors and founders.

  • Loan Amortization Schedule Excel

    Model a loan repayment plan in Excel by entering the financing terms and reviewing how each scheduled payment is divided between principal and interest.

  • Rolling 13-Week Cash Flow Excel Dashboard

    Plan customer collections and payment commitments in one rolling 13-week cash flow forecast. A compact dashboard shows the cash balance, minimum reserve and weeks that need attention.

Work through cash, working capital and funding questions

20 cash and liquidity workbooks

Cash planning, reporting and working-capital resources help you investigate receipts, obligations and funding. The broader selections also include the named cash-flow valuation tools. Every item below is separate from the Excel-tools list above.

  • 12 Months Cash Flow Statement Template

    Lay out twelve monthly periods in one cash planning table so you can follow expected receipts, scheduled payments, monthly net cash movement, and the resulting ending cash balance across a full year.

  • 3 Year Cash Flow Projection Template

    Build a three-year view of where cash is expected to come from, where it will be used, and how those movements affect the balance available at the end of each year.

  • Annual Cash Flow Excel Template

    Organize annual cash movements into a clear statement that shows where cash comes from, where it is used, and how each period changes the closing cash balance.

  • Annual Indirect Method Cash Flow

    Turn annual profit and balance-sheet movements into a structured view of operating, investing, and financing cash flow.

  • Budget vs Actual Cash Flow Analysis

    Compare planned cash inflows and outflows with recorded results, quantify the variance, and see how the difference affects monthly cash movement and the ending cash balance.

  • Daily Cash Flow Template

    Turn expected receipts and payments into a day-by-day view of available cash, so you can see when liquidity is tightening before deciding which collections, purchases, or payments need attention.

  • DCF Model Discounted Cash Flow Excel Calculator

    Estimate the value of a business or investment by translating operating forecasts into unlevered free cash flow, discounting those cash flows to present value, and calculating terminal value.

  • Monthly Cash Flow Statement

    Organize a full year of monthly cash activity in one structured Excel view, then see how operating, investing, and financing movements affect the cash available at the end of each month.

  • Monthly Cash Flow Template Excel

    Build a month-by-month view of cash coming into the business, cash leaving through operations and investment, financing activity, and the resulting cash balance across a 12-month period.

  • Monthly Indirect Method Cash Flow

    Turn monthly accrual-based results into a structured view of cash movement by reconciling net income with working-capital changes and other operating adjustments.

  • Profit vs Cash Calculator

    Compare operating profit with cash movement and review the working-capital and timing items that separate them.

  • Simple Cash Flow Template

    Turn individual cash receipts and payments into a structured statement that shows where cash came from, where it was used, and how the period changed your available balance.

  • Weekly cash planning

    Organise expected cash receipts and payments by week and follow the opening and closing cash balances.

  • Working Capital Cycle Excel Dashboard

    Review the connection between inventory, customer collection and supplier-payment timing.

  • Receivables Aging & Collections Excel Dashboard

    Review aging, overdue exposure and the receivables requiring collection attention.

  • Payables Due-Date Ladder Excel Dashboard

    Arrange upcoming supplier obligations by due date so concentrated payment periods are visible.

  • Collections Performance Excel Dashboard

    Review collection performance and the activity behind expected customer receipts.

  • Liquidity Buffer Stress Excel Dashboard

    Test cash-buffer assumptions and identify the timing and size of a potential liquidity shortfall.

  • Bank Reconciliation Excel Dashboard

    Trace bank and ledger differences to their adjusted balances and identify reconciling items.

  • Marketplace Payout Reconciliation Excel Dashboard

    Investigate differences between marketplace activity, settlements and the amounts received.

Give the finance review a defined method

14 AI and playbook packs

The named packs provide instructions, templates, worked examples and review checks for use with your own source information and compatible Claude access.

7 Claude Agents for Budget vs. Actuals

A monthly review from source intake and account mapping through revenue and cost analysis, management commentary and independent checks.

  • 7 agent files with required inputs, defined outputs, handoffs and review checks.
  • A formula-driven Excel workbook covering Monthly, YTD, Products, Drivers, Inputs, Mapping and Checks.
  • A four-page playbook, workflow instructions and a one-page reference.
  • Fictional budget and actuals CSVs, mapping files, driver evidence, expected control totals and a worked management note.
  • An optional Python calculation checker for the supplied example.
Use it for: Explaining revenue and operating-profit movements while keeping the calculations tied to their source evidence.

Finance Team Toolkit for Claude

25 finance playbooks covering data checks, planning, profitability, cash, funding and CFO decisions.

  • 25 editable Markdown playbooks and 25 copy-ready prompts.
  • Reusable CSV input templates, fictional sample data and worked answers.
  • A searchable start guide and catalogue, plus optional Python checks for the supplied examples.
Use it for: Giving a recurring finance task clear inputs, a defined method and an output another person can review.

12 Shopify Finance Agents for Claude

A Shopify finance kit organised around sales, cash and profit, with a worked close that traces figures back to their source records.

  • 12 Markdown agent definitions for Claude Code, with guidance for using selected roles in regular Claude chat.
  • An editable Excel control workbook with sales, cash, profit, SKU and reconciliation views.
  • A five-page PDF playbook, setup instructions and 12 synthetic source CSVs.
  • An independent Python calculation checker for the included example.
Use it for: Understanding how orders, returns, fees and costs connect to payouts, deposits and operating profit.

Pitch Deck Skills Kit for Claude

A slide-by-slide kit for preparing a pitch from company evidence, operating data and a funding plan.

  • 20 slide skills in Markdown, one deck builder and four prompts.
  • Five editable templates: company brief, evidence register, slide outline, slide blueprint and financial plan.
  • A complete Northstar example in PowerPoint with editable charts, tables and speaker notes.
Use it for: Drafting a pitch and checking that its financial claims can be traced to supporting evidence.

13-Week Cash Flow Forecast with 8 Claude Agents

A 13-week cash forecast and eight focused agent definitions for reviewing receipts, payments and minimum cash balances.

  • An editable Excel forecast comparing a base plan with a delayed customer payment.
  • Eight Claude Code agent definitions and a four-page PDF playbook.
  • Fictional source CSVs and a Python calculation checker for the worked case.
Use it for: Reviewing settlement-date cash timing and the week in which closing cash may fall below a chosen floor.

Finance Operations Kit for Claude

A collection of finance workflows, guides and templates for recurring planning, liquidity and performance work.

  • 32 Markdown workflows, including budgeting, cash forecasting, pricing and monthly reporting.
  • 8 guides and playbooks for preparing inputs, using Claude and reviewing the result.
  • 8 templates and trackers, including a company brief, assumptions register, report outline and funding-readiness tracker.
  • Four editable Excel workbooks covering cash, budget vs. actual, unit economics and a KPI scorecard.
Use it for: Preparing the inputs and review steps for a recurring finance process.

Xero + Claude FP&A Playbook - Free PDF

A 70-page English PDF containing 150 practical FP&A workflows for Xero information and Claude-assisted analysis.

  • 150 numbered workflows with a tip, required inputs, a copy-ready prompt and a specific check.
  • An index covering reporting, forecasts, performance analysis and management decisions.
  • Session guidance for reviewing reporting dates, accounting basis, currency and source totals.
Use it for: Preparing a source-based review from Xero reports and the operating information behind them.

The Claude Finance Department

A planning and review kit for founders, owners and small finance teams.

  • 32 task-specific workflows, eight practical guides and eight editable templates.
  • Four formula-driven Excel workbooks for cash flow, budget vs. actual, unit economics and a KPI scorecard.
  • A company brief, assumptions register and supporting reporting templates.
Use it for: Selecting a finance workflow and working through it with reconciled figures and explicit assumptions.

The Claude Sales Department

48 working resources for founders, consultants and small B2B sales teams.

  • Workflows, playbooks, question and script libraries, editable messages and CSV trackers.
  • One organised ZIP in Markdown and CSV, with a self-contained start page.
  • Task prompts for use with company context and the relevant source material.
Use it for: Structuring a sales task and reviewing the resulting draft or analysis before use.

25 Claude Skills for FP&A

25 self-contained Claude Skills for financial planning and analysis, from preparing source data to reviewing a management result.

  • 25 individual skill folders with editable Markdown instructions.
  • Fictional inputs, a worked answer and a local calculation checker within each skill.
  • Tasks spanning mapping, consolidation, data quality, period reconciliation, variance analysis and other FP&A reviews.
Use it for: Turning a repeated analysis task into an inspectable workflow with a worked example and defined checks.

QuickBooks + Claude FP&A Playbook - Free PDF

A 68-page English PDF containing 150 practical FP&A workflows for QuickBooks information and Claude-assisted analysis.

  • 150 numbered workflows, each with a practical tip, required data, a copy-ready prompt and a check.
  • An index for selecting the next reporting, forecasting or management-review task.
  • Session guidance for using reviewed exports or connected reports where the required tools are available.
Use it for: Structuring analysis from QuickBooks reports and related operating records.

AI Finance Roadmap & Prompt Pack

A learning roadmap from messy finance inputs to repeatable, reviewed AI workflows.

  • A 25-page illustrated PDF covering six learning stages.
  • Eight copy-ready instructions in a Markdown prompt pack.
  • Three fictional CSV files for a monthly reporting exercise, plus expected results.
  • A readiness checklist and a short start guide.
Use it for: Practising source preparation, variance analysis, review and management summaries against a worked answer.

AI Agent Loop Starter Kit for Claude

An inspectable code example for understanding the loop between a model, local tools and execution checks.

  • Editable Python source for the Claude adapter, three local tools, the execution loop and logging.
  • Task instructions, fictional contacts and a CSV price-list attachment.
  • 16 offline tests plus setup, validation and extension guides.
  • A package manifest for checking the downloaded files.
Use it for: Learning how an agent prepares a local email draft and validates the attachment; the example is a learning resource.

50 Finance Agents for Claude

50 specialist agent definitions for modeling, planning, valuation, cash management and reporting.

  • 50 Markdown role definitions with inputs, methods, deliverables, acceptance checks and example requests.
  • An Excel agent catalogue with a filterable directory and six workflow routes.
  • A 22-page PDF playbook and a coordinating Skill for Claude Code.
  • A synthetic retail financial example, expected results and a Python checker.
  • Templates for work orders, source and assumption registers, findings, change logs and structured handoffs.
Use it for: Choosing specialist roles and organising a finance task into explicit inputs, deliverables and review stages.
Fractional CFO Library: a workflow for selecting a business model, reviewing performance, planning cash and structuring the analysis.
Choose the files relevant to the question. The collection contains separate workbooks and guidance resources that you adapt to your business.

A practical starting point for the next planning or review task

Use the library across different client or business contexts. Select the model closest to the operating business and the supporting resources relevant to the decision, reporting cycle or planning task.

What you need

Microsoft Excel for the workbooks and your own compatible Claude access for the AI resources. Some workflows use Claude Code; selected instructions can also be used in regular Claude chat. Code-based examples may require Python and separate API access, as stated in their setup guides.

How to begin

Review the selected file’s scope, inspect its worked example and prepare the required inputs. Adapt the assumptions and reporting periods, then compare the calculations with your source information.

Is this one combined workbook?

The bundle contains separate files, each with its own structure and instructions. Select the tools that fit the task and the operating business.

What do the counts mean?

The four groups contain 212 named catalogue products. AI packs include multiple files; the counts do not represent a total of unique agents or individual worksheets.

Are the examples actual business results?

The financial-model cases and supporting examples are illustrations for planning and review. Replace the relevant assumptions with information appropriate to the business.

Are software subscriptions included?

Use your own Excel and Claude access. Software subscriptions, API charges, custom integrations and individual consulting services are separate from this digital collection.

Some supporting dashboards and AI resources are also available individually at no charge. This bundle combines the selected industry financial models with the named supporting resources. Created by Henry Sheykin / FinModelsLab.