企业财务部企业筹资决策.xlsx

《企业财务部企业筹资决策.xlsx》由会员分享，可在线阅读，更多相关《企业财务部企业筹资决策.xlsx（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、租租赁赁筹筹资资分分析析模模型型租赁设备名称A机器租金￥680,000.00租金支付方式先付租赁年利率7.50%租赁年限5年付款期数2总付款期数10每期应付租金￥79,805.02实际总付租金￥798,050.24双双变变量量模模拟拟运运算算模模型型公司名称华郎集团制表时间2013/5/30￥79,805.023585.00%￥120,442.91￥75,800.94￥50,816.895.50%￥121,156.36￥76,596.60￥51,684.706.00%￥121,870.19￥77,394.90￥52,558.626.50%￥122,584.39￥78,195.77￥53,438

2、.547.00%￥123,298.92￥78,999.16￥54,324.337.50%￥124,013.78￥79,805.02￥55,215.898.00%￥124,728.94￥80,613.31￥56,113.088.50%￥125,444.38￥81,423.96￥57,015.789.00%￥126,160.10￥82,236.94￥57,923.889.50%￥126,876.07￥83,052.18￥58,837.2410.00%￥127,592.27￥83,869.63￥59,755.75单位：元1015￥42,556.14￥31,696.39￥43,461.58￥32,68

3、2.63￥44,375.42￥33,682.62￥45,297.47￥34,695.95￥46,227.57￥35,722.23￥47,165.52￥36,761.05￥48,111.14￥37,811.99￥49,064.26￥38,874.64￥50,024.67￥39,948.56￥50,992.19￥41,033.34￥51,966.63￥42,128.55逆逆算算利利率率和和贷贷款款额额模模型型逆逆算算利利率率: :函函数数法法逆逆算算利利率率：单单变变量量求求解解贷款总额￥280,000.00贷款总额￥250,000.00贷款期限20贷款期限15可承受月偿还额1800可承受月偿还额

4、1388.89可承受年利率4.69%可承受年利率逆逆算算贷贷款款额额：函函数数法法逆逆算算贷贷款款额额：单单变变量量求求解解需要贷款总额￥1,483,586.66需要贷款总额#贷款利率8.00%贷款利率8.00%可承受月偿还额18000可承受月偿还额￥180,000.00贷款期限10贷款期限10贷款偿还进度分析贷贷款款基基本本资资料料贷贷款款金金额额￥580,000.00贷贷款款期期限限5贷贷款款利利率率6.80%年年偿偿还还额额￥140,699.93月月偿偿还还额额￥11,430.05计计划划还还款款额额实实际际归归还还贷贷款款年年份份月月份份计计划划还还款款额额实实际际还还款款额额2009￥140,699.93￥49,000.0020101￥11,430.05￥4,000.002￥11,430.05￥4,000.003￥11,430.05￥2,800.004￥11,430.05￥1,000.00合计￥186,420.11￥60,800.00贷款偿还比例已还本金￥60,800.00已还贷款比例10.48%计划完成比例32.61%data15.24%data4data244.76%data5data350.00%data616.31%33.69%50.00%还还款款进进度度图图计计划划完完成成进进度度图图贷款偿还进度分析