can you help me with this

choose one company you think you would like to work for (eg. Apple, McDonald's,....). Do an analysis of the ratios on your company for the past five years and include industry averages. You should get your financial statements from Mergent available through the library's Databases. from

The Industry average ratios are available in IBISWorld also in thedatabases. IBISWorld is organized by industry codes so enter apple or McDonald's company's name to get the correct industry code for your company. looking for ( balance sheet, income statement, ratio)

Do your analysis on an EXCEL spreadsheet so I can view the formulas in the cells.

As Reported Annual Balance Sheet

Report Date	03/31/2015		03/31/2014		03/31/2013		03/31/2012		03/31/2011
Currency	INR		INR		INR		INR		INR
Audit Status	Not Available		Not Available		Not Available		Not Available		Not Available
Consolidated	Yes		Yes		Yes		Yes		Yes
Scale	Millions		Millions		Millions		Millions		Millions
Share capital	556.701		556.701		556.701		556.701		556.701
Reserves & surplus	(395.888)		(399.34)		(403.054)		(402.097)		(403.543)
Total shareholders' funds	160.814		157.361		153.647		154.605		153.158
Long-term provisions	222.766		222.766		222.236		214.444		214.444
Total non-current liabilities	222.766		222.766		222.236		214.444		214.444
Trade payables	0.114		0.015		0.037		(0.023)		0.081
Other current liabilities	0.398		0.251		1.433		8.955		8.932
Short-term provisions	9.628		9.1		9.097		7.353		6.191
Total current liabilities	10.139		9.365		10.567		16.285		15.203
Total equity & liabilities	393.72		389.493		386.45		385.334		382.805
Tangible assets	56.29		59.491		61.452		62.527		64.582
Total fixed assets	56.29		59.491		61.452		62.527		64.582
Non-current investments	106.821		106.821		106.821		106.821		127.407
Total non-current assets	163.111		166.312		168.273		169.349		191.989
Inventories	24.675		24.675		24.675		24.675		24.675
Cash & cash equivalents	195.624		189.982		184.878		182.45		150.664
Other current assets	10.31		8.523		8.625		8.861		15.478
Total current assets	230.609		223.181		218.178		215.986		190.817
Total assets	393.72		389.493		386.45		385.334		382.805

Business Summary

Apple Finance is a holding company. Through its subsidiary, Apple Asset Management Limited, Co. is engaged in securities investment and related activities. Through its associate company, Apple Housing Limited, Co. is engaged in property development. Co. operates predominantly in India.

Pricing Summary

Time Period 1 week14 days30 days3 months6 months1 year

No chart available

	Yesterday	5 Days	30 Days
Close	N/A	N/A	N/A
Volume	N/A	N/A	N/A
52 Week High/Low :	N/A - N/A
% Price Change (100 Days) :	N/A
200-Day Moving Avg. :	N/A

• Company News
• Corporate Events

There is no news found for this company

Key Executives

Atul Nishar
Chmn. & Managing Dir.
P Rao
Secretary
M Karani
Director
N Bhogilal
Director
G Dave
Director

Key Financials

(In INR as of 03/31/2015)

Income Statement
Revenue	22m
Net Income	4m
EPS - Net Income - Diluted	0.07
Balance Sheet
Total Assets	394m
Total Liabilities	233m
Shareholders' Equity	161m
Cash Flows
Cash from Operations	-14m
Cash from Investing	19m