Freelance Business Startup Worksheets

January 22, 2008

I know it can be nauseating trying to figure out all the numbers that go into calculating startup costs, cash flow, taxes, etc…, for a freelance business. But, numbers can be a marvelous thing.

To help you get started, I assembled 7 Excel worksheets into a single workbook. The included worksheets will help you…

1. Calculate income replacement

2. Determine a purchase decision (based on tax implications)

3. Predict cash flow

4. Calculate a loan repayment

5. Calculate a day rate

6. Calculate estimated taxes

7. Track schedule “C” expenses

These are calculations that helped me when I first started. I realize there are probably hundreds more. I only included what I felt are the “meaty” calculations.

These worksheets contain macros for navigation purposes only. They have been scanned for viruses and—I guarantee—will not crash your system. If your security settings do not allow you to open the files, follow these instructions to lower your settings:

1. Open Excel (do not open the files)
2. Click the “Tools” menu, point to “Macro”, and then click “Security”
3. Click the “Security Level” tab, and then select “Medium”
4. This option will warn you before opening worksheets with macros

When you open the file, you will need to click “Enable macros” on the first pop-up screen. This will open the files correctly.

I tried to make it as simple as possible, even if you’ve never used Excel before.

Please leave comments if you have any questions.

Download - Freelance Business Startup Worksheets

Tags: startup worksheets, freelance worksheets, business startup spreadsheet, calculating startup costs