Budget Problem Solutions 1. Sales budget: $ 9,500,000 2. schedule of expected cash collections: $9,482,500 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Budget Problem Solutions 1. Sales budget: $ 9,500,000 2. schedule of expected cash collections: $9,482,500 2. A purchases budget: $5,377,500 3. Cash payment schedule: $5,362,500 4. A cash budget: $ 50,910 5. A budgeted income statement: Net Income: $ 12,565 6. A budgeted balance sheet: $ 1,321,030 Required: Prepare the following budgets and schedules for the year, showing both quarterly and total amounts. 1. Sales budget and a schedule of expected cash collections. 2. A purchases budget 3. Cash payment schedule 4. A cash budget. Determine any borrowing needed to maintain a cash balance of $50,000. Beginning cash balance $55,000 Loans are made at the beginning of the quarter and paid at the end of the quarter; interest is 6% per year. 5. A budgeted income statement. 6. A budgeted balance sheet. 1 Budgeted unit sales Selling price per unit Total Sales Sales Budget Year 3 quarters 1 2 3 4 Year Accounts receivable beginning First quarter Second quarter Third quarter Fourth quarter Total cash collections 1 Cash Collections Schedule Year 3 quarters Calculate the Accounts Receivable Ending Balance: 2 3 4 Year 2 Budgeted unit sales Desired ending inventory Total needs Beginning inventory Required purchases Cost per unit Total purchases Purchases Budget 1 Year 3 Quarters 2 3 4 Year Calculate the Merchandise Inventory Ending Balance: 3 Accounts payable beginning First quarter Second quarter Third quarter Fourth quarter Total cash paid Calculate the Accounts Payable Ending Balance 1 Cash Payments Schedule Year 3 Quarters 2 3 4 Year 4 Beginning Cash Balance Add: Cash collection from customers Total cash available Less: Cash Disbursements Purchase of inventory Sales commission Advertising Rent Salaries Utilities Insurance Equipment purchases Total disbursements Excess (deficiency) of cash available Financing: Borrowings Repayments (including interest) Total finaning 1 Cash Budget Year 3 quarters 2 3 4 Year Excess (deficiency) of cash available Financing: Borrowings Repayments (including interest) Total finaning Cash balance, ending 5 Peoples Company Budgeted Income Statement For the Year Ending December 31, 20Y3 Sales Cost of Goods Sold Gross Profit Operatingexpenses: Advertising expense Salaries expense Sales commisson expense Rent expense Utilities expense Insurance expense Depreciation expense Interest expense Total Operating expenses Net operating income 6 Peoples Company Budgeted Balance Sheet December 31, 20Y3 Assets Current Assets Cash Accounts receivable Merchandise inventory Total current assets Land Plant Assets Equipment Less: Accumulated Depreciation Total Assets $ Current Liabilities Accounts Payable Interest payable Notes payable Total current liabilities Notes payable (long-term) Total Liabilities Liabilities Stockholders' Equity Common Stock $ 641,336 Paid in capital in excess of par 160,334 Retained Earnings 31,015 Total stockholders' equity Total liabilities and stockholders'equity 832,685 Budget Problem Solutions 1. Sales budget: $ 9,500,000 2. schedule of expected cash collections: $9,482,500 2. A purchases budget: $5,377,500 3. Cash payment schedule: $5,362,500 4. A cash budget: $ 50,910 5. A budgeted income statement: Net Income: $ 12,565 6. A budgeted balance sheet: $ 1,321,030 Required: Prepare the following budgets and schedules for the year, showing both quarterly and total amounts. 1. Sales budget and a schedule of expected cash collections. 2. A purchases budget 3. Cash payment schedule 4. A cash budget. Determine any borrowing needed to maintain a cash balance of $50,000. Beginning cash balance $55,000 Loans are made at the beginning of the quarter and paid at the end of the quarter; interest is 6% per year. 5. A budgeted income statement. 6. A budgeted balance sheet. 1 Budgeted unit sales Selling price per unit Total Sales Sales Budget Year 3 quarters 1 2 3 4 Year Accounts receivable beginning First quarter Second quarter Third quarter Fourth quarter Total cash collections 1 Cash Collections Schedule Year 3 quarters Calculate the Accounts Receivable Ending Balance: 2 3 4 Year 2 Budgeted unit sales Desired ending inventory Total needs Beginning inventory Required purchases Cost per unit Total purchases Purchases Budget 1 Year 3 Quarters 2 3 4 Year Calculate the Merchandise Inventory Ending Balance: 3 Accounts payable beginning First quarter Second quarter Third quarter Fourth quarter Total cash paid Calculate the Accounts Payable Ending Balance 1 Cash Payments Schedule Year 3 Quarters 2 3 4 Year 4 Beginning Cash Balance Add: Cash collection from customers Total cash available Less: Cash Disbursements Purchase of inventory Sales commission Advertising Rent Salaries Utilities Insurance Equipment purchases Total disbursements Excess (deficiency) of cash available Financing: Borrowings Repayments (including interest) Total finaning 1 Cash Budget Year 3 quarters 2 3 4 Year Excess (deficiency) of cash available Financing: Borrowings Repayments (including interest) Total finaning Cash balance, ending 5 Peoples Company Budgeted Income Statement For the Year Ending December 31, 20Y3 Sales Cost of Goods Sold Gross Profit Operatingexpenses: Advertising expense Salaries expense Sales commisson expense Rent expense Utilities expense Insurance expense Depreciation expense Interest expense Total Operating expenses Net operating income 6 Peoples Company Budgeted Balance Sheet December 31, 20Y3 Assets Current Assets Cash Accounts receivable Merchandise inventory Total current assets Land Plant Assets Equipment Less: Accumulated Depreciation Total Assets $ Current Liabilities Accounts Payable Interest payable Notes payable Total current liabilities Notes payable (long-term) Total Liabilities Liabilities Stockholders' Equity Common Stock $ 641,336 Paid in capital in excess of par 160,334 Retained Earnings 31,015 Total stockholders' equity Total liabilities and stockholders'equity 832,685
Expert Answer:
Answer rating: 100% (QA)
It seems that you have posted images showing a budget problem and related templates for various types of budgets sales budget cash collections schedul... View the full answer
Related Book For
College Algebra
ISBN: 978-0134697024
12th edition
Authors: Margaret L. Lial, John Hornsby, David I. Schneider, Callie Daniels
Posted Date:
Students also viewed these accounting questions
-
The Excel worksheet form that appears below is to be used to recreate the Review Problem related to Mynor Corporation. Download the workbook containing this form from Connect, where you will also...
-
The Excel worksheet form that follows is to be used to recreate the Review Problem related to Mynor Corporation. Download the workbook containing this form at from Connect. On the website you will...
-
1. You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the...
-
If the current spot rate is 2.10 (HC/FC) and the government undertakes policies to depreciate the currency 16%, what is the new spot rate? Note: 2.10 * 1.16 is not the right formula. Based on this,...
-
How do accounting exposure and economic exposure differ?
-
In the survey on which Table D.12 of the Data Bank is based, a larger number of persons was asked to respond to the statement "I would characterize my political beliefs as liberal" on a seven point...
-
Summarize the race system of Brazil and compare it to that of the United States.
-
Hart Corporation encounters the following situations: 1. Hart collects $1,300 from a customer in 2014 for services to be performed in 2015. 2. Hart incurs utility expense which is not yet paid in...
-
SCENARIO: Sydney Pratt, an investor, joined hands with a well-known Italian Chef Antonio Bottura, to open the first Michelin Star Italian Fusion cuisine restaurant in Montreal. With the wealth and...
-
Which changes are evidence of a chemical reaction? Drag each item to the appropriate bin. Help Reset A beaker of water becomes cool to the touch upon adding a saltto it. A cloudy solution becomes...
-
Annual average wind speed values over time measured for a residential area located at 27th latitude and 34th longitude are given in the Table. After checking the goodness-of-fit by Kolmogorov -...
-
Given the following information on M&C Inc.'s capital structure, compute the company's weighted average cost of capital. Type of Capital Bonds Preferred Stock Common Stock (Internal Only) Percent of...
-
Vandal Doughnuts is considering launching a new line of frozen doughnuts that customers can bake at home or coffee shops can bake in-store and sell. The estimated start-up cost is $300,000 for the...
-
Sara Gandhi is a 5 0 - year - old entrepreneur with a great idea of developing a new computer software product that will help users communicate using the next - generation magnet. Sara owns a...
-
The Parker Company recently hired you to help them prepare financial statements when their accounting manager left town suddenly. The following trial balance was completed by the manager prior to his...
-
Explain how three features of the Fast Track Schedule 9s features will help you manage information systems projects. Be specific in relating the feature to the systems tasks you would want to achieve...
-
Write the binomial probability in words. Then, use a continuity correction to convert the binomial probability to a normal distribution probability. P(x 110)
-
The tube is subjected to a torque of 750 N. m. Determine the amount of this torque that is resisted by the gray shaded section. Solve the problem two ways: (a) by using the torsion formula, (b) by...
-
The solid shaft has a diameter of 0.75 in. If it is subjected to the torques shown, determine the maximum shear stress developed in regions BC and DE of the shaft. The bearings at A and F allow free...
-
The solid shaft has a diameter of 0.75 in. If it is subjected to the torques shown, determine the maximum shear stress developed in regions CD and EF of the shaft. The bearings at A and F allow free...
Study smarter with the SolutionInn App