Question

In: Accounting

Course Project Option 2 is to complete the following budgeting assignment: Stillwater Video Company, Inc. produces...

  1. Course Project Option 2 is to complete the following budgeting assignment:

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 a budgeted income statement for the quarter ended March 31.
  2. Prepare a budgeted balance sheet as of March 31.​

Solutions

Expert Solution

Here is the solution if any doubt please ask. Kindly rate me. Thankyou


Related Solutions

Stillwater Video Company, Inc. produces and markets two popular video games, High Range and Star Boundary....
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...
Assignment Option #2: Government Transactions Complete all work on the Option 2 Spreadsheet (linked at the...
Assignment Option #2: Government Transactions Complete all work on the Option 2 Spreadsheet (linked at the bottom of the page) to this assignment; it will be your only deliverable. Using the data in the attached spreadsheet, perform the accounting required for each of the following government fund transactions: Perform the required journal entries Requirements: Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so...
Signature Assignment - Capital Budgeting Course Project Work must be done in Excel. Please show formulas...
Signature Assignment - Capital Budgeting Course Project Work must be done in Excel. Please show formulas if possible so I can get a true understanding of the deliverables. You have recently assumed the role of CFO at your company. The company's CEO is looking to expand its operations by investing in new property, plant, and equipment. You are asked to do some capital budgeting analysis that will determine whether the company should invest in these new plant assets. Signature Assignment...
Read the Hospital Scenario for this course and complete the following assignment: Write a 500-750 word...
Read the Hospital Scenario for this course and complete the following assignment: Write a 500-750 word paper that addresses the following: APA style ( title: Leadership styles) Evaluate the management styles and identify the positive and negatives of each manager’s characteristics. Identify what transactional and transformational leadership theories are present. Provide an example of how one leader mentioned in the case study could adapt the servant leadership model into practice, and how this change could have an impact on a...
This assignment addresses the following course outcome: - Describe the process of managing project knowledge using...
This assignment addresses the following course outcome: - Describe the process of managing project knowledge using existing knowledge and creating new knowledge. Class - For the purpose of this assignment, you can use a fictional project or a project that you worked for. Create a project charter using the following template. In addition, include a one to two page summary explaining the lessons learned from using this template. How did it help you better understand your project? Project Charter Template:...
SIGNS OF PREGNANCY WATCH THE FOLLOWING VIDEO Play Video THEN complete and submit the following chart:...
SIGNS OF PREGNANCY WATCH THE FOLLOWING VIDEO Play Video THEN complete and submit the following chart: Presumptive Signs (Primarily Subjective Signs) Probable Signs (Primarily Objective Signs) Positive Signs
This question has 2 parts. Assignment Details Final Project Overview Throughout this course, you have learned...
This question has 2 parts. Assignment Details Final Project Overview Throughout this course, you have learned various components of accounting. These components work hand-in-hand to create the accounting cycle – the process of recording, summarizing and reporting transactions. The final project will provide you the opportunity to apply the skills covered in this course through the completion of the accounting cycle. In addition, you will be able to demonstrate your understanding through analysis of the completed information. This project will...
Course Project: Master Budget Milo-Freeze Company Description This course contains a Course Project, where you will...
Course Project: Master Budget Milo-Freeze Company Description This course contains a Course Project, where you will be required to submit the final completed project at the end of Week 7. Using the budgeting assumptions provided for Milo-Freeze Company, you will prepare a sales budget, a production budget, a direct materials budget and a schedule of expected cash payments for purchases of materials. An Excel template will be provided and required to use to complete and submit. Budgeting Assumptions Milo-Freeze Company...
I ask that you complete a project consisting of the following: (2) a 2 or 3...
I ask that you complete a project consisting of the following: (2) a 2 or 3 dimensional physical model of an inclined plane (ramp) including force vectors of the given problem. (1) a paper was written on the problem explaining the role of each force in the problem. The paper must include the equations and free body diagram of all forces acting on the system. Students should solve the equations for acceleration of the system while explaining each step taken...
Capital Budgeting The Recycled Paper Inc. corporation is considering a project with the following cash flows....
Capital Budgeting The Recycled Paper Inc. corporation is considering a project with the following cash flows. Year Cash Flow 0 ($75,000) 1 $18,500 2 $18,500 3 $18,500 4 $18,500 5 $12,500 6 $12,500 7 $12,500 8 $12,500 Refer to the Capital Budgeting narrative. What is the payback period of the proposed project? A. 1.28 years B. 2.28 years C. 3.28 years D. 4.08 years Refer to the Capital Budgeting narrative. What is the net present value of the proposed project...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT