Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following data are from the budget of Ritewell Publishers. Half the companys sales are transacted on a cash basis. The other half are paid

The following data are from the budget of Ritewell Publishers. Half the companys sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $80, and total sales in January were $420.

February

March

April

Total sales

$

300

$

320

$

280

Cash purchases

95

105

85

Credit purchases

65

55

65

Labor and administrative purchases

55

55

55

Taxes, interest, and dividends

35

35

35

Capital expenditures

150

0

0

Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.)

Sources of cash

February

March

April

Collections on current sales

$150

$160

$140

Collections on amounts receivable

$

$150

Total sources of cash

$265

$310

$140

Uses of cash

Payments of accounts payable

$80

$65

$55

Cash purchases

$95

$105

$85

Labor and administrative expenses

$55

$55

$55

Capital expenditures

$150

$0

$0

Taxes, interest, and dividends

$35

$35

$35

Total uses of cash

$415

$260

$230

Net cash inflow

$

$50

$70

Cash at start of period

$155

$

$

+Net cash inflow

$

$50

$70

=Cash at end of period

$5

$200

$120

+Minimum operating cash balance

$150

$

$

=Cumulative short-term financing required

$145

$(100)

$(90)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions