Fin Saimen CV PDFFF

Download as pdf or txt
Download as pdf or txt
You are on page 1of 1

Cash Budget

Company Velesto Energy Berhad

Year 2022 2023 2024 2025 2026 2027 2028


Sales 377,509.00 580,853.00 781,850.00 842,001.00 762,500.00 742,000.00 983,020.00 725,890.00

Cash Receipts :
Cash Sales (10%) 84,200.10 76,250.00 74,200.00 98,302.00 72,589.00
Collection on Sales (50%) 390,925.00 421,000.50 381,250.00 371,000.00 491,510.00
Collection on Sales (30%) 174,255.90 234,555.00 252,600.30 228,750.00 222,600.00
Collection on Sales (10%) 37,750.90 58,085.30 78,185.00 84,200.10 76,250.00
Total cash receipts 687,131.90 789,890.80 786,235.30 782,252.10 862,949.00

Purchases 348,511.80 469,110.00 505,200.60 457,500.00 445,200.00 589,812.00 435,534.00

Cash Disbursements :
Cash (20%) 101,040.12 91,500.00 89,040.00 117,962.40 87,106.80
Payment on Purchases (50%) 234,555.00 252,600.30 228,750.00 222,600.00 294,906.00
Payment on Purchases (30%) 104,553.54 140,733.00 151,560.18 137,250.00 133,560.00
New Equipment 42,500.00
Rent 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00
Loan Payment 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00
Wages and Salaries (5%) 42,100.05 38,125.00 37,100.00 49,151.00 36,294.50
Total cash disburments 518,248.71 558,958.30 584,950.18 562,963.40 587,867.30
Net Cash Flow 168,883.19 230,932.50 201,285.12 219,288.70 275,081.70
Beginning Cash Balance 60,950.00 229,833.19 460,765.69 662,050.81 881,339.51
Ending Cash Balance 229,833.19 460,765.69 662,050.81 881,339.51 1,156,421.21
Minimum Cash Balance 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00
Surplus 184,833.19 415,765.69 617,050.81 836,339.51 1,111,421.21
Deficit

You might also like