NUBD Corporation has a P35,000 balance of account receivable at the beginning of its budget period. It has budgeted P160,000 credit sales and expects to collect 60% of these during the budget period. What is the ending balance of accounts receivable assuming that all but 15% of the beginning balance is collected during the budget period.

NUBD Corporation has a P35,000 balance of account receivable at the beginning of its budget period. It has budgeted P160,000 credit sales and expects to collect 60% of these during the budget period. What is the ending balance of accounts receivable assuming that all but 15% of the beginning balance is collected during the budget period.

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

p15
A company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken to meet this requirement at a cost of 1% interest per month (paid at the end of each month). Any preliminary cash balance above $12,400 is used to repay loans at month-end. The cash balance on March 1 is $12,400, and the company has no outstanding loans. Budgeted cash receipts from sales are: March, $26,000; April, $32,400; and May, $41,000. Budgeted cash payments (excluding loan or interest payments) are: March, $30,000; April, $30,200; and May, $32,400. Required: Prepare a cash budget for March, April, and May. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash receipts from sales Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance,…
Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers within the same month, 60% the following month, and the remaining 20% by the end of the second following month, how much would accounts receivable be at the end of February?
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) 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…
Boris detergents expects to have a cash balance of P46,000 on January 1, 2020. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January P71,000, February P146,000. 2. Payments to suppliers: January P40,000, February P75,000. 3. Wages: January P30,000, February P40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January P21,000, February P24,000. These costs include depreciation of P1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January P15,000, February P20,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize P12,000 in cash. The Company has a line of credit at a local bank that enables it to borrow up to P25,000. The company wants to maintain a minimum monthly cash balance of P20,000. Prepare a cash budget for January and February.
The following is the sales budget for Yellowhead Inc. for the first quarter of 2021: January February $212,000 $232,000 March $255,000 Sales Credit sales are collected as follows: 70% in the month of the sale, 15% In the month after the sale, and 15% in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $96,000 ($66,000 of which was uncollected December sales), a. Calculate the sales for November. (Omit "$" sign in your response.) November sales $ b. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit "$" sign in your response.) $ December sales c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations. Round the final answers to 2 decimal places. Omit "$" sign in your response.) January February March Cash collections $ $ $
Karim Corporation requires a minimum $8,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,300 is used to repay loans at month-end. The cash balance on July 1 is $8,700, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan July $ 24,300 28,450 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance August $ 32,300 30,300 Loan balance - Beginning of month Additional loan (loan…
Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $100,000 September 185,000 October 225,000 The company expects to sell 40% of its merchandise for cash. Of the sales on account, one third are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections of accounts receivable for August, September, and October. For each month's sales on account, enter the collection months in chronological order. Trapp Co. Schedule of Collections of Accounts Receivable For Three Months Ending October 31, 20xX August September October August sales on account: Collected in August Collected in September September sales on account: Collected in September Collected in October October sales on account: Collected in October Totals
Karim Corporation requires a minimum $8,100 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,100 is used to repay loans at month-end. The cash balance on July 1 is $8,500, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash available July August $ 24,100 $ 32,100 28,150 30,100 Total cash payments Preliminary cash balance Loan activity Ending cash balance September $ 40,100 32,100 KARIM CORPORATION Cash Budget $ July Loan balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance…
Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be $38,000. The company expects credit and cash sales to increase 10% for the month of February. Credit sales are collected in the month following the month in which sales are made. Based on this information, the amount of cash collections in February would be:
The beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on account. The remainder are cash sales. Sixty percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $465,000. Accounts receivable from previous accounting periods totaling $11,000 will be collected in the current year. The company is required to make a $21,500 loan payment and an annual interest payment on the last day of the year. The loan balance as of the beginning of the year is $145,000, and the annual interest rate is 10%. What will be reported as 'cash' on the budgeted balance sheet?