Excel Spreadsheets

Projecting your balance sheet can be quite a complex accounting problem, but that does not mean you need to be a professional accountant to do it or to benefit from the exercise. The desired result is not a perfect forecast, but rather a thoughtful plan detailing what additional resources will be needed by the company, where they will be needed, and how they will be financed. Using your last historical balance sheet as a starting point, project what your balance sheet will look like at the end of the 12 month period covered in your Profit & Loss and Cash Flow forecasts. How will the year’s operations affect assets, debts and owners’ equity? For example, if you are planning significant sales growth in the coming year, go through the balance sheet item by item and think about the probably effects of assets.

This model brings a micro economical point of view to credit risk modeling. The logic behind the model is that in its fundamental, all the money that makes it available to pay the outstanding debt is driven from the total revenue figure. The model is pretty basic and straightforward  that it captures the risks arousing from the variations in income statement items pretty well.

Nearly everyone who has ever started a business has underestimated the costs, and then faced the danger of running with inadequate capital reserves. The key to avoiding this pitfall is to adopt a rigorous approach to your research and planning. This spreadsheet is created to lead you through the process.

This spreadsheet allows you to check your computations of Jensen’s alpha, range on beta and expected return, given the output from a return regression (to accompany this spreadsheet you can download related excel spreadsheet here).

This spreadsheet provides a Fill In The Blank invoice form and is capable of creating and calculating invoices. You can easily create invoice using WYSIWYG form. If you are running a small business and all you need is just a simple invoice, this one may be the right billing tool for you.