1.ABC Furniture Inc. has hired you to build a 3-month cash budget. It is currently August1. ABC has $10,000 in the bank and owes $20,000 on its bank line of credit. The bankcharges .5% (.005) monthly on any outstanding balance the previous month. ABCborrows as little as possible and repays back any outstanding loans as quickly as possible,but must keep at least $10,000 in its account. ABC can borrow or pay back any amountat the end of each month.Projected cash receipts from customers for the next three months, respectively, are$250,800, $280,000, and $275,000. Projected cash receipts from Notes Receivables are$10,500, $20,000, and $31,500. Projected cash payments for merchandise are $187,600,$182,000, and $190,000. Projected cash payments for operating expenses are $90,000,$95,000, and $99,000.Prepare cash budgets for August, September, and October in side-by-side columns. Showhow much cash will be borrowed or repaid each month according to the bank's rulesabove. Show the loan balance for the end of each month.

Prepare cash budgets for August, September, and October in side-by-side columns. Show how much cash will be borrowed or repaid each month according to the bank's rules above. Show the loan balance for the end of each month.

Prepare cash budgets for August, September, and October in side-by-side columns. Show how much cash will be borrowed or repaid each month according to the bank's rules above. Show the loan balance for the end of each month.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Can I get the answer for requirement A in the attached picture
Kindy assist with b & c . Thank you a) The business needs to have a sense of its future cashflows and therfore requires the preparation of the following: A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months October to December. A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months October to December. A cash budget, with a total column, for the quarter ending December 31, 2021, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place. (b) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement at December 31, 2021. Is that a reasonable request? If yes, what should these amounts be? c) Upon…
Can someone help me with 2A, 2B, and 3 please?
The business needs to have a sense of its future cashflows and therefore requires the preparation of the following: 1. A schedule of budgeted cash collections for trade receivables for each of the months January to March. 2. A schedule of expected cash disbursements for accounts payable for each of the months January to March.
Required: (a) The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months July to September. A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months July to September. A cash budget, with a total column, for the quarter ending September 30, 2022, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place. (b) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending September 30, 2022, has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? (c) Upon receipt of the budget,…
Please help with question 1 and 2. Both the images are of the same continuing question
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $225,000 $ 293,000 $ 438,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May: 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate…
Required:(a) The business needs to have a sense of its future cash flows and therefore requires thepreparation of the following:▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each ofthe months July to September. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account)for each of the months July to September.▪ A cash budget, with a total column, for the quarter ending September 30, 2022, showing theexpected cash receipts and payments for each month and the ending cash balance for eachof the three months, given that no financing activities took place.
Assets ($) 2019 2018 2017 Cash on Hand & at Banks 1844388 2907252 3696201 Accounts Receivable Net 21373839 27958818 23638244 Notes Receivable 0 0 0 Post Dated Cheques 7430502 5910795 5481999 Short Term Investments 111502 111502 0 Inventory 14772540 15359933 16127022 Total Current Assets 50764763 59355234 56162203 Long Term Investments 2247122 2305477 2346362 Fixed Assets Net 36960544 32892460 23018610 Lands 3338194 3344028 3364400 Projects in Progress 5544 4350057 10455510 Total Fixed Assets 40304282 40586545 36838520 Other Assets 6417935 6157108 5067638 Total Assets 99734102 108404364 100414723 Liabilities ($) 2019 2018 2017 Accounts and Notes Payable 9488026 9042459 6830212 Credit Banks 21176536 19278649 13508941 Short Term Loans 15347569 14306482 12568640 Accrued Part of Long Term Loans 3816788 3818532 3663256 Total Current Liabilities 63973817 67090416 44303485 Long Term Loans & Notes Payable 9883426 8547662 10299548 Other…
Explain and give example of the following Management Reports Procedures Activities: Six Week Cash Flow Report
What about preparing a schedule of expected cash disbursement for merchandise purchases, by month and the total and budgeted income statement for the three-month period ending June 30.
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $163,000. About 85% of sales is cash; the remainder is on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $103,000. La Famiglia pays 25% in the month of purchase and 75% in the month following purchase. d. Most of the work is done by the owners, who typically withdraw $6,000 a month from the business as their salary. (Note: The $6,000 is a payment in total to the two owners, not per person.) Various part-time workers cost $7,300 per month. They are paid for their work weekly, so on average 90% of their wages are paid in the month incurred and the remaining 10% in the next month. e. Utilities average $5,950 per month. Rent on the building is $4,100 per month. f. Insurance is paid…