Concept explainers
Refer to the data for Minden Company in Problem 8-19. The company is considering making the following changes to the assumptions underlying its masterbudget:
1. Sales are budgeted for S220, 000 for May.
2. Each month’s credit sales are collected 60% in the month of sale and 40% in the month following the sale.
3. The company pays for 50% of its merchandise purchases in the month of the purchase and the remaining 50% in the month following the purchase.
All other information from Problem 8-19 that is not mentioned above remains the same.
Required:
Using the new assumptions described above, complete the following requirements:
1. Calculate the expected cash collections for May.
2. Calculate the expected cash disbursements for merchandise purchases for May.
3. Prepare a cash budget for May.
4. Using Schedule 9 as your guide, prepare a
5. Prepare a budgeted balance sheet as of May 31.
1.
The expected cash collection for May
Introduction: Net sales means the revenue that a company generates from the sales after deducting the amount of sales allowance, sales returns, and sales discount
Explanation of Solution
M. company | ||
Expected cash collection from sales | ||
Particulars | Calculations | Amount($) |
Cash sales of May | 60,000 | |
Collection of account receivable of April | 54,000 | |
Cash from may credit sale | 96,000 | |
Total cash receipts | 210,000 | |
Hence, $210,000 is the total receipts of sales.
2.
Te expected cash disbursement for merchandise purchase
Introduction: Net sales means the revenue that a company generates from the sales after deducting the amount of sales allowance, sales returns, and sales discount
Explanation of Solution
M. company | ||
Expected cash disbursements for merchandise purchases | ||
Particulars | Calculations | Amount($) |
Payment of Account payables balance as on April 30 | 63,000 | |
Payment of May’s credit purchases | 60,000 | |
Total cash disbursements | 123,000 | |
Hence, $123,000 is the total cash disbursements.
3.
To prepare: Cash budget for May
Introduction: Net sales means the revenue that a company generates from the sales after deducting the amount of sales allowance, sales returns, and sales discount
Explanation of Solution
M. company | ||
Cash budget for the month of May | ||
Particulars | Amount($) | |
Beginning cash balance | 9,000 | |
Add: Cash collection | 210,000 | |
Total cash Available | A | 219,000 |
Less: Cash disbursements | ||
For merchandise | 123,000 | |
For selling and administrative expenses | 72,000 | |
For equipment | 6,500 | |
Total cash disbursement | B | 201,500 |
Excess (deficiency) of cash | 17,500 | |
Financing: | ||
Borrowings | D | 20,000 |
Repayments | E | (14,500) |
Interest | F | (100) |
Ending cash balance | 22,900 | |
Hence, the expected ending cash balance is $22,900.
4.
To prepare: The income statement for May
Introduction: Net sales means the revenue that a company generates from the sales after deducting the amount of sales allowance, sales returns, and sales discount
Explanation of Solution
M. company | ||
Budget income statement | ||
For the month ended May 31 | ||
Particulars | Amount($) | |
Budgeted sales | 220,000 | |
Less: Cost of goods sold | 110,000 | |
Gross profit | 110,000 | |
Less: | ||
Selling and administrative expenses | 72,000 | |
Depreciation | 2,000 | |
Interest | 100 | |
Net income | 35,900 | |
Working notes:
Calculate the amount of cost of goods sold,
Hence, the net income of the M. Company is $15,900.
5.
To prepare: Balance sheet for May
Introduction: Net sales means the revenue that a company generates from the sales after deducting the amount of sales allowance, sales returns, and sales discount
Explanation of Solution
M. company | ||
Balance sheetAs at May 31 | ||
Particulars | Calculations | Amount($) |
Current assets | ||
Cash | 22,900 | |
Account receivable | 64,000 | |
Inventory | 40,000 | |
Fixed Assets | ||
Building and equipment | 211,500 | |
Total assets | 338,400 | |
Liability and stockholder’s equity | ||
Stockholder’s equity | ||
Capital stock | 180,000 | |
Retained earnings | 78,400 | |
Total stockholder’s equity | 258,400 | |
Accounts payable | 60,000 | |
Notes payable | 20,000 | |
Total liabilities and stockholders’ equity | 338,400 | |
Hence, the balance of the balance sheet is $338,400.
Want to see more full solutions like this?
Chapter 8 Solutions
INTRO MGRL ACCT LL W CONNECT
- Review the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)arrow_forwardRelevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yeararrow_forwardCASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.arrow_forward
- A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971arrow_forwardA companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forwardRelevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.arrow_forward
- Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?arrow_forwardA. The following information is extracted from Merry Hotel’s management report for themonth of January 2022. USD Beginning cash balance 8,200 Budgeted revenue 13,000 Purchase of inventory by cash 4,500 Cash repayment of bank loan 5,800 Additional information, 70% of Sosana Hotel’s revenue is received in cash and theremaining 30% on credit. All credit sales are expected to be collected in the followingmonth. Assume that there were no credit sales and credit purchases in December 2021.Based on the given information, prepare a cash budget for the month ended 31st January2022 to calculate ending cash balance.arrow_forwardPreparing a financial budget—schedule of cash receipts and schedule of cash payments</b></p><p>Agua Cool is a distributor of bottled water. For each of the items, compute the number of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item. Management expects to sell equipment that cost $14,000 at a gain of $7,000. Accumulated depreciation on this equipment is $55,000. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for $14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one—half of the commissions and other selling expenses in the month incurred, with the…arrow_forward
- Matthew Young has been working on Sheffield Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $40,700, cash collections will be $550,000, and cash disbursements will be $584,000. Sheffield Paints desires to maintain a $45,000 minimum cash balance. The company has a 12% open line of credit with its bank, which provides short-term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments are made at the end of the month (in $500 increments). Accrued interest is paid at the time of repayment. (a) Your answer is correct. How much will Sheffield Paints need to borrow from the bank at the beginning of March? Sheffield Paints should borrow $ 38500 %24arrow_forwardTodd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: Sales. Merchandise purchases Operating expenses: Payroll.. Advertising Rent. Depreciation End of April balances: Cash Bank loan payable. May April $150,000 $157,500 107,000 112,400 13,600 5,400 2,500 7,500 30,000 26,000 14,280 5,700 2,500 7,500 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the…arrow_forwardQUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning