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
- While determining the appropriate discount rate, if a firm uses a weighted average cost of capital that is unique to a particular project, it is using the Blank______. Multiple choice question. pure play approach economic value added method subjective approach security market line approacharrow_forwardWhen a company's interest payment Blank______, the company's tax bill Blank______. Multiple choice question. stays the same; increases decreases; decreases increases; decreases increases; increasesarrow_forwardFor the calculation of equity weights, the Blank______ value is used. Multiple choice question. historical average book marketarrow_forward
- A firm needs to raise $950,000 but will incur flotation costs of 5%. How much will it pay in flotation costs? Multiple choice question. $50,000 $55,000 $55,500 $47,500arrow_forwardQuestion Mode Multiple Choice Question The issuance costs of new securities are referred to as Blank______ costs. Multiple choice question. exorbitant flotation sunk reparationarrow_forwardWhat will happen to a company's tax bill if interest expense is deducted? Multiple choice question. The company's tax bill will increase. The company's tax bill will decrease. The company's tax bill will not be affected. The company's tax bill for the next year will be affected.arrow_forward
- The total market value of a firm is calculated as Blank______. Multiple choice question. the number of shares times the average price the number of shares times the future price the number of shares times the share price the number of shares times the issue pricearrow_forwardAccording the to the Blank______ approach for project evaluation, all proposed projects are placed into several risk categories. Multiple choice question. pure play divisional WACC subjectivearrow_forwardTo invest in a project, a company needs $50 million. Given its flotation costs of 7%, how much does the company need to raise? Multiple choice question. $53.76 million $46.50 million $50.00 million $53.50 millionarrow_forward
- While determining the appropriate discount rate, if a firm uses a weighted average cost of capital that is unique to a particular project, it is using the Blank______. Multiple choice question. economic value added method pure play approach subjective approach security market line approacharrow_forwardWhat are flotation costs? Multiple choice question. They are the costs incurred to issue new securities in the market. They are the costs incurred to insure the payment due to bondholders. They are the costs incurred to meet day to day expenses. They are the costs incurred to keep a project in the business.arrow_forwardGeneral Financearrow_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