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

DOI

10.2991/meess-18.2018.89How to use a DOI?

Keywords

Real interest rate; loan; installment; scenario manager; excel.

Abstract

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 input data. The multi scheme comparison can be realized easily with the scenario manager tool.

Copyright

© 2018, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Jianli Han
AU  - Jianyong Bai
PY  - 2018/08
DA  - 2018/08
TI  - Design and Application of General Calculation Model for Real Interest Rate of Loan and Installment
BT  - Proceedings of the 2018 International Conference on Management, Economics, Education and Social Sciences (MEESS 2018)
PB  - Atlantis Press
SP  - 478
EP  - 482
SN  - 2352-5398
UR  - https://doi.org/10.2991/meess-18.2018.89
DO  - 10.2991/meess-18.2018.89
ID  - Han2018/08
ER  -