Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hobby Gardens is a garden design and landscaping business. At 30 June 2021, it had a bank balance of $666,100. Provided below are estimates
Hobby Gardens is a garden design and landscaping business. At 30 June 2021, it had a bank balance of $666,100. Provided below are estimates for receipts and payments for the three months ending 30 September 2021. Receipts Fees Proceeds from the sale of surplus non-current assets Payments Salaries and wages Supplies New equipment Purchase of plants. ANTICIPATED RECEIPTS Fees Sale of surplus non-current assets Total receipts ANTICIPATED PAYMENTS Salaries and wages Supplies New equipment Plants July Total payments 2021 Required: Prepare a monthly cash budget for the three months ending 30 September 2021. Excess/Deficit receipts over payments Bank balance at beginning of month Bank balance at end of month $ 233,000 0 July 2021 $ 87,800 6,500 0 88,200 August 2021 $ Important: If you think the amount in a cell should be 0, type 0 - don't leave that cell empty. For any amounts, please don't include the dollar sign ($) or any thousands separator - i.e., $12,000 should be written as 12000. For payments, please don't include the - (minus) sign in front of the amounts and also don't place the amounts in parentheses. The - (minus) sign should only be used in front of any amounts that are negative in the last three rows of the cash budget (i.e., Excess/deficit receipts over payments, Bank balance at beginning of month, Bank balance at end of month) - don't place the negative amounts in parentheses. Cash budget for three months ended 30 September 2021 311,600 0 76,600 5,300 ol 86,800 September 2021 $ 248,800 388,400 86,000 6,400 330,500 87,300 August 2021 September 2021 $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Answer Heres the cash budget for Hobby Gardens for the three months e...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