Preparing a financial budget Cramer Company projects the following sales for the first three months of the year: $12,500 in January; $13,240 in February; and $14,600 in March. The company expects 70% 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. Requirements 1. Prepare a schedule of cash receipts for Cramer for January, February, and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?

Preparing a financial budget Cramer Company projects the following sales for the first three months of the year: $12,500 in January; $13,240 in February; and $14,600 in March. The company expects 70% 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. Requirements 1. Prepare a schedule of cash receipts for Cramer for January, February, and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?

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

Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.
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. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,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.)
Spana Company has the following data: Table 4: Total Monthly Purchasing Budget Month Budgeted Purchases January 220,000 February 185,000 March 240,000 April 155,000 May 180,000 Purchases are paid as follows: ∙ 10% in the month of purchase ∙ 60% one month after purchase ∙ 30% two months after purchase Required: (i) Develop a schedule of cash disbursements for purchases for March, April and May.
Spana Company has the following data: Total Monthly Purchasing Budget MONTH Budgeted purchases January 220,000 february 185,000 march 240,000 april 155,000 may 180,000 Purchases are paid as follows: * 10% in the month of purchase. * 60% one month after purchase * 30% two months after purchase Required: 1. Develop a schedule of cash disbursements for purchases for March, April and May.
5
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $34,000 and $50,000, respectively. It also expects credit sales of $60,000 and $70,000, respectively. The companyvexpects to collect 60% of its credit sales in the month of the sale, 35% in the following month, and 5% is deemed uncollectible. What amount of cash collections would appear in the company's cash budget for the first month
Don't give answer in image format
Please do not give image format
Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552
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 $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,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 $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
The following assumptions are made by a company when preparing its cash budget Invoices paid in the month after sales. Invoices paid in the second month after sale Invoices paid in the third month after sale Bad debts 50% 30% 15% 5% Invoices are issued on the last day of each month. Customers paying in the month after sale are entitled to deduct a 4% settlement discount. Credit sales values for August to November are budgeted as follows: August September October November $100 000 $120 000 $80 000 $70 000 The amount budgeted to be received from credit sales in November is ABCD ] $89 400 ] $91000 [ ] ] $100 000 $92 000
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 $42,000 and $78,000, respectively. The company expects to collect 35% of its credit sales in the month of the sale, 55% in the following month, and 10% is deemed uncollectible. What amount of cash collections from credit sales would the company include in its cash budget for the second month? Multiple Choice $50, 400 $42,900 $27,300 $58, 200