10)資金移動表を応用しての簡易資金繰り表の作成(後期)
A社Z期後期資金繰予定表 | |||||||||||||
Y期各月損益・貸借実績をもとに、Z期各月損益・貸借予算をたて、各月ごとに資金移動表を作成し、そのまま暦月に並べたもの | |||||||||||||
Z期後期予算 | 10月 | 累計 | 11月 | 累計 | 12月 | 累計 | 1月 | 累計 | 2月 | 累計 | 3月 | 累計 | |
売上高 | 74,173 | 85,314 | 12,809 | 98,123 | 12,916 | 111,039 | 11,670 | 122,709 | 12,924 | 135,633 | 13,647 | 149,280 | |
売上債権増▲ | 2,299 | -155 | 765 | 610 | -574 | 36 | -201 | -165 | -36 | -201 | 1,184 | 983 | |
営業外収益 | 595 | 646 | 0 | 646 | 0 | 646 | 0 | 646 | 0 | 646 | 0 | 646 | |
前受金増 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
経常収入 | 72,469 | 86,115 | 12,044 | 98,159 | 13,490 | 111,649 | 11,871 | 123,520 | 12,960 | 136,480 | 12,463 | 148,943 | |
売上原価 | 59,658 | 69,629 | 9,577 | 79,206 | 10,487 | 89,693 | 10,134 | 99,827 | 9,495 | 109,322 | 9,472 | 118,794 | |
買掛増▲ | -1,440 | -1,680 | -240 | -1,920 | -240 | -2,160 | 0 | -2,160 | 0 | -2,160 | 0 | -2,160 | |
未払増▲ | 19,011 | 18,945 | -66 | 18,879 | -67 | 18,812 | -89 | 18,723 | -67 | 18,656 | -67 | 18,589 | |
他流動負債▲ | 235 | 231 | -4 | 227 | 58 | 285 | 40 | 325 | 15 | 340 | 651 | 991 | |
管理・営業外費 | 8,759 | 9,921 | 1,030 | 10,951 | 3,026 | 13,977 | 1,316 | 15,293 | 1,179 | 16,472 | 1,219 | 17,691 | |
減価償却▲ | 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 | |
他流動資産 | 276 | 276 | 0 | 276 | 0 | 276 | 27 | 303 | 0 | 303 | -60 | 243 | |
経常支出 | 50,887 | 62,330 | 10,917 | 73,247 | 13,762 | 87,009 | 11,526 | 98,535 | 10,726 | 109,261 | 10,047 | 119,308 | |
経常収支(1) | 21,582 | 23,785 | 1,127 | 24,912 | -272 | 24,640 | 345 | 24,985 | 2,234 | 27,219 | 2,416 | 29,635 | + |
特別利益 | 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 | |
法人税等 | 70 | 70 | 0 | 70 | 0 | 70 | 0 | 70 | 0 | 70 | 0 | 70 | |
報酬・配当 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
有形固定資産 | 19,600 | 19,600 | 0 | 19,600 | 0 | 19,600 | 0 | 19,600 | 0 | 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 | |
貸付金増 | -2,016 | -2,016 | 0 | -2,016 | 0 | -2,016 | 0 | -2,016 | 0 | -2,016 | 0 | -2,016 | |
特別損失 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
経常外支出 | 17,654 | 17,654 | 0 | 17,654 | 0 | 17,654 | 0 | 17,654 | 0 | 17,654 | 0 | 17,654 | |
経常外収支(2) | -17,654 | -17,654 | 0 | -17,654 | 0 | -17,654 | 0 | -17,654 | 0 | -17,654 | 0 | -17,654 | - |
長期借入増 | -7,629 | -8,874 | -1,245 | -10,119 | -1,245 | -11,364 | -1,245 | -12,609 | -1,245 | -13,854 | -1,245 | -15,099 | |
短期借入増 | 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 | 0 | 0 | 0 | 0 | 0 | |
財務収入(3) | -7,629 | -8,874 | -1,245 | -10,119 | -1,245 | -11,364 | -1,245 | -12,609 | -1,245 | -13,854 | -1,245 | -15,099 | - |
現預金増 | -3,701 | -2,743 | -118 | -2,861 | -1,517 | -4,378 | -900 | -5,278 | 989 | -4,289 | 1,171 | -3,117 | 現預金勘定合 |
(1+2+3) | -3,701 | -2,743 | -118 | -2,861 | -1,517 | -4,378 | -900 | -5,278 | 989 | -4,289 | 1,171 | -3,118 | |
期首現預金残高 | 18,602 | 20,827 | 18,084 | 20,827 | 17,966 | 20,827 | 16,449 | 20,827 | 15,549 | 20,827 | 16,538 | 20,827 | |
期末現預金残高 | 14,901 | 18,084 | 17,966 | 17,966 | 16,449 | 16,449 | 15,549 | 15,549 | 16,538 | 16,538 | 17,709 | 17,709 |
しばらくお待ちください