Islamic norms, the excel formula and home financing models

Hasan, Zubair (2012): Islamic norms, the excel formula and home financing models. Published in: ISRA: International Journal of Islamic Finance , Vol. 5, No. 1 (June 2013): pp. 7-28.

Abstract

This paper adds to the series of writings on Islamic home financing presented and published by the author since February 2010. 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, and not after, the selection of the formula; additional juristic requirements may only follow subsequently. Is it not then strange many Islamic banks are using the formula to determine the periodic instalment payments in their home financing programs? The paper finds, for example, the popular Musharakah-Mutanaqisa Partnership (MMP) Islamic home financing model to be non-compliant with the stated norms. It presents a new model―the Zubair Diminishing Balance Method (ZDBM) ― and argues that the alternative is not only fully observant but is superior to the MMP model on some other counts as well.

• Item Type: MPRA Paper
• Language: English
• Keywords: Home finance; Excel amortization formula; Compounding; Islamic norms; Justice.
• Subjects: G - Financial Economics > G0 - General > G02 - Behavioral Finance: Underlying Principles; G - Financial Economics > G2 - Financial Institutions and Services

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. (2007, September). Mortgage Contracts and Housing Tenure Decisions. Working Paper, Federal Reserve Bank of St. Louis, Research Division, pp. 1-40.

Hasan, Z. (2010). Islamic House Financing: Current Models and a Proposal from Social Perspective. Journal of Islamic Banking & Finance. Vol. 27, Issue 4.

Hasan, Z. (2011a). Islamic Home Finance in the Social Mirror. ISRA International Journal of Islamic Finance. Vol. 3, Issue 1, June.

Hasan, Z. (2011b). The Diminishing Balance Model for Home Financing. Journal of Islamic Banking & Finance. Vol. 28, Issue 3.

Hasan, Z. (2011c). Riba in La-Riba Contracts―Where to turn in Islamic Home Financing? MPRA Working Paper # 35421

Hussain, A. (2010). Islamic Home Financing and Mortgages. Islamic Mortgages.co.uk. Accessed on 1.1.2012.

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 01.01.2012.

Meera, A. K. (2012). A Critique of Diminishing Balance Method of Islamic Home Financing. ISRA International Journal of Islamic Finance. Vol. 4, Issue 2, December.

Meera, A. K. M. and Razak, D. A. (2009). Home Financing Through the Musharakah Mutanaqisah Contracts: Some Practical Issues. JKAU: Islamic Economics. Vol. 22, No.1.

Microsoft (2011). How to Calculate Compound Interest for an Intra-year Period in Excel. Available at http://support.microsoft.com/kb/213907

Osmania, N. M. and Abdullah, M. F. (2010). Musharakah Mutanaqisa Home Financing: A Review of Literatures and Practices of Islamic Banks in Malaysia. International Review of Business Research Papers. Vol. 6, No. 213.

Smolo, E. and Hassan, M. K. (2011). The Potentials of Musharakah Mutanaqisa for Islamic Housing Finance. International Journal of Middle Eastern Finance and Management. Vol. 4, No. 3, pp. 237–258.

Usmani, T. (2010). Musharakah and Mudarabah as Modes of Financing. Journal of Islamic Banking & Finance. Vol. 27, Issue 3.

Wittwer, Jon (2012). Amortization Calculation Formula―Excel. Available at http://www.vertex42.com/Calculators/simple-interest-loan.html