Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started