Excel formula and Islamic norms for home financing

Hasan, Zubair (2012): Excel formula and Islamic norms for home financing.

Abstract

This paper is in a series of writings on Islamic home financing. It spells out certain norms Islamic banks must observe in home financing and demonstrates that the conventional model based on an Excel formula does not meet the stated norms. It may well be emphasized that in Islam the question of observing these norms arises before not after the selection of the formula: additional juristic requirements may only follow subsequently. Is it not then queer that many Islamic banks are using the formula to determine the periodic installment payments in their home financing programs? The paper finds for example the popular MMP non-compliant of the stated norms. It presents a new model and argues that the alternative is not only fully observant but is superior to MMP on some other counts as well.

• Item Type: MPRA Paper
• Language: English
• Keywords: Home finance; Excel amortization formula; Compounding; Islamic norms; Justice; MMP
• Subjects: G - Financial Economics > G2 - Financial Institutions and Services > G21 - Banks ; Depository Institutions ; Micro Finance Institutions ; Mortgages

References

American Finance House – LARIBA: Financing alternative to the conventional, Riba System, Lariba.com Home Financing – Accessed on 24.10.2011

Chambers, M. S, Garage, C and Sehlagehauf, D (September 2007): Mortgage contracts and housing tenure decisions, Working Paper, Federal Reserve Bank of St. Louis (Research Division), pp. 1-40.

Hasan, Zubair (2012) Mortgage Contracts in Islamic Home Finance:MusharakahMutanaqisah Program vs. Diminishing Balance Model, International Journal of Banking and Finance (Forthcoming).

Hasan, Zubair (2012): Islamic home finance, INCEIF Blog postings, 16.5.12 and 18.5.12. www.inceif.org/blog.

Hasan, Zubair (2011): Islamic home finance in the social mirror, ISRA: International Journal of Islamic Finance, Vol. 3, No.1 June.

Hasan, Zubair (2011a): The Diminishing balance model for home financing, Journal of Islamic Banking & Finance, Karachi Vol 28 Issue 3 pp. 150-156.

Hasan Zubair (2011b): Riba in La-riba contracts – Where to turn in Islamic home financing? MPRA working paper # 35421

Hasan, Zubair (2010): Islamic house financing: current models and a proposal from social perspective,Journal of Islamic Banking & Finance, Karachi. Volume 27 Issue 4

Hussain, A (2010): Islamic Home Financing and Mortgages, .Islamic Mortgages.co.uk.Accessed on 1.1.2012. ISRA (2011): Financing based on MusharikahMutanaqisa contracts, Downloaded on 12.11. 2011.

LARIBA, Knowledge Center: Frequently asked questions: In answer to the question -- I heard that in your contract you have a term as interest. What does that mean?Accessed on 1.1.2012.

Malaysia International Islamic Finance Centre (November 12, 2011): Shaping Islamic Finance together – MusharikahMutanaqisah – Last update Downloaded 12.11.2011.

Maybank2u.com (November 12, 2011: MusharkahMutanaqisah Term Financing (MMTF-i) – A shari’ah compliant financing facility for asset acquisitions and refinancing. Downloaded12.11.2011.

Meera, A. K. M &Razak, D. A (2009): Home financing through the MusharakahMutanaqisah contracts: some practical issues, JKAU: Islamic Economics, Vol. 22, No.1, pp. 3-25.

Microsoft (2012): Amortization Calculation Formula – Excel, http://www.vertex42.com/ExcelArticles/amortization-calculation.html (Cached Page)

Microsoft (2011): How to calculate compound interest for an intra-year period in Excelhttp://support.microsoft.com/kb/213907

Osmania, N.M & Abdullah, M.F (July 2010): MusharakahMutanaqisa Home Financing: A Review of Literatures and Practices of Islamic Banks in Malaysia, International Review of Business Research Papers, Volume 6, and No. 2

Smolo, E. and Hasssn, M.K (2011): The potentials of musharakahmutanaqisa for Islamic housing finance. International journal of Middle Eastern Finance and Management, Vol.4; No.3 PP. 237 - 258

Usmani, Maulana Taqi (2010): Musharakah andMudarabah as modes of financing, Journal of Islamic Banking & Finance, Volume 27, Number 3, July-September, PP. 56-76

Zayan Finance: The declining balance program - integrity in financing; Shari'ah Compliance informa