投資項目財務計算模型全套表格含公式自動計算-土地一級開發二期項目.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份