Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 CASH BUDGET EXTRA QUESTION 01 ABC Store has applied for a loan at Riyad Bank. Before the loan is approved, the bank has

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Question 1 CASH BUDGET EXTRA QUESTION 01 ABC Store has applied for a loan at Riyad Bank. Before the loan is approved, the bank has requested a cash budget at June 30, 2017. As the controller of the store; you have assembled the following information: May 31 balance sheet information: Cash Account Receivable Inventory balance Equipment Accumulated depreciation Account Payable Owners' Equity $50,200 $15,300 $11,900 $80,800 $12,400 $8,300 S137,500 Planned June operating activity information: a. Purchase inventory costing $60,000 b. Sales $85,000 c. Salary of S1 2,000 for cash d. Depreciation expenses, S4,000. e. Purchase office equipment $15,000 and paid 20% cash and the remaining will be paid in the next month. f. Other June operating expenses, including income tax, total $34,000, 75% of which will be paid this month and remaining in the following month, Utility expenses of $6,000 ( 75% of cash), g. Incur advertising expense $5,000 and it will be paid in the next month July operating information:- a. Sales of $180,000 b. Purchase of $170,000 c. Salary of $25,000 for cash. d. Other operating expenses, income taxes $7,000 of which 60% will be paid for cash. Supplies expenses of $2,000 cash, Rent expenses of $1,500. e Owner invest additional capital $20,000 f. Sale an old computer for $500 cash g. Paid utilities expense $10,000 h. Bought a land costing $200,000 and paid 15% for this transaction and the remaining is on notes payable The company paid policy is to pay 40% of purchase within current month and the remainder for the next month. The company collects cash from customer 60% in the current month and the remainder for the next month. The company need to maintain $20,000 cash balance every month. Instructions: Prepare the cash budget for the month of June and July 2017 TOTAL SALES CURRENT MONTH 60% CURRENT 40% AFTER 1 MONTH JUNE 60% CURRENT 40% AFTER 1 MONTH JULY COLLECTION & PAYMENT POLICY SCHEDULE 1 EXPECTED COLLECTION FROM CUSTOMER BS 6b MAY JUNE JULY TOTAL COLLECTIONS 7- $ $ Instructions: Prepare the cash budget for the month of June and July 2017 TOTAL SALES CURRENT MONTH 60% CURRENT 40% AFTER 1 MONTH JUNE 60% CURRENT 40% AFTER 1 MONTH JULY COLLECTION & PAYMENT POLICY SCHEDULE 1 EXPECTED COLLECTION FROM CUSTOMER BS 6b MAY JUNE JULY TOTAL COLLECTIONS 7- $ $ Less: Disbursements Direct materials (See Schedule 2] 7- C 6- Salary Purchase of office equipment 20% cash of the amount 6- f 6 Selling and administrative & income tax expenses 7- d 7- 8 Utility expenses Advertising expenses 6- 8 7- Purchase of land Total disbursements Excess (deficiency) of available cash over cash disbursements Financing Add: Borrowings Less: Repayments 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

Finance And Accounting For Nonfinancial Managers

Authors: Steven A. Finkler

5th Edition

9780808046905

More Books

Students also viewed these Accounting questions

Question

Delete

Answered: 1 week ago