People who are motivated to improve their personal financial status generally keep a budget. Using a personal budget helps keep spending and saving in perspective. Goals can be formulated and progress checked. Here’s just another option for tracking your personal budget in Excel. It’s designed to be
Read more →
An incremental purchase or sale of an investment can impact your average basis. The basis is your average cost of the original investment. For tax purposes, the method of computing the gain or loss on investments must be elected and consistently applied. This spreadsheet does not track
Read more →
Download this bank reconciliation template and incorporate it into your month-end close process. A bank reconciliation is a check between your records (or your company’s) and the banks records. It is a necessary control for every cash account. Going through the bank reconciliation process can identify errors and
Read more →
Enter the inputs for the loan, and a simple amortization schedule is produced. This schedule is designed using an Excel table, and includes a dynamic print range so only the applicable information will print. Simple Loan Amortization Schedule
Read more →
This schedule is very similar to the simple loan amortization schedule; however, it allows for additional payments to be added. Based on these additional payments, it calculates the amount of interest saved. Can’t make the same additional monthly payment? Do you have a little extra to pay
Read more →
The biggest purchase you’re likely to make in your lifetime is the purchase of your home. When looking for a home to buy, it becomes easy to get individual houses confused with one another. It’s difficult to keep up with all of the details. When it’s time
Read more →
How much money do you need in your emergency fund? The answer is, no one knows. There are a lot of variables to consider: how risk averse you are, number of incomes, extent to which your expenses are fixed vs. variable, amount of income earned from investments,
Read more →
Do you know how much you need to save for your child’s college education? Use this college savings calculator to estimate the total costs of college and the required yearly and monthly savings goals that will get you there. Of course, it’s impossible to know what the
Read more →
This template will help you quickly prepare a personal balance sheet (aka calculate net worth). A personal balance sheet is a simple tool in which all assets and all liabilities are listed. Net worth is calculated as total assets minus total liabilities. It’s not uncommon to have a
Read more →