Lowe's Companies Inc (NYS: LOW) PREPARE FIVE YEAR PRO FORMA BALANCE SHEET?
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date	02/03/2017		01/29/2016		01/30/2015		01/31/2014		02/01/2013
Currency	USD		USD		USD		USD		USD
Audit Status	Not Qualified		Not Qualified		Not Qualified		Not Qualified		Not Qualified
Consolidated	Yes		Yes		Yes		Yes		Yes
Scale	Thousands		Thousands		Thousands		Thousands		Thousands
Cash & cash equivalents	558000		405000		466000		391000		541000
Short-term investments	100000		307000		125000		185000		125000
Merchandise inventory, net	10458000		9458000		8911000		9127000		8600000
Deferred income taxes, net	-		-		230000		252000		217000
Other current assets	884000		391000		348000		341000		301000
Total current assets	12000000		10561000		10080000		10296000		9784000
Land	7329000		7086000		7040000		7016000		6986000
Buildings & building improvements	18147000		17451000		17247000		17161000		16968000
Equipment	10978000		10863000		10426000		10063000		9780000
Construction in progress	464000		513000		730000		834000		932000
Total cost	36918000		35913000		35443000		35074000		34666000
Less: accumulated depreciation	16969000		16336000		15409000		14240000		13189000
Property, less accumulated depreciation	19949000		19577000		20034000		20834000		21477000
Long-term investments	366000		222000		354000		279000		271000
Deferred income taxes - net	222000		241000		-		-		-
Goodwill, net	1082000		-		-		-		-
Other assets	789000		665000		1359000		1323000		1134000
Total assets	34408000		31266000		31827000		32732000		32666000
Short-term borrowings	510000		43000		-		386000		-
Current maturities of long-term debt	795000		1061000		552000		49000		47000
Accounts payable	6651000		5633000		5124000		5008000		4657000
Accrued compensation & employee benefits	790000		820000		773000		785000		670000
Deferred revenue	1253000		1078000		979000		892000		824000
Self-insurance liabilities	327000		343000		346000		324000		316000
Accrued dividends	304000		255000		222000		186000		178000
Sales tax liabilities	210000		140000		131000		122000		104000
Accrued interest	194000		179000		165000		153000		136000
Accrued property taxes	108000		111000		124000		121000		112000
Other current liabilities	832000		829000		932000		850000		664000
Other current liabilities	1975000		1857000		1920000		1756000		1510000
Total current liabilities	11974000		10492000		9348000		8876000		7708000
Secured mortgage notes	7000		7000		16000		17000		19000
Unsecured debt - notes	14321000		12073000		10860000		9617000		8627000
Capitalized lease obligations	861000		526000		491000		501000		431000
Total long-term debt	15189000		12606000		11367000		10135000		9077000
Less: current maturities	795000		1061000		552000		49000		47000
Long-term debt, excluding current maturities	14394000		11545000		10815000		10086000		9030000
Deferred income taxes - net	-		-		97000		291000		455000
Deferred revenue - extended protection plans	763000		729000		730000		730000		715000
Other liabilities	843000		846000		869000		896000		901000
Total liabilities	27974000		23612000		21859000		20879000		18809000
Common stock	433000		455000		480000		515000		555000
Capital in excess of par value	-		-		-		-		26000
Retained earnings	6241000		7593000		9591000		11355000		13224000
Accumulated other comprehensive income (loss)	-240000		-394000		-103000		-17000		52000
Total shareholders' equity	6434000		7654000		9968000		11853000		13857000

Qestion 2) Prepare Five year pro forma Income Statement using following historical Income statement. Use Excel for the calculation

As Reported Annual Income Statement
Report Date	02/03/2017	01/29/2016	01/30/2015	1/31/2014	02/01/2013
Currency	USD	USD	USD	USD	USD
Scale	Thousands	Thousands	Thousands	Thousands	Thousands
Net sales	65017000	59074000	56223000	53417000	50521000
Cost of sales	42553000	38504000	36665000	34941000	33194000
Gross margin	22464000	20570000	19558000	18476000	17327000
Selling, general & administrative expense	15129000	14115000	13281000	12865000	12244000
Depreciation	-	1484000	1485000	1462000	1523000
Depreciation & amortization	1489000	-	-	-	-
Income (loss) from operations	5846000	-	-	-	-
Interest expense on long-term debt	583000	505000	470000	431000	418000
Interest expense on capitalized lease obligations	53000	42000	42000	40000	37000
Interest income	12000	4000	6000	4000	9000
Interest capitalized	4000	3000	2000	4000	4000
Interest on tax uncertainties	2000	-1000	-1000	6000	-27000
Other interest expense	23000	13000	13000	7000	8000
Interest income (expense), net	-645000	-552000	-516000	-476000	-423000
Total expenses	-	16151000	15282000	14803000	14190000
Pre-tax earnings (losses)	5201000	4419000	4276000	3673000	3137000
Current provision (benefit) for income taxes - federal	1824000	1688000	1475000	1342000	1162000
Current provision (benefit) for income taxes - state	275000	248000	221000	203000	155000
Total current provision (benefit) for income taxes	2099000	1936000	1696000	1545000	1317000
Deferred provision (benefit) for income taxes - federal	6000	-59000	-112000	-133000	-133000
Deferred provision (benefit) for income taxes - state	3000	-4000	-6000	-25000	-6000
Total deferred provision (benefit) of deferred income taxes	9000	-63000	-118000	-158000	-139000
Income tax provision	2108000	1873000	1578000	1387000	1178000
Net earnings	3093000	2546000	2698000	2286000	1959000
Weighted average shares outstanding - basic	880000	927000	988000	1059000	1150000
Weighted average shares outstanding - diluted	881000	929000	990000	1061000	1152000
Year end shares outstanding	866000	910000	960000	1030000	1110000
Net earnings per share - basic	3.48	2.73	2.71	2.14	1.69
Net earnings per share - diluted	3.47	2.73	2.71	2.14	1.69
Cash dividends per share	1.33	1.07	0.87	0.7	0.62

Question 3) Prepare Property plant and equipment ( Gross and net forcast) development by Using above balancesheet for five year?

Question 4) Prepare Finacial ratios Using pro forma income statement and Balance sheet?

Note: All calculation should be done through spread sheet.