Prepare budgeted balance sheet as of march

Assignment Help Accounting Basics
Reference no: EM132726905

Question - Stillwater Video Company, Inc. produces and markets two popular video games, High Range and Star Boundary. The closing account balances on the company's balance sheet for the last year are as follows: Cash, $18,735; Accounts Receivable, $19,900; Materials Inventory, $18,510; Work in Process Inventory, $24,680; Finished Goods Inventory, $21,940; Prepaid Expenses, $3,420; Plant and Equipment, $262,800; Accumulated Depreciation-Plant and Equipment, $55,845; Other Assets, $9,480; Accounts Payable, $52,640; Mortgage Payable, $70,000; Common Stock, $90,000; and Retained Earnings, $110,980.

Operating budgets for the first quarter of the coming year show the following estimated costs: direct materials purchases, $58,100; direct materials usage, $62,400; direct labor expense, $42,880; overhead, $51,910; selling expenses, $35,820; general and administrative expenses, $60,240; cost of goods manufactured, $163,990; and cost of goods sold, $165,440. Estimated ending cash balances are as follows: January, $34,610; February, $60,190; and March, $54,802. The company will have no capital expenditures during the quarter.

Sales are projected to be $125,200 in January, $105,100 in February, and $112,600 in March. Accounts receivable are expected to double during the quarter, and accounts payable are expected to decrease by 20 percent. Mortgage payments for the quarter will total $6,000 of which $2,000 will be interest expense. Prepaid expenses are expected to go up by $20,000, and other assets are projected to increase by 50 percent over the budgeted period. Depreciation for plant and equipment (already included in the overhead budget) averages 5 percent of total plant and equipment for the year. Federal income taxes (34 percent of profits) are payable in April. The company pays no dividends.

Required -

1. Prepare budgeted income statement for the quarter ended March 31.

2. Prepare budgeted balance sheet as of March 31.

Reference no: EM132726905

Questions Cloud

How do social media analytics aid organization : How do social media analytics aid an organization? Give an example of a social media data stream and the type of insight that might be drawn from it.
Record the transactions which occurred in the year ending : Record the following transactions which occurred in the year ending December 31,2020 - Total contributed capital 810,000
How would you track and remove the worm the network : How would you track, and remove the worm the network?
What is the value of staff and customer feedback : What's the value of staff and customer feedback? Identify five ways staff and customer feedback can help enhance customer service delivery
Prepare budgeted balance sheet as of march : Sales are projected to be $125,200 in January, $105,100 in February, and $112,600 in March. Prepare budgeted balance sheet as of March 31
Managerial issues of networked organization : Research at least two articles on the topic of managerial issues of a networked organization.
What is the cost of equity for the new project : The new machine has an expected disposal value of RM100,000 in 5 years. What is the cost of equity for the new project
Role of analytics in solving business problems : The Role of Analytics in Solving Business Problems - Describe one type of analytics (from Workshop 1) and evaluate how it could be used as part of a solution
It organizations in ethics frameworks : Survey at least two IT organizations in Ethics frameworks (for example, ACM has its framework on Ethics).

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