Re: ::: vuaskari.com ::: Re: || VU Expert 2009 || MY FINAL ANSWERS OF MCB RATIO ANALYSIS

ist i tell u about current ratio that why is the differnece
differnce is due to the Other Assets amount in 2008
U have taken the Other Assets amount as 13,283,715
But in actual the amount will be 13,183,715
Which i have taken
so due to current ratio acid ratio and working capital will be creasting the difference

 

 

 

Now come to the time interest earned ratio
In time interest earned ratio of 2008  difference is due to the amount of

Profit before tax

U have taken the value of profit after tax by mistake in 2008 thats y 2008 ratio is different

u have taken the amount of

Profit before tax as 15,323,227

Which in actual is 21,886,740

 

 

 

Now come to the net profit margin
In 2008 and 2009 the difference is due to the amount of net income which is profit after tax
in 2008 and 2009 U have taken the wrong amount.Means u have taken profit before tax as profit after tax thats y there is difference

 

 

Now come to the returrn on asset ratio
In this ratio difference is sue to the change of formula
U have taken EBIT in this formula and i have taken Profit before tax in this formula
 i have confirmed from instructor and many students have also confirmed about profit before tax, but the confusion is sue to the intrctor differnt answers may b he/she told u to use EBIT now upto u So i will use Profit before tax now u can use EBIT if u want to use EBIT

 

 

Now last one i don;t have ur complete calculation of fixed asset turnover so i can't judge why there is difference
But i think so u have taken the amount of defferd assets from maturity period but i hace taken this amount from balance sheet and in balance sheet the amoubnt of deffered assets is nill.
I have confirmed thsi from intrctor to take the amount of deffered assets from balance sheet.thats y i have takn from balance sheet.Rest up to u

On Sun, Jul 3, 2011 at 3:14 PM, Hafiz Salman Majeed <hafiz.salman.majeed1@gmail.com> wrote:

My few answers are different from u...

Your Answers

Current Ratio

Year 2008	Year 2009	Year 2010
0.886 times	0.903 times	0.926 times

 

My answers

329,757,818 / 354,914,556 = 0.929 Times

384,140,489 / 413,485,780 = 0.929 Times

438,572,699 / 461,267,829 = 0.950 Times

Acid Test Ratio
Year 2008
Year 2009
Year 2010

0.878 times
0.897 times
0.919 times

My Answers

Company Name	2008	2009	2010
MCB	326,790,789 / 354,914,556 = 0.920759049 Times	381,249,295 / 413,485,780 = 0.922037258 Times	435,605,670 / 461,267,829 = 0.944366033 Times

Your answers

Working Capital

Year 2008	Year 2009	Year 2010
-42,552,543 times	-41,020,413 times	-35,103,457 times

 

My Answers

Company Name	2008	2009	2010
MCB	(25,156,738)	(29,345,291)	(22,695,130)

Your answer

Times Interest Earned
Year 2008
Year 2009
Year 2010

2.89 times
2.474 times
2.470 times

My answers

Company Name	2008	2009	2010
MCB	2.32177 Times	2.47408 Times	2.47052 Times

There is some difference in 2008... i took all 2008 amount from Annual report 2009...

Your answers

Net Profit Margin

Year 2008	Year 2009	Year 2010
38.26%	30.35%	30.77%

My answers

Company Name	2008	2009	2010
MCB	54.6492148%	45.2310764%	30.7720616%

Your answers

Return on Assets

Year 2008	Year 2009	Year 2010
4.915%	4.563%	4.647%

My answers

Return on Assets

Year 2008	Year 2009	Year 2010
7.518691402%	7.657936488%	7.806910419%

You answers

Fixed Assets Turnover
Year 2008
Year 2009
Year 2010

0.346 times
0.405 times
0.416 times

My answers

Company Name	2008	2009	2010
MCB	0.342803225  Times	0.39947528 Times	0.411825842 Times

On Fri, Jul 1, 2011 at 5:39 PM, LAIBA BUTT <laiba.butt98@gmail.com> wrote:

HERE ARE MY FINAL ANSWERS OF MCB RATIO ANALYSIS

