Sat 11 Feb 2017

Downloads 12 - Template 10 - A Flexible Amortization Schedule Generator

By |Saturday, February 11th, 2017|Categories: Downloads||0 Comments

This flexible Amortization Schedule Generator can be downloaded from Amortization Schedule Template

1. You can specify Interest Rate not only annually but also weekly, monthly, quarterly and half yearly. Default is Yearly if nothing is specified.

2. You can specify Loan Period in weeks, months, quarters, half years and years. Default is Years if nothing is specified.

3. You can specify payment frequency not only monthly but also in weekly, quarterly, half yearly and annually also. Default is Months if nothing is specified.

4. You can also specify the decimal places to be shown in your figures.

5. PMT and few other financial functions have a parameter called TYPE which can also be specified. Default value is End.

6. It will automatically put the border around the data.

7. The schedule is valid for a period of 50 years.

8. If you are printing it, choose FROM and To pages otherwise it will print many pages which are not needed as formulas are contained in cells beyond visible data also.

Sat 23 May 2015

Tips & Tricks 92 – Financial Function – Calculate Effective Interest

By |Saturday, May 23rd, 2015|Categories: Tips and Tricks||0 Comments

You are applying for a loan and an interest rate has been quoted. The interest rate which is quoted is called "Nominal Interest Rate". They will quote Nominal Interest Rate in yearly terms. Hence, if they quote 12% interest for a loan, this is yearly figure. Now, you generally pay EMIs every month. They simply say that you need to pay 1% monthly interest which has been derived by annual interest rate / 12 which 12%/12=1% in this case.

Sat 16 May 2015

Tips & Tricks 91 – Financial Function – Calculate Compounded Interest

By |Saturday, May 16th, 2015|Categories: Tips and Tricks|Tags: , , |0 Comments

As part of our Mathematics courses in our childhood, we had learned about Compounded Interest. The famous formula which we remember is

Compounded Balance = Principal x (1+rate)^N

Sat 09 May 2015

Tips & Tricks 90 – Financial Function - Calculate Interest Rate

By |Saturday, May 09th, 2015|Categories: Tips and Tricks|Tags: , , , , , , , |0 Comments

You want to take a loan. You know how much loan to take (pmt), you know how many months you want to pay up (nper) and you want to know effective rate of interest.

Excel makes it easy to do. RATE function is the answer for this.

Sat 25 Apr 2015

Tips & Tricks 88 – Financial Function - Calculate Principal Part of an EMI

By |Saturday, April 25th, 2015|Categories: Tips and Tricks|Tags: , , , , , |0 Comments

This Tips and Tricks is in continuation of Tips & Tricks 84 – Financial Function - Calculate EMI. Now the EMI for a month = Interest for that month and Principal for that month. IPMT is used to calculate the interest portion of your EMI. This I talked about in Tips & Tricks 87 – Financial Function - Calculate Interest Part of an EMI. To calculate the principal part of an EMI, you will need to use PPMT.

Sat 18 Apr 2015

Tips & Tricks 87 – Financial Function - Calculate Interest Part of an EMI

By |Saturday, April 18th, 2015|Categories: Tips and Tricks|Tags: , , , , , |1 Comment

This Tips and Tricks is in continuation of Tips & Tricks 84 – Financial Function - Calculate EMI. Now the EMI for a month = Interest for that month and Principal for that month. IPMT is used to calculate the interest portion of your EMI.

Excel defines IPMT as "Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate"

Sat 28 Mar 2015

Tips & Tricks 84 – Financial Function - Calculate EMI

By |Saturday, March 28th, 2015|Categories: Tips and Tricks|Tags: , , , , , , |1 Comment

You want to take a loan and you want to calculate EMI OR you want to build an EMI calculator in Excel. It is a fairly easy job to do -

You will need to use PMT function for this. It has following structure -

PMT(rate, nper, pv, [fv], [type])