Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do i make a quarterly statement from this information? Reciepts: July August September October November December Customers 30,928.00 28,526.00 29,704.00 31,168.00 29,445.00 29,025.00 Capital
how do i make a quarterly statement from this information?
Reciepts: | July | August | September | October | November | December |
Customers | 30,928.00 | 28,526.00 | 29,704.00 | 31,168.00 | 29,445.00 | 29,025.00 |
Capital | ||||||
Total Reciepts | 30,928.00 | 28,526.00 | 29,704.00 | 31,168.00 | 29,445.00 | 29,025.00 |
Payments | ||||||
Rent | 27,150.00 | 27,150.00 | ||||
Utilities | 8,000.00 | 8,000.00 | ||||
Maintenance | 8,500.00 | 8,500.00 | ||||
Salaries | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 |
Food & Vet | 7,256.25 | 7,837.00 | 6,966.50 | 7,546.00 | 7,837.00 | 7,256.25 |
Cleaning | 3,134.80 | 2,786.60 | 3,018.40 | 3,134.80 | 2,902.50 | 2,902.50 |
Marketing | 1,000.00 | 1,000.00 | ||||
Computer | ||||||
Total Payments | 60,081.05 | 15,663.60 | 15,024.90 | 60,370.80 | 15,779.50 | 15,198.75 |
Net Cash Flow | - 29,153.05 | 12,862.40 | 14,679.10 | - 29,202.80 | 13,665.50 | 13,826.25 |
Opening Balance | 18,513.75 | - 10,639.30 | 2,223.10 | 16,902.20 | - 12,300.60 | 1,364.90 |
Closing Balance | - 10,639.30 | 2,223.10 | 16,902.20 | - 12,300.60 | 1,364.90 | 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