The Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800

The Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800

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

Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter $ 210,000 $ 281,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Required: Prepare the company's cash budget for the upcoming fiscal year.…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 519,000 $ 468,000 404,000 452,000 353,000 521,000 Kayak requires a minimum cash balance of $40,000 at each month end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January February March $ 519,000 409,000 476,000 $ 459,200 349,200 532,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan…
Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Carol's Chocolate Company has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,700 $47,000 Cash payments: Purchases of direct materials 31,000 21,400 17,000 Operating expenses 12,200 8,700 11,700 Capital expenditures 13,100 24,400 0 The cash balance on June 30 is projected to be $5,500. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 4%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the ending projected cash balance before financing for August.
Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
Karim Corporation requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $9,000 is used to repay loans at month-end. The cash balance on July 1 is $9,400, 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. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 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.)
Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 525,000 400,000 450,000 $ 475,000 350,000 525,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay Ibans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add Cash receipts Total cash available Less Cash payments for Interest on loan Total…
The company wants to maintain a minimum cash balance of $35,000 and borrows from the local bank as needed in increments of $1,000 at the beginning of the quarter. Principal repayments are made at the beginning of the quarter when excess funds are available and in increments of $1,000. Interest is 6% per year and paid at the beginning of the quarter based on the amount outstanding from the previous quarter Kiara's Coats Cash Budget For the year ended December 31, 2021 First Quarter Second Quarter Third Quarter Fourth Quarter Total Beginning cash balance $38,000 $35,569 $35,185 Cash receipts $71,600 $75,400 91,650 107,900 346,550 Cash available $109,600 $110,969 126,835 Cash payments: Total cash payments before interest $107,031 $52,289 57,755 63,639 280,714 Interest expense $0 $495 495 Total cash payments $107,031 $52,784 58,250 Ending cash balance before financing $2,569 $58,185 68,535 Minimum cash balance desired…