Excel Templates

[enlarge]

Present value calculator is a tool to calculate the present value of any investment based on the investment return you will received within your investment period. This is useful when you want to invest on something and want to calculate whether the return is bigger than just put your money in the bank. If the result of calculation (based on bank interest, period and yearly payment) is higher than your current investment value, than your investment is worth.

There are two kinds of calculator which created with different payment method available in this preadsheet and one comparator tool that compare side by side the present value calculated in both calculators. So, you can objectively compare the result and finalize your investment choice based on this present value calculator.

Download »

[enlarge]

You can use this savings calculator spreadsheet to calculate the growth of your money. You will need this if you plan to have some amount of money when you retired from your job, or plan a holiday travel or plan to pay a submission fee for your son school in the future.

And there is a comparator tables inside where you can compare several savings combination to find out the suitable savings plan based on your financial condition.

Download »

[enlarge]

This is an excel tool that can be used to convert three temperature scales, Celcius, Fahrenheit and Kelvin. In daily activities, you will need this tool because of different application usage of this scale. And probably that is one reason why Microsoft put this conversion as one of its built-in function that you can use easily.

Download »

[enlarge]

Amortization is a most popular term for people who plan to loan some money from bank for buying a house or a car. Amortization refers at the process of paying off a debt from a loan/mortgage over time through regular payments. A portion of each payment is for interest while the remaining amount is applied towards the principal balance. The percentage of interest versus principal in each payment is determined in an amortization schedule.

There are many types of amortization schedule tool created in excel spreadsheet you can find through internet because microsoft excel itself provide a built-in function that you can use easily to calculate your amortization or build your own amortization schedule. And this calculator is one of them.

Download »

[enlarge]

If you want to understand how your money will grow if you save your money in the bank, you should learn about compound interest. Compound interest is an interest that arises when interest is added to the principal everytime the interest is due, so the total amount will be calculated together to earn next interest. The addition of interest to the principal to get another interest is called compounding. You will see that some banks put advertisement about daily interest rate, weekly interest rate which mean your savings amount will grow based on that interest period. For example, a saving with $1000 initial principal and 1% interest per month would have a balance of $1010 at the end of the first month, $1020.1 at the end of the second month, and so on.

This excel spreadsheet will help you understand that calculation.

Download »