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

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

Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…
Jasper Company has 59% of its sales on credit and 41% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $534,000 for April, $544,000 for May, and $569,000 for June. Total sales for March are $301,800. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 534,000 May 544,000 June 569,000
OfficeMart Inc. has “cash and carry” customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 40% pay their accounts in the month of sale, while the remaining 60% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: Month Projected sales April $56,000 May 65,000 June 72,000 The Accounts Receivable balance on March 30 was $35,000. Prepare a schedule of cash collections from sales for April, May, and June.
Thornton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Thornton expects sales in January year 1 to total $300,000 and to Increase 15 percent per month in February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Thornton will report on the year 1 first quarterly pro forma Income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare a sales budget for the first quarter of year 1. Sales…
Miller Company expects its November sales to be 25% higher than its October sales of $170,000. All sales are on credit and are collected as follows: 35% in the month of the sale and 60% in the following month. Purchases were $70,000 in October and are expected to be $100,000 in November, Purchases are paid 20% in the month of purchase and 80% in the following month. The cash balance on November 1 is $13,800. The cash balance on November 30 will be OA. $86,575 OB. $114,175 OC. $190,175 OD. $100,375
< Innovative Office Inc. has "cash and carry" customers and credit customers. Innovative Office estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the first three months of 20Y4 are as follows: January February March The Accounts Receivable balance on December 31, 20Y3, was $72,000. Prepare a schedule of cash collections from sales for January, February, and March. INNOVATIVE OFFICE INC. Schedule of Collections from Sales For the Three Months Ending March 31, 20Y4 January February Receipts from cash sales: Cash sales December sales on account: Collected in January January sales on account: Collected in January Collected in February February sales on account: Collected in February Collected in March March sales on account: Collected in March $107,000…
J.TOY Inc., was organized on August 1 of the current year. Projected sales for the ا ی و ن ن و ر می و ی و و و و و ی next three months are as follows: -August : $120,000 -September : $200,000 -October : $230,000 The J.TOY expects to sell 40% of its merchandise for cash. Of the sales on account, 25% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating total cash collections for August, September, and October.
Ind
Campbell Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Campbell expects sales in January year 1 to total $360,000 and to increase 10 percent per month in February and March. All sales are on account. Campbell expects to collect 66 percent of accounts receivable in the month of sale, 22 percent in the month following the sale, and 12 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Campbell will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1.
Vikrambhai
Jasper Company has 65% of its sales on credit and 35% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $531,000 for April, $541,000 for May, and $566,000 for June. Total sales for March are $301,600. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April May 531,000 541,000 June 566,000
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?