Frontier Ltd., a leader in solar technology, makes all sales on credit, offering terms 2/10 net 40. Expected sales for each month January to June (in $M) are respectively; Jan Feb Mar April May June 145 Sales (SM) 70 95 120 130 110. The accounting staff has prepared a schedule detailing the expected cash collections over the 6 month period January to June. From experience, Frontier expects to collect 20% of any month's sales in that same month, 70% in the following month, and the remaining 10% in the second month following the month of sale. Its expenses, estimated as a percentage of the month's projected sales are; for raw material (50%) paid in the following month since it gets 30 days' credit from its suppliers, wages and salaries (15%) and lease payments (5%) both paid in the month of sale. Taxes are paid at the end of each quarter and are expected to be $22M. (i) Set out ABC's cash budget for the April – June quarter? (ii) Identify whether Frontier has a cash surplus or deficit for each month

Frontier Ltd., a leader in solar technology, makes all sales on credit, offering terms 2/10 net 40. Expected sales for each month January to June (in $M) are respectively; Jan Feb Mar April May June 145 Sales (SM) 70 95 120 130 110. The accounting staff has prepared a schedule detailing the expected cash collections over the 6 month period January to June. From experience, Frontier expects to collect 20% of any month's sales in that same month, 70% in the following month, and the remaining 10% in the second month following the month of sale. Its expenses, estimated as a percentage of the month's projected sales are; for raw material (50%) paid in the following month since it gets 30 days' credit from its suppliers, wages and salaries (15%) and lease payments (5%) both paid in the month of sale. Taxes are paid at the end of each quarter and are expected to be $22M. (i) Set out ABC's cash budget for the April – June quarter? (ii) Identify whether Frontier has a cash surplus or deficit for each month

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Similar questions

Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in January; $10100 in February and $10400 in March. the company expects 60% of the sales to be cash and the remainder on accounts. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Account Receivable account has a zero on January. 1. Prepare a schedule of cash receipts for Marlin 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 70% in the month of the sale, 20% in the following month of the sale and 10% in the second month of the sale. What is the balance in Accounts Receivable on March 31?
Wells Company reports the following sales forecast: September, $55,000; October, $66,000; and November, $80,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November.
Homer Company expects credit sales for January to be $50,000. Cash sales are expected to be $30,000. The company expects credit and cash sales to increase 10% for the month of February. Credit sales are collected in the month following the month in which sales are made. Based on this information the amount of cash collections in February would be: A) $88,000B) $80,000C) $85,000D) $83,000
Al Bahr Corporation, a wholesaler, provided the following informationMonthSalesJanuary64000February59000March42000April48000Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale.Required: Determine the expected cash collection during March.
Shalom Company expects credit sales for April, May, and June to be P200,000, P260,000, and P300,000, respectively. It is expected that 75% of the sales will be collected in the month of sale, and 25% will be collected in the following month. Amounts must be in whole numbers. Example: 88,000 or (88,000) Calculate cash collections from customers for each month. MAY
Al Bahr Corporation, a wholesaler, provided the following information (photo) Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. Required: Determine the expected cash collection during April.
The Palos Company expects sales for June, July, and August of $48,000, $54,000, and $44,000, respectively. Experience suggests that 40% of sales are for cash and 60% are on credit. The company collects 50% of its credit sales in the month following sale, 45% in the second month following sale, and 5% are not collected. What are the company's expected cash receipts for August from its current and past sales?