App Development Cost Calculator Excel: Spreadsheet Layout
Build your own app cost spreadsheet in Excel or Google Sheets: the columns, the formulas, and engine benchmarks to check every row against.
Florin Florea
10+ years web dev · Scoping web projects since 2011
Some links in this guide are affiliate links — if you buy through one, I earn a commission at no extra cost to you. I only link to tools I'd use myself.
Want your specific number? Try our free calculator — it takes 2 minutes.
Open the Free Cost CalculatorQuick answer: the spreadsheet in one line
A simple mobile app (5 to 15 screens with user accounts) costs $32,250–$64,550 from a US freelancer (median $46,100) and $55,350–$110,750 from an agency (median $79,100), and an app cost spreadsheet is just that total broken into hours x rate per line. Those bands are the Project Cost Estimator engine's US mobile rows.
People search for an app development cost calculator in xls form because they want something they can edit, share with a co-founder and paste supplier quotes into. This page gives you the exact layout to build in Excel or Google Sheets in about ten minutes: the columns, the rows, the formulas written out, and the engine benchmark each total should land near.
The calculator above gives you the benchmark band in seconds. The spreadsheet is where you check a supplier's quote against it, line by line.
Mobile Web App / PWA Cost Calculator
Live estimateWeb app or PWA version of your app
Where's your developer?
Budget
$16,100
Realistic
$23,000
Premium
$32,200
Powered by the same 9-engine calculator behind every estimate on this site — full version →
The sheet layout: columns and rows
Create one sheet called Estimate with these columns in row 1:
| Column | Header | What goes in it |
|---|---|---|
| A | Line item | One feature or task per row |
| B | Platform | iOS, Android, both (cross-platform), backend, or design |
| C | Hours (low) | The supplier's lowest estimate for this line |
| D | Hours (high) | The supplier's highest estimate |
| E | Hourly rate | The rate on the quote, or a benchmark from the table below |
| F | Cost (low) | formula: =C2*E2 |
| G | Cost (high) | formula: =D2*E2 |
| H | Notes | What is included and what is not |
Then add these rows in column A, one per line. Delete what your app does not need; add rows for anything specific to it.
- 1. Discovery and specification
- UX and UI design
- Login and user accounts
- Main feature 1 (name it)
- Main feature 2 (name it)
- Payments or in-app purchases
- Push notifications
- Admin panel or dashboard
- Backend and API
- Third-party integrations (one row each)
- Testing on real devices
- App store submission
- Project management
Under the last line, total the two cost columns: =SUM(F2:F14) and =SUM(G2:G14). Those two cells are your quote range.
Benchmarks: what the totals should land near
Once the sheet is filled, compare the totals with the engine band for the same scope. US mobile rows:
| Scope | Freelancer band (median) | Weeks | Agency band (median) | Weeks | Monthly running |
|---|---|---|---|---|---|
| Smallest version (up to 5 screens, no accounts) | $16,100–$32,200 ($23,000) | ~5.5 | $27,600–$55,250 ($39,450) | ~4 | $176/mo |
| Simple (5–15 screens, user accounts) | $32,250–$64,550 ($46,100) | ~9.5 | $55,350–$110,750 ($79,100) | ~7 | $196/mo |
| Medium (accounts + payments) | $74,250–$148,450 ($106,050) | ~23 | $127,450–$254,950 ($182,100) | ~16 | $226/mo |
| Complex (roles, many APIs, AI chatbot) | $165,050–$330,100 ($235,800) | ~54.5 | $283,600–$567,200 ($405,150) | ~36.5 | $401/mo |
If your sheet total is well below the low end of the band, a row is missing. The usual missing rows are testing, the backend and project management. If it is well above the high end, the scope is bigger than the row you compared it with: move one row down the table and check again.
To turn a band into hours, divide by the hourly median. A US freelancer's simple app: $46,100 / $135 ≈ 341 hours. If your sheet adds up to 90 hours for a simple app, the supplier is either very fast or has left work out. Ask which.
A second tab for hourly rates
Add a sheet called Rates and paste the engine's custom-code hourly bands. Column E in the Estimate sheet can then pull from it with a lookup, so you can switch region and watch the total move.
| Region | Freelancer low–high (median) | Agency low–high (median) |
|---|---|---|
| US | $88–$218 ($135) | $145–$385 ($232) |
| UK | $72–$190 ($120) | $130–$319 ($202) |
| Australia | $72–$190 ($120) | $130–$334 ($202) |
| Western Europe | $65–$168 ($105) | $116–$283 ($185) |
| Eastern Europe | $29–$95 ($52) | $65–$168 ($105) |
| South Asia | $16–$62 ($31) | $36–$109 ($63) |
Put the region names in column A of Rates and the medians in columns B (freelancer) and C (agency). In the Estimate sheet, put the region in a single cell, say J1, and use =VLOOKUP($J$1,Rates!A:C,2,FALSE) for a freelancer rate or 3 instead of 2 for an agency rate. Change J1 from US to Eastern Europe and the whole sheet re-prices.
Same hours, different rate: 341 hours x $52 = $17,732 at the Eastern Europe freelancer median, against 341 x $135 = $46,035 at the US median. The work is the same size; only the hour price changes. More roles and platforms are in the rate database.
A third tab for running cost
The build is not the whole budget. Add a sheet called Running with one row per monthly or yearly cost and a column that converts each to a yearly figure.
- 1. Hosting, backend services and monitoring. The engine's figure is $176/mo for the smallest version, $196/mo for a simple app, $226/mo for a medium app and $401/mo for a complex one. A year for a simple app: $196 x 12 = $2,352; for a complex one: $401 x 12 = $4,812.
- Apple Developer Program membership (yearly) and Google Play registration (one-time). Enter the current amounts from their pages, linked in sources.
- Payment-provider fees, if the app takes money. Enter the provider's own percentage and multiply by expected revenue.
- Third-party services: maps, email, SMS, analytics. One row each, with the price from the vendor's pricing page.
- Updates for new iOS and Android versions. Enter hours per year x the hourly rate from the Rates tab.
Then make a Summary sheet: build total from Estimate + yearly total from Running = first-year cost. For a simple app built by a US freelancer at the median: $46,100 + $2,352 = $48,452 before store fees and third-party services.
Calculator or spreadsheet: when to use which
Use the calculator first. It gives you the band for your scope and market in a few seconds, with no setup. That band is the number to take into a first conversation with a supplier or an investor. The mobile app cost calculator covers every scope and market, and the general project cost calculator covers websites and web apps.
Use the spreadsheet once you have quotes. A quote is a total; the sheet turns it into rows you can question. Paste each supplier's hours into its own copy of the Estimate sheet and compare them side by side. The rows where two suppliers differ most are the rows to ask about.
Use both for a budget you have to defend. Put the engine band in the Summary sheet next to your own total. If they disagree, the gap is a question, not an error.
If your app is web-based rather than native, price it with the web app development cost calculator instead; the rows are similar but app store lines drop out.
Spreadsheet mistakes that hide real cost
One row called "Development". A single line cannot be checked. Split it until every row is a feature you can see on a screen.
Hours without a range. Every estimate is uncertain. Keep low and high columns, and plan on the high one.
No testing row. Testing on real phones is real hours. A sheet without it is a sheet that will be wrong.
Counting iOS and Android once when they are built natively. Two native apps are close to two builds. The engine's rows assume one codebase for every platform.
Forgetting the Running tab. A $196/mo running cost is $2,352 a year, every year the app is live.
Mixing currencies. Keep every figure in one currency. The engine bands on this page are all in USD.
Sources
App bands, timelines, running cost and hourly rates: Project Cost Estimator engine, calibrated against 600+ project quotes and public rate benchmarks across 6 markets. All figures in USD.
- - Methodology: https://projectcostestimator.com/methodology
- Rate database: https://projectcostestimator.com/rate-database
- Apple Developer Program: https://developer.apple.com/programs/
- Google Play Console registration: https://support.google.com/googleplay/android-developer/answer/6112435
- Microsoft, VLOOKUP function: https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Figures used, US mobile (freelancer / agency): smallest version $16,100–$32,200 ($23,000) / $27,600–$55,250 ($39,450); simple $32,250–$64,550 ($46,100) / $55,350–$110,750 ($79,100); medium $74,250–$148,450 ($106,050) / $127,450–$254,950 ($182,100); complex $165,050–$330,100 ($235,800) / $283,600–$567,200 ($405,150). Custom-code hourly (freelancer / agency): US $88–$218 ($135) / $145–$385 ($232); UK $72–$190 ($120) / $130–$319 ($202); Australia $72–$190 ($120) / $130–$334 ($202); Western Europe $65–$168 ($105) / $116–$283 ($185); Eastern Europe $29–$95 ($52) / $65–$168 ($105); South Asia $16–$62 ($31) / $36–$109 ($63). Running $176/mo, $196/mo, $226/mo and $401/mo; $2,352 and $4,812 a year. Arithmetic shown inline: $17,732, $46,035, $48,452.
Ready to build? Three ways to do it
The right path depends on budget, not preference. These bands come from our own published cost data.
Do it yourself
$0–$500
WordPress on cheap hosting like SiteGround — enough for a simple site you maintain yourself.
Hire a freelancer
$500–$5,000
Custom design and setup without agency overhead — the sweet spot for most small-business sites.
Browse Fiverrdevelopers →Custom project
$5,000+
Scope it properly before you talk to anyone — our calculator prices your exact feature list so quotes can't inflate.
Price my project →Magento & Shopify Plus
Scopebit
The agency behind this calculator builds, upgrades and migrates Magento and Shopify Plus stores for companies across Europe and North America.
Book a call with Scopebit →Disclosure: some links above are partner links — we may earn a commission at no extra cost to you. Recommendations come from our cost data, not from who pays us.
Get your personalized estimate
Our 9-engine calculator analyzes 30+ features, platform-specific rates, and your geographic market.
Start Free EstimateFree · No signup · Results in 2 minutes