Reformulate Financial statements;Company – Betfair group
Reformulate Financial statements;Company – Betfair group
1.Download the financial statements from the company’s website or from data analysis libraries. Read the notes to the financial statements to discover more detail.
Input all the finincal statements ( balance sheets, changes in equity, income statements and cash flows in excel spreadsheet and ratios for 5 years form 2010 to 2014
and sample piece will be uploaded I want the work excalty as that but with my companys data which is Betfair group )
Reformulated statements
2. Build a detailed spreadsheet using your company’s financial data for years (preferably more) to produce reformulated ( balance sheets, changes in equity, income
statements and cash flows in excel spreadsheet and ratios for 5 years form 2010 to 2014 and sample piece will be uploaded I want the work excalty as that but with my
companys data which is Betfair group )
Produce comparative common-size and trend statements, based on your reformulated statements. Compare To Halfords spreadsheet which will be uploaded
Consolidated Income Statement of Halfords Group Plc
Fiscal data as of Mar 28 2014 2014 2013 2012 2011 2010 2014 2013 2012 2011 2010 2014 2013 2012 2011 2010
REVENUE AND GROSS PROFIT
Total revenue 940 871 863 870 832 940 871 863 870 832
Cost of revenue total 436 394 390 385 379 436 394 390 385 379
Gross Profit 504 477 473 485 453 504 477 473 485 453
OPERATING EXPENSES
Selling, general and admin. expenses, total 426 399 376 357 333 426 399 376 357 333
Depreciation/amortization — — — — — — — — — —
Unusual expense(income) 0.2 1 -1.9 7.5 7.4 0.2 1 -1.9 7.5 7.4
Other operating expenses, total — — — — — — — — — —
Total operating expense 426.2 400 374.1 364.5 340.4 426.2 400 374.1 364.5 340.4
Operating income 78 77 99 121 112 78 77 99 121 112
Net Finance expense -5 -6.1 -5 -2.5 -2.6 -5 -6.1 -5 -2.5 -2.6
Tax benefit of finance expense 1.15 1.46 1.3 0.7 0.7 1.15 1.46 1.3 0.7 0.7
Net finance expense after tax -3.85 -4.64 -3.7 -1.8 -1.9 -3.85 -4.64 -3.7 -1.8 -1.9
Net income before taxes 73 71 94 118 110
Provision for income taxes 17 18 26 33 33 17 18 26 33 33
Tax benefit of finance expense 1.15 1.46 1.3 0.7 0.7 1.15 1.46 1.3 0.7 0.7
Effective tax on operations 18.15 19.46 27.3 33.7 33.7 18.15 19.46 27.3 33.7 33.7
Net income after taxes 56 53 68 86 77 59.85 57.54 71.7 87.3 78.3 -3.85 -4.64 -3.7 -1.8 -1.9
Minority interest — — — — —
Net income before extra. Items 56 53 68 86 77 56 53 68 86 77 56 53 68 86 77
Total extraordinary items — — — — — — — — — — — — — — —
Net income 56 53 68 86 77 56 53 68 86 77 56 53 68 86 77
Inc.avail. to common excl. extra. Items 56 53 68 86 77 56 53 68 86 77 56 53 68 86
77
Inc.avail. to common incl. extra. Items 56 53 68 86 77 56 53 68 86 77 56 53 68 86
77
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
