This Class Schedule template is designed to help students plan their week. It is especially useful during course registration, to help avoid overlapping classes and fitting in a work schedule.
This free Mortgage Payment Calculator is for comparing various fixed-rate mortgages side-by-side. It can be used for both US (monthly compounding) and Canadian (semi-annual compounding) mortgages and also allows you to enter extra monthly payments.
This new Break Even Analysis spreadsheet is helpful for analyzing the financial viability of a new venture or product. It calculates the break-even sales (number of sales required to break even), the break-even price, or the payback period. Each scenario is a separate worksheet within the workbook. The download page also includes detailed information about the formulas used to calculate the break-even point.
This Monthly Planner Template is great for printing letter-size planner pages for a 3-ring binder. It is more than just a calendar. It includes a To-Do list and sections for monthly Goals and Notes. Unlike many of my other calendar templates, this one allows you to copy the worksheet so that you can have multiple months within the same workbook, which is nice if you are using this for planning rather than just printing a blank planner page.
This Weekly Meal Planner template lets you create your own list of main dishes, side dishes, breakfast and lunch meals. These lists appear as drop-down lists within the meal planner, making it easy to quickly select meals for the week.
The Monthly Menu Planner template also lets you customize lists, and can be useful for longer-term planning. It only includes space for one meal per day - mostly likely dinner. However, it could also be used for a school lunch menu.
This weekly planner spreadsheet lets you print a letter-size planner page that will fit common 3-ring binders. You can enter yearly events like birthdays and holidays and it will automatically add them to the planner (up to 3 events/holidays per day).
This Personal Budget Template let's you plan your budget for an entire year. My article How to Make a Budget explains how to use this budget template to keep track of expenses from month-to-month so that you can figure out an average for each expense category.
This BMI Chart was created in Excel using similar techniques as the Ideal Weight Chart. The spreadsheet also includes a BMI Calculator.
By request, I created a new loan calculator specifically for fixed-rate interest-only mortgage loans. It is based on my amortization schedule template, but allows you to enter the IO period in years and make extra payments during that time. At the end of the IO period, the loan is amortized using the current balance and number of years remaining.
I've added a new spreadsheet that includes a table, chart, and calculator for estimating your ideal weight. The Ideal Weight Chart uses the BMI, Devine, Robinson, and Miller formulas - all on the same graph - so it is fairly easy to compare them.
I created a new Printable Daily Planner that lets you print a letter-size planner page that will fit common 3-ring binders. There are no macros and it doesn't tie in to a database, so if you're looking for an electronic planner - something similar to the way Outlook works - this daily planner is probably not for you. However, you CAN enter yearly events like birthdays and holidays and it will automatically add them to the planner.
This new template is for recording what you eat and how much water you drink each day. Today was my first official day to use the food log, and I was surprised to find out that my typical bowl of Honey Nut Cheerios is actually 550 calories. I looked at the other cereal boxes that we have, and it appears as if the manufacturers just change the serving size so that every serving comes to about 110-120 calories. Interesting trick.
This timecard template is different than the other timesheet templates at Vertex42.com. Instead of just listing the hours worked each day, it lets you break down your hours by project. The hours are totaled by project and by day.
This checkbook template uses a formula for the balance that makes it very easy to add or remove transactions from the checkbook register. It also includes a column for recording an expense category. Although it doesn't let you include more than one category per row, you can split a transaction into multiple rows in order to specify different expense categories for a single transaction.
This new Shift Schedule template was designed for small businesses, such as a fast food restaurant. It is highly customizable, and was also designed to work in Google Spreadsheets and OpenOffice.org.
I just created a new Savings Calculator that estimates the interest earned in a savings account over time. It lets you include monthly and annual deposits, graphs your balance vs. investment, and creates an amortization table showing the interest earned each year.
The new 401k Calculator let's you estimate your future 401(k) balance at retirement. It is very simple to use and let's you include your employer match, annual raise. Perhaps the most unique feature of this spreadsheet is that it let's you specify a random rate of return so you can see how fluctuations in the market might affect your balance.
I just finished creating a New Year's Resolution Calendar for Excel that fits a whole year on a single page. It is designed to be used as a checklist for your top three daily goals, but it is pretty easy to modify to add or remove rows.
We created a fairly comprehensive Wedding Budget Template that groups items into major categories. The workbook also has a weddin budget estimator worksheet in which you can specify an allowable budget and allocate the amount available to various categories by specifying the percentage to go to each category.
To go along with the budget worksheet, we created a printable Wedding Checklist that you can print out and mark off as you go.
