Exercise D5-21 In the coming year, Swifty, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $19 to retailers throughout the country. All sales will be made on account. An expected 73% of sales will be collected within the quarter of the sale, and another 22 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: Budgeted sales units. Prepare Swifty, Inc.'s, cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Budgeted units sold Budgeted sales price Budgeted sales revenue 1st quarter sales 2nd quarter sales 3rd quarter sales 4th quarter sales Totals $ 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,600 44,700 52,000 83,700 Cash Receipts Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Bad Debts $ $ Net Accounts Receivable $1 $ Determine the Net Accounts Receivable at the end of the year. Assume that no accounts have been written off during the year.

Exercise D5-21 In the coming year, Swifty, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $19 to retailers throughout the country. All sales will be made on account. An expected 73% of sales will be collected within the quarter of the sale, and another 22 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: Budgeted sales units. Prepare Swifty, Inc.'s, cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Budgeted units sold Budgeted sales price Budgeted sales revenue 1st quarter sales 2nd quarter sales 3rd quarter sales 4th quarter sales Totals $ 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,600 44,700 52,000 83,700 Cash Receipts Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Bad Debts $ $ Net Accounts Receivable $1 $ Determine the Net Accounts Receivable at the end of the year. Assume that no accounts have been written off during the year.

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

In the coming year, Concord, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive- motion injuries. The brace will be sold for $13.00 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30% in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales units 29,000 41,000 57,000 77,000 Prepare Concord, Inc's cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Round "Budgeted sale price" and "Cash Receipts Budgets" answers to 2 decimal places, eg. 52.75 and all other answers to 0 decimal places, e.g. 5,275.)
Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $30 million minimum balance. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can Invest any excess funds in short-term marketable securities at a rate of 2 percent per…
69) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
h2
Navigator sells GPS trackers for $33 each. It expects sales of 3,387 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Calculate the total sales for the first four quarters (year 1). Round to the nearest penny, two decimal places.
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…
9 Rundle 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. Rundle expects sales in January year 1 to total $370,000 and to increase 10 percent per month in February and March. All sales are on account. Rundle expects to collect 70 percent of accounts receivable in the month of sale, 21 percent in the month following the sale, and 9 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 Rundle 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 Required Required A B Required D с Prepare a sales budget for the first quarter of year 1. Sales Budget…
Kau.5