Resources

Loan Calculator

Loan Calculator

Loans are an important part of our lives. This how most of us buy a house, a car, or pay for college. So it is important to understand to use a loan calculator before applying for a loan. There are three factors that determine you monthly loan payment: loan amount,...

How to create a Waterfall Chart in Excel

How to create a Waterfall Chart in Excel

A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...

How to cut and paste transpose in Excel

How to cut and paste transpose in Excel

A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...

Safety Stock Inventory Template

Safety Stock Inventory Template

This Safety Stock Inventory template is prepared for simulating orders and inventory positions according to Safety Stock policy. SigmaPedia defines Safety Stock as the inventory held in a process as a buffer against demand and supply variations. Starting inventory,...

Retirement Savings Calculator

Retirement Savings Calculator

This is an Excel based retirement savings calculator. Download the Excel template from the link below and start using it. It requires entering your current age, retirement age, investments up to now, expected annual return, annual payments and number of remaining...

Mortgage Calculator

Mortgage Calculator

This is an easy to use Excel mortgage calculator template. Simply download from the link below and start using it. It requires home value, loan amount, interest rate, loan term and property tax rate inputs. It calculates your monthly payments. It also calculates the...