For this assignment choose a hypothetical business and prepare a forecasted Cash Budget for that business for 5 years (Month Wise).

Sample:

May June October November December April 535,000 September 750,365 572,450 Cash Forecasting of ABC Company July August 612,522 655,398 701,276 428,765 458,779 490,893 183,756 196,619 210,383 802,891 859,093 Particulars Sale (500000) @ 7% per month Cash Sale (70% of Sale) Credit Sale (30%) 919,230 374,500 525,256 562,024 601,365 643,461 400,715 171,735 160,500 225, 110 240,867 257,728 275, 769 Cash Collection 374,500 561,215 600,500 642,535 687,513 735,638 787,133 842,232 901,189 347,750 398,139 426,009 455,829 487,737 521,879 558,411 597,499 91,878 372,093 85,868 22,898 98,310 105, 191 112,555 120,434 128,864 CGS (65% of Sale) Admin Exp (15% of Sale) Tax (20%) Cash Payment Cash Balance 137,884 80,250 21,400 449,400 24,501 26,216 28,051 30,015 32,116 34,364 36,769 480,858 514,518 550,534 589,072 630,307 674,428 721,638 772,153 74,900 80,357 85,982 92,001 98,441 105,332 112,705 120,594 129,036 Profit 107,000 114,490 122,504 131,080 140,255 150,073 160,578 171,819 183,846 Options Borrow (10%) 74,900 - 82,390 2,236 74,900 - 2,033 83,746 Cash Balance Cash Balance Invest (10%) 83,746 175,746 274,187 379,519 492,224 741,854 612,818 772,617 83,746 184,121 300,974 436,403 592,748 978,915 May June October November December April 535,000 September 750,365 572,450 Cash Forecasting of ABC Company July August 612,522 655,398 701,276 428,765 458,779 490,893 183,756 196,619 210,383 802,891 859,093 Particulars Sale (500000) @ 7% per month Cash Sale (70% of Sale) Credit Sale (30%) 919,230 374,500 525,256 562,024 601,365 643,461 400,715 171,735 160,500 225, 110 240,867 257,728 275, 769 Cash Collection 374,500 561,215 600,500 642,535 687,513 735,638 787,133 842,232 901,189 347,750 398,139 426,009 455,829 487,737 521,879 558,411 597,499 91,878 372,093 85,868 22,898 98,310 105, 191 112,555 120,434 128,864 CGS (65% of Sale) Admin Exp (15% of Sale) Tax (20%) Cash Payment Cash Balance 137,884 80,250 21,400 449,400 24,501 26,216 28,051 30,015 32,116 34,364 36,769 480,858 514,518 550,534 589,072 630,307 674,428 721,638 772,153 74,900 80,357 85,982 92,001 98,441 105,332 112,705 120,594 129,036 Profit 107,000 114,490 122,504 131,080 140,255 150,073 160,578 171,819 183,846 Options Borrow (10%) 74,900 - 82,390 2,236 74,900 - 2,033 83,746 Cash Balance Cash Balance Invest (10%) 83,746 175,746 274,187 379,519 492,224 741,854 612,818 772,617 83,746 184,121 300,974 436,403 592,748 978,915