Question: Please fill in the red boxes Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. Sales Purchases January $360,300

Please fill in the red boxes

Please fill in the red boxes Pronghorn Corp prepares monthly cash budgets.Here are relevant data from operating budgets for 2017. Sales Purchases January$360,300 121,200 84,500 70,000 79,900 February $400,300 131,200 81,700 73,400 87,900 Salaries

Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. Sales Purchases January $360,300 121,200 84,500 70,000 79,900 February $400,300 131,200 81,700 73,400 87,900 Salaries Administrative expenses Selling expenses All sales and purchases are on account. Budgeted collections and disbursement data are given below. All other expenses are paid in the month incurred except for administrative expenses, which include $1,200 of depreciation per month. Other data. 1. Collections from customers: January $332,300; February $378,800. 2. Payments for purchases: January $106,200; February $145,000. 3. Other receipts: January: collection of December 31, 2016, notes receivable $17,100; February: proceeds from sale of securities $6,500. 4. Other disbursements: February $12,800 cash dividend. The company's cash balance on January 1, 2017, is expected to be $48,300. The company wants to maintain a minimum cash balance of $55,280. Prepare a cash budget for January and February. (Do not leave any answer field blank. Enter o for amounts.) -- -- -- ---- - - - - PRONGHORN CORP Cash Budget For the Two Months Ending February 28, 2017 A January February Beginning cash balance 48300 58300 Add Add a. Cash rec Cash receipts | Collections from customers 332300 378800 T Notes receivable 17100 0 Sale of securities 6500 Total receipts 397700|| 443600 Total available cash 397700 443600 7 Less Less 2 .cash disbursements Cash disbursements Purchases 106200 145000 Salaries 84500 81700 Administrative expenses 1 68800 72200 T Selling expenses 79900 87900 Dividends 12800 Total disbursements T 339400 399600 Excess (deficiency) of available cash over disbursements 58300 44000 Financing T Borrowings A 14300 Repayments 48300 55280 Ending cash balance 58300 44000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!