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.