Skip navigation.
Home

Templates

Sponsored Links

I am sure they will help you reduce the groundwork you need to do to begin any project.

The best part is that these templates are free for you to download and use. Whether you need a financial template to assist you with your budgeting efforts, or just want to plot out which chores need to be done by each family member, you can be assured that there is a template for it. Of course, there are other sources on the web for Excel Templates, but Excel depot gives you a simple list and takes you to the download pages for each of them (So you do not have to keep looking a lot).

 

Name Description
Loan amortization schedule Loan amortization schedule
Breakeven analysis Breakeven analysis helps you calculate how much you need to sell before you begin to make a profit. You can also see how fixed costs, price, volume, and other factors affect your net profit. Use this template to perform breakeven analysis.
College comparison worksheet College comparison worksheet
Ratio analysis This template helps management, finance, and accounting teams calculate and compare a set of business ratios to measure the operational performance of a business. After you calculate the ratios (quarterly and annually), you can compare them within an industry and track them over time to analyze the effectiveness and efficiency of the business.
Competitive benchmark analysis for financial services This template helps financial service executives and managers compare a company's key financial and operating metrics against competitors and the market.
Sales compensation model This template helps sales managers analyze the performance of their sales representatives and calculate their compensation. You can use this template to assess whether sales representatives have attained their revenue targets and to calculate their sales commissions.
Sales compensation model This template helps sales managers analyze the performance of their sales representatives and calculate their compensation. You can use this template to assess whether sales representatives have attained their revenue targets and to calculate their sales commissions.
Job Decision Matrix Weighted factors decision matrix specifically for evaluating job prospects. If you're lucky enough to have multiple offers and can't decide which one you should take, this is my stab at helping decide. I've included weights and factors for myself, so you should definitely modify them, but it's a good start. It's also a good example for showing how to work with them (the other one I submitted may be to general to really be undestandable.)
TuitionEstimate Simple college tuition estimator. You can edit % increase per year and current tuition.
Competitive analysis using SWOT Competitive analysis using SWOT
Operating expense analysis This template is designed to help you create an operating expense analysis report that shows key expense items from your company's profit and loss statement over your financial year and compares actual expenses to budgeted expenses to generate a variance report and a comparison chart. Each worksheet in this workbook is divided into financial quarters so that you can track variance for months, quarters, or the entire fiscal year.
Project earned value analysis You can use this template on a periodic basis to take a snapshot of the current or future health of your project. This template uses source data to automatically produce trend analysis graphs that you can use to keep track of your project at a glance.
Customer profitability analysis Finance, management, and sales management professionals can use this template to assess the overall profitability of different customer segments. You can reconfigure the template to calculate profitability of individual customers by inputting data at the customer level rather than at the segment level.
Competitive market benchmark analysis Version: Excel 2003 or later
Loan amortization schedule Loan amortization schedule
Job applicant data and comparison table Job applicant data and comparison table
Break-even analysis Break-even analysis
Product profitability analysis This template helps finance, product management, and operations teams assess the overall profitability of specific products quarterly and annually. By conducting a product profitability analysis, your company can understand the direct and indirect costs associated with developing and offering a specific product and assess a product's contribution to the bottom line.
Market analysis This template is designed to help marketing, sales, and finance teams forecast the market share for a new product or service. You can use the template to forecast annual revenue and gross margin based on the market share forecast, and to generate charts that illustrate revenue and gross margin trends.
Treasury analysis worksheet This template helps professionals document and analyze their cash forecast targets, liquidity, and short-term assets, as well as a summary of their investments.
Bidder comparison worksheet and process This template helps you analyze competitors and solution discriminators to help position your bid and determine if your strategy is appropriate.
Debt ratio analysis worksheet Debt ratio analysis worksheet
Procurement analysis worksheet This template helps business owners and procurement professionals document and request capital, or operating goods and services.
Due diligence assessment model This template helps you analyze key aspects of a potential merger and acquisition target or of a strategic business partner by helping you identify and track important factors. It then produces a summary to help your overall decision-making. And, the template includes a worksheet containing a list of documents that you should analyze as part of any due diligence exercise.
Debt ratio analysis worksheet Debt ratio analysis worksheet
Partner marketing funds analysis This template is designed to help marketing channel managers analyze how their companies spent marketing funds allocated to channel partners. You can use the template to assess your company's spending on market development funds and cooperative funds for your channel partners.
Accounts receivable aging workbook Accounts receivable aging workbook
Loan analysis worksheet Use this template to compare various term and rate combinations for a new loan.
Cost of sales tool This template helps sales managers determine which of their company's customers are providing the best return for the company. You can use this template to determine the cost-of-sales percentage and gross profit per customer.
Risk assessment and financial impact model This template is designed to assist executives, risk management, and line management in analyzing the potential risks facing an organization, as well as mitigating controls that can be used to manage these risks. It allows you to weight the financial impact and probability of specified risks versus the cost of controls, in order to facilitate a cost/benefit decision analysis.
Prospect ranking tool This template helps sales managers to determine who their companies' best potential customers are. You can use this template to analyze prospective sales opportunities for your company and your competitors and to determine where best to focus your sales efforts and resources.
Prospect ranking tool This template helps sales managers to determine who their companies' best potential customers are. You can use this template to analyze prospective sales opportunities for your company and your competitors and to determine where best to focus your sales efforts and resources.
Training needs assessment Use this template to assess how many employees need training and the type of training they need. You can also keep track of your course lists and who provides each course.
Competitive analysis Competitive analysis
CD switch analysis CD switch analysis
Operating lease vs. own analysis This template is designed to help compare and analyze the financial data between leasing versus owning (purchasing) property, including asset lifetime cost comparisons and loan cash flow details.
Channel selection matrix Use this template to define business and consumer criteria for multiple potential sales channels. After assigning weights to your criteria, you can analyze your data to select the best channel for your business needs.
Supplier analysis worksheet This template is designed to help you analyze current and potential suppliers. By weighting the criteria that are important to your organization, you can calculate a weighted average score for each supplier and compare the effectiveness of different suppliers.
Return on marketing investment (ROMI) worksheet This worksheet provides a sample ROMI calculation worksheet for a direct mail program with varying rates of closure based on the expected lead quality level. It then compares it to the ROMI Hurdle Rate.
Intellectual property analysis Determine what kind of legal protection you'll need for your trademarks, copyrights, and patents.
Customer ranking tool This template is designed to help you assess customer value and where your sales dollars are bringing the greatest return for your efforts.
Law firm financial analysis worksheet This template can help law firms analyze their legal consulting engagements over the course of a year. You can use this template to capture the actual time frame, effort, and duration of each engagement.
My Personal Account Evaluate and control your Expenses from this Template
Sales opportunity review worksheet Because time is of the essence for any sales team, it's crucial to plan ahead and decide where to focus your efforts. One way to make the planning stages as efficient and productive as possible is to gather information about prospects in a centralized place so that everyone on your team can have access to the data. Use this template to collect the information you need about prospects, and then publish your worksheets to a shared network folder or web server.
Competitive benchmark analysis for manufacturing This template helps manufacturing executives and managers compare a company's key financial and operating metrics against competitors and the market.
ROMI hurdle-rate calculation This template provides a basis to calculate ROMI Hurdle Rates for product lines, business units, divisions, or the entire company for revenue sources by low, medium, and high risk programs.
ARM vs. fixed mortgage comparison ARM vs. fixed mortgage comparison
Product sales sample The ability to analyze sales data quickly for future opportunities is an important part of any salesperson's job. The sample data in this template, when used in conjunction with the article, "Use Excel AutoFilter to analyze sales data," will help you understand the basics of how to use the AutoFilter command in Microsoft Office Excel 2003.
Portfolio analysis Portfolio analysis
Fitness chart for women Fitness chart for women

