Calculate your hourly rate in Excel (German) | Calculation for the self-employed and freelancers | From desired income to hourly and daily rates
Price:$7.95
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
You enter your desired profit margin and your business costs. The file then calculates the hourly rate you need to charge.
The template can do that
- Your needs: Profit before taxes, health insurance, retirement savings, other insurance coverage
- Operating costs in twelve lines that you can rename
- Reserve as a surcharge in percent
- Billable hours: Working days after deducting weekends, public holidays, vacation and sick leave, multiplied by the proportion of billable time
- Result: Hourly rate net and gross, daily rate
- Counter-example: What's your net profit from your current hourly rate?
- Scenarios: How the rate changes at 30 to 90 percent occupancy
Honest advice
The calculation shows the rate you need. Whether the market will pay it depends on the industry, region, and product/service. The example figures are placeholders and not a recommendation.
What you get
- 1 Excel file (.xlsx), available for immediate download after purchase
- In German, in Euros, with quick start guide
- Yellow fields to fill in, everything else is calculated automatically.
- Without macros
What you need
Microsoft Excel from version 2010 on PC or Mac.
Good to know
This template is a guide only and does not replace tax or legal advice. Digital items are non-returnable and non-exchangeable. If something doesn't work, write to me and I'll take care of it.
Origin
Concept and review: Stefan Dangl. Implementation with AI support (Claude). All formulas have been verified using sample data.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Founder's Package Excel German | Hourly Rate Calculation, Cash Flow Plan and Quote Template | 3 Templates for Freelancers
$20.62
-
Digital download
Quote and invoice Excel template for cleaning companies | Hours, areas, jobs | Small businesses § 19 UStG | German
$14.86
-
Digital download
Quote and invoice Excel template for coaches and consultants | Sessions, packages, workshops | Small businesses according to § 19 UStG | German
$14.86
-
Digital download
Quote and invoice Excel template for photographers | Photoshoot, image editing, usage rights | Small business owner § 19 UStG | German
$14.86