多项目投资决策分析模板

初始投资计算：,,,出售现有资产税后收益：,,,净营运资本变化,

提议购买B资产安装后成本,"$420,000.00",,旧资产购买价格,"$240,000.00",,现金,+101000

安装成本,"$20,000.00",,3年后折旧,"$32,493.88",,应收账款,0

提议购买B资产安装后总成本,"$440,000.00",,账面价值,"$207,506.12",,存货,+52000

出售现有资产的税后收益,"$251,002.45",,旧资产出售价格,"$280,000.00",,应付帐款,+30000

净营运资本变化,"$183,000.00",,税金,40%,,应付利息,0

初始投资,"$371,997.55",,出售现有资产税后收益,"$251,002.45",,净营运资本变化,"$183,000.00"

年份,提议购买机器,,现有机器,,,,

,收益,支出,收益,支出,,,

1,"$2,530,000.00","$2,310,000.00","$2,200,000.00","$1,990,000.00",,,

2,"$2,530,000.00","$2,310,000.00","$2,300,000.00","$2,110,000.00",,,

3,"$2,530,000.00","$2,310,000.00","$2,400,000.00","$2,230,000.00",,,

4,"$2,530,000.00","$2,310,000.00","$2,400,000.00","$2,250,000.00",,,

5,"$2,530,000.00","$2,310,000.00","$2,250,000.00","$2,120,000.00",,,

提议购买机器和现有机器折旧费用,提议购买机器,,现有机器,,,,

年份,成本,折旧,成本,折旧,,,

1,"$440,000.00","$131,120.00","$240,000.00","$54,240.00",,,

2,"$440,000.00","$92,046.24","$240,000.00","$41,981.76",,,

3,"$440,000.00","$64,616.46","$240,000.00","$32,493.88",,,

4,"$440,000.00","$45,360.76","$240,000.00","$25,150.26",,,

5,"$440,000.00","$31,843.25","$240,000.00","$19,466.30",,,

6,"$440,000.00","$22,353.96","$240,000.00","$15,066.92",,,

7,"$440,000.00","$15,692.48","$240,000.00","$11,661.80",,,

提议购买机器经营性现金流,,,,,,,

,第1年,第2年,第3年,第4年,第5年,第6年,第7年

收益,2530000,2530000,2530000,2530000,2530000,0,0

支出,2310000,2310000,2310000,2310000,2310000,0,0

折旧、息税前利润,220000,220000,220000,220000,220000,0,0

折旧,131120,92046.24,64616.46048,45360.75526,31843.25019,22353.96163,15692.48107

息税前利润,88880,127953.76,155383.5395,174639.2447,188156.7498,-22353.96163,-15692.48107

税金,40%,40%,40%,40%,40%,40%,40%

税后经营净利润,53328,76772.256,93230.12371,104783.5468,112894.0499,0,0

经营性现金流入,184448,168818.496,157846.5842,150144.3021,144737.3001,22353.96163,15692.48107

提议购买机器经营性现金流,,,,,,,

,第1年,第2年,第3年,第4年,第5年,第6年,第7年

收益,2200000,2300000,2400000,2400000,2250000,0,0

支出,1990000,2110000,2230000,2250000,2120000,0,0

折旧、息税前利润,210000,190000,170000,150000,130000,0,0

折旧,54240,41981.76,32493.88224,25150.26485,19466.305,15066.92007,11661.79613

息税前利润,155760,148018.24,137506.1178,124849.7351,110533.695,-15066.92007,-11661.79613

税金,40%,40%,40%,40%,40%,40%,40%

税后经营净利润,93456,88810.944,82503.67066,74909.84109,66320.217,0,0

经营性现金流入,147696,130792.704,114997.5529,100060.1059,85786.522,15066.92007,11661.79613

经营性现金流入,,,,,,,

年数,提议机器,现有机器,净增量,,,,

1,184448,147696,36752,,,,

2,168818.496,130792.704,38025.792,,,,

3,157846.5842,114997.5529,42849.0313,,,,

4,150144.3021,100060.1059,50084.19