Prepare a master budget for a merchandising company, for the three-month ending period ending June 30. Include
Fantastic news! We've Found the answer you've been seeking!
Question:
Prepare a master budget for a merchandising company, for the three-month ending period ending June 30. Include all required schedules and budgets including pro forma financial statements ?
Transcribed Image Text:
Number Font Alignment Cipboard Sign In () SIGN IN TO OFFICE It looks lilke your stored credentials are out of date. Please sign in as so we can verify your subscription. 09 H. K 1 Data Sheet 2. 17.00 AN sales are made on acrount Balance Sheet at March 31st 3 Selling price per widget 4. Assets 5 Widgets sold (actual and budgeted): 6 January tactual) Z February (actual) 8 March (actual) 9 April (budget) 10 May (budget) 53,600 Cash $ 92,000 June (budget) 25,600 29,600 33,600 Accounts receivable luly (budget) August (budget) September (budget 50,320 31,600 28,600 43,600 February sales 68.600 March sales 592,960 643,280 103,600 Inventory 159,152 Prepaid insurance 33,600 11 Property & equipment (net) 1,130,000 12 Ending Inventory 13 40% of widgets to be sold in the following manth Total assets $2,058,032 5.80 Al purchases are made on account 14 Cost per widget 15 16 Payments for merchandise (widgets) 17 Month of purchase 18 Following month Liabilities & Stackholders" Equity Cash collections of sales on account Accounts payable S 155,440 50% Month of sale 20% Dividends payable 28,500 50% Following month 70% Common stock 1,160,000 19 Second month 10% Retained earnings 714,092 Total liabilities & stackholders' equiti 52.058. 032 20 Monthly operating expenses: 21 Variable 22 Sales commissions 23 Fixed 4% of sales 24 Advertising 25 Rent S 380,000 S 36,000 S 142,000 26 Salaries 27 Utilities S 16,000 28 Insurance 29 Depreciation 4,800 IThe insurance premium is paid on an annual basis, in November of each year) $ 32,000 30 31 Planned equipment cash purchases: 32 May 33 June $ 25,000 S 58,000 34 35 Dividends declared per quarter (payable in the first month of the following quarter $28,500 36 37 Mininum cash balance: S68,00 38 38 39 Borrowing increments: $1,000 All borrow ing occurs at the beginning of the month as needed. 40 Interest rate per month: 1% simple interest Any money borrawed, as well as the interest due is paid back on the last day of the quarter. When repaying ar 41 you can not go below your minimum cash balonce 42 43 Dudget Data Data Sheet Sales Budget P Type here to search DELL Esc F1 F2 E3 F4 F5 F6 F7 44 # $ % 2 Number Font Alignment Cipboard Sign In () SIGN IN TO OFFICE It looks lilke your stored credentials are out of date. Please sign in as so we can verify your subscription. 09 H. K 1 Data Sheet 2. 17.00 AN sales are made on acrount Balance Sheet at March 31st 3 Selling price per widget 4. Assets 5 Widgets sold (actual and budgeted): 6 January tactual) Z February (actual) 8 March (actual) 9 April (budget) 10 May (budget) 53,600 Cash $ 92,000 June (budget) 25,600 29,600 33,600 Accounts receivable luly (budget) August (budget) September (budget 50,320 31,600 28,600 43,600 February sales 68.600 March sales 592,960 643,280 103,600 Inventory 159,152 Prepaid insurance 33,600 11 Property & equipment (net) 1,130,000 12 Ending Inventory 13 40% of widgets to be sold in the following manth Total assets $2,058,032 5.80 Al purchases are made on account 14 Cost per widget 15 16 Payments for merchandise (widgets) 17 Month of purchase 18 Following month Liabilities & Stackholders" Equity Cash collections of sales on account Accounts payable S 155,440 50% Month of sale 20% Dividends payable 28,500 50% Following month 70% Common stock 1,160,000 19 Second month 10% Retained earnings 714,092 Total liabilities & stackholders' equiti 52.058. 032 20 Monthly operating expenses: 21 Variable 22 Sales commissions 23 Fixed 4% of sales 24 Advertising 25 Rent S 380,000 S 36,000 S 142,000 26 Salaries 27 Utilities S 16,000 28 Insurance 29 Depreciation 4,800 IThe insurance premium is paid on an annual basis, in November of each year) $ 32,000 30 31 Planned equipment cash purchases: 32 May 33 June $ 25,000 S 58,000 34 35 Dividends declared per quarter (payable in the first month of the following quarter $28,500 36 37 Mininum cash balance: S68,00 38 38 39 Borrowing increments: $1,000 All borrow ing occurs at the beginning of the month as needed. 40 Interest rate per month: 1% simple interest Any money borrawed, as well as the interest due is paid back on the last day of the quarter. When repaying ar 41 you can not go below your minimum cash balonce 42 43 Dudget Data Data Sheet Sales Budget P Type here to search DELL Esc F1 F2 E3 F4 F5 F6 F7 44 # $ % 2
Expert Answer:
Answer rating: 100% (QA)
Sales Budget For the Quarter Ended June 30 April May ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A spreadsheet containing completed pro forma financial statements for Ottawa Corporation is available for download from McGraw-Hill's Connect or your course instructor (see the Preface for more...
-
The future is uncertain and so pro forma financial statements will almost certainly prove to be inaccurate. It is, therefore, a waste of time to prepare them. Comment.
-
Your first assignment is to prepare a master budget for the next fiscal year, starting October 1, 2020. The office manager brought a pile of files on your desk including the past sale records,...
-
Barbara buys 100 shares of DEM at $35 a share and 200 shares of GOP at $40 a share. She buys on margin and the broker charges interest of 10 percent on the loan. a. If the margin requirement is 55...
-
What five factors determine your credit score, and how are these factors weighted by BEACON?
-
A compressor brings a hydrogen gas flow at 280 K, 100 kPa up to a pressure of 1000 kPa in a reversible process. How hot is the exit flow and what is the specific work input?
-
Search the Internet and determine what hap- pened to these individuals. a. Robert Pfaff (KPMG). b. Adrian Dicker (BDO Seidman).
-
As of January 1, 2012, the trial balance for Haven Hospital was as follows: During the fiscal year ended December 31, 2012, the following transactions occurred: 1. Patient service revenue amounted to...
-
3333333333 What must be the beta of a portfolio with zap) = 16.70%, if rf = 5% and any) = 14%? (Round your answer to 2 decimal places.) Beta of portfolio I I
-
Step 1 Analyze Business Transactions (Accounting Cycle) Assume that you are the Financial Accountant of a newly started business from your chosen in August 2020: You are requested to assume the...
-
You must use a 23 factorial design and analysis of variance to investigate a new direct energy deposition machine produced by Optomec. Titanium powder is fused onto a surface using a CO laser with...
-
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 5 Purchased 8 Purchased 11 Sold 90 units of Product A @...
-
Three capacitors are connected as shown to the right. a) Calculate their equivalent capacitance, Ceq. b) Calculate the charge supplied by the 15 V battery. c) Calculate the voltage across and charge...
-
It is written that it is also important to ensure that there is no information that, if discovered, would disqualify the applicant from employment or could subject other employees, clients, or...
-
Paul Pindel, age 23, but with the mental capacity of a five-year-old, lived in a group home in a residential neighborhood in Mitchell City, along with eight other young adults with intellectual...
-
Does Ricardo see a limit to economic growth? If yes, what? How are Ricardo's views of limits on economic growth related to his theory of rents? In what way could any such limit be considered...
-
Q5. Please answer in the format provided. . Governmental Funds Statement of Revenues, Expenditures, and Changes in Fund Balance For the year ended December 31, 2025 Capital Debt Total General ...
-
APC16550D UART has a clock running at18.432 MHz and its baud rate is set to 2000.Determine the HEX contents of its DLM and DLL registers. Please can you explain step by step and in detail how you get...
-
This problem asks you to prepare one- and five-year financial fore-casts and conduct some sensitivity analysis and scenario analysis for Aquatic Supplies Company. A spreadsheet containing the...
-
Table 3.1 in the last chapter presents R&E Supplies financial statements for the period 2011 through 2014, and Table 3.5 presents a pro forma financial forecast for 2015. Use the information in these...
-
The annual standard deviation of return on Stock As equity is 37 percent and the correlation coefficient of these returns, with those on a well-diversified portfolio, is 0.62. Comparable numbers of...
-
Compare the three ways you can purchase mutual funds.
-
Describe a mutual fund prospectus.
-
You just inherited $4,000. You need to decide whether to invest this money in a mutual fund, pay down your credit card debt, or simply hold the money in an interest-bearing checking account to pay...
Study smarter with the SolutionInn App