Spreadsheet Templates, Calculators, and Calendars

What's New at Vertex42

• 6/26/09: Free Exercise Log and Free Workout Log
• 6/23/09: Free Workout Chart for creating a weekly weight lifting program.
• 6/18/09: Free Exercise Chart
• 6/3/09: Free Sign In Sheets for meetings, patient appointments, visitor sign in / sign out, etc.
• 5/19/09: Create a Pareto Chart in Excel.
• 5/15/09: Vacation Accrual and Tracking template for employees and HR.
• 4/23/09: New Break Even Analysis Calculator for analyzing new ventures or products.
• 4/22/09: Free printable Monthly Planner template.
• 4/16/09: Free Meal Planner template and printable menu planners.
• 4/13/09: Printable weekly planner template.
• 3/31/09: Billing Statement Template that can double as an accounts receivable ledger for invoice tracking.
• 3/20/09: Expense Tracking template.
• 3/11/09: Invoicing article and a Weight Loss Chart template.
• 2/26/09: Calendars for Blogs, holiday calendar, and other ideas for Embedding Google Spreadsheets in Your Blog.
• 2/24/09: Created a printable grocery list template.
• 2/11/09-2/13/09: New Interest-Only Loan Calculator, Ideal Weight Chart and Calculator and Body Mass Index (BMI) Chart for Excel and in PDF format.
• 1/15/09: Printable daily planner template.
• 12/17/08: New articles: How to Make a Budget and How to Budget
• 12/15/08: Added many new yearly calendars.
• 11/13/08: Articles on Simple Interest and Negative Amortization, and a brand new Simple Interest Loan Calculator. Updated Amortization Chart template.
• 10/28/08: Added a Net Worth Calculator for Excel.
• 10/8/08: Created Financial Statement Templates, including a Balance Sheet template, Income Statement template, and Statement of Cash Flows.
• 8/12/08: Printable daily Food Log for keeping track of your calorie and water intake.
• 7/16/08: Many of the Vertex42 spreadsheet templates are now available in the new Google Docs Template Gallery.
• 4/30/08: Loan Calculator
• 4/23/08: Expense Report Template
• 4/22/08: Timesheets and a Timecard template
• 4/21/08: To Do List Template
• 4/19/08: Service Invoice and Sales Invoice and Purchase Order Template
• New Budget Spreadsheets :: We've created 4 new budget spreadsheets: Personal Monthly Budget | Personal Yearly Budget | Household Monthly Budget | Family Budget Planner
• Shift Schedule Template :: Organize your employee work assignments.
• Savings Interest Calculator :: Estimate interest earned in your savings account, with optional monthly or annual deposits.
• 401(k) Savings Calculator :: Estimate your future 401k balance, taking into account your employer match, annual raises, etc.
• Wedding Budget and Wedding Checklist :: These two new templates provide a comprehensive list of items to consider for wedding planning.
• Gas Mileage Log & Calculator :: Print a mileage log to keep in your car, and use the mileage calculator to create a mileage chart to track your car's performance over time.
• Debt Reduction Snowball Calculator :: Use the debt snowball strategy to pay off your credit cards, student loans, and other debts as soon as possible. Creates a printable payment schedule.
• Mortgage Calculator :: A feature-packed mortgage calculator for fixed or adjustable rate mortgages, with extra payment options.
• Home Equity Loan Calculator :: Three home equity calculators for (1) creating a payment schedule for a fixed-rate loan, (2) estimating how much money you can borrow, and (3) estimating how much equity you will have in your home X years from now.
• Credit Card Payoff Calculator :: If I make a monthly payment of $X.XX, how long will it take to pay off a credit card at the current interest rate?
• Free Canadian Mortgage Calculator :: Finally, an Excel spreadsheet designed specifically for Canada mortgage calculations.
• Free Auto Loan Payment Calculator :: Calculate the cost of purchasing a car or truck, create an auto loan amortization table, and analyze different loans to see the effect on the monthly payment and total interest.
• Free Printable Calendars :: Visit our new Calendar Nexus. This section of our website is THE place to download free calendars in a variety of colors and formats.
• Home Budget Worksheet :: A free spreadsheet for planning your family, personal, and home budget, plus a list of printable budget worksheets in pdf format.
• Excel Gantt Chart Template :: A free spreadsheet for creating simple project schedules and timelines.
• Loan Amortization Calculator :: This handy loan calculator is web-based, so you don't need to own Excel to use it. It was converted from some of the loan spreadsheets on this website. (6/10/2006)
• Retirement Planning Spreadsheet :: Estimate the value of an annuity at retirement. Compare total payments to interest earned. Run simulations with random annual interest rates and a variable number of annual payments. (12/13/2005)
• Stock Quotes in Excel :: This page provides a Stock Quote web query template and explains how to use the MSN Money Stock Quote Add-in to download free stock quotes into Excel.(12/6/2005)
• How to Create a Timeline in Excel :: A tutorial showing a new way of creating timeline using an XY chart with error bars as leader lines. (9/2/05)
• Adjustable Rate Mortgages: ARM Calculator :: Estimate monthly payments for 10/1, 7/1, 5/1, and 3/1 ARM loans. (6/4/05)
• Amortization Schedule (with optional extra payments) :: Yet another spreadsheet related to loans and mortgages. This one allows optional extra payments and includes rounding to nearest cent. (4/9/05)
• Extra Payment Mortgage Calculator :: A spreadsheet for calculating the amount of interest expense saved when making additional mortgage payments. (4/6/05)
• Balloon Loan Calculator :: Download a free loan calculator spreadsheet that creates a payment and amortization schedule for a balloon loan. (3/24/05)