You can practice addition, subtraction, multiplication, and division by either print sheets or directly entering answers. 2 sheets available for different types of practice. Check if you got all right answers by green or red colors!
College Degree Course Credits Tracker Track college courses, credits, professors and semesters. Keeps a running record of courses taken and courses left to complete for degree or certification.
Loan calculator with extra payments Loan calculator with extra payments 
Loan calculator  Loan calculator 
Mortgage qualification worksheet  Mortgage qualification worksheet 
Employee Time Card Calculator This is a little excel sheet I put together that allows you to quickly and easily calculate the hours an employee might submit to you when using paper time sheets or when just tracking hours by hand. It has four sliders to enter in the start and end times. The idea of which is so you can keep you other hand free to follow along with your finger on the page. Your other hand never leaves the mouse except to jot in the output. 
Daylight Calculator Calculate the number of hours of daylight for the entire year for your location based on your latitude.
Net worth calculator  Net worth calculator 
Vehicle loan payment calculator  Vehicle loan payment calculator 
Consumer debt manager  Consumer debt manager 
Bathroom remodel cost calculator Bathroom remodel cost calculator
Year-end tax planning calculator This template is designed to help personal financial analysts project their clients' income taxes at the end of the prior year. This year-end tax planning can help your clients understand how changes in tax laws and changes in their personal lives, such as a new child or a divorce, can affect taxable income. Note that this template contains a macro. When you download the template, a dialog box may appear asking if you want to enable macros. Click Enable Macros to ensure that the features in this template work properly.
TuitionEstimate Simple college tuition estimator. You can edit % increase per year and current tuition.
Payroll calculator  Payroll calculator 
Stock investment performance  Stock investment performance 
Currency rate calculator  Click Enable automatic refresh to get the latest currency rates. The process may take a few seconds to fully refresh the data.
Electoral College calculator  This template contains macros that have been validated by Microsoft. In order for the template to function fully, click Enable Macros when prompted during download.
Biweekly mortgage payment amortization  Biweekly mortgage payment amortization 
Large number math checker This template was created by John Marshall, Visio MVP and administrator of a Visio information site. It contains macros that have been validated by Microsoft. In order for the template to function fully, click Enable Macros when prompted during download.
Buy vs. rent home calculator Buy vs. rent home calculator
Closing costs calculator  Closing costs calculator 
Multi-family garage sale calculator Multi-family garage sale calculator
Real estate commission calculator  Real estate commission calculator 
Annuity investment calculator  Annuity investment calculator 
Buy vs. lease car calculator  Buy vs. lease car calculator 
Sales commission calculator  Sales commission calculator 
Kitchen remodel cost calculator  Kitchen remodel cost calculator 
Food fat percentage calculator  Food fat percentage calculator 
Bulk purchase depreciation calculator  This template helps accountants and other financial professionals calculate the book value and projected depreciation associated with assets that are purchased as a group by using a lump-sum payment.
College costs calculator College costs calculator
Depreciation methods comparison This template helps accountants and other financial professionals compute depreciation by using three methods: straight line, sum-of-years' digits, and declining balance. By using this template, you can compare the flow of depreciation for each depreciation method to help you decide which method to use for a particular asset.
Mortgage refinance calculator  Mortgage refinance calculator 
Net present value calculator By using this template, financial analysts can evaluate the expected impact of a capital budgeting project on the financial bottom line of a company.
Value analysis calculator for product or service  Use this template to create a quantitative analysis of the bottom-line impact that your product or service will have on the customer's business. The template will help you generate figures such as breakeven point and ROI.
Product pricing calculator  This template helps sales professionals calculate the price of bulk orders. You can use this calculator to price orders that include complex markups or product discounts, and to create detailed invoices.
Tip calculator  Tip calculator 
Life insurance needs calculator Life insurance needs calculator
Home office tax benefits comparison  Determine whether the tax on the sale would be larger than the tax savings on the deduction.
Total cost of ownership calculator  Use this template to document and evaluate your total product costs (and indirect costs) per year, and to create an annual cost comparison.
Sales costing calculator  This template is designed to help sales professionals determine the cost of the sales department and contrast this cost with the company's sales revenue. You can use this template to analyze your departmental spending in relation to your department's value to the company in revenue terms.
Balloon loan calculator  Balloon loan calculator 
Internal Rate of Return (IRR) calculator  By using this template, financial analysts can evaluate the return that a company would earn for a project or investment
Activity-based asset depreciation  Activity-based asset depreciation recognizes the change in an asset's value as a result of use, rather than time. Management accountants often use this method when it more closely matches economic reality. Use this template to calculate depreciation for each period based on units of use.
Step costs graph  This template helps you calculate step costs for your business. Step costs are those costs that stay the same for a certain level of activity. When you exceed that level of activity, these costs jump.
Price elasticity of demand calculator This template can help you evaluate how customer demand will change for products that you've test-marketed at different prices. You can also use this template to determine the best price to maximize revenue for the products. Note that this template contains a macro. When you download the template, a dialog box may appear asking if you want to enable macros. Click Enable Macros to ensure that the features in this template work properly.
Capital gains and losses calculator  Capital gains and losses calculator 
Gain on home sale calculator  Gain on home sale calculator 
Automated Resume and Application Processing (ARAP) savings calculator  This template can help recruiting specialists calculate the savings that could be realized by investing in recruiting software. You can use this template to compile data on your recruiting program and then calculate how your organization can benefit from an investment in recruiting software.
Personal net worth calculator  Use this template to quickly and easily calculate your clients' net worth. When you enter your clients' individual assets and liabilities, their total assets and liabilities are automatically displayed in a table and graphically represented on pie charts.
Intangible asset depreciation  The U.S. Internal Revenue Service generally requires you to amortize intangible assets, or Section 197 intangibles, over 15 years (180 months). Use this template to calculate the asset amortization for each period. The number of months in the first period is based on the acquisition date and your fiscal year, and no amortization is allowed for the month the asset is disposed of.
Weighted Factors Decision Matrix Simple spreadsheet that uses weighted sums to help you make complex decisions in which many factors are competing and in which you have at least two options. For instance, I have used this sheet to help me decide between jobs. You enter options along the top, factors down the left, assign weights (importance) to the factors, score the factors for each option, and look at the result. The magic of the spreadsheet is that it forces to you decide how important different factors are to you.
Lifetime savings calculator  This template determines the total wealth you can accumulate in your lifetime if you were to opt to reduce one monthly expense and invest the amount saved at a reasonable rate of interest. The calculator also determines the amount that you could withdraw each month after retirement from this investment.
A cutting diet  Community template. This template has been supplied by a member of the Microsoft Office Online community. Microsoft does not promise that it will work for your purposes or be free from viruses and defects. The Microsoft Service Agreement applies to your use of this template.
Annuity payout calculator  Annuity payout calculator 
2007 Tax Calculator This tax calculator will help you analyze your tax rates and taxes due based on your specific income and State/Federal filing status (married, single, head of household, etc.). Consult a tax professional for your tax decisions -- this is an advisory calculator only. This tax calculator is brought to you by Spreadsheet Marketplace.
21st century pie char 21st century pie chart
Fitness chart for men Fitness chart for men
Fitness chart for women Fitness chart for women
Fitness progress chart for women (metric) Fitness progress chart for women (metric)
Normal Blood Sugar Chart Blood sugar chart
Simple flowchart Simple flowchart
Baby growth chart Baby growth chart
Excel Gantt Chart Template to create Gantt charts using Microsoft Excel.
Production errors scatter chart Production errors scatter chart
Family tree Family tree
Control chart Control chart
Revenue trend charting his template can help you project future revenue by creating graphs with various revenue trendlines. After you enter your baseline sale data, you can view separate graphs with linear, power, exponential, and other trendlines.
21st century donut chart 21st century donut chart
Cost analysis with Pareto chart Cost analysis with Pareto chart
Run chart Run chart
Problem analysis with Pareto chart Problem analysis with Pareto chart
Manufacturing output histogram Manufacturing output histogram
12 month profit and loss projection 12 month profit and loss projection
Small business cash flow projection Adequate cash flow is essential to the survival of a business. This template can help you predict whether your business will have enough cash to meet its obligations. Projected cash balances below the minimum amount you specify are displayed in red. You can also see a chart of your projected monthly balances
Detailed sales forecast Estimating monthly sales projections for a year is easy with this template, because formulas and other worksheet features are already set up for you. The forecasting model uses weighted forecasts based on the probability of closing each sales opportunity.
Four-year profit projection Four-year profit projection
Proyeccion de perdidas y ganancias de 12 meses Proyeccion de perdidas y ganancias de 12 meses
Pipeline management solution sales worksheet Sales organization managers can use this template to review the quarterly solution sales pipeline over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
Hoja de balance proyectado Hoja de balance proyectado
tactical sales worksheet Sales managers can use this template to review the monthly sales pipeline over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
12 month sales forecast 12 month sales forecast
Streamlined sales forecast Estimating quarterly sales projections for a year is easy with this template, because formulas and other worksheet features are already set up for you. The forecasting model uses weighted forecasts based on the probability of closing each sales opportunity.
product sales worksheet Sales organization managers can use this template to review the quarterly product sales pipeline over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
Pipeline management strategic sales worksheet Sales organization managers can use this template to review the monthly sales pipeline over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
Proyeccion de ventas de 12 meses Proyeccion de ventas de 12 meses
Sales account adjustment forecast This template makes it easy for sales professionals to forecast sales by account because formulas and other worksheet features are already set up. You can use this template to track sales by district, account executive, account, and account status. You can also use this template to manually adjust forecasted sales based on how likely they are to become firm orders.
streamlined worksheet Sales organization managers can use this template to review quarterly sales pipeline figures over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
Detailed sales pipeline management Sales organization managers can use this template to review the monthly sales pipeline over the course of a year. The forecasting model in the template calculates weighted forecasts based on the probability of closing each sales opportunity.
Five year projection worksheet Five year projection worksheet
New product sales and profit forecasting model This template allows financial analysts to evaluate different sales and income scenarios for a new product. The template allows users to conduct two sales and income forecasts: one based on a target operating income scenario and another based on a target market share scenario.
Channel sales forecast A channel sales forecast helps you establish goals based on the key channels that your company is targeting. Creating a channel sales forecast is easy with this template, because formulas and other worksheet features are already set up for you.
Channel partner pipeline forecast Sales and finance professionals can use this template to track and forecast sales opportunities with channel partners.
Waterfall forecasting model Financial professionals can use this template to analyze key line items from the profit and loss statement and balance sheet on a monthly basis. The user can enter forecast and actual data in this template and determine monthly progress toward an organization's financial goals.
Balance sheet Balance sheet
Two-year balance sheet with instructions Two-year balance sheet with instructions
Balance sheet with financial ratios Balance sheet with financial ratios
Projected balance sheet Projected balance sheet
Opening day balance sheet Opening day balance sheet
Two-year balance sheet Two-year balance sheet
Cashier balance sheet This template has been supplied by a member of the Microsoft Office Online community. Microsoft does not promise that it will work for your purposes or be free from viruses and defects. The Microsoft Service Agreement applies to your use of this template.
Balance sheet with ratios and working capital Balance sheet with ratios and working capital
Balance sheet Balance sheet
Checkbook register Checkbook register
General ledger (multiple tabs) General ledger (multiple tabs)
Cash Receipts Report Simple Cash Receipts Journal Report
Sample payroll register This sample payroll register will help you follow along with the examples in the article, "Instant payroll totals for quarterly tax reporting." The article explains how to use the Excel 2003 List feature and AutoFilter feature to get customized totals from a payroll register.
General ledger General ledger
Bond amortization Bond amortization
Investment ledger This template is designed to assist finance and accounting teams in tracking key information regarding a company’s investments, including purchase date, initial cost (basis), current value, and unrecognized gain or loss on current investments.
Checkbook register Checkbook register
2006 World Cup tracker 2006 World Cup tracker
Grade tracker Grade tracker
Blood pressure tracker Blood pressure tracker
Medical bill tracker Medical bill tracker
Wedding guest tracker (tulip design) Wedding guest tracker (tulip design)
Employee absence tracker Employee absence tracker
Wedding gift tracker Wedding gift tracker
Charitable gifts and donations tracker Charitable gifts and donations tracker
Subscription and membership tracker Subscription and membership tracker
Weight loss tracker This template has been supplied by a member of the Microsoft Office Online community. Microsoft does not promise that it will work for your purposes or be free from viruses and defects. The Microsoft Service Agreement applies to your use of this template.
Blood pressure tracker Blood pressure tracker
Employee attendance tracker Employees and their supervisors often need to know information about the employee's time off, including how many vacation days they have left, how many sick days they've used, and if they have personal days remaining. This attendance tracking workbook provides a place for you to record attendance and also summarizes critical information for a scannable year-to-date status report.
Detailed leads tracking This template helps consultants track contact and sales information related to sales leads.
Warranty tracker Warranty tracker
Product or service cost tracker This template can help you evaluate the total costs for producing any product or service. And the template can compare production costs of multiple products, both on a per-unit basis and for total units produced per week.
Law firm project tracker This template can help you track your firm's legal engagements over the course of a year. Use this template to capture planned data and actual data for types and duration of legal engagements, workload, costs, and more.
Project time performance tracking You can use this spreadsheet to help your business track its projects over the course of a year. This template provides a format for capturing the planned and actual time frame, effort, and duration of your projects, and it provides a model for estimating workloads for a variety of projects. The template calculates and displays both the planned and actual work efforts for each project.

Teachers, use this template to track your continuing education credits and to help ensure they are correctly reported and processed by your school district.
Business debt tracker Business debt tracker
Commission tracker This template helps you track the sales commissions earned by your sales team. Sales managers can use this template to project and track the sales that your team generates and the commissions that they earn.
Event management project tracker Event management project tracker
Quarterly leads tracking This template helps personal financial analysts, consultants, and sales professionals track contact and sales information related to sales leads.
Marketing campaign tracker Marketing professionals can use this template to track time-sensitive tasks in campaigns. You can also customize this template and use it to track the action items leading up to your marketing deadlines.
IRS audit information tracker This template helps financial officers respond to audit-related communications and document requests. The template also helps financial officers manage questions or issues that arise from an auditor analysis.
Activity-based cost tracker This template helps you evaluate the total costs of producing a product by totaling the direct, indirect, general and administrative costs. You can use this template to help you determine pricing for your product or service.
OP MANUAL TIMELINE this is usefull for putting together large club manuals, to track pages and costs as well as what sections are complete or waiting approval