Question
A cash budget by quarters for the Carney Company is given below (note that some data are missing).Missing data amounts have been keyed with either
A cash budget by quarters for the Carney Company is given below (note that some data are missing).Missing data amounts have been keyed with either question marks or lowercase letters (a, b, c, etc.); these lowercase letters will be referred to in the questions that follow.(It will be useful to calculate a value for items where a question mark appears.)The company requires a minimum cash balance of at least $10,000 to start a quarter. All data are in thousands of dollars.
a. What are the collections from customers during the first quarter (item a), in thousands of dollars?
b. What is the borrowing required during the first quarter to meet the minimum cash balance (item b),in thousands of dollars?
c. What is the cash disbursed for purchases during the second quarter (item c), in thousands of dollars?
d. What is the repayment (including interest) of financing during the second quarter (item d), in thousands of dollars?
e. What is the cash balance at the beginning of the second quarter (item e), in thousands of dollars?
f. What were the total disbursements during the third quarter (item f), in thousands of dollars?
g. Show the total cash budget for the year.
IIN 3 Cash Balance, Beginning $16 Se $13 $10 Add: Collections from Customers Sa $70 $67 $81 Total Cash Available $ ? $80 $91 Less: Disbursements: Purchase of Inventory $32 $40 $35 Operating Expenses $35 $22 $ ?1 $15 Equipment Purchases $10 $14 $19 SO Dividends $ 6 $ ol $ 5 ? Total Disbursements $77 $ ? S f $55 Excess (Deficiency) of Cash Over Disbursements $ 71 $17 ($2) $36 Financing: Borrowings S b $12 Repayments (Including Interest) S d ($21 Total Financing S ? $ ? $12 ($21) Cash Balance, Ending $10 $ ? $10 $15
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