1st Assaignment (group No Six).xlsx

FINANCIAL ANALYSIS

Financial Analysis refers to an assessment of the Weig Capital (WACC) MBA 1ST Weakend (1.5) Saba Shakeel Majid Ali Abdula Mateen

Blow Is The Folmula For Calculating The Weight Average Cost Of Capital (WACC

WACC = We(ke)+wd(kd)(1-T)+Wp(kp)

Spread sheet caculation

Enter Data

WACC = W Required return on debt

RD

3%

WACC = 73%(10 Required return on equity

RE

11%

Marignal tax rate

T

38%

Debt

D

27%

Equity

E

73%

Actual calculation return debt return equity tax/nibt debt equity income Statement Sales Cost of sales Gorss Profit Operating expences Operating income Interest and other expences Net income before tax Tex expences

Net income after tax

2.70% 10.50% 38% 27% 73% sin m 9,488.80 5,784.90 3,703.90 2,689.70 1,014.20 92.80 921.40 331.70 589.70

Blance sheet Current Assets Non Current Assets Total Assets Total Current Liabilities Long term Debt Income tax and other liabilities Prefreed stock Common stock Retain earining Total equity

Total debt and equity

ALYSIS

ent of the Weight Average Cost Of WACC)

e Cost Of Capital (WACC)

Blow is the formula for Calculating the Cost of Equity

KE= Rf +B(Rm-Rf)

+Wp(kp)

WACC = We(ke)+wd(kd)(1-T)+Wp(kp)

Rf B Rm-Rf

5.74% 0.8 0.059

WACC = 73%(10.50%)+27%(2.70%)(1-38%)=0(0)

0.0811698

0.1046

8%

10% AMOUNT IN M

CURRENRT PORATION NOTES PAYABLE LONG TEEM DEBT TOTAL DEBT TOTAL Equity

TOTAL

Sin m 3,625.30 2,194.30 5,819.60 1,786.70 435.90 102.20 0.30 2.80 3,194.30 3,494.50

5.40 855.30 435.90 1,296.60 3,494.50 4,791.10

5,819.60

FINANCIAL ANALYSIS

Financial Analysis refers to an assessment of the We Capital (WACC) MBA 1ST Weakend (1.5) Saba Shakeel Majid Ali Abdula Mateen

Blow Is The Folmula For Calculating The Weight Average Cost Of Capital (WA

WACC = We(ke)+wd(kd)(1-T)+Wp(kp)

Spread sheet caculation

Enter Data

Required return on debt

RD

15%

Required return on equity

RE

7%

Marignal tax rate

T

17%

Debt

D

26%

Equity

E

74%

Actual calculation return debt return equity tax/nibt debt equity income Statement Sales Cost of sales Gorss Profit Operating expences Operating income Other income Frofit from operation Finance Cost Income Befor Tex

15.16% 6.70% 17% 26% 74%

Tax Expences

sin m 53,729,124.00 48,178,678.00 5,550,446.00 3702134 1,848,312.00 4,102,639.00 5,950,951.00 993,824.00 4,957,127.00 860,000.00

Profit after tax

4,097,127.00

Blance sheet Current Assets Non Current Assets Total Assets Total Current Liabilities Long term Debt Total Liabilities Prefreed stock Common stock Retain earining Total equity

Total debt and equity

ANALYSIS

ssessment of the Weight Average Cost Of pital (WACC)

ght Average Cost Of Capital (WACC)

d)(1-T)+Wp(kp)

WACC = We(ke)+wd(kd)(1-T)+Wp(kp) 8%

0.0811698

8%

Blance sheet Current Assets on Current Assets Total Assets

Sin m 29,042,685.00 73,693,348.00 102,736,033.00

al Current Liabilities Long term Debt Total Liabilities Prefreed stock Common stock Retain earining Total equity

21,260,216.00 5,762,672.00 27,022,888.00 3,434,253.00 72,278,892.00 75,713,145.00

Reserve dividend Retain Earning total equity

72197146 81746 72278892 75,713,145.00

l debt and equity

102,736,033.00

common stock

3,434,253.00

Beginnin End of g of Year Year

Year 2012 2013 2014 2015 2016

d0/D1-1 current/last year - 1

$45.87 $43.34 $41.13 $49.19 $46.42

$43.34 $41.34 $49.17 $46.42 $49.15

Annual Growth -5.50% -4.60% 19.50% -5.60% 5.90%

-5.52% -5.10% 19.60% -5.63% 5.88%