固定資產(chǎn)投資估算表

固定資產(chǎn)投資估算表單位：元序號項目估算金額1加盟費300002設(shè)備費100003保證金20004裝修費300005基本預(yù)備費20000投資合計82000分年投資計劃表單位：元序號名稱第一年第二年第三年第四年……1分年計劃%2建設(shè)投資3建設(shè)期利息4流動資金5項目總投入資金（1+2+3）序號項目合計計算期1234……1房租144000360003600036000360002外購原材料費2400060006000600060003水電費2400060006000600060004工資及福利費80000200002000020000200005修理費400010001000100010006折舊費900018001800180018007攤銷費1000040003000300008利息支出5599.0728001866.69933.3809其他費用8000200020002000200010總成本費用合計322932.077960077666.6976732.3888933其中：可變成本67732.071580013866.6912932.3825133固定成本2552006380063800638006380011經(jīng)營成本26240065600656006560065600總成本費用估算表單位：元序號項目合計計算期1234……1現(xiàn)金流入1.1銷售收入7632001908001908001908001908001.2回收固定資產(chǎn)余值1.3回收流動資金1.4其他現(xiàn)金流入2現(xiàn)金流出2.1項目資本金319710.6270000088084.2161626.422.2借款本金償還4000013333133331333402.3借款利息支付5599.0728001866.69933.3802.4經(jīng)營成本262400656006560065600656002.5銷售稅金及附加40068100171001710017100172.6增值稅202176505445054450544505442.7所得稅121086.1130644.7929151.7430644.7930644.792.8其他現(xiàn)金流出89280223202232022320223203凈現(xiàn)金流量（1-2）資本金現(xiàn)金流量表單位：元序號項目計算期1231借款40000001.1年初本息余額4000029466.0714266.381.2本年借款40000001.3本年應(yīng)計利息28001866.69933.381.4本年還本付息1613315199.6914266.38其中：還本133331333313334付息28001866.69933.381.5年末本息余額29466.0714266.3804還本資金來源11608.688084.2165493.114.1當(dāng)年可用于還本的未分配利潤5808.683284.287808.64.2當(dāng)年可用于還本的折舊和攤銷5800480048004.3以前年度結(jié)余可用于還本資金0072884.514.4可用于還款的其他資金000還本付息計劃表單位：元利潤和利潤分配表單位：元序號項目合計計算期1234……1產(chǎn)品銷售收入7632001908001908001908001908002銷售稅金及附加40068100171001710017100173總成本費用351680879208792087920879204利潤總額（1-2-3）371452928639286392863928635彌補以前年度虧損4524.404524.4006應(yīng)納稅所得額（4-5）366927.69286388338.692863928637所得稅121086.1130644.7929151.7430644.7930644.798凈利潤（4-7）250365.8962218.2163711.2662218.2162218.219期末未分配利潤463186.57072884.51151266.73239035.3310可供分配利潤（8+9）713552.4662218.21136595.77213484.94301253.5411息稅前利潤（利潤總額+利息支出）377052.079566394729.6993796.389286312息稅折舊攤銷前利潤（11+折舊+攤銷）396052.0710146399529.6998596.3894663項目財務(wù)現(xiàn)金流量表序號項目合計計算期1234……1現(xiàn)金流入1.1銷售收入7632001908001908001908001908001.2回收固定資產(chǎn)余值1.3回收流動資金1.4其他現(xiàn)金流入2現(xiàn)金流入2.1建設(shè)投資82000820002.2流動資金2.3經(jīng)營成本4600001150001150001150001150002.4銷售稅金及附加40068100171001710017100172.5增值稅202176505445054450544505442.6其他現(xiàn)金流出3凈現(xiàn)金流量（1-2）4累計凈現(xiàn)金流量銷售收入和銷售稅金及附加估算表序號項目總計計算期1234……1銷售收入7632001908001908001908001908001.1奶茶銷售收入547200136800136800136800136800單價5555數(shù)量109440273602736027360273601.2果汁銷售收入5184012960129601296012960v單價6666數(shù)量864021602160216021601.3冰沙銷售收入4320010800108001080010800單價5555數(shù)量864021602160216021601.4冰激凌銷售收入12096030240302403024030240單價7777數(shù)量1728043204320432043202銷售稅金及附加40068100171001710017