Prepare a budgeted income statement for videonet

Assignment Help Financial Accounting
Reference no: EM13875659

Return on Investment (ROI) Videonet Company manufactures highly specialized products for networking video-conferencing equipment. Production of specialized units are, to a large extent, performed under contract, with standard units manufactured according to marketing projections. Maintenance of customer equipment is an important area of customer satisfaction. With the recent downturn in the computer industry, the video-conferencing equipment segment has suffered, caus- ing a slide in Videonet's financial performance. Its income statement for the fiscal year ended Octo- ber 31, 2010, follows.

VIDEONET COMPANY

Income  Statement

For the Year Ended October 31, 2010

Net sales:

 

Equipment

$6,500

Maintenance contracts

1,800

Net sales Expenses:

$8,300

Cost of goods sold

4,600

Customer  maintenance

1,000

Selling expense

600

Administrative  expense

900

Interest expense

150

Total expenses

$7,250

Income before tax

1,050

Income tax

420

Videonet's return on sales before interest and income tax was 14.5 percent in fiscal 2010 when the industry average was 18 percent. Its total asset turnover was two times, and its return on average assets before interest and income tax was 29 percent, both well below the industry average. To improve performance and raise these ratios closer to, or above, industry averages, Bill Hunt, Vid- eonet's president, established the following goals for fiscal 2011:

Return on sales, before interest and income tax 15%

Total asset turnover 3 times

Return on average assets, before interest and income tax 35%

To achieve Hunt's goals, Videonet's management team considered the growth in the international video-conferencing market and proposed the following actions for fiscal 2011:

• Increase equipment sales prices by 10 percent.

• Increase the cost of each unit sold by 3 percent for needed technology, and quality improvements and for increased variable costs.

• Increase maintenance inventory by $250,000 at the beginning of the year and add two mainte- nance technicians at total cost of $130,000 to cover wages and related travel expenses. These revisions are intended to improve customer service and response time. The increased inventory will be financed at an annual interest rate of 12 percent; no other borrowings or loan reductions are contemplated during fiscal 2011. All other assets will be held to fiscal 2010 levels.

• Increase selling expenses by $250,000, but hold administrative expenses at 2010 levels.

• The effective combined federal and state income tax rate for 2011 is expected to be 40 percent, the same as it was in 2010.

These actions were taken to increase equipment unit sales by 8 percent, with a corresponding 8 per- cent growth in maintenance contracts.

Required

1. Prepare a budgeted income statement for Videonet for the fiscal year ending October 31, 2011, on the assumption that the proposed actions are implemented as planned and that the increased sales objectives will be met.

2. Calculate the following ratios for Videonet for fiscal year 2011 and determine whether Bill Hunt's goals will be achieved:

a. Return on sales (ROS), before interest and income tax.

b. Total asset turnover.

c. Return on average assets, before interest and income tax.

3. Discuss the limitations and difficulties that can be encountered in using the ratios in requirement 2, particularly when making comparisons to industry averages.

Reference no: EM13875659

Questions Cloud

Explain the differences between the three charts : Analyze the three different charts. Write a 1-2 page paper in which you explain the differences between the three charts and which chart best represents the data and why
Determine the moment about point o : A precast concrete wall section is temporarily held by two cables as shown. Knowing that the tensions in cables BD and FE are 900 N and 675 N, respectively, determine the moment about point O of the force exerted by
Thesis of the book - why nation fail : The central thesis of the book WHY NATION FAIL is that inclusive political and economic institutions are necessary for sustained economic growth.
Force with an equivalent force-couple system : A plumber applies a 220-N force to the handle of a wrench as she removes a coupling from the end of a pipe. Knowing that the wrench and the force lie in a vertical plane parallel to the yz plane, replace the force with an equivalent force-couple s..
Prepare a budgeted income statement for videonet : Prepare a budgeted income statement for Videonet for the fiscal year ending October 31, 2011, on the assumption that the proposed actions are implemented as planned and that the increased sales objectives will be met.
Company did not have a whistle blower policy : How would you act in the following situations?
Discuss what the disorder and how one gets the disorder : You should discuss what the disorder is (general description, types if different types exist, symptoms), and how one gets the disorder (possible causes, risk factors).
Determine the magnitude of resulting forces : Knowing that the drill exerts a 12 N m · couple on the piece of plywood, determine the magnitude of the resulting forces applied to the nails if the are located
Ifrs standard - capital market or social accounting : Students are also required to choose and comment on a relevant IFRS standard either related to capital market or social accounting or environmental accounting.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Compute arrows direct labor variances

Total overhead incurred amounted to $508,400. Budgeted fixed overhead totals $1.8 million and is spread evenly throughout the year.

  Prepare summary journal entries for 2011 and 2012

Prepare summary journal entries for 2011 and 2012 to account for the installment sales and cash collections. The company uses the perpetual inventory system.

  Compute total fraud and negligence penalties incurred

A court found that a portion of that deficiency constituted civil fraud ($80,000). Compute total fraud and negligence penalties incurred. Explain your answer as necessary.

  Prepare income statements for both years

Required: Prepare income statements for both years using both absorption and variable costing methods.

  Discuss the relative performance of each supplier

Calculate the total cost of ownership and the supplier performance index for each of the four suppliers and discuss the relative performance of each supplier.

  Transaction is disclosed on statement of cash flows

Zeus Manufacturing purchased plant assets that cost $50,000 by paying $20,000 in cash and financing the balance by issuing a note payable to the seller. This transaction is disclosed on a statement of cash flows as follows:

  Journal entries for issued shares at par-value1322009nbsp

journal entries for issued shares at par-value.1.322009nbsp paid 8300 cash for office supplies.nbspdateaccount

  Construction of bases for equipment to be installed later

On July 6, Zonker Company acquired the plant assets of Doonesbury Company, which had discontinued operations. Zonker Company expended the following amounts in cash between July 6 and December 15, the date when it first occupied the building. On Decem..

  Determine the corporations income tax liability

In each of the following independent situations, determine the corporation's income tax liability. Assume that all corporations use a calendar year for tax purposes and that the tax year involved is 2014.

  Define issuance of long-term bonds

Most decisions made by to management impact the ratios analysts use evaluate performance.  Indicate (by letter) whether each of the actions listed below will immediately increase (I), decrease (D) or have no effect (N) on the ratios shown.

  Financial analysis of the company

Carefully read the annual report and the income and cash-flow statements? 2. Reclassify the expense and income statements by function. ?

  What do you estimate as the fair market value for this stock

A stock just paid an annual dividend of $2.50 per share yesterday (assume the stock pays dividends once per year). You project that the stock’s 3-year growth rate in dividends will be 8% per year. -Based on a dividend discount model, what do you esti..

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