Hoppy Company requires a minimum cash balance of $3,500.When the company expects a cash deficiency, it borrows the exact amount required on the first of themonth. Expected excess cash is used to repay any amounts owed. Interest owed from the previousmonth's principal balance is paid on the first of the month atcompleted the budgeting process for the first quarter for cash receipts and cash payments for allexpenses except interest.|per year. The company has alreadyHoppy CompanyCash BudgetFor the Three Months Ended March 31JanuaryFebruaryMarchTotalBeginning cash balance243,500Cash receipts19,00027,50042,00088,500Cash available22,500Cash payments:Allexpenses except interest34,00035,00039,000108,000Interest expenseTotal cash payments34,000Ending cash balance before fiOnancingMinimum cash balance desired(3,500)(3,500)(3,500)(3,500)(Complete all input fields. Enter a "0" forany zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter acash deficiency and/or negative effects of financing with a minus sign or parentheses.)

A cash budget is an estimation of expected cash receipts and disbursements on the basis of past…

Hoppy Company requires a minimum cash balance of $3,500. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month's principal balance is paid on the first of the month at completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except interest. Iper year. The company has alread Hoppy Company Cash Budget For the Three Months Ended March 31 January February March Total 3,500 19,000 Beginning cash balance Cash receipts 27,500 42,000 88,500 Cash available 22,500 Cash payments: All expenses except interest 34,000 35,000 39,000 108,000 Interest expense Total cash payments 34,000 Ending cash balance before fiOnancing Minimum cash balance desired (3,500) (3,500) (3,500) (3,500) (Complete all input fields. Enter a "0" any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Ente cash deficiency and/or negative effects of financing with a minus sian or parentheses.)

Hoppy Company requires a minimum cash balance of $3,500. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month's principal balance is paid on the first of the month at completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except interest. Iper year. The company has alread Hoppy Company Cash Budget For the Three Months Ended March 31 January February March Total 3,500 19,000 Beginning cash balance Cash receipts 27,500 42,000 88,500 Cash available 22,500 Cash payments: All expenses except interest 34,000 35,000 39,000 108,000 Interest expense Total cash payments 34,000 Ending cash balance before fiOnancing Minimum cash balance desired (3,500) (3,500) (3,500) (3,500) (Complete all input fields. Enter a "0" any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Ente cash deficiency and/or negative effects of financing with a minus sian or parentheses.)

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

Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget…
Peach Corporation's only cash receipts are those derived from customer sales. Peach makes both cash sales and sales on account. For its credit sales, Peach collects 50% in the month of the sale, 40% in the month following the sale, and 10% in the second month following the sale. Peach is preparing its cash budget for the upcoming year. Sales on account for the month of March are budgeted at $150,000. The budgeted accounts receivable balance on March 1 is $113,000, of which $90,000 represents uncollected sales made in February and $23,000 represents uncollected sales made in January. If Peach's total cash receipts for the month of March are budgeted at $205,000, what are Peach's budgeted cash sales during March? O $17,000 O $35,000 $53,000 $71,000 O None of the above
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…
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,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.)
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 2nd Quarter 3rd Quarter $ 310,000 $ 438,038 $365,008 $ 335,000 Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. The company's beginning cash balance for the upcoming fiscal year will be $25,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…
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.
The budget director for Rundle Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations, accordingly, there are no beginning account balances. Required a. Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. b. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. c. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Complete this question by entering your answers in the tabs below. Req A Complete the schedule of cash payments for S&A expenses by filling in the missing amounts.…
Santos Company is preparing a cash budget for February. The company has $15,000 cash at the beginning of February and budgets $72,000 in cash receipts from sales and $105,000 in cash payments during February. Prepare the cash budget for February assuming the company maintains a $5,000 minimum cash balance and will take a loan if necessary to maintain this balance. The company has no loans outstanding on February 1. (Negative cash balances, if any, should be indicated with minus sign.) SANTOS COMPANY Cash Budget Beginning cash balance Total cash available Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month February
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.
Gibson is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities Depreciation on store equipment Rent Miscellaneous Total S&A expenses before interest Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Complete this question by entering your answers in the tabs below. Req A Req B and C July $18,300 August September $18,300 $18,300 2,800 2,800 2,800 290 320 350 2,500 2,500 2,500 2,700 2,700 2,700 5,700 5,700 5,700 790 790 790 $33,080 $33,110 $33, 140…