组合贷款最优还款年限的确定

Optim alLoan Duration Determ ination of a Combined Mortgage Loan

在申请包含两种不同利率贷款的组合贷款以支付购房款的情况下，如何合理安排两种贷款还款年限问题，在数学上可以表述为一个有约束的最优化问题：在两种贷款的每月还款金额之和不超过申请者月还款承受能力的约束条件下，使两种贷款的月还款额在银行存款利率下计算出来的净现值达到极小。在一个Ｅｘｃｅｌ工作表建立起相应的模型之后利用ＭｉｃｒｏｓｏｆｔＥｘｃｅｌ的数据分析能力和我们所创造的可调图形工具可以清楚地表现出问题的性质并且可以提供一种十分便于操作的、解决上述最优化问题的手段。

The optim alloan duration determ ination ofa com bined m ortgage loan can be form ulated as a constrained optim ization problem . For a com bined m ortgage loan consisted oftw o loans w ith differentinterestratesthe problem is represented as the follow ing: finding the optim alduration ofthe tw o loans to m inim ize the sum m ation ofthe netpresentvalues of the tw o loans’m onthly paym entscalculated atthesavingsinterestrate ofthe bank underthe constraint that the total m onthly paym ents not exceed the paym ent ability of the loan applicant. With the pow erfuldata analysis function of Microsoft Exceland the adjustable chart tool, w e can get a solution ofthe problem in a form at of a dynam ic adjustable chart, w hich is not only interested in theory but very easy to operate in practice.