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...
-
In your mind, which organizational entity is more important to the stability and growth of global trade, the G8 or the G20? Why?
-
Explain the difference between a measure and an indicator.
-
Explain how an auditor might acquire evidence about each of the follow- ing transactions: (i) Equipment Cash 3,000 3,000 (ii) Equipment 4,000 Creditors 4,000 (iii) Depreciation expense 2,000...
-
Chief executive officer compensation can be a material amount and is often scrutinized by regulators, analysts, competitors, and investors. For CEOs of publicly traded companies, compensation can...
-
The production manager of Rordan Corporation prepared the following quarterly production forecast for next year: Units to be produced 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 9,600 7,500 7,800...
-
Sigrid contributed $200 every month for nine years into an RRSP earning 4.3% compounded annually. She then converted the RRSP into an annuity that pays her monthly for 20 years. If the first payment...
-
Womack Toy Company's stock is currently trading at $51 per share. The stock's dividend is projected to increase at a constant rate of 6.1 percent per year. The required rate of return on the stock,...
-
What is an isentropic process? Determine an expansion for the work done in a non-flow isentropic process.
-
Determine an expansion for the heat transfer and work done in a non-flow Polytropic process.
-
Determine an expansion for the work done in a steady flow adiabatic process.
-
What is the purpose of a drilling machine ? Explain its working principle.
-
How the size of milling machine is specified?
-
Balance the following using the algebraic method (show your steps): _MnSO4 + NaBiO3 + H2SO4 -> NaMnO4+ Bi2(SO4)3 + H2O + Na2SO4
-
In a nonmagnetic medium, E = 50 cos (10 9 t 8x) a y + 40 sin (10 9 t 8x) a z V/m find the dielectric constant r and the corresponding H.
-
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...
-
A company with a price-earnings ratio of 14 has an earnings yield closest to: A. 7.14% B. 14.00% C. 92.86%
-
Which of the following is not produced by a company to communicate its financial results? A. Schedule 13D. B. Annual report. C. 10-K statement.
-
The role of the 8-K filing with the Securities and Exchange Commission is best described as to disclose: A. the annual report. B. executive compensation. C. holdings of beneficial owners.
Study smarter with the SolutionInn App