Madison Corporation's expected beginning cash balance is $35,000. Cash collections are budgeted at $50,000 and cash disbursements are estimated to be $80,000. The minimum required cash balance is $20,000 and the company can borrow as much as needed in increments of $10,000. Calculate the expected ending cash balance for the month. O $20,000 $5,000 0 $5,000

Madison Corporation's expected beginning cash balance is $35,000. Cash collections are budgeted at $50,000 and cash disbursements are estimated to be $80,000. The minimum required cash balance is $20,000 and the company can borrow as much as needed in increments of $10,000. Calculate the expected ending cash balance for the month. O $20,000 $5,000 0 $5,000

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

The information in the following table is from a company's sales budget Expected sales April May June $ 96,000 116,000 126,000 Cash sales are normally 25% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in June OAS118,500 O $31,500 OC$213,000 005126,000 O $87,000
Here are some important figures from the budget of Nashville Nougats, Incorporated, for the second quarter of 2022: April May June $399,000$ 348,000 $436,000 176,000 164,000 197,000 Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2022, credit sales were $326,000. Cash collections from credit sales Total cash available Cash disbursements Using this information, complete the following cash budget. Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Purchases Wages, taxes, and expenses Interest Equipment purchases 79,400 9,100 31,500 Total cash…
ladeo Corp. has provided a part of its budget for the second quarter Apr $43,000 Jun $42,000 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of May OA. $56,000 OB. $54,900 O C. $87,500 OD. $32,600 May $43,000 4,500 7,000 0 7,000 5,600 20,000 5,000 4,500 10,000 HELHE
Your Company is working on its cash budget for July. The budgeted beginning cash balance is $46,000. Budgeted cash receipts total $174,000 and budgeted cash disbursements total $175,000. The desired ending cash balance is $50,000. What is the excess (deficiency) of cash available over disbursements for July? Group of answer choices $ 45,000 $221,000 $ 50,000 $ 1,000 $ 47,000
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?
Stuart Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 115,000 $ 121,000 $ 141,000 Cash payments For inventory purchases 97,500 79,500 92,500 For S&A expenses 38,500 39,500 34,500 Stuart Medical had a cash balance of $15,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Stuart pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year’s quarterly results. Required Prepare a cash budget.
1
a1
Complete your calculations by filling in the highlighted cells. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
am. 116.
Fanning Medical Clinic has budgeted the following cash flows. January $105,000 February $111,000 March Cash receipts Cash payments For inventory purchases For S&A expenses $131,000 92,500 33,500 74,500 34,500 87,500 29,500 Fanning Medical had a cash balance of $10,500 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Fanning pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage
Newman Medical Clinic has budgeted the following cash flows. January February March $101,000 $107,000 $127,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Cash Budget Beginning cash balance Add: Cash receipt Cash available Less: Cash payments 90,500 31,500 Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) For inventory purchases For S&A expenses Interest expense per month…