上傳人:地**
編號:1304415
2024-12-19
8頁
26.50KB
該文檔所屬資源包:
財務(wù)行政管理EXCEL模板
1、長期借款分期等額還款模型借款金額500000年利率10%借款期限10每年還款期數(shù)1還款總期數(shù)10分期等額還款金額¥-81,372.70長期借款分期等額還款模型借款金額500000年利率10%借款期限10每年還款期數(shù)1還款總期數(shù)10分期等額還款金額¥-81,372.70不同借款額每期償還金額¥-81,372.70500000-81372.7045000-7323.5448000-7811.78400000-65098.16長期借款分期等額還款模型借款金額500000年利率10%借款期限10每年還款期數(shù)1還款總期數(shù)10分期等額還款金額¥-81,372.70借款年利率還 款 總 期 數(shù)#2345672、4%-265098.04-180174.27-137745.02-112313.56-95380.95-83304.815%-268902.44-183604.28-141005.92-115487.40-98508.73-86409.916%-272718.45-187054.91-144295.75-118698.20-101681.31-89567.517%-276545.89-190525.83-147614.06-121945.35-104897.90-92776.618%-280384.62-194016.76-150960.40-125228.23-108157.69-960363、.209%-284234.45-197527.38-154334.33-128546.23-111459.89-99345.2610%-288095.24-201057.40-157735.40-131898.74-114803.69-102702.758910-74263.92-67246.50-61645.47-77360.91-70345.04-64752.29-80517.97-73511.12-67933.98-83733.88-76743.24-71188.75-87007.38-80039.85-74514.74-90337.19-83399.40-77910.04-93722.4、01-86820.27-81372.70長期借款分期等額還款模型借款金額50000年利率10%借款期限5每年還款期數(shù)1還款總期數(shù)5分期等額還款金額¥-13,189.87等等額額還還款款籌籌資資決決策策分分析析表表所得稅率:33%貼現(xiàn)率:8%單位:期限等額還款金額償還本金期初尚欠本金償還利息避稅額凈現(xiàn)金流量113189.878189.8750000.005000.001650.0011539.87213189.879008.8641810.134181.011379.7311810.14313189.879909.7532801.263280.131082.4412107.43413189.875、10900.7222891.522289.15755.4212434.45513189.8711990.7911990.791199.08395.7012794.18合計65949.3750000.0015949.375263.2960686.08元現(xiàn)值10685.0710125.299611.279139.698707.5048268.83長期借款分期等額還款模型借款金額20000年利率8%借款期限4每年還款期數(shù)2還款總期數(shù)8分期等額還款金額¥-2,970.56等等額額還還款款籌籌資資決決策策分分析析表表所得稅率:33%貼現(xiàn)率:8%單位:期限等額還款金額償還本金期初尚欠本金償還利息避稅額凈現(xiàn)金流量12970.562170.5620000.00800.00264.002706.5622970.562257.3817829.44713.18235.352735.2132970.562347.6715572.06622.88205.552765.0142970.562441.5813224.39528.98174.562795.9952970.562539.2410782.81431.31142.332828.22合計14852.7811756.433096.351021.7913830.99元現(xiàn)值2506.072345.002194.952055.141924.8411026.00
建筑設(shè)計
上傳時間:2022-07-14
12份
CAD圖紙
上傳時間:2022-06-30
20份