Internet Archive Scholar

Design and Application of General Calculation Model for Real Interest Rate of Loan and Installment

Jianli Han, Jianyong Bai
2018 Proceedings of the 2018 International Conference on Management, Economics, Education and Social Sciences (MEESS 2018)   unpublished

Preserved Fulltext

fulltext thumbnail
Web Archive Capture PDF (2.5 MB)
https://web.archive.org/web/20190501121645/https://download.atlantis-press.com/article/25900569.pdf

A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL. The file type is application/pdf.

Based on Excel, this paper designs a general calculation model of real interest rates for loans and instalments. The model is very applicable and can easily calculate the real interest rates of various types of loans and instalments. In addition, the pretax capital cost of bond financing and the gain on bond investments can be calculated. The design of the model is simple. The interface is simple and beautiful. The operation is easy. The model can automatically adjust the form according to the
more » ... nput data. The multi scheme comparison can be realized easily with the scenario manager tool.
doi:10.2991/meess-18.2018.89 fatcat:m6svdnte4nbsvltymebc2qh6je
Citation

Jianli Han, Jianyong Bai. "Design and Application of General Calculation Model for Real Interest Rate of Loan and Installment." Proceedings of the 2018 International Conference on Management, Economics, Education and Social Sciences (MEESS 2018) (2018)