Question #1 – Strategic Quantitative Financial Analysis

1 answer below »

View more »
Answered Same DayApr 30, 2021

Answer To: Question #1 – Strategic Quantitative Financial Analysis

Ayush answered on May 01 2021
143 Votes
Slide 1
Question #1 – Strategic Quantitative Financial Analysis
Given Data:
    Financial Items    Existing    New
    Sales    $303,225    $303,225
    Operating Costs    $267,500    $267,500
    Year-end Assets    $195,00
0    $195,000
    Debt/Total Assets (%)    27%    45%
    Interest on debt (%)    8.2%    8.2%
    Firm Tax Rate (%)    37%    37%
Assumptions: Sales and total assets would not be affected, and that the interest rate and tax rate would both remain constant
Question #1 – Strategic Quantitative Financial Analysis
In Summary
    Income Statement    Existing     New
    Sales    $303,225    $303,225
    Operating Costs    $267,500    $267,500
    Earning before Interest Taxes (EBIT) (Sales-OC)    $35725    $35725
    Interest Expense (Interest Rate*Debt)    $4317.3    $7195.5
    Tax Expense (Tax rate*(EBIT-Interest Exp)    $11620.85    $10555.9
    Net Income    $19786.85    $17973.6
    RoE% (NI/Equity)    13.9%    16.7%
Changing capital structure from 27% to 45% will lead to a change of +2.8% of ROE
As we can see, changing debt (increasing) has the benefit of “Tax Shield” (Tax rate*Interest Rate*Debt). However, there is an optimal value of debt that has Tax savings beyond which begin to profitability of the firm deteriorate.
Also, that the higher debt, the greater Return on Equity
For Detailed calculations, Please see next slide.
2
Question #1 – Strategic Quantitative Financial Analysis
Calculations:
Total Asset = Debt + Equity
Existing Debt/ Total Asset = 27%
Debt = 27% * Total Asset =>Debt = 27% * 195000
Debt = $ 52,650, Equity = 195000-52650 = $ 142350
Similarly, we calculate, New Debt = $ 87750, New Equity = $107250
Existing Interest Expenses = Interest Rate * Debt = 8.2%* 52650 = $4317.3
=> New Interest Expense = 8.2%* 87750 = $7195.5
Existing Tax Expense = 37%*(EBIT-Interest Exp) = 37%* 31407 = $11620.85
=>New Tax Expense = 37%*(EBIT-Interest Exp) = 37%*28529.5 = $10555.9
Net Income = Sales – OC – Interest Expense – Tax Expense
=>Existing NI = $19786.85
=> New NI = $17973.6
Return on Equity (ROE) =...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30