Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following Data related to cash of Widow company Beginning Cash Balance of May 25,000 Minimum cash Required at ending of each month is $20,000, it

image text in transcribed
image text in transcribed
image text in transcribed
Following Data related to cash of Widow company Beginning Cash Balance of May 25,000 Minimum cash Required at ending of each month is $20,000, it has an ability to borrow from a bank to reach for minimum required cash at monthly interest rate 15 and repay the loan in month has sufficient cash fund Estimated sales: for May is $220,000 and For June is $200,000 Estimated FG Purchases for May is $140,000 and for June is $200,000 operating Expenses include 55000 monthly depreciation for May is $55,000 and for June Is $45,000 the policy of Company is collect cash from customer as following 80% in same month, 20% in following month and pay to supplier for FG purchases as following: Tosin same month and 305 in Following month Pald operating expense in same month occurred except depreciation there is no A/R or A/P at beginning of May Prepare cath budget for May and June June May Beginning Cash Balance Add Cash Receipts Cash Collection from Customers Cash Available les Cash Disbursements Cash Pald to suppliers CashPoid to Operating Expenses Total Cash Disbursements Excess deficiency cash available over cash disbursed Financing Add borrowings Less: Loan Repayment Les interest Ending Cash Balance

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

Step: 3

blur-text-image

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

Operational Auditing A Complete Guide Practical Tools For Self Assessment

Authors: The Art Of Service Operational Auditing Publishing

2021 Edition

1867442043, 978-1867442042

More Books

Students also viewed these Accounting questions