財務分析與決策-固定資產(chǎn)更新決策模型設計

,固定資產(chǎn)更新決策模型,,,,,,項目,舊設備,新設備

資金成本,10%,所得稅稅率,40%,設備凈現(xiàn)值差,"￥11,756",,原價,40000,60000

舊設備：,,,,新設備：,,,預計使用年限,10,5

初始投資,40000,凈現(xiàn)值,,初始投資,60000,凈現(xiàn)值,已使用年限,5,0

預計使用年限,10,"￥51,555",,預計使用年限,10,"￥53,311",年銷售收入,50000,80000

已使用年限,5,,,已使用年限,5,,每年付現(xiàn)成本,30000,40000

殘值,0,變現(xiàn)收入,,殘值,10000,,殘值,10000,10000

折舊方法,直線法,"￥10,000",,折舊方法,年數(shù)總和法,,目前變現(xiàn)價值,10000,

舊設備\剩余使用年限,1,2,3,4,5,,折舊方法,直線法,年數(shù)總和法

年銷售收入,50000,50000,50000,50000,50000,,,,

每年付現(xiàn)成本,30000,30000,30000,30000,30000,,,,

折舊額,"￥4,000","￥4,000","￥4,000","￥4,000","￥4,000",,SLN函數(shù)：返回某項資產(chǎn)在一個期間中的線性折舊值。（直線法）,,

稅前凈利,16000,16000,16000,16000,16000,,"SLN(cost,salvage,life)","初始成本,資產(chǎn)在可用年限結(jié)束后的價值,資產(chǎn)的可用年限。",

所得稅,6400,6400,6400,6400,6400,,,,

稅后凈利,9600,9600,9600,9600,9600,,營業(yè)現(xiàn)金流量=稅后凈利+折舊額,,

營業(yè)凈現(xiàn)金流量,13600,13600,13600,13600,13600,,經(jīng)營現(xiàn)金流量=EBIT–稅+折舊,,

終結(jié)現(xiàn)金流量,,,,,,,,,

現(xiàn)金流量,"￥13,600","￥13,600","￥13,600","￥13,600","￥13,600",,,,

新設備\剩余使用年限,1,2,3,4,5,,,,

年銷售收入,80000,80000,80000,80000,80000,,,,

每年付現(xiàn)成本,40000,40000,40000,40000,40000,,,,

折舊額,"￥16,667","￥13,333","￥10,000","￥6,667","￥3,333",,SYD函數(shù)返回某項資產(chǎn)按年限總和折舊法計算的指定期間的折舊值,,

稅前凈利,23333,26667,30000,33333,36667,,,,

所得稅,9333,10667,12000,13333,14667,,,,

稅后凈利,14000,16000,18000,20000,22000,,,,

營業(yè)凈現(xiàn)金流量,30667,29333,28000,26667,25333,,,,

終結(jié)現(xiàn)金流量,,,,,10000