投资项目财务计算模型全套表格含公式自动计算-土地一级开发二期项目.xls
下载文档
上传人:正***
编号:850774
2023-12-20
10页
41.50KB
1、损损益益表表 单单位位:万万元元土土地地一一级级开开发发二二期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期2013201320142014201520151 1产产品品销销售售收收入入(不不含含增增值值税税)33,12533,1254,1414,1414,1414,1414,1414,1412 2销销售售税税金金及及附附加加(不不含含增增值值税税)99991212121212123 3总总成成本本费费用用(不不含含增增值值税税)5,4965,4966876876876876876874 4利利润润总总额额27,53027,5303,4413,4413,4413,4413,44132、,4415 5弥弥补补以以前前年年度度亏亏损损0 00 00 00 06 6应应纳纳税税所所得得额额27,53027,5303,4413,4413,4413,4413,4413,4417 7所所得得税税6,8826,8828608608608608608608 8税税后后利利润润20,64720,6472,5812,5812,5812,5812,5812,5818.1盈余公积金2582582582588.2未分配利润20,38920,3892,3232,3232,5812,5812,5812,581累计未分配利润90,84890,8482,3232,3234,9044,9047,4857,483、520162016201720172018201820192019202020204,1414,1414,1414,1414,1414,1414,1414,1414,1414,141121212121212121212126876876876876876876876876876873,4413,4413,4413,4413,4413,4413,4413,4413,4413,4410 00 00 00 00 03,4413,4413,4413,4413,4413,4413,4413,4413,4413,441860860860860860860860860860860企业所得税25%2,58124、,5812,5812,5812,5812,5812,5812,5812,5812,581法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册资本的50%时,即不再提取2,5812,5812,5812,5812,5812,5812,5812,5812,5812,581项目建成后三年还款宽限期10,06610,06612,64612,64615,22715,22717,80817,80820,38920,389短期还款在贷款第二年年底还损损益益表表 单单位位:万万元元土土地地一一级级开开发发二二期期项项目目达达产产期期企业所得税25%法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册5、资本的50%时,即不再提取项目建成后三年还款宽限期短期还款在贷款第二年年底还总成本费用估算表 单位:万元土土地地一一级级开开发发二二期期项项目目序序号号项项目目合合计计熟熟地地转转让让期期2,0132,0132,0142,0142,0152,0152,0162,0163工工资资及及福福利利费费1,9201,9202402402402402402402402403日日常常运运营营成成本本1,9201,9202402402402402402402402408其其他他费费用用1,6561,6562072072072072072072072079总总成成本本费费用用5,4965,496687687686、76876876876876879.1固固定定成成本本-9.2可可变变成成本本-10经经营营成成本本5,4965,4966876876876876876876876872,0172,0172,0182,0182,0192,0192,0202,020240240240240240240240240土地转让公司20人工资按10000计算240240240240240240240240转让收入的5%207207207207207207207207按固定资产投资4%计算687687687687687687687687-687687687687687687687687总成本费用估算表 单位:万元熟熟地地7、转转让让期期投投资资计计划划与与资资金金来来源源 单位:万元土土地地一一级级开开发发二二期期项项目目序序号号项项目目合合计计建建设设期期熟熟地地转转让让期期20132013201420141 1总总投投资资¥16,56316,563¥16,56316,563¥-1.1固定资产投资¥16,56316,563¥16,56316,563¥-1.2建设期利息¥-¥-¥-1.2.2固定资产利息¥-¥-¥-1.2.2流动资金利息¥-¥-¥-1.3流动资金¥-¥-¥-2 2资资金金来来源源¥16,56316,563¥16,56316,563¥-2.1自有资金¥16,56316,563¥16,56316,568、3¥-2.1.1固定资产投资¥16,56316,563¥16,56316,563 2.1.2流动资金¥-2.2固定资产投资借款¥-¥-¥-2.2.1建行借款当年借款¥-待还利息¥-¥-累计贷款金额¥-¥-¥-2.3流动资金借款¥-¥-¥-当年借款¥-待还利息¥-¥-2015201520162016¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-总投资41725.86利率7.50%¥-¥-¥-¥-¥-¥-投投资资计计划划与与资资金金来来源源 单位:万元熟熟地地转转让让期期销售收入、销售税金及附加估算表 单位:万元土土地地一一级级开开发发二二期期项项目目序序号号项项目目合合计计熟熟地地经经9、营营期期201320132014201420152015201620161 1熟熟地地转转让让收收入入34,65634,6564,1414,1414,1414,1414,1414,1414,1414,1412 2销售税金及附加2,3352,3351371371371371371371371372.1增值税994994124124124124124124124124 2.1.1销售税额(17%)267,660267,660124124124124124124124124 2.1.2进项税额-2.2城市维护建设税(7%)70709 99 99 99 92.3教育费附加(3%)16,59216,5910、24 44 44 44 4201720172018201820192019202020204,1414,1414,1414,1414,1414,1414,1414,141二期项目开发土地1530.7137137137137137137137137可供转让的土地1242.2124124124124124124124124124124124124124124124124 土地转让估价 400元/平米266666.667-政府生地估价 160元/平米9 99 99 99 94 44 44 44 416,56316,563销售收入、销售税金及附加估算表 单位:万元熟熟地地经经营营期期33125.333 4140.667
地产规划
上传时间:2024-10-10
163份