Employee Payroll Calculator Template for Microsoft Excel® with HR Dashboards that is designed for small business. As the owner of the small business myself, I needed to have a Payroll System to pay my employees and at the same time be able to analyze financial data. Of course before I came up with the idea of making this payroll calculator, I have created dozens of individual timesheet templates as well as used few of well known payroll templates from Microsoft, which was a big help, but it also was taking a long time to calculate all of it individually. I needed something much more powerful than just a simple timesheet or a payroll to allow myself to safe some time and money.

I've decided to use the simple employee list spreadsheet, that I was using to keep track of the employees, their tax deduction and hourly rates, as a template to create a Simple Payroll System.

The payroll template, that is available for you to download contains five parts: Employee List, Payroll Calculator, Individual Payslips, which can be printed on the standard printer, HR Dashboards and Salary and Revenue Forecast. This worksheet works well together with our weekly timesheet template and timesheet with breaks template.

This simple Annuity Calculator can help you plan for retirement by answering questions like "how much will I need to have saved" or "how many years will my savings last". It let's you solve for the annuity payment, starting principal, or years to pay out.

For more detailed information about annuity calculations, visit the original download page: more information

This Depreciation Calculator contains 2 different worksheets.

The first worksheet is a basic depreciation calculator that includes the straight-line, sum-of-years' digits, and declining balance methods commonly used in financial reporting.

The second worksheet is a MACRS depreciation calculator based on the approach outlined in the IRS publication. It includes the option to select the half-year, mid-quarter, or mid-month convention.

... more information

This College Savings Calculator helps you create a college savings plan, including costs for elementary, middle, and high school.

... more information

This NPV Calculator spreadsheet will help you calculate the Net Present Value (NPV) and Internal Rate of Return (IRR) of a series of cash flows. It uses the NPV, IRR, XNPR, and XIRR functions.

Visit the official NPV Calculator download page for detailed information about How to calculate NPV and IRR.

This Amortization Schedule template creates an amortization schedule for a fixed-rate loan or mortgage, with optional extra payments.

... more loan calculators.