Quarters Function

[Chandrashekhar]

I am searching for function to calculate quarters in a year to calculate the interest amount on Quarterly basis?

[davesexcel]

here's a place to check your answers

http://www.easycalculation.com/compound-interest.php

=PMT(6%/12,30*12,180000)

here is a cool userform you could make

http://www.functionx.com/excel/appli...ndinterest.htm

this site has some sort of down load you could use as an example
http://www.vertex42.com/ExcelTemplat...rtization.html

[Chandrashekhar]

I think i have not placed my quastion right, attached herewith the worksheet which may give you general idea what formula i am looking for.
Rate of Interest 10.5%
Construction period 3 3
Loan Moratorium Years 2 8 Quarter
Loan Tenure Years 10 40 Quarter
Door to Door tenor Years 15 48 Quarter
Repayment 40 Quarterly Installments

Principle 100 2.5
Starting Month of Operations Sep-11
Repayment starts from year Sep 2013 and end Aug 2023
formula should set for following results
Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
5 10 10 10 10 10 10 10 10 10 5