Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 BB Corp sells waterproof winter jackets. Sales are 20% cash sales and 80% credit sales (A/R). Of the credit sales, BB noted that 30%

1 BB Corp sells waterproof winter jackets. Sales are 20% cash sales and 80% credit sales (A/R). Of the credit sales, BB noted that 30% pay in the same month as the sale, 60% pay the month after the sale and 6% pay two months after the sale (4% of the credit sales are never collected in cash). Last year (2022), November sales revenues were $90,000 and December sales revenues were $180,000. Forecasted 2023 sales are shown below. Prepare the cash collections budget for the first quarter (Q1 2023), showing a column for each month (Jan, Feb, March) and a totals column for Q1. Forecasted Sales Revenues: January March $100,000 $150,000 February $140,000 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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

8. Do the organizations fringe benefits reflect diversity?

Answered: 1 week ago