Perne
Financial model and unit economics in Excel/Google Sheets: illustration 1
Business and analytics

Financial model and unit economics in Excel/Google Sheets

We work as a team. We build a spreadsheet where revenue, costs and per-unit indicators for a product or service are linked by formulas. When you change the price, purchase cost or number of customers, the model recalculates profit, margin, customer acquisition cost and payback period. We work in Excel or Google Sheets and keep the inputs on a separate sheet so the model is easy to maintain. Forecasts depend on the starting assumptions, so we show which ones matter most.

from 35,000 ₸ (≈ $70) one-off

timeline: 4–8 working days

  • Review of your business model and a list of the inputs we need
  • An inputs table on a separate sheet
  • Unit economics: revenue, cost of goods, margin per unit

Order

Message on WhatsApp
TelegramCall

The service name is added to the message for you.

This is a starting price; we give the final amount before work starts. USD is approximate.

What is included

  • Review of your business model and a list of the inputs we need
  • An inputs table on a separate sheet
  • Unit economics: revenue, cost of goods, margin per unit
  • Monthly revenue and cost forecast for 1 to 3 years
  • Break-even point, cash flow and payback period
  • Base, pessimistic and optimistic scenarios with a switch
  • A short guide to working with the model and two rounds of revisions

Who it is for

Suits entrepreneurs who want to know whether each unit of a product or service makes money, and business owners who need a model for planning and for talking to a bank. It does not suit you if you need IFRS financial reporting or a complex multi-user accounting system.

Not included

To avoid surprises, here is what the base price does not cover and what is discussed separately:

  • Collecting market and competitor data, which is a separate service
  • Audit, filing financial statements and tax calculations
  • Connecting bank statements or a CRM to update the numbers automatically

FAQ

After payment the file is fully yours: you can change it, copy it and use it in your work and negotiations. We do not use your model or data in other projects without consent. The file is delivered in Excel or Google Sheets, whichever you choose.

The price includes two rounds of revisions after the first version: changing assumptions, sheet structure and formulas. Adding new business lines or complex logic, such as tax schemes, is paid separately.

Usually 4 to 8 working days after we receive all the source data. If we have to look up the numbers ourselves, the timing shifts. We will name the date after discussing the task.

A description of the product or service, the price, cost of goods, load and sales forecast data, plus fixed costs and salaries. If the model is for a bank, send their format requirements. The more precise the data, the more precise the model.

We work in Excel and Google Sheets and use plain formulas without macros, so the model opens on any computer. We add macros and external connections only when they are needed. The file opens in both services.

Yes, we build a scenario switch or separate columns for each option. That shows how profit changes at different prices or sales channels. We build the comparison on the same assumptions so the results are fair.

The main risk is overstated sales and understated costs. That is why we put all assumptions in plain sight and mark the ones that are not verified. The model shows the result, but you make the decisions.

You may also need

Business plan for a launch, bank loan or grant

Business plan for a launch, bank loan or grant

We write a business plan with calculations that investors, banks and grant committees can follow.

from 45,000 ₸ (≈ $90) one-off

Timeline: timeline: 5–10 working days

Accounting spreadsheets: sales, warehouse, payroll

Accounting spreadsheets: sales, warehouse, payroll

Sales, warehouse and payroll tables in Google Sheets or Excel that calculate themselves and do not break when someone edits them.

from 18,000 ₸ (≈ $36) one-off

Timeline: timeline: 3–6 working days

Dashboards in Power BI and Looker Studio

Dashboards in Power BI and Looker Studio

A clear panel with sales, costs and key metrics in Power BI or Looker Studio that the whole team can read.

from 40,000 ₸ (≈ $80) one-off

Timeline: timeline: 5–10 working days

Shall we discuss your project?

The product name and a link to this page are filled into the WhatsApp message for you.

Message on WhatsApp
TelegramCall

Or send a request

We will reply in the channel you choose: WhatsApp, Telegram, phone or email. Your contact is used only to reply.

Service
How to reply

from 35,000 ₸ (≈ $70) one-off

Message on WhatsAppTelegramCall