Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hobby Gardenis is a garden design and landscaping business. At 30 June 2021. it had a bank balance of $279.000. Provided below are estimates for
Hobby Gardenis is a garden design and landscaping business. At 30 June 2021. it had a bank balance of $279.000. Provided below are estimates for receipts and payments for the three months ending 30 September 2021. July 2021 August 2021 September 2021 $ $ s Recents Tees 257.000 134.000 293.500 Proceeds from the sale of surplus non-current assets 331.900 Payments Salaries and wages 97,700 74.700 79.100 Supplies 4300 7.600 5.700 New equipment 167,500 0 Purchase of plants 81,200 63.800 79,700 Required: Prepare a monthly cash budget for the three months ending 30 September 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.o. $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. Tho - (minus) sign should only be used in front of any amounts that are negative in the last three rows of the cash budget (10., 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. Cush budget for three months ended 30 September 2021 July 2021 s August 2021 September 2021 S 5 ANTICIPATED RECEIPTS Fees Sale of surplus non-current assets Total receipts ANTICIPATED PAYMENTS Salaries and wages Supplies New equipment Plants Total Dyments EXCAS/Detit receipts aver payments Bank balance at beginning of month Bank balance at end of month
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