Advanced excel programming of time value of money in the context of real estate financing
by Adedeji Badiru; Andreas Mertens
International Journal of Sustainable Real Estate and Construction Economics (IJSRECE), Vol. 2, No. 3/4, 2023

Abstract: The research objective of this paper is to develop a practical and functional software tool to serve the needs of both practitioners and researchers in the mortgage industry. The software development capitalises on published research available in the literature, as documented by the cited references. The spreadsheet tool presented in this paper carries out computational and graphical analyses of loan-based investments at the intersection of real estate and economics. The effort is thereby designed to referee the impact of the time value of money on real estate finance from a capital investment perspective. Based on specific data entries, the utilised methodology leverages basic and advanced modules to generate comprehensive information for the assessment of mortgage repayments or the corporate financial strategy related to real estate financing scenarios. The paper has practical implications, particularly in the light of real estate transactions: The computational spreadsheet program modules, calculations and visualisations can pertinently guide mortgage situations and provide a fertile toolbox for financial decisions made by investors. Amid the recent substantial interest rate risings and increase in real estate finance cost, the presented methodology with dashboard-style elements is designed to boost transparency in loan-based property financing.

Online publication date: Thu, 01-Feb-2024

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Sustainable Real Estate and Construction Economics (IJSRECE):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com