计算机财务模型 筹资决策分析模型

1、筹资界面第1页 对比分析筹资决策分析模型租赁分析筹资界面第2页中财公司分期偿还借款分析模型借款种类工业贷款借款金额15,200借款年利率8%借款年限2每年还款期数2总付款期数4每期偿还金额4,187.45中中财财公公司司分分期期偿偿还还贷贷款款双双变变量量分分析析表表借款年利率 总付款期数4,187.45481216246.60%4,118.592,192.831,554.501,238.01926.777.00%4,138.222,211.251,572.961,256.81946.557.50%4,162.802,234.381,596.191,280.52971.578.00%4,187

2、.452,257.621,619.591,304.46996.928.50%4,212.152,280.991,643.171,328.641,022.609.00%4,236.902,304.471,666.931,353.031,048.6010.00%4,286.582,351.771,714.951,402.501,101.5610.50%4,311.502,375.601,739.211,427.571,128.50ABCDEF1234567891011121314151617181920212223借款第4页中财公司分期偿还借款分析模型借款种类 TY220机床借款金额2,000,0

3、00借款年利率10%借款年限5每年还款期数1总付款期数5每期偿还金额527,595中中财财公公司司贷贷款款分分期期偿偿还还分分析析表表年还款额 偿还本金偿还利息折 旧 税款节约额 净现金流量现 值 1527,595327,595200,000400,000198,000329,595308,8992527,595360,354167,241400,000187,189340,406298,9983527,595396,390131,205400,000175,298352,297290,0124527,595436,02991,566400,000162,217365,378281,89355

4、27,595479,63247,963400,000147,828379,767274,597 合计2,637,9752,000,000637,9752,000,000870,5321,767,4431,454,399 借款成本总现值 中财公司租赁分析模型租赁项目 TY220机床租金2,500,000制服租金方法先付每年付款次数1租赁年利率10%租赁年限5总付款次数5每期应付租金599,540中中财财公公司司贷贷款款分分期期偿偿还还分分析析表表年还款额 偿还本金偿还利息折 旧 税款节约额 净现金流量现 值1527,595327,595200,000400,000198,000329,59530

5、8,8992527,595360,354167,241400,000187,189340,406298,9983527,595396,390131,205400,000175,298352,297290,0124527,595436,02991,566400,000162,217365,378281,8935527,595479,63247,963400,000147,828379,767274,597 合计2,637,9752,000,000637,9752,000,000870,5321,767,4431,454,399 借款成本总现值 借款成本总现值中中财财公公司司租租赁赁分分析析模模型

6、型26租租赁赁项项目目名名称称生生产产厂厂家家租租金金1 1, ,0 00 00 0, ,0 00 00 0德国支支付付租租金金方方法法先先付付美国1每每年年付付款款次次数数1 1日本6租租赁赁年年利利率率6.00%6.00%美国5租租赁赁年年限限5 5美国总总付付款款次次数数5 5美国每每期期应应付付租租金金2 22 23 3, ,9 95 59 9日本注：租赁年利率为525中中财财公公司司租租赁赁摊摊销销分分析析表表 租赁年限为15年年租金支付税款节约额租赁净现金流量现 值 每年付款次数为14次0223,95973,906150,052150,052所得税税率33%1223,95973,9

7、06150,052144,253 2223,95973,906150,052138,679 3223,95973,906150,052133,319 4223,95973,906150,052128,1675-合计1,119,794369,532750,262694,470 租赁成本总现值 TY110机床(美国)ABCDEFGHI123456789101112131415161718192021222324252627租租赁赁公公司司价价格格表表设设备备名名称称 租租金金总总额额支支付付方方法法TY220机床(德国)2,500,000先付TY220机床(美国)2,300,000先付TY220机床(日本)2,100,000先付486计算机(AST)20,000后付386计算机(IBM)10,000后付TY110机床(美国)