确定公司的最佳贷款方案.xlsx
上传人:lj****88 上传时间:2024-09-13 格式:XLSX 页数:3 大小:15KB 金币:10 举报 版权申诉
预览加载中,请您耐心等待几秒...

确定公司的最佳贷款方案.xlsx

确定公司的最佳贷款方案.xlsx

预览

免费试读已结束,剩余 2 页请下载文档后查看

10 金币

下载此文档

如果您无法下载资料,请参考说明:

1、部分资料下载需要金币,请确保您的账户上有足够的金币

2、已购买过的文档,再次下载不重复扣费

3、资料包下载后请先用软件解压,在使用对应软件打开

企业最佳还款方案选择贷款时间1/1/2012贷款金额¥2,000,000.00贷款年限2企业可承受月还款额范围¥49,000.00方案1:等额本息方案2:等额本金年利率:6.20%年利率:6.50%月份数每月偿还额月份数月利率累计归还本息1¥88,821.5710.542%¥0.002¥88,821.5720.542%¥94,166.673¥88,821.5730.542%¥187,823.264¥88,821.5740.542%¥280,972.555¥88,821.5750.542%¥373,617.296¥88,821.5760.542%¥465,760.197¥88,821.5770.542%¥557,403.998¥88,821.5780.542%¥648,551.399¥88,821.5790.542%¥739,205.0710¥88,821.57100.542%¥829,367.7111¥88,821.57110.542%¥919,041.9612¥88,821.57120.542%¥1,008,230.4913¥88,821.57130.542%¥1,096,935.9114¥88,821.57140.542%¥1,185,160.8415¥88,821.57150.542%¥1,272,907.8816¥88,821.57160.542%¥1,360,179.6317¥88,821.57170.542%¥1,446,978.6618¥88,821.57180.542%¥1,533,307.5219¥88,821.57190.542%¥1,619,168.7720¥88,821.57200.542%¥1,704,564.9421¥88,821.57210.542%¥1,789,498.5522¥88,821.57220.542%¥1,873,972.1023¥88,821.57230.542%¥1,957,988.0824¥88,821.57240.542%¥2,041,548.98还款本息总额¥2,131,717.65还款本息总额最高月还款额¥88,821.57最高月还款额是否可以考虑该方案否是否可以考虑该方案否方案评价月还款金额方案2比方案1每月多付5345元还款本金利息和方案1比方案2总共多付7060元