Debt Service Calculator
Whether you are launching or growing a business, you will likely need outside funding. Can you afford the loans? How do the loans affect your profitability and cash flow?
To best understand the impact of the loans, you need to know a few things:
- How much money are you borrowing?
- What are the terms of the loan?
- What will be your monthly payments? If you know the amount and term of the loan, then calculating the monthly payment is straightforward.
For “quick and dirty” cash flow projections, knowing the monthly payment is sufficient to know how much revenue (and cash) you need to earn each month to support your monthly payments.
If you are assembling an investor package to include financial projections (Pro-Forma Income Statement, Balance Sheet and Cash Flow Statement), then you will need to look at the numbers with more detail. You will need to know the following information:
- Total Annual Debt Service: this is monthly payments (principal and interest) times 12.
- Monthly and Annual Interest Expense: Each monthly payment has a portion allocated to repayment of the principal and a portion is interest expense. The interest expense will appear on the income statement and as a cash outflow on Cash Flows from Operations section of the Statement of Cash Flow.
- Monthly and Annual Principal Repayment: Each monthly payment has a portion allocated to repayment of the principal and a portion is interest expense. The principal repayment will appear on the Cash Flows from Financing section of the Statement of Cash Flow. Further the amount of principal repaid will be used to calculate the ending balance of what is owed on each loan at the end of the year; this will appear on the balance sheet.
- Ending Balances for the Balance Sheet: At the end of each month, quarter and year, what do you still owe on each loan?
This worksheet calculates all the information you need for both the "Quick and Dirty" cash flow projections as well as the more detailed investor packages.
Need more help? Download our debt service calculator to calculate all these numbers for up to 5 loans. For even more support, we offer a half-hour phone consultation with screen-share to coach you through the use of this template.
Recipe Card: Vegetarian Sweet Potato Burgers
Download the two-sided, full-color recipe card with a detailed description of sweet potatoes, expert storage tips and an illustrated recipe for Vegetarian Sweet Potato Burgers from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Eggplant Curry
Download the two-sided, full-color recipe card with a detailed description of eggplant, expert storage tips and an illustrated recipe for Eggplant Curry from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Watermelon and Goat Cheese Salad with Minty-Citrus Vinaigrette
Download the two-sided, full-color recipe card with a detailed description of watermelon, expert storage tips and an illustrated recipe for Watermelon and Goat Cheese Salad with Minty-Citrus Vinaigrette from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Tender Turnip Vinaigrette
Download the two-sided, full-color recipe card with a detailed description of turnips, expert storage tips and an illustrated recipe for Tender Turnip Vinaigrette from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Moroccan Style Beet Salad
Download the two-sided, full-color recipe card with a detailed description of beets, expert storage tips and an illustrated recipe for Moroccan Style Beet Salad from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: French Onion Soup
Download the two-sided, full-color recipe card with a detailed description of onions, expert storage tips and an illustrated recipe for French Onion Soup from The Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Peas with Caramelized Onions
Download the two-sided, full-color recipe card with a detailed description of English peas, expert storage tips and an illustrated recipe for Peas with Caramelized Onionsfrom TThe Farmers Market Cookbook.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Recipe Card: Roasted Kohlrabi
Download the two-sided, full-color recipe card with a detailed description of kohlrabi, expert storage tips and an illustrated recipe for Roasted Kohlrabi from The Farmer's Kitchen.
For best results, we recommend taking the files to your local printer and printing on cardstock.
Contact us for volume discounts, if you'd like to download 10 or more recipes.
Chart of Accounts for QuickBooks - Restaurants (Mac)
QuickBooks is the industry standard accounting software. The Chart of Accounts lays out the structure of how you will input data; and more importantly how your Profit and Loss Statement and Balance Sheet will look.
We recommend that you organize your accounts into meaningful categories. The most common are:
- Cost of Goods Sold
- Direct Operating
- Payroll
- Repairs and Maintenance
- Occupancy
- General and Administrative
- Advertising and Promotion
Once you have your main categories you can create sub-accounts for things like cleaning supplies (under direct operating) or rent (under occupancy).
Our Chart of Accounts has all the the accounts that a restaurant will need, organized into major categories.
Need more help? We offer phone consultations with screen-share to coach you through the use of this template.