計算機財務(wù)模型 籌資決策分析模型

1、籌資界面第1頁 對比分析籌資決策分析模型租賃分析籌資界面第2頁中財公司分期償還借款分析模型借款種類工業(yè)貸款借款金額15,200借款年利率8%借款年限2每年還款期數(shù)2總付款期數(shù)4每期償還金額4,187.45中中財財公公司司分分期期償償還還貸貸款款雙雙變變量量分分析析表表借款年利率 總付款期數(shù)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每年還款期數(shù)1總付款期數(shù)5每期償還金額527,595中中財財公公司司貸貸款款分分期期償償還還分分析析表表年還款額 償還本金償還利息折 舊 稅款節(jié)約額 凈現(xiàn)金流量現(xiàn) 值 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 借款成本總現(xiàn)值 中財公司租賃分析模型租賃項目 TY220機床租金2,500,000制服租金方法先付每年付款次數(shù)1租賃年利率10%租賃年限5總付款次數(shù)5每期應(yīng)付租金599,540中中財財公公司司貸貸款款分分期期償償還還分分析析表表年還款額 償還本金償還利息折 舊 稅款節(jié)約額 凈現(xiàn)金流量現(xiàn) 值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 借款成本總現(xiàn)值 借款成本總現(xiàn)值中中財財公公司司租租賃賃分分析析模模型

6、型26租租賃賃項項目目名名稱稱生生產(chǎn)產(chǎn)廠廠家家租租金金1 1, ,0 00 00 0, ,0 00 00 0德國支支付付租租金金方方法法先先付付美國1每每年年付付款款次次數(shù)數(shù)1 1日本6租租賃賃年年利利率率6.00%6.00%美國5租租賃賃年年限限5 5美國總總付付款款次次數(shù)數(shù)5 5美國每每期期應(yīng)應(yīng)付付租租金金2 22 23 3, ,9 95 59 9日本注：租賃年利率為525中中財財公公司司租租賃賃攤攤銷銷分分析析表表 租賃年限為15年年租金支付稅款節(jié)約額租賃凈現(xiàn)金流量現(xiàn) 值 每年付款次數(shù)為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 租賃成本總現(xiàn)值 TY110機床(美國)ABCDEFGHI123456789101112131415161718192021222324252627租租賃賃公公司司價價格格表表設(shè)設(shè)備備名名稱稱 租租金金總總額額支支付付方方法法TY220機床(德國)2,500,000先付TY220機床(美國)2,300,000先付TY220機床(日本)2,100,000先付486計算機(AST)20,000后付386計算機(IBM)10,000后付TY110機床(美國)