a.
To prepare: The income statement and determine if it is profitable.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
a.
Explanation of Solution
The income statement for the company has been prepared:
Working note: Preparation of income statement and computation of net income has been shown below:
b.
To compute: Operating breakeven point units and dollars.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
b.
Explanation of Solution
Breakeven point is the point at which the company neither earns
The operating break even for the company has been computed:
Working note: The computation of operating break even for the company has been computed has been shown below:
c.
To compute: Operating breakeven point units with target profit.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
c.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
The operating break even with target profit for the company has been computed:
Working note: The computation of operating break even with target profit for the company has been computed has been shown below:
d.
To compute: Selling price that would lead to operating breakeven point using goal seek.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
d.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
Step 1: Enter all the details using the formulas
Working notes: Its computation using formulas has been shown below:
Step 2: Go to ‘data’ tab and click on ‘what-if analysis’ to select ‘goal seek’ function. Set the value of profit as 0 by changing the selling price. It has been shown below:
Step 3: Click on ‘OK’. The new selling price that would lead to operating profit would be computed.
e.
To compute: DOL, DFL and DCL.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
e.
Explanation of Solution
Breakeven point is the point at which the company neither earns profit nor incurs loss. It is the minimal sales required to cover variable as well as fixed costs.
Leverage is the degree of change in component on the other component. It can be divided into three categories i.e. degree of operating leverage (DOL), degree of financial leverage (DFL) and degree of combined leverage (DCL).
Working notes: Calculation for each leverage has been shown below:
Want to see more full solutions like this?
Chapter 7 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- APQ Company currently sells a piece of equipment for $150 per unit. It plans on lowering the price of the unit to $119 per unit. The cost of goods for each unit is consistent each year, at $52 per unit. The company expects to sell 100,000 units in the current year. Suppose that if APQ drops the price on the equipment immediately, it can increase sales over the next year by 30% to 130,000 units. Will this price decrease have a positive or negative impact on the company's EBIT? What will be the dollar value of the incremental impact of this price drop on the firm's EBIT? Will this have a positive or negative impact on the EBIT for the company? What will the dollar value of the incremental impact of the price drop be for the company? (Enter a negative for a loss, positive for a gain; round your answer to the nearest whole dollar.)arrow_forwardHyperion Inc., currently sells its latest high-speed color printer, the Hyper 500, for $350. Its cost of goods sold for the Hyper 500 is $200 per unit, and this year's sales (at the current price of $350) are expected to be 20,000 units. Hyperion plans to lower the price of the Hyper 500 to $300 one year from now. a. Suppose Hyperion considers dropping the price to $300 immediately, (rather than waiting one year). By doing so, it expects to increase this year's sales by 25% to 25,000 units. What would be the incremental impact on this year's EBIT of such a price drop? b. Suppose that for each printer sold, Hyperion expects additional sales of $75 per year on ink cartridges for the three-year life of the printer, and Hyperion has a gross profit margin of 70% on ink cartridges. What is the incremental impact on EBIT for the next three years of dropping the price immediately (rather than waiting one year)?arrow_forwardThe ABC Corporation is considering introducing a new product, which will require buying new equipment for a monthly payment of $5,000. Each unit produced can be sold for $20.00. ABC incurs a variable cost of $10.00 per unit. Suppose that ABC would like to realize a monthly profit of $50,000. How many units must they sell each month to realize this profit?arrow_forward
- Shue Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $24,400, and the company expects to sell 1,610 per year. The company currently sells 1,960 units of its existing model per year. If the new model is introduced, sales of the existing model will fall to 1,630 units per year. The old board retails for $22,800. Variable costs are 56 percent of sales, depreciation on the equipment to produce the new board will be $1,215,000 per year, and fixed costs are $3,175,000 per year. If the tax rate is 21 percent, what is the annual OCF for the project? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. OCFarrow_forwardThe ABC Corporation is considering introducing a new product, which will require buying new equipment for a monthly payment of $5,000. Each unit produced can be sold for $20.00. ABC incurs a variable cost of $10.00 per unit. How many units must ABC sell each month to break even?arrow_forwardMilberg Golf has decided to sell a new line of golf club. The clubs will sell for $1,000 per set and have a variable cost of 80% of revenues per set. The company has spent $450,000 for a marketing study that determined the company will sell 80,000 sets per year for seven years. The company also plans to offer a line of golf balls, which are expected to sell for $40/dozen and have a variable cost of $15. The company expects to sell 100,000 boxes (of a dozen) balls. The fixed costs each year will be $11,200,000. The company has also spent $1,000,000 on research and development for the new clubs. The plant and equipment required will cost $28,000,000 and will be depreciated using the MACRS seven-year schedule. Assume that the equipment will be sold for 15% of its original cost. The new clubs will also require an increase in net working capital of $2,000,000 that will be returned at the end of the project. The tax rate is 25 percent. Information for computing the cost of capital is…arrow_forward
- Milberg Golf has decided to sell a new line of golf club. The clubs will sell for $1,000 per set and have a variable cost of 80% of revenues per set. The company has spent $450,000 for a marketing study that determined the company will sell 80,000 sets per year for seven years. The company also plans to offer a line of golf balls, which are expected to sell for $40/dozen and have a variable cost of $15. The company expects to sell 100,000 boxes (of a dozen) balls. The fixed costs each year will be $11,200,000. The company has also spent $1,000,000 on research and development for the new clubs. The plant and equipment required will cost $28,000,000 and will be depreciated using the MACRS seven-year schedule. Assume that the equipment will be sold for 15% of its original cost. The new clubs will also require an increase in net working capital of $2,000,000 that will be returned at the end of the project. The tax rate is 25 percent. Information for computing the cost of capital is…arrow_forwardHyperion Inc., currently sells its latest high-speed colour printer, the Hyper 500, for $354. Its cost of goods sold for the Hyper 500 is $202 per unit, and this year's sales (at the current price of $354) are expected to be 24,000 units. Hyperion plans to lower the price of the Hyper 500 to $303 one year from now. a. Suppose Hyperion considers dropping the price to $303 immediately, (rather than waiting one year). By doing so it expects to increase this year's sales by 30% to 31,200 units. What would be the incremental impact on this year's EBIT of such a price drop? b. Suppose that for each printer sold, Hyperion expects additional sales of $82 per year on ink cartridges for the three-year life of the printer, and Hyperion has a gross profit margin of 61% on ink cartridges. What is the incremental impact on EBIT for the next three years of dropping the price immediately (rather than waiting one year)? a. Suppose Hyperion considers dropping the price to $303 immediately, (rather than…arrow_forwardPhlight Restaurant is considering a delivery service. The firm expects that sales from the new service will be $150,000 per year. Phlight currently offers a sit-down service with annual sales of $100,000. While many of the delivery sales will be to new customers, Phlight estimates that 60% of their current sit-down customers will switch and use the delivery service. The level of incremental sales associated with introducing the delivery service is closest to: Select one: a. $90,000 b. $150,000 c. $60,000 d. $120,000arrow_forward
- Vinic Films has developed a new film that will increase the shelf-lives of frozen foods. Between equipment installation, labor, and overhead costs the initial development cost for this new product will be $4,000,000. It is expected that this new film will turn an initial profit of $725,000, increasing by 3.5% every year until until year 6. From years 7-12, the profit is expected to decrease by 30% every year as new products are introduced. In total, this product is expected to be sold for 12 years. Find the annual equivalent worth of this product if a 10% return on investment is expected.arrow_forwardWhite Bakery plans to produce 15,000 cakes per year. The company is considering purchasing new cake decorating equipment. The new equipment would cost $30,000. This equipment qualifies for the use of MACRS (3-year asset class) and would be sold at the end of 3 years for an estimated $6,000. The company estimates that with the new equipment revenues will be $2.60 per cake and variable expenses will be $2 per cake. All revenues and expenses are paid in cash. The company does not have any fixed expenses. A 10% rate of return is required on all investments (cost of capital is 10%). White expects its tax rate to be 30%. What is an accounting rate of return on original investment (ignoring taxes; e.g., assume that the tax rate is zero)? What is a payback period on this investment (ignoring taxes; e.g., assume that the tax rate is zero)?arrow_forwardA recently retired professor, Melinda Marketing, plans to establish the Hot-Air FanCompany and manufacture circulating fans. She estimates the fixed cost of operations tobe $357,500 annually. The variable cost of producing the fans is forecasted to be $85 perunit.a. How many fans must be sold to break even if the fans are priced at $150?b. If Hot-Air sells 6,000 fans, what will be the EBIT?c. If Hot-Air sells 6,000 fans and has interest expense of $8,125, what is Hot-Air’stimes-interest-earned? Hot-Air does not have any nonoperating expenses.d. If the fans are priced at $150, what is Hot-Air’s breakeven sales?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education