投资回收计算器

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

息税前利润(EBIT)销售额-变动成本-固定成本(EBIT=S-V-F)(销售单位-单位变动成本)*产销售量-固定成本经营成本该年不包括财务费用的总成本费用-该年折旧额-该年无形资产和其他资产的摊销额营运成本经营成本+折旧费用+摊销费总成本营运成本+财务费用营业收入该产品不含税单位*该年产品的产销量项目资本金是指在建设项目总投资中,由投资者认缴的出资额,对于建设项目来说是非债务性资金,项目法人不承担这部分资金的任何利息和债务;投资者可按其出资的比例依法享有所有者权益,也可转让其出资及其相应权益,但不得以任何方式抽回。调整所得税营业收入-不包括财务费用的总成本费用-营业税金及附加或息税前利润*所得税税率总投资收益率(ROI)年息税前利润(或年均息税前利润)/项目总投资内部收益率(FIRR)采用excelIRR自动计算功能净现值(FNPV)净现金流量×复利现值系数静态回收期(Pt)最后一项为负值的累计净现金流量对应的年数+最后一项为负值的累计净现金流量绝对值/下一年度净现金流量动态回收期(P't)(累计净现金流量现值出现正值的年数-1)+上一年累计净现金流量现值的绝对值/出现正值年份净现金流量的现值净现值率NPVR项目净现值/原始投资的现值合计项目资本金净利润率年平均净利润/项目资本金投资利税率(年平均利润总额+年平均营业税金及附加)/项目总资金成本利润率年平均利润总额/年平均总成本费用销售利润率年平均利润总额/年平均营业收入资产负债率负责总额/资产总额*100%流动比率流动资产(净)/流动负责速动比率速动资产/流动负责(流动资产-存货-预付帐款-待摊费用-待处理流动资产损失)/流动负责利息备付率税息前利润/当期应付利息*100%税息前利润=利润总额+计入总成本费用的利息费用当期应付利息=计入总成本费用的全部利息偿债备付率偿债备付率=可用于还本付息的资金/当期应还本付息的金额*100%可用于还本付息的资金=息税前利润+折旧+摊销-企业所得税DSCR=(EBITDA-Tax)/PD*100%式中,可用于还本付息的资金--包括可用于还款的折旧和摊销、成本中列支的利息费用、可用于还款的利润等EBITDA--息税前利润+折旧+摊销Tax--企业所得税PD--当期应还本付息利息当期应还本付息的金额--包括当期应还贷款本金额及计入成本费用的利息1234567运营负荷(%)0.500.501.001.001.001.001.001现金流入324,905.5018,000.0018,000.0036,000.0036,000.0036,000.0036,000.0036,000.001.1营业收入(含增值税)324,000.0018,000.0018,000.0036,000.0036,000.0036,000.0036,000.0036,000.001.2补贴收入0.000.000.000.000.000.000.001.3回收固定资产和无形资产余值905.500.001.4回收流动资金0.000.002现金流出167,209.4327,428.0827,860.1513,990.1513,990.1513,990.1513,990.1513,990.152.1建设投资26,880.0016,128.0010,752.000.000.000.000.002.2流动资金7,423.004,305.003,118.000.000.002.3经营成本84,655.934,455.588,911.158,911.158,911.158,911.158,911.158,911.152.4营业税金及附加(含增值税)4,593.25241.75483.50483.50483.50483.50483.50483.502.5维持运营投资0.000.000.000.000.000.000.002.6所得税43,657.252,297.754,595.504,595.504,595.504,595.504,595.504,595.503净现金流量157,696.07-9,428.08-9,860.1522,009.8522,009.8522,009.8522,009.8522,009.854累计净现金流量157,696.07-9,428.08-19,288.232,721.6224,731.4746,741.3268,751.1790,761.025所得税前净现金流量(1-2)201,353.32-7,130.33-5,264.6526,605.3526,605.3526,605.3526,605.3526,605.356累计净现金流量[所得税前]201,353.32-7,130.33-12,394.9814,210.3740,815.7267,421.0794,026.42120,631.77现值系数(查现值系数表)0.79290.69720.61180.53550.46740.40660.3523净现值[所得税前]72,061.22-5,653.64-3,670.5116,277.1514,247.1612,435.3410,817.749,373.067累计净现值[所得税前]-7,130.33-10,800.845,476.3119,723.4732,158.8142,976.5552,349.618调整所得税(EBIT+I)60,062.393,386.112,272.216,772.216,772.216,772.216,772.216,772.21所得税后净现金流量(5-8)141,290.93-10,516.44-7,536.8619,833.1419,833.1419,833.1419,833.1419,833.14累计净现金流量[所得税后]-10,516.44-18,053.301,779.8421,612.9841,446.1161,279.2581,112.39净现值[所得税后]47,077.34-8,338.48-5,254.7012,133.9110,620.659,270.018,064.156,987.21累计净现值[所得税后]-8,338.48-13,593.18-1,459.279,161.3818,431.3926,495.5433,482.75计算指标:所得税后所得税前项目投资财务内部收益率(FIRR):0.761.25项目投资财务净现值(FNPV):ic=12%47,077.34万元72,061.22万元年份序号项目年份合计项目投资静态投资回收期(Pt):2.47年2.91年项目投资动态投资回收期(P't):2.66年3.14年静态回收期(Pt)动态回收期(P't)最后一项为负值的累计净现金流量对应的年数+最后一项为负值的累计净现金流量绝对值/下一年度净现金流量(累计净现金流量现值出现正值的年数-1)+上一年累计净现金流量现值的绝对值/出现正值年份净现金流量的现值89101.001.001.0036,905.5036,000.0036,000.0036,000.0036,000.0036,000.000.00905.500.000.0013,990.1513,990.1513,990.150.008,911.158,911.158,911.15483.50483.50483.500.004,595.504,595.504,595.5022,915.3522,009.8522,009.85113,676.37135,686.22157,696.0727,510.8526,605.3526,605.35148,142.62174,747.97201,353.320.30220.25580.11718,313.786,805.653,115.4960,663.3967,469.0470,584.536,998.596,772.216,772.2120,512.2619,833.1419,833.14101,624.65121,457.79141,290.936,198.815,073.322,322.4639,681.5644,754.8847,077.34年份最后一项为负值的累计净现金流量对应的年数+最后一项为负值的累计净现金流量绝对值/下一年度净现金流量(累计净现金流量现值出现正值的年数-1)+上一年累计净现金流量现值的绝对值/出现正值年份净现金流量的现值

1 / 6
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功