Use the provided Excel template to complete the following question using Excel formulas where appropriate. Sprint Nextel is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 32.5 million direct subscribers (accounts) that generated revenue of $35,345 million. Costs and expenses for the year were as follows (in millions): Cost of revenue $20,841 Selling, general, and administrative 9,765 expenses Depreciation 2,239 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). 1. What is Sprint Nextel's break-even number of accounts, using the data and assumptions given? Round units (accounts) and per-account amounts to one decimal place. 2. How much revenue per account would be sufficient for Sprint Nextel to break even if the number of accounts remained constant?

Break-Even Analysis for a Service Company Rotelco is a digital wireless service provider in the United States. In a recent year, it had approximately 100 direct subscribers (accounts) that generated revenue of $52,800. Costs and expenses for the year were as follows: Cost of revenue Selling, general, and administrative expenses Depreciation $25,300 14,300 5,800 Assume that 75% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). In part (a) and (b), round all interim calculations to two decimal place and final answers to the nearest whole number. a. What is Rotelco's break-even number of accounts, using the data and assumptions above? accounts b. How much revenue per account would be sufficient for Rotelco to break even if the number of accounts remained constant? per account

Required information [The following information applies to the questions displayed below.] Megamart provides the following information on its two investment centers. Investment Center Electronics Income $ 3,114,000 2,261,000 Average Assets $ 17,300,000 13,300,000 Sporting goods Sales $ 41,520,000 18,088,000 1. Compute return on investment for each center. Using return on investment, which center is most efficient at using assets to generate income? 2. Assume a target income of 11% of average assets. Compute residual income for each center. Which center generated the most residual income? 3. Assume the Electronics center is presented with a new investment opportunity that will yield a 14% return on investment. Should the new investment opportunity be accepted? The target return is 11%. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute return on investment for each center. Using return on investment, which center is most efficient…

need both answer

Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages.   TannenhillCompany   ElectronicsIndustryAverage Sales $800,000     100 % Cost of goods sold 512,000     70   Gross profit $288,000     30 % Selling expenses $176,000     17 % Administrative expenses 64,000     7   Total operating expenses $240,000     24 % Operating income $48,000     6 % Other revenue 16,000     2     $64,000     8 % Other expense 8,000     1   Income before income tax $56,000     7 % Income tax expense 24,000     5   Net income $32,000     2 % a.  Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive numbers.

Subject:- finance

еВook updates now or try tonight? Lat Break-Even Analysis for a Service Company Sprint Corporation is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 32.6 million direct subscribers (accounts) that generated revenue of $33,600 million. Costs and expenses for the year were as follows (in millions): Cost of revenue $13,389 Selling, general, and administrative expenses 7,774 Depreciation 8,783 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). In part (a) and, (b), round all interim calculations and final answers to one decimal place. a. What is Sprint's break-even number of accounts, using the data and assumptions given? 26.9 X million accounts b. How much revenue per account would be sufficient for Sprint to break even if the number of accounts remained constant? 932.6 X million per account

Nextel Communications, Inc. is one of the largest digital wireless service providers in the United States. In a recent year, it had 8,666,500 accounts that generated revenues of $7,689,000,000. Costs and expenses were as follows: Cost of revenue$ 2,869,000,000 Selling, general and administrative expenses 3,020,000,000 Depreciation 1,746,000,000 Assume that 65% of the cost of revenue and 55% of the selling, general and administrative expenses are variable to the number of accounts.Required: a) What is Nextel’s break-even number of accounts using the data and assumptions above? Round any per-unit computations to the nearest dollar. b) How much revenue per account would be sufficient for Nextel to break even if the number of accounts remained constant?

Solve this problem