Alpha Company makes all its sales on account. The accounts receivable payment experience is as follows: Percent paid in the month of sale 35% Percent paid in the month after the sale 54% Percent paid in the second month after the sale 6% Alpha provided the following information on sales: May $150,000 June $125,000 July $136,000 August (expected) $142,000 What is the budgeted cash to be collected on account for the month of August? a.$150,000 b.$130,640 c.$45,000 d.$132,000 e.$154,600

Based on the following data, prepare a cash budget (in proper form with labels) for July and August.   Forecast sales   May     $12,000   June     15,000     July      $16,000   August $12,000   Cash sales are 30% of total sales. Credit sales are collected as follows: 60% one month after the sale and 40% 2 months after the sale   Accounts payable are paid 100% 2 months after the purchase   Expected A/P   May     $5,000     June    $6,000   July     $7,000   August $8,000   In addition to purchases, there are utility bills of $1,500 each month   Beginning cash for July is $3,800

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 $ 520,000 $ 463,500 February 401,500 345,000 March 465,000 527,000  Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, 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 $50,000 is used to repay loans at month-end. The company has a cash balance of  $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)

he following table lists data from the budget of Ritewell Publishers. Half the company’s sales are for cash on the nail; the other half are paid for with a one-month delay. The company pays all its credit purchases with a one-month delay. Credit purchases in January were $47, and total sales in January were $214. Assume all expenses, other than purchases, are cash transactions.     February March April Total sales $234 $254 $214 Purchases of materials       For cash 87 97 77 For credit 57 47 57 Other expenses 47 47 47 Taxes, interest, and dividends 27 27 27 Capital investment 30 0 0     Complete the cash budget in the following table.

The management of Palind Ltd decide to prepare a Cash Budget for November and December. The following information is available: Sales: Cash Credit Purchases Salaries & Wages Sundry Expenses WY Actual August September October R 194 500 287 300 510 000 72 600 17 800 R 235 700 350 000 490 000 72 600 18 400 R 275 000 410 000 495 000 72 600 22 000 Additional information: 1. Cash in respect of credit sales is collected as follows: • 50% within 30 days • 30% within 60 days • 15% within 90 days • The balance is written off as irrecoverable. 2. The following discounts are allowed on sales: Budgeted 7. The cash in the bank on 31 October was R44 500. November December R 250 500 400 400 520 000 72 600 22 600 R 368 000 697 000 680 000 72 600 25 700 • 10% on cash sales • 7.5% on credit sales if accounts are settled within 30 days. 3. All salaries, wages and sundry expenses are paid in cash. 4. Sundry expenses include depreciation of R4 200 per month. 5. Seventy-five (75%) of all purchases are on…

Wellness Products, needs a cash budget for September. The following information is available: 1. The cash balance at the beginning of August is 9,000€. 2. Contribution margin is 50% (COGS are 50% of sales) 3. Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. 4. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month's inventory purchases are paid for during the month of purchase. 1. Prepare a schedule of expected cash collections for August, September & October. 2. Prepare a merchandise purchases budget for July, August, and September. 3. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and September. Cash Sales…

Complete all requirements   <><>

Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,444,000 2,600,000 696,000 176,000 674,000

Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in…

How do you get the last addition loan and ending cash balance?