预算资产负债表excel模板

74,928 89,870 103,564 103,564 107,075 107,075 963,673
91,001 97,823 98,785 98,785 98,785 98,785 994,643
999 1,198 1,381 1,381 1,428 1,428
12,709
141,489 164,345 186,266 189,711 193,951 196,774 2,008,957
110,019 125,783 138,359 132,359 125,509 117,233 1,368,362
132,000 132,000 132,000 132,000 132,000 132,000 1,706,000 13,703 20,117 28,881 37,646 48,056 58,475 250,997
97,000
3,535 3,535 3,535 3,535 3,693 3,693
500
670
670
703
770
783
799
199,500 47,693 47,682 50,701 55,485 56,326 57,470
银行借款 - USD 银行借款 - RMB
银行借款合计
8,280
8,280 8,280 8,280 8,280 8,280 16,560
固定资产 资产折旧 固定资产净值
资产合计
96,000
96,000 96,000 96,100 104,380 115,380 129,600
(12,000) (12,386) (12,773) (13,159) (13,595) (14,064) (14,687)
84,000
83,614 83,227 82,941 90,785 101,316 114,913
345,780 194,491 194,970 198,557 204,644 208,917 229,857
应付帐款
89,000
41,322 41,322 44,255 48,470 49,029 50,072
应交税金 应付工资 其他流动负债 流动负债合计
13,000
2,167 2,156 2,207 2,709 2,822 2,906
2019年预算资产负债表
资产负债表预算
货币资金 盈余资金 应收帐款款 存货 其他流动资产 流动资产合计
2019年 1月
2月
3月
4月
5月
6月
160,000
6,696 6,696 7,031 7,700 7,828 7,995
3,280
3,373
423 (1,390) (10,139) (24,614) (31,631)
145,703 152,117 160,881 169,646 180,056 190,475 1,956,997 255,723 277,899 299,241 302,005 305,565 307,709 3,325,358
负债和所有者权益合计
1
算资产负债表
7月
8月
9月
10月 11月 12月 2019年
9,990 11,983 13,808 13,808 14,277 14,277 282,090
(35,429) (36,529) (31,271) (27,827) (27,613) (24,789) (244,158)
12,709
71,459 85,223 97,799 97,799 98,949 98,953 1,065,042
16,560 16,560 16,560 16,560 16,560 8,280 157,320 22,000 24,000 24,000 18,000 10,000 10,000 146,000 38,560 40,560 40,560 34,560 26,560 18,280 303,320
盈余公积
4,000来自百度文库
4,517 5,008 5,576 6,879 8,311 9,828
所有者权益
134,000 134,517 135,008 135,576 136,879 140,311 141,828
345,780 194,491 194,970 198,557 204,644 208,917 229,857
62,260 74,118 84,933 84,933 84,933 84,933 839,581
4,508 6,214 7,793 7,793 8,896 8,900
72,070
3,693 3,693 3,693 3,693 3,693 3,693 140,682
999 1,198 1,381 1,381 1,428 1,428
48,000
50,220 50,220 52,731 57,753 58,712 59,962
50,000
49,918 53,735 56,541 57,775 64,891 77,820
500
670
670
703
770
783
799
261,780 110,877 111,743 115,616 113,859 107,601 114,944
129,600 129,600 129,700 129,700 129,700 129,700 1,511,460 (15,366) (16,046) (16,726) (17,406) (18,086) (18,765) (195,058) 114,234 113,554 112,974 112,294 111,614 110,935 1,316,402 255,723 277,899 299,241 302,005 305,565 307,709 3,325,358
4,000
4,000 4,000 4,000 4,000 4,000 14,000
12,280
12,280 12,280 12,280 12,280 12,280 30,560
负债合计
211,780 59,973 59,962 62,981 67,765 68,606 88,030
实收资本
130,000 130,000 130,000 130,000 130,000 132,000 132,000