155 Patient Company prepares monthly cash budgets. Relevant data follows for 2023: 156 157 Sales 158 Direct Materials Purchases 159 Direct Labor 160 Manufacturing Overhead 161 Selling & Administrative Expenses May April $420,000 $440,000 145,000 $80,000 $130,000- $ 100,000 $80,000 $70,000 $ 78,000 $82,000 162 163 Sales are 40% cash and 60% credit. Credit collections are expected to be 50% in the month of the sale, 30% in the 164 first month following the sale, and 15% in the second month following the sale. 60% of direct materials purchases 165 are paid in cash in the month of the purchase, and the balance is paid in the month following the purchase. 166 All other items above are paid in the month incurred except for depreciation of $5,000 in Manufacturing 167 Overhead for both April and May, and depreciation of $4,000 in Selling and Administrative Expenses for 168 both April and May. 169 170 Other data: February 2023 credit sales of $150,000; March 2023 credit sales of $120,000. 171 Purchases of direct materials for March of 2023 of $110,000. 172 Other payments of $35,000 for dividends in May. 173 The company's cash balance on April 1, 2023 is expected to be $40,000. 174 175 Prepare a cash budget for April and May. (Show computations.

Please help me with show all calculation thanku

X-Tel budgets sales of $55,000 for April, $110,000 for May, and $70,000 for June. Sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. Total sales for March were $13,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: Total cash receipts X-TEL Schedule of Cash Receipts from Sales April $ $ 55,000 $ 0 $ May 110,000 $ 0 $ June 70,000 0

Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.

Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020:     April   May   June     Credit sales $ 312,000   $ 292,000   $ 352,000     Credit purchases   120,000     143,000     168,000     Cash disbursements                       Wages, taxes, and expenses   43,200     10,700     62,200       Interest   10,200     10,200     10,200       Equipment purchases   72,000     134,000     0       The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase.   In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)

Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…

Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $45,000 and $65,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month? Multiple Choice   $13,500   $31,500   $25,500   $49,000

6