投资收益及项目现金流测算(明细模板)

51,938.25
72,647.21
37,802.60
25,475.13
32,715.92
35,072.91
4,117.02 2,917.25 1,166.90 1,100.00 2,374.50 13,965.12 2,333.80 2,756.93
6,345.43 4,906.90 1,962.76 1,100.00 2,374.50 13,708.97 3,925.52 4,249.17
9279900 12690000 9214749 31184649 7065000 24119649 118.75
15700
7,140.00 547.59 739,359.95
71,400.00 739,359.95 739,359.95
2014 Q3 67,936.00 9,936.00 3,000.00 50,000.00 5,000.00 44,418.94 40,000.00 95,158.52 47,051.00 300,000.00 43,003.00 Q4 87,456.05 43,456.05 4,000.00 Q1 395,351.64 80,178.48 15,173.16
5,008.17 3,667.99 1,467.19 1,210.00 2,374.50 13,555.28 2,934.39 3,353.69
2,394.22 1,334.10 533.64 1,210.00 2,374.50 13,401.59 1,067.28 1,603.27
900.03 1,210.00 2,374.50 13,247.90 602.70
23,517.06 23,517.06
-7,702.47 15,814.59
2,380.00 352,348.64 368,163.23
7,140.00 13,467.21 381,630.44
2015 Q3 273,518.18 58,345.02 15,173.16 Q4 113,311.20 98,138.04 15,173.16 Q1 89,431.64 73,359.70 16,071.94
2015 Q2 51,895.14 36,721.98 15,173.16
38,427.93
32,000.00 556.42 496.80 198.72 1,000.00 1,424.50 1,898.46 397.44 372.60 934.00 800.00 1,465.00 2,875.00
10,500.00 2,433.54 2,172.80 869.12 1,000.00 1,424.50 3,073.72 1,738.24 1,629.60 805.00 445.00 1,465.00 2,875.00 17,676.00 5,339.69 4,008.92 1,603.57 1,100.00 2,374.50 9,772.49 3,207.14 3,575.69 676.00 1,465.00 7,500.00 2,906.13 1,836.10 734.44 1,100.00 2,374.50 9,618.81 1,468.88 1,946.07 338.00 1,465.00 7,500.00
项目名称： 现金流入 股东投入 销售收入 租金收入 银行按揭 信托资金 银行贷款 物业贷 现金流出 2.1 土地费用 2.2 前期工程费 2.3 基础设施建设费及规费 2.4 建筑安装工程费 2.5 公共配套及配套设施建设费 2.6 装修费 2.6 不可预见费 2.7 税金及附加 2.8 销售--管理费用 2.9 销售--销售费用 3.0 出租--管理费用 3.1.1 财务费用（浦发） 3.1.2 财务费用（农行或 2号物业 贷） 3.2 土增税 2.10开发期税费 2.11所得税 信托利益偿还（长城） 信托利益偿还（华融） 信托利益偿还（中粮） 信托本金偿还（长城） 信托本金偿还（华融） 信托本金偿还（中粮） 银行贷款归还农行 净现金流 资金余额
656.00
224.00
7,140.00 234,181.66 615,812.10
11,900.00 61,372.95 677,185.05
31,280.00 7,140.00 16,784.43 693,969.48
6,520.00 7,140.00 4,951.32 698,920.80
7,140.00 -9,403.19 689,517.61
2,934.87 1,816.82 726.73 1,210.00 2,374.50 13,094.22 1,453.46 1,965.32
3,621.81 2,381.71 952.68 1,331.00 2,374.50 12,940.53 1,905.36 2,425.32
Baidu Nhomakorabea1,465.00
1,465.00
7,140.00 19,692.48 709,210.09
7,140.00 29,602.27 738,812.36
2017 Q2 28,004.28 10,963.22 17,041.06
合计 1,282,813.57 521,751.05 159,062.52 50,000.00 5,000.00 27,456.69 543,453.62 47,051.00 42,500.00 1,568.24 548.16 219.26 1,331.00 2,374.50 12,786.84 438.53 1,050.16 20,870.04 25,530.52 38,125.57 26,087.55 10,435.01 13,902.00
2016 Q2 42,753.92 26,681.98 16,071.94 Q3 16,071.94 16,071.94 Q4 52,408.40 36,336.46 16,071.94
2017 Q1 64,675.18 47,634.12 17,041.06
200,000.00 39,336.52