Eastern Auto Parts Inc. has 15 percent of its sales paid for in cash and 85 percent on credit. All credit accounts are collected in the following month. Assume the following sales:

January

\(65,000

February

\)55,000

March

\(100,000

April

\)45,000

Sales in December of the prior year were $75,000. Prepare a cash receipts schedule for January through April.

Short Answer

Expert verified

The cash receipts will be $73,500 in January, $63,500 in February, $61,750 in March, and $91,750 in April.

Step by step solution

01

Formula used for calculating the monthly cash receipts

Monthlysales=15%×Presentmonthsales+85%×Priormonthsales

02

Cash receipts schedule

Month

January

February

March

April

Sales

$65,000

$55,000

$100,000

$45,000

15% cash sales

$9,750

$8,250

$15,000

$6,750

85% prior month sales

$63,750

$55,250

$46,750

$85,000

Total cash receipts

$73,500

$63,500

$61,750

$91,750

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Tobin Supplies Company expects sales next year to be \(500,000. Inventory and accounts receivable will increase \)90,000 to accommodate this sales level. The company has a steady profit margin of 12 percent with a 40 percent dividend pay-out. How much external financing will Tobin Supplies Company have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing.

Fast Turnstiles Co. is evaluating the extension of credit to a new group of customers. Although these customers will provide \(180,000 in additional credit sales, 12 percent are likely to be uncollectible. The company will also incur \)16,200 in additional collection expense. Production and marketing costs represent 72 percent of sales. The firm is in a 34 percent tax bracket and has a receivables turnover of four times. No other asset build-up will be required to service the new customers. The firm has a 10 percent desired return.

b. Calculate the incremental income after taxes and the return on incremental investment if 15 percent of the new sales prove to be uncollectible. Should credit be extended if 15 percent of the new sales prove uncollectible?

Esquire Products Inc. expects the following monthly sales:

January

\(28,000

February

\)19,000

March

\(12,000

April

\)14,000

May

\(8,000

June

\)6,000

July

\(22,000

August

\)26,000

September

\(29,000

October

\)34,000

November

\(42,000

December

\)24,000

Total annual sales

\(264,000

Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for \)2 each and produces them for \(1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12.

c. Determine a cash payments schedule for January through December. The production costs (\)1 per unit produced) are paid for in the month in which they occur. Other cash payments (besides those for production costs) are $7,400 per month.

City Farm Insurance has collection centers across the country to speed up collections. The company also makes its disbursements from remote disbursement centers so the firm’s checks will take longer to clear the bank. Collection time has been reduced by two days and disbursement time increased by one day because of these policies. Excess funds are being invested in short-term instruments yielding 12 percent per annum.

b. How much can City Farm earn in dollars per year on short-term investments made possible by the freed-up cash?

Why would a financial manager want to slow down disbursements?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free