Business Budget Worksheets – Download

After reading and commenting on a post at BibleMoneyMatters about business income tracking, I used my caffeinated spreadsheet marauder skills to build a few more worksheets.

The following worksheets are included in the downloadable Excel workbook:

Income Replacement – Calculates what you’ll need to earn as a business owner to cover your living and business expenses. This is a biggie because it’s easy to forget that your business will also require monetary care and feeding.

Schedule C – This is a sample schedule C with an array of expenses you can write off throughout the year. This isn’t an all inclusive list. Please feel free to tailor to your needs.

Estimated Taxes – Shows you, based on net business income, what you’ll need to pay each quarter. Or, if you’re like me, how much you’ll owe at the end of the year.

Day Rate – Calculates what you’ll need to earn each day to reach an income goal. Assumes three separate billable days/cycles—160, 200, and 230.

Loan Repayment – Simple loan repayment calculator based on annual interest rate, loan length in years, and amount borrowed.

Cash Flow – Predicts yearly cash flow based on annual income and annual growth rate. Kind of a neat toy to play with. Allows for much daydreaming and good feelings.

Let me know what you think or if you have any questions.

Download files:
Business Budget Worksheets (.xls file)Excel – 97-07
Business Budget Worksheets (.xlsx)Excel – 2007+

3 Responses to “Business Budget Worksheets – Download”

  1. Peter September 10, 2010 at 8:42 am #

    Nice worksheet, tweeted!

  2. Jason @ Redeeming Riches September 10, 2010 at 12:36 pm #

    Nice job!

  3. Jerret September 10, 2010 at 1:28 pm #

    @Peter @Jason – Thanks! I appreciate the re-tweets. Peter, it was your post that prompted me to resurrect these worksheets. They had been half-finished, lying dormant on an old laptop. I’m glad I’m able to share.