NOTE:

All the values are taken from consolidate financial statement.

and the values of assets and laibilities all are taken according to maturity period

Current Ratio

Year 2008	Year 2009	Year 2010
0.886 times	0.903 times	0.926 times

 

Acid Test Ratio

Year 2008	Year 2009	Year 2010
0.878 times	0.897 times	0.919 times

 

Working Capital

Year 2008	Year 2009	Year 2010
-42,552,543 times	-41,020,413 times	-35,103,457 times

 

Times Interest Earned

Year 2008	Year 2009	Year 2010
2.89 times	2.474 times	2.470 times

 

Debt Ratio

Year 2008	Year 2009	Year 2010
0.865 times	0.859 times	0.856 times

 

Debt/Equity Ratio

Year 2008	Year 2009	Year 2010
7.114 times	6.959 times	6.856 times

 

 

Debt to Tangible Net worth Ratio

Year 2008	Year 2009	Year 2010
6.43 times	6.097 times	5.98 times

 

Total Capitalization Ratio

Year 2008	Year 2009	Year 2010
0.193   times	0.184  times	0.172 times

 

Net Profit Margin

Year 2008	Year 2009	Year 2010
38.26%	30.35%	30.77%

 

 

Return on Assets

Year 2008	Year 2009	Year 2010
4.915%	4.563%	4.647%

 

DuPont Return on Assets

Year 2008	Year 2009	Year 2010
3.44%	3.06%	2.96%

 

Operating Income Margin

Year 2008	Year 2009	Year 2010
83.59%	75.91%	81.23%

 

Return on Operating Assets          

Year 2008	Year 2009	Year 2010
10.229%	12.28%	13.62%

 

Return on Total Equity

Year 2008	Year 2009	Year 2010
28.30%	24.81 %	23.68%

 

Gross Profit Margin

Year 2008	Year 2009	Year 2010
71.05%	69.32%	67.12%

 

Total Assets Turnover

Year 2008	Year 2009	Year 2010
0.09 times	0.10 times	0.096 times

 

Fixed Assets Turnover

Year 2008	Year 2009	Year 2010
0.346 times	0.405 times	0.416 times

 

Dividend per Share

Year 2008

Year 2009

Year 2010

Rs 15.65

Rs 9.75

Rs 11.26

 

Earning per Share

Year 2008

Year 2009

Year 2010

Rs 24.39

Rs 22.67

Rs 22.19

 

Price/Earning Ratio

Year 2008	Year 2009	Year 2010
Rs 5.166	Rs 9.704	Rs 10.30

 

 

REMEMBER ME IN UR PRAYERS

REGARDS
ADMIN LAIBA BUTT
MBA 4TH SEM ( FINANCE)
VUASKARI TEAM

JOIN US ON
www.vuaskari.com

We are the ASKARIANS!!!! A Name of Quality

--

REMEMBER ME IN UR PRAYERS

REGARDS
ADMIN LAIBA BUTT
MBA 4TH SEM ( FINANCE)
VUASKARI TEAM

JOIN US ON
www.vuaskari.com

We are the ASKARIANS!!!! A Name of Quality

--
Please visit http://www.weblyceum.com and get registered for Past Papers, Quiz, Assignments, GDBs and much more...
 
To post to this group, send email to vu-experts@googlegroups.com
 
Do write to bilal.zaheem@gmail.com for Help, suggestion and Complaint.

--

█▓▒░ Hafiz Salman Majeed░▒▓█

            www.vuaskari.com

MBA Last Semester (Finance Group)

                  LAHORE

اللہ آپ کو آسانیاں عطا فرمائے۔
جزاكم الله خيرا وأحسن الجزاء في الدنيا والأخرة

جہاں رہیے اللہ کے بندوں کے لیے باعثِ آزار نہیں، باعثِ رحمت بن کر رہیے

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

--

REMEMBER ME IN UR PRAYERS

REGARDS
ADMIN LAIBA BUTT
MBA 4TH SEM ( FINANCE)
VUASKARI TEAM

JOIN US ON
www.vuaskari.com

We are the ASKARIANS!!!! A Name of Quality

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en