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

  Affected by the choice of depreciation methods

Which of the following measurements would not be affected by the choice of depreciation methods?

  Evaluate the missing amount

Evaluate the missing amount from each of the separate situations and What are the beginning and ending amounts of equity?

  Lauren flintoff is the owner of a retail sports equipment

lauren flintoff is the owner of a retail sports equipment business located in milton that she established 3 years

  Earnings adjustment to alternative minimum taxable income

Which of the following is a false statement regarding the adjusted current earnings adjustment to alternative minimum taxable income? Under Illinois Corporation's plan of liquidation, the corporation distributes land to one of its shareholders, Sprin..

  Record the transaction will consist of a debit to cash

The Sneed Corporation issues 10,000 shares of $50 par value preferred stock for cash at $75 per share. The entry to record the transaction will consist of a debit to Cash for $750,000 and a credit or credits to:

  Find accounts receivable turnover

Find the financial statements for 2 related/similar companies (Nike and reebok) and calculate the following ratios for each (note whether a particular ratio is not applicable):

  Evaluating the special sales order from lawnpro

Identification of relevant costs - Identify all the relevant costs that HMI should consider in evaluating the special sales order from LawnPro

  How you recommend handling the situation

One of your employees complained not about the remark about religion, but that the emails were partisan against the members of their political party. Your boss has asked you how you recommend handling the situation.

  Q on 1st january 20x8 alaska corporation acquired

q on 1st january 20x8 alaska corporation acquired mercantile corporations net assets by paying 160000 cash. balance

  Define the term budgetary slack

Greg Weetman is the controller of a large security technology firm. He is currently preparing the annual budget and reviewing the current business plan. The firm’s business unit managers prepare and assemble the detailed operating budgets with techni..

  Information from its accounting records

Barr Mfg. provided the following information from its accounting records for 2013: Expected production 30,000 labor hours Actual production 28,000 labor hours Budgeted overhead $900,000 Actual overhead $870,000 How much is the overhead application ra..

  Non-operating revenue and expenses

A classified income statement consists of all of the following major sections except for: a, operating revenues, b. cost of goods sold, c. operating expenses, d. non-operating revenue and expenses, e. current assets

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