Budgeted income statement and budgeted balance sheet

Assignment Help Accounting Basics
Reference no: EM131116537

Budgeted Income statement and Budgeted Balance sheet

P4. Local Bank has asked Wonderware Products, Inc.'s president for a budgeted income statement and budgeted balance sheet for the quarter ended June 30. These pro forma financial statements are needed to support Wonderware's request for a loan.

Wonderware routinely prepares a quarterly master budget. The operating budgets prepared for the quarter ending June 30 have provided the following information:

(Continued)

Projected sales for April are $220,400; for May, $164,220; and for June, $165,980. Direct materials purchases for the period are estimated at $96,840; direct materials usage, at $102,710; direct labor expenses, at $71,460; overhead, at $79,940; selling and administrative expenses, at $143,740; capital expenditures, at $125,000 (to be spent on June 29); cost of goods manufactured, at $252,880; and cost of goods sold, at $251,700.

Balance sheet account balances at March 31 were as follows: Accounts Receivable,

$26,500; Materials Inventory, $23,910; Work in Process Inventory, $31,620; Finished Goods Inventory, $36,220; Prepaid Expenses, $7,200; Plant, Furniture, and Fixtures,

$498,600; Accumulated Depreciation-Plant, Furniture, and Fixtures, $141,162; Pat- ents, $90,600; Accounts Payable, $39,600; Notes Payable, $105,500; Common Stock,

$250,000; and Retained Earnings, $200,988.

Projected monthly cash balances for the second quarter are as follows: April 30,

$20,490; May 31, $35,610; and June 30, $39,320. During the quarter, accounts receiv- able are expected to increase by 30 percent, patents to go up by $6,500, prepaid expenses to remain constant, and accounts payable to go down by 10 percent (Wonderware will make a $5,000 payment on a note payable, $4,100 of which is principal reduction). The federal income tax rate is 30 percent, and the second quarter's tax is paid in July. Depre- ciation for the quarter will be $6,420, which is included in the overhead budget. The company will pay no dividends.

reQUIred

1. Determine the June 30 ending balances for Materials Inventory, Work in Process Inventory, and Finished Goods Inventory.

2. Prepare a budgeted income statement for the quarter ended June 30.

3. Prepare a budgeted balance sheet as of June 30.

Reference no: EM131116537

Questions Cloud

Company began selling magazine subscriptions : A review of the ledger of Obi Company at December 31, 2010, produces the following data pertaining to the preparation of annual adjusting entries.
Large corporation announces to the shareholders company : Imagine a CEO of a large corporation announces to the shareholders company made $1B in profits in the year that has just ended, which is much as what they made in the previous year. How will the market react. such news? In other words, how will the s..
How is performance measured in your current job : How is performance measured in your current job? What leadership performance does your organization employ?
Transactional and transformational leadership : Discuss (a) managerial craft and (b) leadership including transactional and transformational leadership. Discuss their importance in public/nonprofit organizations for effectively and efficiently achieving organizational goals.
Budgeted income statement and budgeted balance sheet : P4. Local Bank has asked Wonderware Products, Inc.'s president for a budgeted income statement and budgeted balance sheet for the quarter ended June 30. These pro forma financial statements are needed to support Wonderware's request for a loan.
Elements of product identity and meaning : A Brand encompasses the various elements of product identity and meaning. Brand equity reflects the value of a brand name based on its strength and appeal in the marketplace and its power as a communication vehicle.  There is also the aspect of br..
Relative to its actual average inventory position : If Kroger had Whole Foods' number of days' sales in inventory, how much additional cash flow would have been generated from the smaller inventory relative to its actual average inventory position? Round interim calculations to one decimal place an..
Considered as opportunity for market expansion : Going global is many times considered as an opportunity for market expansion. Discuss the option(s) of distribution networks considering the local competition in the foreign country. Discuss the phases for identifying regions for facility locations a..
Walsh company manufactures and sells one product : Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit:

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd