Question
Q2 Ace Co manufactures car component parts. Prepare a Combined Cash Budget for the fourth quarter, considering the data and info below: Cash collections in
Q2 Ace Co manufactures car component parts. Prepare a Combined Cash Budget for the fourth quarter, considering the data and info below: Cash collections in October, November and December are expected to be $90,000, $150,000 and $95,000 respectively. Cash payments for Q4 are projected to be $138,000 in October, $112,000 in November and $60,000 in December. On October 1, the cash balance is expected to be $25,000. Ace Co must have a minimum cash balance of $25,000. In months when cash is below this level, Ace can borrow money at an interest rate of 1% PER MONTH. Ace pays back borrowed money on the last day of the month after it is borrowed (if there are excess funds, over $25,000). Funds are borrowed/repaid in increments of $1000
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