Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following cash budget is for the third quarter of this year. Solve for the missing numbers on the cash budget, assuming that the accountant

The following cash budget is for the third quarter of this year. Solve for the missing numbers on the cash budget, assuming that the accountant has requested a minimum cash balance of $11,200 at the start of each month. All borrowings, repayments, and investments are made in even $1,600 amounts. No borrowings or investments exist at the beginning of July.

July August September Total
Beginning cash balance $11,840 ? ? ?
Cash receipts 26,240 32,320 ? ?
Total cash available ? ? $65,600 $124,480
Cash disbursements
Payments on account ? $12,480 $18,240 ?
Wages expense 16,000 ? 19,840 55,360
Overhead costs 12,800 14,720 ? 41,600
Total disbursements $32,960 ? $52,160 ?
Cash excess (deficiency) ? ? ? ?
Minimum cash balance (11,200) (11,200) ? ?
Cash available (needed) ? $(14,080) ? $(18,560)
Financing
Borrowings (repayments) $6,400 ? $(1,600) ?
Acquire (sell) investments - - ? ?
Receive (pay) interest - - ? (32)
Ending cash balance $11,520 ? ? $11,808

Please answer the ?. Thank you!

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 Accounting questions