Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting

Authors: Tracie Miller Nobles, Brenda Mattison

7th Edition

0136516254, 9780136516255

More Books

Students also viewed these Accounting questions