9)資金移動表を応用して簡易資金繰表の作成(前期)
A社Z期前期資金繰予定表 | ||||||||||||
Y期各月損益・貸借実績をもとに、Z期各月損益・貸借予算をたて、各月ごとに資金移動表を作成し、そのまま暦月に並べたもの | ||||||||||||
Z期前期予算 | 前期末 | 4月 | 5月 | 累計 | 6月 | 累計 | 7月 | 累計 | 8月 | 累計 | 9月 | 累計 |
売上高 | 12,621 | 11,728 | 24,349 | 12,306 | 36,655 | 12,802 | 49,457 | 11,752 | 61,209 | 11,141 | 72,350 | |
売上債権増▲ | 2,728 | -2,353 | 375 | 10 | 385 | 407 | 792 | 383 | 1,175 | -2,454 | -1,279 | |
営業外収益 | 16 | 0 | 16 | 356 | 372 | 1 | 373 | 0 | 373 | 51 | 424 | |
前受金増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
経常収入 | 0 | 9,909 | 14,081 | 23,990 | 12,652 | 36,642 | 12,396 | 49,038 | 11,369 | 60,407 | 13,646 | 74,053 |
売上原価 | 10,532 | 9,287 | 19,819 | 9,489 | 29,308 | 9,681 | 38,989 | 10,829 | 49,818 | 9,971 | 59,789 | |
買掛増▲ | -240 | -240 | -480 | -240 | -720 | -240 | -960 | -240 | -1,200 | -240 | -1,440 | |
未払増▲ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19,077 | 19,077 | -66 | 19,011 | |
他流動負債▲ | 21 | 69 | 90 | -12 | 78 | 39 | 117 | 73 | 190 | -4 | 186 | |
管理・営業外費 | 1,110 | 2,101 | 3,211 | 1,486 | 4,697 | 1,486 | 6,183 | 1,342 | 7,525 | 1,162 | 8,687 | |
減価償却▲ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
繰延償却▲ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
棚卸増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
他流動資産 | 0 | 0 | 0 | 416 | 416 | 114 | 530 | -254 | 276 | 0 | 276 | |
経常支出 | 0 | 11,861 | 11,559 | 23,420 | 11,643 | 35,063 | 11,482 | 46,545 | -6,993 | 39,552 | 11,443 | 50,995 |
経常収支(1) | 0 | -1,952 | 2,522 | 570 | 1,009 | 1,579 | 914 | 2,493 | 18,362 | 20,855 | 2,203 | 23,058 |
特別利益 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
他固定負債増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
経常外収入 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
法人税等 | 0 | 70 | 70 | 0 | 70 | 0 | 70 | 0 | 70 | 0 | 70 | |
報酬・配当 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
有形固定資産 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19,600 | 19,600 | 0 | 19,600 | |
無形・投資・繰延 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
引当金増▲ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
貸付金増 | 0 | 0 | 0 | -2,016 | -2,016 | 0 | -2,016 | 0 | -2,016 | 0 | -2,016 | |
特別損失 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
経常外支出 | 0 | 0 | 70 | 70 | -2,016 | -1,946 | 0 | -1,946 | 19,600 | 17,654 | 0 | 17,654 |
経常外収支(2) | 0 | 0 | -70 | -70 | 2,016 | 1,946 | 0 | 1,946 | -19,600 | -17,654 | 0 | -17,654 |
長期借入増 | -1,245 | -1,245 | -2,490 | -2,961 | -5,451 | -1,245 | -6,696 | 312 | -6,384 | -1,245 | -7,629 | |
短期借入増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
割引手形増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
預り保証金増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
有価証券増▲ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
資本金増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
財務収入(3) | 0 | -1,245 | -1,245 | -2,490 | -2,961 | -5,451 | -1,245 | -6,696 | 312 | -6,384 | -1,245 | -7,629 |
現預金増 | -3,197 | 1,207 | -1,990 | 65 | -1,925 | -332 | -2,257 | -926 | -3,183 | 960 | -2,223 | |
(1+2+3) | 0 | -3,197 | 1,207 | -1,990 | 64 | -1,926 | -331 | -2,257 | -926 | -3,183 | 958 | -2,225 |
期首現預金残高 | 20,827 | 17,630 | 20,827 | 18,837 | 20,827 | 18,901 | 20,827 | 18,570 | 20,827 | 17,644 | 20,827 | |
期末現預金残高 | 20,827 | 17,630 | 18,837 | 18,837 | 18,901 | 18,901 | 18,570 | 18,570 | 17,644 | 17,644 | 18,602 | 18,602 |
ただいま工事中です。しばらくお待ちください。