項(xiàng)目投資回報(bào)測(cè)算模板

財(cái)務(wù)管理工具——盈利能力分析工具,,,,,,,,,,,,

××公司××項(xiàng)目投資回報(bào)測(cè)算模板,,,,,,,,,,,,

說明：1.什么項(xiàng)目值得投資？所投資的項(xiàng)目未來回報(bào)如何？本模板是一個(gè)項(xiàng)目定量評(píng)估分析工具，既可以幫助您對(duì)是否投資某個(gè)項(xiàng)目做出理性的決策，也可以幫助您估算現(xiàn)有項(xiàng)目的預(yù)期投資回報(bào)。

2.本模板已內(nèi)嵌公式，您輸入相應(yīng)數(shù)據(jù)后可直接生成分析數(shù)據(jù)結(jié)果，非常方便實(shí)用。

3.本表格假設(shè)項(xiàng)目經(jīng)營(yíng)周期為6年。表中數(shù)字僅供參考，您可以把這個(gè)作為模版，根據(jù)項(xiàng)目實(shí)際經(jīng)營(yíng)周期進(jìn)行修改。黃色部分為需要輸入的信息，年份數(shù)據(jù)可以改動(dòng)，其他數(shù)據(jù)已經(jīng)鎖定，不可更改，且均為自動(dòng)生成。,,,,,,,,,,,,

項(xiàng)目名稱：項(xiàng)目負(fù)責(zé)人：項(xiàng)目周期：金額單位：,,,,,,,,,,,,

年投資回報(bào)率要求,20%,,所得稅率,25%,,,,,,,,

,,,,,,,,,,,,,

年份,0,1,2,3,4,5,6,7,,,,

,,,,,,,,,,,,,

年折舊率（稅法規(guī)定）,,16.67%,16.67%,16.67%,16.67%,16.67%,16.67%,,,,,

凈營(yíng)運(yùn)資本（存貨+應(yīng)收賬款-應(yīng)付賬款）,,670.00,1365.00,3826.00,4540.00,5620.00,5411.00,,,,,

凈營(yíng)運(yùn)資本變化,,670.00,695.00,2461.00,714.00,1080.00,-209.00,-5411.00,,,,

固定資產(chǎn),3000.00,2499.90,1999.80,1499.70,999.60,499.50,-0.60,,,,,

,,,,,,,,,,,,,

銷售收入,,650.00,13556.00,35200.00,56230.00,65962.00,70561.00,,,,,

減：銷售成本,,715.00,8263.00,25320.00,38237.00,29870.00,15856.00,,,,,

減：折舊,,500.10,500.10,500.10,500.10,500.10,500.10,,,,,

減：其他費(fèi)用,8000.00,3500.00,1580.00,1695.00,1899.00,2560.00,1900.00,,,,,

稅前利潤(rùn),-8000.00,-4065.10,3212.90,7684.90,15593.90,33031.90,52304.90,,,,,

減：稅收,0.00,0.00,803.23,1921.23,3898.48,8257.98,13076.23,0.00,,,,

凈利潤(rùn),-8000.00,-4065.10,2409.68,5763.68,11695.43,24773.93,39228.68,,,,,

加：折舊,0.00,500.10,500.10,500.10,500.10,500.10,500.10,0.00,,,,

減：凈營(yíng)運(yùn)資本變化,0.00,670.00,695.00,2461.00,714.00,1080.00,-209.00,-5411.00,,,,

經(jīng)營(yíng)活動(dòng)現(xiàn)金流,-8000.00,-4235.00,2214.78,3802.78,11481.53,24194.03,39937.78,5411.00,,,,

減：資本投資,3000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,,,

加：固定資產(chǎn)清理收入,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1120.00,,,,

減：固定資產(chǎn)清理收入應(yīng)繳所得稅,0.00,0.00,0.00,0.00,0.00,0.00,0.00,280.15,,,,

凈現(xiàn)金流入,-11000.00,-4235.00,2214.78,3802.78,11481.53,24194.03,39937.78,6250.85,,,,

現(xiàn)值折扣因素,1.00,0.83,0.69,0.58,0.48,0.40,0.33,0.28,,,,

現(xiàn)值,-11000.00,-3529.17,1538.04,2200.68,5537.00,9723.04,13375.08,1744.50,,,,

凈現(xiàn)值,