Required:1. Prepare a schedule of expected cash collections for July, August, and September. Also, compute total cash collections for thequarter ended September 30.2-a. Prepare a merchandise purchases budget for July, August, and September. Also, compute total merchandise purchases for thequarter ended September 30.2-b. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September. Also, computetotal cash disbursements for merchandise purchases for the quarter ended September 30.3. Prepare an income statement for the quarter ended September 30.4. Prepare a balance sheet as of September 30.Complete this question by entering your answers in the tabs below.Required 1 Required 2A Required 2BRequired 3 Required 4Prepare a merchandise purchases budget for July, August, and September. Also, compute total merchandise purchases for thequarter ended September 30.Budgeted cost of goods soldMerchandise Purchases BudgetJuly$August September Quarter277,500 $292,500 $285,000 $855,000Add: Desired ending merchandise inventoryTotal needsLess: Beginning merchandise inventoryRequired purchases83,250< Required 1Required 2B >83,250

1. Expected Cash CollectionsThis involves forecasting how much money your business expects to…

Answered: Required: 1. Prepare a schedule of…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,760,000 Quarter 2 5,620,000 Quarter 3 3,060,000 Quarter 4 7,720,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,310,000 and for the fourth quarter of the current year are $7,350,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year 4, current year 1, next year 2, next year 3. next vear 4, next year 2. Construct a cash receipts budget for…
LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of December 31, 2018 is as follows: Assets Liabilities Cash $5,000 Accounts Payable $9500 Accounts Recievable 28,000 Inventories Direct Materials 8,100 Finished Goods (500 Units) 16,870 Stockholders Equity Equipment - gross 45,000 Accumulated depreciation 15.000 Common Stock $15,000 Net Equipment 30,000 Retained Earnings 63,470 Total Assets $87,970 Total Liabilities and $87,960 Equity LB sells one product for $45/unit. The Company forecasts that it will sell 2,000; 1,500; 1,600; and 1,700 units in January, February, March and April, respectively. • Sales to customers are all on credit. 40% of the cash for these sales is collected in the month of the sale and the remaining 60% is collected in the following month. LB wants finished goods inventory equal to 25% of the next month's sales on hand at the end of each month. LB wants direct materials equal to 75% of the current month's production…
I need help with starting the calculations for the following two questions.
Please provide complete and correct answer for both requirements and show all work like explanation , computation , formula with steps. Answer in text. Million thanks !
Ahmed Company purchases all merchandise on credit. It recently budgeted the month-end accounts payable balances below. Cash payments on accounts payable during each month are expected to be June, $1,450,000; July, $1,300,000; and August, $1,300,000. Hint: Use the relation (Beg. Accounts Payable + Purchases on Credit - Payments on Accounts Payable = End. Accounts Payable) to solve for budgeted purchases. Accounts payable May 31 June 30 $ 130,000 $ 110,000 Ending accounts payable Add: Cash paid on accounts payable Total accounts payable Less: Beginning accounts payable Budgeted merchandise purchases Computing budgeted merchandise purchases from accounts payable Budgeted amounts: $ June July 31 $ 400,000 0 0 $ July 0 August 31 $ 170,000 0 $ August 0 0
Please help solve steps
A-2
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.
The amount of prepaid expense reflected in the disbursement section of the cash budget is the same amount that is found on the monthly operating statement. True False
Hello - Where does the opening balance of cash come from (how is it derived) in Step 3. Preparing a Cash Budget? (see included picture. THANK YOU!! pz

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS