Required: Prepare the following budgets and schedules for the year, showing both quarterly and total amounts....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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)
The images youve provided are templates for creating various financial budgets and statements for a company However to fill out these templates specific financial data is needed for each of the line i... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the...
-
How to respond to the following? Cycle stock, pipeline inventory, buffer stock, and in-transit inventory all have associated carrying costs. Interest rates on inventory values, warehousing expenses,...
-
Why would balance sheets prepared under SFAS No. 8 lack additivity?
-
Referring to Exercise 10.51, denote by p1 and p2 the population proportions in the two groups who have In Exercise 10.51 Random samples of 250 persons in the 30- to 40-year age group and 250 persons...
-
Analyze the nature of ethnicity and its relationship to the nation-state.
-
An audit partner is developing an office training program to familiarize her professional staff with audit sampling decision models applicable to the audit of dollar-value balances. She wishes to...
-
Discuss how your approach to leading a domestic multicultural team or international team is shaped based on the theories you have learned in this unit. Your essay must be a minimum of two pages in...
-
Describe the ramifications of each of the following changes to ArrayCollection: a. the first three lines of the add method are deleted b. the numElements++ statement is deleted from the add method in...
-
Given the system of linear equation AX = B. (a) Show that e() = [I-wQA]*(0), where e()) is the error in the iterative scheme for the solution r of AX = B. (b) With 4 2 6 -(#) -(e) 270 003 B 3 i. If...
-
The stream function for the two-dimensional unsteady Taylor-Green vortex (TGV) flow is given by = cos(x) cos(y) e-2vt ay a Derive the velocity components (u, v) for this stream function where u = and...
-
Use the Factor Calculator to find values of factors. Use goal-seek function as needed. Show all your calculations to support how you get to the final answer. 1. You borrowed $5000 today to be paid...
-
Focus on the key drivers of price to earnings, earnings per share, dividend per share, cash flow per share, and annual growth rates for Adidas. This information will continue to assist you as you...
-
Rahm Robotics Inc (RRI) is considering a large investment of $20,000,000 in a new project. The company currently has $15,000,000 of 6% coupon bonds and 2,000,000 common shares outstanding. The tax...
-
Suppose that you are interviewing for a job when the interviewer asks you which cost-benefit analysis technique is best for assessing a projects economic feasibility. What would your response be?
-
A sample statistic will not change from sample to sample. Determine whether the statement is true or false. If it is false, rewrite it as a true statement.
-
Use the code given earlier for R to make this plot. The command would be plot(percentage)
-
Why would you not feel comfortable computing a Pearson correlation on the data in Exercise 9.10? Exercise 9.10 Down syndrome is another problem that psychologists deal with. It has been proposed that...
-
In Exercise 9.1 the percentage of mothers over 40 does not appear to be important, and yet it is a risk factor in other societies. Why do you think that this might be? Exercise 9.1 In Sub-Saharan...
Study smarter with the SolutionInn App