7InstructionsKey Code:[Key code here]89 Answers are entered in the cells with gray backgrounds.10 Cells with non-gray backgrounds are protected and cannot be edited.11 An asterisk (*) will appear to the right of an incorrect entry.121314 A.15Break-Even (in accounts)%3D1617181920212224million (rounded) accountsSupporting calculations:Revenue per account (in millions):Total revenue (in millions)Total accounts (in millions)Revenue per account (in millions)3031323334Variable cost per account (in millions):VariableFull AmountPercentage35Cost of revenue (in millions)36Selling, gen., admin. exp. (in millions)37Total variable costs38Divided by number of accountsVariable cost per account (in millions)3940Total fixed costs (in millions):4142FixedFull AmountPercentage43Cost of revenue (in millions)44Selling, gen., admin. exp. (in millions)45Depreciation46Total fixed costs (in millions)47484950 B.51Break-even (in $ revenue, in millions):52Total costs53Divided by number of accounts54Break-evenmillion55 Ch05 Excel AssignmentEX 05 -17 (14th ed)Break-even analysis for a service companyUse the provided Excel template to complete the following questionusing Excel formulas where appropriate...... ..Sprint Nextel is one of the largest digital wireless service providers in theUnited States. In a recent year, it had approximately 32.5 million directsubscribers (accounts) that generated revenue of $35,345 million. Costs andexpenses for the year were as follows (in millions):Cost of revenue$20,8419,765Selling, general, and administrativeexpensesDepreciation2,239Assume that 70% of the cost of revenue and 30% of the selling, general, andadministrative expenses are variable to the number of direct subscribers(асcounts).1. What is Sprint Nextel's break-even number of accounts, using the data andassumptions given? Round units (accounts) and per-account amounts to onedecimal place.2. How much revenue per account would be sufficient for Sprint Nextel to breakeven if the number of accounts remained constant?

Break-even number of accounts=Total Fixed Costs(Revenue Per Account – Variable Cost per Account)

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?

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?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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 $40,100. Costs and expenses for the year were as follows: Cost of revenue $18,400 Selling, general, and administrative expenses 11,600 Depreciation 4,400 Assume that 65% of the cost of revenue and 40% 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? fill in the blank accounts b. How much revenue per account would be sufficient for Rotelco to break even if the number of accounts remained constant? $ fill in the blank per account
Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales $ 17,400,000 Net operating income $ 5,400,000 Average operating assets $ 35,300,000 Required: 1. Compute the margin for Alyeska Services Company. (Round your answer to 2 decimal places.) 2. Compute the turnover for Alyeska Services Company. (Round your answer to 2 decimal places.) 3. Compute the return on investment (ROI) for Alyeska Services Company. (Round your intermediate calculations and final answer to 2 decimal places.)
Giardin Outdoors is a recreational goods retailer with two divisions: Online and Stores. The two divisions both use the services of the corporate Finance and Accounting (F and A) Department. Annual costs of the F and A Department total $5.215 million a year. Managers in the two operating divisions are measured based on division operating profits. The following selected data are available for the two operating divisions: Online Stores Revenues ($000) Fixed Variable Total $ 74,700 40,500 Required: Determine the cost allocation if $3.815 million of the F and A costs are fixed and allocated on the basis of revenues, and the remaining costs, which are variable, are allocated on the basis of transactions. Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar. Transactions_ (000) 1,216.5 358.5 Online Stores
The Home Depot, Inc. (HD), is the world's largest home improvement retailer and one of the largest retailers in the United States based on sales volume. Home Depot operates over 2,200 stores that sell a wide assortment of building, home improvement, and lawn and garden items. Home Depot recently reported the following end-of-year balance sheet data (in millions): Year 3 Year 2 Year 1 Total assets $42,549 $39,946 $40,518 Total liabilities 36,233 30,624 27,996 Total stockholders' equity 6,316 9,322 12,522 Compute the ratio of liabilities to stockholders' equity for all three years. Round to two dec- imal places. a. b. What conclusions regarding the margin of protection to creditors can you draw from the trend in this ratio for the three years?
Lasky Manufacturing has two divisions: Carolinas and Northeast. Lasky has a cost of capital of 7.5 percent. Selected financial information (in thousands of dollars) for the first year of business follows: Sales revenue Income Divisional assets (beginning of year) Current liabilities (beginning of year) RAD expenditures Carolinas $1,600 160 1,000 240 800 Northeast $5,500 Complete this question by entering your answers in the tabs below. 432 1,500 240 720 R&D is assumed to benefit two periods. All R&D is spent at the beginning of the year. Required: a-1. Evaluate the performance of the two divisions assuming Lasky Manufacturing uses economic value added (EVA). a-2. Which division had the better performance?
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.] Westerville Company reported the following results from last year's operations: Sales Variable expenses Contribution margin Fixed expenses $ 1,600,000 700,000 900,000 660,000 Net operating income $4 240,000 Average operating assets $ 1,000,000 At the beginning of this year, the company has a $325,000 investment opportunity with the characteristics: Sales Contribution margin ratio Fixed expenses $ 520,000 70 % of sales $ 312,000 The company's minimum required rate of return is 15%. 9. If the company pursues the investment opportunity and otherwise performs the same as last year, wha (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be considered as 12.3%.)) ROI % ( Prev 1O Pr Ps to search RELS
Required information Skip to question [The following information applies to the questions displayed below.] Westerville Company reported the following results from last year's operations: Sales $ 1,500,000 Variable expenses 730, 000 Contribution margin 770, 000 Fixed expenses 470,000 Net operating income $ 300,000 Average operating assets $ 937,500 At the beginning of this year, the company has a $362, 500 investment opportunity with the following cost and revenue characteristics: Sales $ 580,000 Contribution margin ratio 70% of sales Fixed expenses $ 319,000 The company's minimum required rate of return is 10%. 8. If the company pursues the investment opportunity and otherwise performs the same as last year, what turnover will it earn this year? (Round your answer to 2 decimal places.)
The vice president of operations of Free Ride Bike Company is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year for each division are as follows: Category Road Bike Division Mountain Bike Division Sales $1,750,000 $1,810,000 Cost of goods sold Operating expenses 1,300,000 1,440,000 202,000 236,800 800,000 Invested assets 1,400,000 Instructions a. Prepare condensed divisional income statements for the year ended December 31, 2020, assuming that there were no service department charges. b. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each division. (Round percentages and the investment turnover to one decimal place.) c. If management's minimum acceptable return on investment is 10%, determine the residual income for each division. d. Discuss the evaluation of the two divisions, using the performance measures…
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.
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?