Neighborhood company has $32,000 cash at the beginning of June and anticipates $80,600 in cash receipts and $51,500 in cash disbursements. The company requires a minimum cash balance of $37,000. Any excess cash over the minimum desired balance is used to pay down debts. Neighborhood has an agreement with its bank to borrow as needed or to repay loans as funds become available. As of may 31, the company owes $32,000 to the bank. The balance of the loan on june 30 will be

Neighborhood company has $32,000 cash at the beginning of June and anticipates $80,600 in cash receipts and $51,500 in cash disbursements. The company requires a minimum cash balance of $37,000. Any excess cash over the minimum desired balance is used to pay down debts. Neighborhood has an agreement with its bank to borrow as needed or to repay loans as funds become available. As of may 31, the company owes $32,000 to the bank. The balance of the loan on june 30 will be

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter6: Cash And Receivables

Section: Chapter Questions

Problem 10RE: On December 1 of the current year, Jordan Inc. assigns 125,000 of its accounts receivable to...

See similar textbooks

Similar questions

Sparks Corporation has a cash balance of $24,100 on April 1. The company must maintain a minimum cash balance of $6,500. During April, expected cash receipts are $49,000. Cash disbursements during the month are expected to total $68,500. Ignoring interest payments, during April the company will need to borrow:
Sparks Corporation has a cash balance of $17,700 on April 1. The company must maintain a minimum cash balance of $14,500. During April, expected cash receipts are $65,000. Cash disbursements during the month are expected to total $77,500. Ignoring interest payments, during April the company will need to borrow: Multiple Cholce $9.300 $5,200 $14,500 $12,500
Green Valley Bank sent Comstock Industries its end-of-month bank statement for July. The end of month balance by the bank is $11,237. The statement shows that a deposit for $4,250 is in transit at the end of the statement period. The statement also revealed that checks for $87, $105, and $95 are outstanding. Green Valley collected a $4,000 note receivable plus $120 of interest revenue. The bank charges $20 for the collection service. The bank charges a monthly account fee of $35. The end-of-month balance per company books is $11,135. Question Content Area a. Prepare a bank reconciliation. Comstock Industries Bank Reconciliation July 31 Line Item Description Amount Amount Cash balance according to bank statement $Cash balance according to bank statement Deduct: Deposits in transit Deduct: Outstanding checks Adjusted balance $Adjusted balance Cash balance according to company's records $Cash balance according to company's records Add: Note and interest collected by bank $Deduct:…
Dante Manufacturing has a cash balance of P8,000 on August 1 of the current year.The company’s controller forecast the following cash receipts and cash disbursements for the upcoming two months of activity. Purchases SalesJanuary P 142,000 P 172,000February 148,000 166,000March 136,000 165,000April 154,000 178,000May 160,000 166,000Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The company pays all invoices in the month following purchase and takes advantage of a 3% discount on all amounts due. Cash payments for operating expenses in May will be P119,500; Crispin’s cashbalance on May 1 was P127,800. Required: Determine the following:1. Expected cash collections during May.2. Expected cash disbursements during May.
Safe Security Doors Ltd. undertakes bank reconciliation at the end of each month before preparing its monthly financial statements. The following information is produced by comparing the cash deposits and withdrawals recorded by the business in July with their bank statement received for the month ending 31 July 2021: The bank statement for the month of July shows a credit balance of $112,250 as at 31 July 2021. Safe Security Doors Ltd.’s cash at bank ledger account has a debit balance of $109,230 at 31 July 2021. $7,850 cash received from a customer Adam on 30 July (invoice no. 211) and $11,045 cash received from another customer Brian on 31 July (invoice no. 213) are recorded in the entity’s accounting record but are not shown in the bank statement. Interest earned on bank account is $85. Cheque no. 112 and 113 are not included in the bank statement. # 112 $ 8,045 # 113 $ 6,950 Bank deducted transaction fees of $15 for an overseas transfer by the entity. Safe Security Doors…
Gray Corporation controls its cash by depositing receipts on a daily basis and making all disbursements by cheque. After all the posting for the month of August 2020 was completed, the cash balance in the general ledger account at the end of the month was $10,475. The bank statement for the month end received from the First National Bank showed the balance to be $18,000. The following data are available for the purpose of reconciling these balances: a. Cash receipts collected on August 31 amounting to $3,000 have been placed in the night depository and do not appear on the bank statement. b. Bank memos previously not available to the company are included with the bank statement. A memo for an NSF cheque, originally received as payment for an account receivable of $3,000, is included. A memo for bank charges of $75 for the NSF cheque is also included. Another memo advises the company that $2,000 Note Receivable has been collected by the bank, ($1,950 deposit and a bank charge of $50).…
Springer Products wishes to borrow $90,000 from a local bank using its accounts receivable to secure the loan. The bank's policy is to accept as collateral any accounts that are normally paid within 30 days of the end of the credit period, as long as the average age of the account is not greater than the customer's average payment period. Springer's accounts receivable, their average ages, and the average payment period for each customer are shown in the following table: Customer Accounts Receivable Average age of account Average payment period of customer A $11,000 42 days 50 days B $25,000 70 days 65 days C $10,000 48 days 45 days D $28,000 55 days 50 days E $14,000 50 days 60 days F $19,000 21 days 35 days G $30,000 10 days 30 days H $16,000 25 days 40 days…
Ramon Manufacturing has a cash balance of P8,000 on August 1 of the current year.The company’s controller forecast the following cash receipts and cash disbursementsfor the upcoming two months of activity.Receipts PaymentsAugust P 45,000 P 57,000September 66,000 56,000Management desires to maintain a minimum cash balance of P8,000 at all times. If necessary, additional financing can be obtained in P1,000 multiples at a 12% interest rate. All borrowings are made at the beginning of the month; debt retirement, on the otherhand, occurs at the end of the month. Interest is paid at the time of repaying loan principal and is computed on the portion of debt repaid. 1. Determine the ending cash balance in August both before and after anynecessary financing or debt retirement.
Lonergan Company occasionally uses its accounts receivable to obtain immediate cash. At the end of June 2021, the company had accounts receivable of $1,000,000. Lonergan needs approximately $610,000 to capitalize on a unique investment opportunity. On July 1, 2021, a local bank offers Lonergan the following two alternatives: Borrow $610,000, sign a note payable, and assign the entire receivable balance as collateral. At the end of each month, a remittance will be made to the bank that equals the amount of receivables collected plus 12% interest on the unpaid balance of the note at the beginning of the period. Transfer $660,000 of specific receivables to the bank without recourse. The bank will charge a 3% factoring fee on the amount of receivables transferred. The bank will collect the receivables directly from customers. The sale criteria are met. Required:1. Prepare the journal entries that would be recorded on July 1 for: a. alternative a. b. alternative b. 2. Assuming that…
If Service World has $1,950 cash, $400 of government Treasury bills purchased last month with a six-week maturity, and $940 of cash set aside for legal reasons, how much will the company report on the balance sheet as “Cash and Cash Equivalents”?
Green Valley Bank sent Comstock Industries their end of month bank statement for July. The end of month balance by the bank is $12,850.00. The statement shows that a deposit for $4,000 is in transit at the end of the statement period. The statement also revealed that checks for $37.00, $45.00, and $186.00 are outstanding. Green Valley collected a 90 day, 12% interest $5,000.00 note receivable charging $25 for the service. No interest has been accrued on the note. The bank charges a monthly account fee of $50.00. The end of month balance per company books is $11,582.00.Complete a bank/account reconciliation and write any necessary journal entries for the reconciliation.
For the month of July, Shalom Company, predicts total cash collections and disbursements of P485,000 and P440,000 respectively. For March, Shalom Company, estimates that its beginning cash balance will be P55,000. If Shalom Company just wants to maintain its beginning cash balance at the end of July, will there be a need for Shalom Company to borrow money from a bank? Yes or no? Use the underlined words as your choice. Input answers in capital letters.