July 275,000 $ $ 272,250 $ 141,900 $ August September October November 290,000 $ 330,000 $ 470,000 $ 400,000 287,100 $ 326,700$ 465,300 $ $ 396,000 202,100 $ $ 172,000 $ $ July August September 27,225$ 54,450 $ 207,900 28,710 $ 54,450 $ 190,575 $ 32,670 57,420 190,575 289,575$ 273,735 $ 280,665 short-term rate uncollectible AR in month AR in 30 AR In 60 labor Information 9% 1.00% 10% 20% 70% 10% of coming mth 131,580 $ 29,000 $ 12,000 $ 165,980$ 33,000$ 12,000 $ $ 190,060 47,000 12,000 30,000 Beg. Bal June minimum bal purchases pald: $ 25,000 1 FILL IN YELLOW BLANKS 2 3 4 5 6 April May June 7 Sales $ 320,000$ $ 300,000 $ 275,000 $ 8 Collectable sales $ 316,800 $ 297,000 $ 272,250 $ 9 Purchases $ 118,250 $ 118,250 $ 124,700$ 10 11 12 Cash Budget June 13 Cash Inflows 14 Collected in cash $ 27,225$ 15 30 days $ 59,400 $ 16 60 days $ 221,760 $ 17 18 Total Cash Inflows | $ $ 308,385 $ 19 20 Cash Outflows 21 Purchase payments $ 120,830$ 22 Labor $ 27,500 $ 23 Overhead $ 12,000 $ 24 Long term interest payments $ 30,000 25 Dividends $ $ 50,000 26 Tax payment $ 25,000 27 Capital outlay $ 28 Interest of short-term borrowing 29 Total Cash Out flows $ 265,330 $ 30 31 Financing 32 Beginning Balance 33 Balance before financing 34 Borrowing needed 35 Repayment 36 Cumulative borrowing 37 38 Balance after financing 39 32 an 40 41 42 43 44 45 46 47 48 CashBudStory Cash Budget + Ready 300,000 $ 20,000 $ 10,000 43% two month forward 40% month of 60% month after $ 12,000 per month $ 50,000 June $ 25,000 June, sept $ 300,000 july $ 30,000 Jun, sep 472,580 $ 210,980 $ Overhead Dividend tax pmts cap ex Interest 304,060 B a July 275,000 $ $ 272,250 $ 141,900 $ August September October November 290,000 $ 330,000 $ 470,000 $ 400,000 287,100 $ 326,700$ 465,300 $ $ 396,000 202,100 $ $ 172,000 $ $ July August September 27,225$ 54,450 $ 207,900 28,710 $ 54,450 $ 190,575 $ 32,670 57,420 190,575 289,575$ 273,735 $ 280,665 short-term rate uncollectible AR in month AR in 30 AR In 60 labor Information 9% 1.00% 10% 20% 70% 10% of coming mth 131,580 $ 29,000 $ 12,000 $ 165,980$ 33,000$ 12,000 $ $ 190,060 47,000 12,000 30,000 Beg. Bal June minimum bal purchases pald: $ 25,000 1 FILL IN YELLOW BLANKS 2 3 4 5 6 April May June 7 Sales $ 320,000$ $ 300,000 $ 275,000 $ 8 Collectable sales $ 316,800 $ 297,000 $ 272,250 $ 9 Purchases $ 118,250 $ 118,250 $ 124,700$ 10 11 12 Cash Budget June 13 Cash Inflows 14 Collected in cash $ 27,225$ 15 30 days $ 59,400 $ 16 60 days $ 221,760 $ 17 18 Total Cash Inflows | $ $ 308,385 $ 19 20 Cash Outflows 21 Purchase payments $ 120,830$ 22 Labor $ 27,500 $ 23 Overhead $ 12,000 $ 24 Long term interest payments $ 30,000 25 Dividends $ $ 50,000 26 Tax payment $ 25,000 27 Capital outlay $ 28 Interest of short-term borrowing 29 Total Cash Out flows $ 265,330 $ 30 31 Financing 32 Beginning Balance 33 Balance before financing 34 Borrowing needed 35 Repayment 36 Cumulative borrowing 37 38 Balance after financing 39 32 an 40 41 42 43 44 45 46 47 48 CashBudStory Cash Budget + Ready 300,000 $ 20,000 $ 10,000 43% two month forward 40% month of 60% month after $ 12,000 per month $ 50,000 June $ 25,000 June, sept $ 300,000 july $ 30,000 Jun, sep 472,580 $ 210,980 $ Overhead Dividend tax pmts cap ex Interest 304,060 B a
