Homework Help is Here – Start Your Trial Now!
Business
Accounting
(Click the icon to view the cash payments schedule.) Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) i (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Reference Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance Carmen Company Cash Budget January, February, and March January Aut www.bala Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April More info S $ $ S Total January February March 10,600 $ 11,600 S 11,100 $ 33,30 January February March Total 6,360 2,120 S 8,480 $ 2,220 2,120 6,960 2,320 S 11,400 S 2,320 6,660 2,220 11,200 $ Carmen's beginning cash balance is $5,000 and Carmen desires to maintain a minimum ending cash balance of $5,000. Carmen borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. 31.08 X

(Click the icon to view the cash payments schedule.) Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) i (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Reference Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance Carmen Company Cash Budget January, February, and March January Aut www.bala Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April More info S $ $ S Total January February March 10,600 $ 11,600 S 11,100 $ 33,30 January February March Total 6,360 2,120 S 8,480 $ 2,220 2,120 6,960 2,320 S 11,400 S 2,320 6,660 2,220 11,200 $ Carmen's beginning cash balance is $5,000 and Carmen desires to maintain a minimum ending cash balance of $5,000. Carmen borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. 31.08 X

Financial Management: Theory & Practice
Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter16: Supply Chains And Working Capital Management
Section: Chapter Questions
Problem 16MC: In an attempt to better understand RR’s cash position, Johnson developed a cash budget for the first...
See similar textbooks
icon
Related questions
Question

Use both images as a reference

 

complete all

 

<><>

Carmen Company has prepared the following schedules and additional information: F(Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance example Get more help. Carmen Company Cash Budget January, February, and March January -C Reference Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April More info $ Print $ $ January February March 10,600 $ 11,600 $ 11,100 $ January February March 6,360 2,120 $ 2,120 6,960 2,320 8,480 $ 2,220 11,400 Done $ Carmen's beginning cash balance is $5,000 and Carmen desires to maintain a minimum ending cash balance of $5,000. Carmen borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. 2,320 6,660 2,220 11,200 $ Total 33,30 Total 31,08 X
Transcribed Image Text:Carmen Company has prepared the following schedules and additional information: F(Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance example Get more help. Carmen Company Cash Budget January, February, and March January -C Reference Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April More info $ Print $ $ January February March 10,600 $ 11,600 $ 11,100 $ January February March 6,360 2,120 $ 2,120 6,960 2,320 8,480 $ 2,220 11,400 Done $ Carmen's beginning cash balance is $5,000 and Carmen desires to maintain a minimum ending cash balance of $5,000. Carmen borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. 2,320 6,660 2,220 11,200 $ Total 33,30 Total 31,08 X
Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash payments schedule.) (Click the icon to view the cash receipts schedule.) (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Er Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance example Get more help. Carmen Company Cash Budget January, February, and March January Reference Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable Print $ $ $ $ $ January 0 0 3,300 3,120 3,120 1,920 5,500 7,420 Done 3,780 4,700 1,180 February March $ 3,200 3,200 3,700 720 720 460 5,500 5,960 13,840 $ 13,580 $ $ 4,300 4,300 $ 4,100 720 720 460 5,500 5,960 15,080 $ Total 7,500 11,100 1.440 3,120 4,560 920 1,920 16,500 19,340 42,500 I X inus sign or parent Check an
Transcribed Image Text:Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash payments schedule.) (Click the icon to view the cash receipts schedule.) (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Er Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance example Get more help. Carmen Company Cash Budget January, February, and March January Reference Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable Print $ $ $ $ $ January 0 0 3,300 3,120 3,120 1,920 5,500 7,420 Done 3,780 4,700 1,180 February March $ 3,200 3,200 3,700 720 720 460 5,500 5,960 13,840 $ 13,580 $ $ 4,300 4,300 $ 4,100 720 720 460 5,500 5,960 15,080 $ Total 7,500 11,100 1.440 3,120 4,560 920 1,920 16,500 19,340 42,500 I X inus sign or parent Check an
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
SEE MORE TEXTBOOKS