l

hi I'm stuck in that exercice . I would really appreciate if you can tell me which steps i need to

follow so i can redo the work by myself.

Westex Products is a wholesale distributor of industrial cleaning products. The company treasurer has assembled the following information to assist in preparing a detalled cash budget to support the company's loan application for short-term financing with a local bank: a. Budgeted sales and merchandise purchases for the year 2020, as well as actual sales and purchases for the iast quarter of 2019 . are as follows: b. The company normally collects 65% of a quarter's sales before the quarter ends and another 3396 in the following quarter. The remalnder are uncollectible. This pattern of collections is now being experienced in the 2019 fourth-quarter actuar data. c. 80% of a quarter's merchandise purchases are paid for within the quarter. The remainder are paid in the following quarter; d. Operating expenses for the year. 2020 are budgeted quarterly at $140.000 plus 15% of sales. Of the fised amount 556.000 each quarter is depreciation. 7. The company will pay $28,000 in dilidends each quarter. f. Equiproent purchases of $210120 will be made in the second quarter, and purchases of $134,400 will be made in the third quartec. These purchases will be for cash. 9. The cash account contained $28.000 ot the end of 2019 . The treosuter feets that this represents a mirlimum balance that munt be maintained. h. Any borrowing willake place at the beginning of a quarter. and any repayrnents will be mode at the end of a guarter iat an annual interest rate of tosk. Literest is paid only when the principal is repaid. All borrowings and all repayments of the principat must be in round $1.000 amounts. interest payments can be in any amount. (Compute ioterest on whote inonthi, e.9. N12, 2142. .) I Al present, the company fias no loans outstanding Required: 1. Prepare the following by quarter and in total for the year 2020 : a. A schedule of expected cash collections. b. A schedute of budgeted cash disbursements for merchandise purchases. b. A schedule of budgeted cash disbursements for merchandise purchases. 2. Compute the expected cash payments for operating expenses, by quarter and in total, for the year 2020 . Assignment i 4. Consider the cash balance at the end of the fourth quarter as calculated in Requirement (3). Recalculate the ending balance if tepayment of principal can be in round $100 amounts. (Do not round intermediate calculations. Round your answer to 2 decimni ploces.) 4. Consider the cash balance at the end of the fourth quarter as calculated in Requirement (3). Recalculate the ending balance if tepayment of principal can be in round $100 amounts. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Westex Products is a wholesale distributor of industrial cleaning products. The company treasurer has assembled the following information to assist in preparing a detalled cash budget to support the company's loan application for short-term financing with a local bank: a. Budgeted sales and merchandise purchases for the year 2020, as well as actual sales and purchases for the iast quarter of 2019 . are as follows: b. The company normally collects 65% of a quarter's sales before the quarter ends and another 3396 in the following quarter. The remalnder are uncollectible. This pattern of collections is now being experienced in the 2019 fourth-quarter actuar data. c. 80% of a quarter's merchandise purchases are paid for within the quarter. The remainder are paid in the following quarter; d. Operating expenses for the year. 2020 are budgeted quarterly at $140.000 plus 15% of sales. Of the fised amount 556.000 each quarter is depreciation. 7. The company will pay $28,000 in dilidends each quarter. f. Equiproent purchases of $210120 will be made in the second quarter, and purchases of $134,400 will be made in the third quartec. These purchases will be for cash. 9. The cash account contained $28.000 ot the end of 2019 . The treosuter feets that this represents a mirlimum balance that munt be maintained. h. Any borrowing willake place at the beginning of a quarter. and any repayrnents will be mode at the end of a guarter iat an annual interest rate of tosk. Literest is paid only when the principal is repaid. All borrowings and all repayments of the principat must be in round $1.000 amounts. interest payments can be in any amount. (Compute ioterest on whote inonthi, e.9. N12, 2142. .) I Al present, the company fias no loans outstanding Required: 1. Prepare the following by quarter and in total for the year 2020 : a. A schedule of expected cash collections. b. A schedute of budgeted cash disbursements for merchandise purchases. b. A schedule of budgeted cash disbursements for merchandise purchases. 2. Compute the expected cash payments for operating expenses, by quarter and in total, for the year 2020 . Assignment i 4. Consider the cash balance at the end of the fourth quarter as calculated in Requirement (3). Recalculate the ending balance if tepayment of principal can be in round $100 amounts. (Do not round intermediate calculations. Round your answer to 2 decimni ploces.) 4. Consider the cash balance at the end of the fourth quarter as calculated in Requirement (3). Recalculate the ending balance if tepayment of principal can be in round $100 amounts. (Do not round intermediate calculations. Round your answer to 2 decimal places.)