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)
Okay lets work through the required budgets and schedules for the year 1 Sales Budget and Cash Colle... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
which mucositis assesmnet tool contians eight categories that reflect oral health and function
-
$ 3 0 Million par of 1 0 year, zero - coupon bonds at a price to yield 1 2 % per year Please prepare a bond amortization schedule using the straight - line and effective interest methods
-
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,...
-
How do accounting exposure and economic exposure differ?
-
Gonalong, Inc., has 10 customers that account for all of its \($4,500,000\) of net income. Its activity-based costing system is able to assign all costs, except for \($650,000\) of general...
-
Better Health Inc. is a health care provider which has clinics across the U.S. Indicate whether each of the following examples of benchmarking for Better Health is considered (1) internal...
-
Make versus buy, activity-based costing opportunity costs. (N. Melumad and S. Reichelstein, adapted) The Ace Company produces bicycles. This years expected production is 10,000 units. Currently, Ace...
-
Required information Skip to question [ The following information applies to the questions displayed below. ] Portions of the financial statements for Parnell Company are provided below. PARNELL...
-
Chloe, age 48, divorced her husband in 2017. Chloes 4 year old grandson, Marcus, has been living with her since his parents were incarcerated in August 2019. Chloe provided all the support for Marcus...
-
Explain why harvesting is an important consideration when the initial decision to invest in a venture is made. How might harvesting be factored into the deal structure and the valuation? Provide...
-
How are game trees different from decision trees? For what kinds of decisions would you want to use game trees instead of decision trees?
-
How is turnaround financing different from financing associated with a healthy growing firm?
-
What are the meanings of bonding and monitoring in the context of new venture finance? What, from an economic standpoint, makes a bond effective?
-
What are accredited investors and why are they important to new ventures seeking registration of their equity securities?
-
Solve d^2y/dx^2 = sec^2 y tan y under the condition y = 0 and dy/dx =1 when x = 0.
-
Graph the following conic sections, labeling vertices, foci, directrices, and asymptotes (if they exist). Give the eccentricity of the curve. Use a graphing utility to check your work. 10 5 + 2 cos 0
-
MPS Corporation manufactures and sells holiday towels. The number and unit price of the towels increase substantially during the third quarter. An accounting clerk has prepared the following sales...
-
Financial statement analysis is a process whereby the basic financial statements are reviewed and evaluated to assess a firms financial health and/or performance. Calculating financial ratios is an...
-
Many corporations finance at least a part of their operations and asset purchases using debt, principally because the cost of debt financing is cheaper than equity financing. Moreover, some firms are...
Study smarter with the SolutionInn App