Answered step by step
Verified Expert Solution
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 $50, and total sales in January were $276.
Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.)
Total sales Cash purchases Credit purchases Labor and administrative purchases Taxes, interest, and dividends Capital expenditures February $ 240 80 50 40 20 120 March $ 260 90 40 40 20 April $ 220 70 50 40 20 $ Answer is complete but not entirely correct. February March April Sources of cash Collections on current sales $ 120 $ 130 $ 110 Collections on amounts receivable $ 138 $ 120 $ 130 Total sources of cash $ 258 250 $ 240 Uses of cash Payments of accounts payable 50 $ 50 $ 40 Cash purchases $ 80 $ 90 $ 70 Labor and administrative expenses $ 40 40 40 Capital expenditures $ 120 $ 0 0 Taxes, interest, and dividends 20 20 $ 20 Total uses of cash $ 310 $ 200 $ 170 OOOO TWITU 8.88 >>>> >I>>>> $ | Net cash inflow $ (52) $ $ 50 $ 70 8 66 GA + 122 (52) 70 $ Cash at start of period Net cash inflow Cash at end of period Minimum operating cash balance Cumulative short-term financing required $ $ $ S 20 70 90 50 X $ 50 $ 100 $ 120 $ 20 $ + $ 120 50 120 30 =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started