Question
Great Grannyflats has provided the following information: Oct-21Nov-21Dec-21 Credit Sales $229,600 $228,520 $212,500 Receipts from Debtors $251,560 $226,792 $219,016 Proceeds from sale of Motor Vehicle
Great Grannyflats has provided the following information:
Oct-21Nov-21Dec-21
Credit Sales $229,600 $228,520 $212,500
Receipts from Debtors $251,560 $226,792 $219,016
Proceeds from sale of Motor Vehicle $-$-$21,600
Payment to suppliers $46,800 $63,000 $86,400
Credit Purchases $15,300 $18,900 $18,900
Payment of Wages $45,000 $63,000 $63,000
Payment of September 2021 BAS $-$115,200 $-
Other Cash Purchases $10,800 $19,800 $12,600
Cash Purchase of Small Truck $135,000 $-$-
The Bank Balance at the end of September 2021 is expected to be $46,800.
Required:
Prepare a Cash Budget on a monthly basis for Great Grannyflats for the quarter ending December 2021
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