Question

In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full,...

In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense. For this problem, please assume that bad debt expense is again 0% for BCM. Purchases for next month's sales are 50% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March. "Other payments," which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for March using your expected cash receipts from problem 7 and calculate the average net cash flow during the month of March. Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

question 7 to refer to

Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

Homework Answers

Answer #1

CALCULATION OF EXPECTED CASH SALES IN MARCH

PARTICULARS JANUARY FEBRUARY MARCH APRIL
SALES 450000 375000 555000 495000
20% CURRENT MONTH 90000 75000 111000
45% OF PREVIOUS MONTH DEBTORS 202500 168750
35% OF SALE OF SECOND LAST MONTH DEBTORS 157500
CASH RECEIPTS DURING MONTH 90000 277500 437250

CASH BUDGET DURING JANUARY TO MARCH

RECEIPTS JANUARY FEBRUARY MARCH
OPENING BALANCE -210000 -303750
RECEIPTS FROM SALES 90000 75000 111000
RECEIPTS FROM DEBTORS (45%+35%) 202500 326250
TOTAL OF RECEIPTS 90000 67500 133500
PAYMENTS
CASH PURCHASES (50%OF NEXT MONTH'S SALES) 187500 277500 247500
OTHER PAYMENTS (RENT WAGES AND TAXES ) 25% OF SALES 112500 93750 138750
TOTAL PAYMENTS 300000 371250 386250
CLOSING BALANCE -210000 -303750 -252750
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In a previous question, Big City Manufacturing (BCM) assumed that all credit sales were paid in...
In a previous question, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense. For this problem, please assume that bad debt expense is again 0% for BCM. Purchases for next month's sales are 50% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March. "Other payments," which include wages, rent, and taxes, are 25% of sales for...
1A. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of...
1A. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in...
Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000...
Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in the...
Big City Manufacturing (BCM) assumed that all credit sales were paid in full, which is not...
Big City Manufacturing (BCM) assumed that all credit sales were paid in full, which is not realistic. BCM studied its past credit sales and determined that 3.25% of its credit sales resulted in Bad Debts that were never collected. Using the data from the previous problem with the new assumption that 3.25% of credit sales were never collected, what is your revised estimate for the expected cash receipts for March? Data from previous problem: Big City Manufacturing (BCM) is preparing...
. Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.25% coupon rate with interest paid...
. Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.25% coupon rate with interest paid semiannually, and a par value of $1,000. The nominal required rate of return on these bonds is 6.75%. What is the bond’s intrinsic value? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually,...
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually, and a par value of $1,000. The nominal required rate of return on these bonds is 7.25%. What is the bond’s intrinsic value? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually,...
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually, and a par value of $1,000. The nominal required rate of return on these bonds is 7.50%. What is the bond’s intrinsic value? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually,...
Big Manufacturer Corporation's bonds have a 10-year maturity, a 5.75% coupon rate with interest paid semiannually, and a par value of $1,000. The nominal required rate of return on these bonds is 6.75%. What is the bond’s intrinsic value? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
1.Using the information from problem 8 on Alpha & Omega, what is the equivalent annual annuity...
1.Using the information from problem 8 on Alpha & Omega, what is the equivalent annual annuity (EAA) for System A? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box. 2.XYZ Corporation is considering the acquisition of a new piece of equipment. The new equipment costs $250,000, plus it will cost $10,000 to ship it to XYZ,...