Moontrust Bank has asked the president of Wishware Products, Inc., for a budgeted income statement and budgeted

Question:

Moontrust Bank has asked the president of Wishware Products, Inc., for a budgeted income statement and budgeted balance sheet for the quarter ended June 30. These pro forma financial statements are needed to support Wishware products’ request for a loan.

Wishware Products routinely prepares a quarterly master budget. The operating budgets prepared for the quarter ending June 30 have provided the following information: Projected sales for April are $220,400; for May, $164,220; and for June, $165,980. Direct material 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, $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; Patents, $90,600; Accounts Payable, $39,600; Notes Payable, $105,500; Common Stock, $250,000. And Retained Earnings, $207,158.

Projected monthly cash balances for the second quarter are as follows: April 30, $20,490; May 31, $35,610; and June 30, $45,400. During the quarter, accounts receivable 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 (Wishware Products will make a $5, 000 payment on a note payable, $4,100 of which is principal reduction). The federal income tax rate is 34 percent, and the second quarter’s tax is paid in July. Depreciation for the quarter will be $6,420, which is included in the overhead budget. The company will pay no dividends.

Required

1. Prepare a budgeted income statement for the quarter ended June 30. Round answers to the nearest dollar.

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

Financial Statements
Financial statements are the standardized formats to present the financial information related to a business or an organization for its users. Financial statements contain the historical information as well as current period’s financial... Accounts Payable
Accounts payable (AP) are bills to be paid as part of the normal course of business.This is a standard accounting term, one of the most common liabilities, which normally appears in the balance sheet listing of liabilities. Businesses receive... Accounts Receivable
Accounts receivables are debts owed to your company, usually from sales on credit. Accounts receivable is business asset, the sum of the money owed to you by customers who haven’t paid.The standard procedure in business-to-business sales is that... Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial...