Question: How would i make a quarterly statement using this? Cash Budget Statement 31st December 2025 Reciepts: January February March April May June July August September

How would i make a quarterly statement using this?

Cash Budget Statement 31st December 2025
Reciepts: January February March April May June July August September October November December TOTAL
Customers 24,544.00 28,346.00 29,704.00 28,346.00 28,785.00 29,025.00 30,928.00 28,526.00 29,704.00 31,168.00 29,445.00 29,025.00 347,546.00
Capital 10,000.00 10,000.00
Total Reciepts 34,544.00 28,346.00 29,704.00 28,346.00 28,785.00 29,025.00 30,928.00 28,526.00 29,704.00 31,168.00 29,445.00 29,025.00 357,546.00
Payments
Rent 27,150.00 27,150.00 27,150.00 27,150.00 108,600.00
Utilities 8,000.00 8,000.00 8,000.00 24,000.00
Maintenance 8,500.00 8,500.00 8,500.00 25,500.00
Salaries 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 5,040.00 60,480.00
Food & Vet 7,546.00 6,966.50 7,546.00 6,966.50 7,256.25 7,256.25 7,837.00 6,966.50 7,546.00 7,837.00 7,256.25 80,980.25
Cleaning 3,018.40 2,786.60 3,018.40 2,786.60 2,902.50 2,902.50 3,134.80 2,786.60 3,018.40 3,134.80 2,902.50 2,902.50 35,294.60
Marketing 3,500.00 1,000.00 1,000.00 5,500.00
Computer 1,000.00 1,000.00 2,000.00
Total Payments 38,708.40 16,372.60 16,024.90 59,022.60 14,909.00 15,198.75 60,081.05 15,663.60 15,024.90 60,370.80 15,779.50 15,198.75 342,354.85
Net Cash Flow - 4,164.40 11,973.40 13,679.10 - 30,676.60 13,876.00 13,826.25 - 29,153.05 12,862.40 14,679.10 - 29,202.80 13,665.50 13,826.25 15,191.15
Opening Balance - - 4,164.40 7,809.00 21,488.10 - 9,188.50 4,687.50 18,513.75 - 10,639.30 2,223.10 16,902.20 - 12,300.60 1,364.90 -
Closing Balance - 4,164.40 7,809.00 21,488.10 - 9,188.50 4,687.50 18,513.75 - 10,639.30 2,223.10 16,902.20 - 12,300.60 1,364.90 15,191.15 15,191.15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!