Create pro forma projected financial statements for TJ MAXX and Pier one imports to compare the two companies, project for two years and please show calculations.
Liabilities and stockholders' eq.. Liabilities Current Liabilities Accounts Payable 2,672.557 2,644,143 2,488,373 2.230,904 Taxes payable 24,700 154,155 114,203 206,288 Accrued liabilities 909.588 812,666 811,547 772,800 Other Current Liabilities 883,684 770,269 626,086 547,523 Total Current Liabilities 7,150,247 5.531,374 5,125,537 4,757,656 Non-current liabilities Long Term Debt 2,236,625 2.233,616 2.230,607 2.227,599 Deferred taxes liabilities 397,541 393,658 277,810 350.713 Other long-term liabilities 28,743 27,278 33,248 34,140 Total non-current liabilities 11,046,544 3,746,049 3,784,169 3,615,553 Total Liabilities 18,196,791 9,277,423 8.909,706 8,373,209 Stockholders' Equity Common Stock 1,199,100 1,217,183 628,009 646,319 Retained Earnings 5.422,283 4,461,744 4,962,159 4,558,506 Accumulated other comprehe... -673,171 -630,321 -441,859 -694,226 Total stockholders' equity 5.948,212 5.048,606 5.148,309 4,510,599 Total liabilities and stockholde... 24.145,003 14,326,029 14,058,015 12.883,808 20 19 18 7 Balance Sheet All numbers in thousands & Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Assets Current Assets Cash Cash And Cash Equivalents 3.216.752 3,030.229 2.758,477 2.929.849 Other Short Term Investme.. 506,165 543.242 Total Cash 3,216,752 3.030.229 3,264.642 3.473.091 Net Receivables 386,261 346,298 327.166 258,831 Inventory 4,872,592 4,579,033 4.187.243 3,644,959 Total Current Assets 8.890,622 8,469,222 8,485.727 7.750.774 Non-current assets Property, plant and equip... Gross property, plant and e. 20.432.610 10.729.119 9.968,308 9,003,403 Accumulated Depreciation -6,047.230 -5,473,911 -4.962.255 -4,470.509 Net property, plant and e... 14.385,380 5.255.208 5.006.053 4.532.894 Goodwill 95,546 97,552 100.069 195,871 Other long-term assets 761,323 497.580 459,608 398,076 Total non-current assets 15,254,381 5,856,807 5,572.288 5,133,034 Total Assets 24,145,003 14,326,029 14.058,015 12.883,808 Tunce Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 1/31/2020 1/31/2019 1/31/2018 Total Revenue 40,637,855 41,716,977 38,972,934 35,864,664 Cost of Revenue 29,137,615 29.845,780 27,831,177 25,502,167 Gross Profit 11,500,240 11,871,197 11,141,757 10,362,497 Operating Expenses Selling General and Administrati... 7,236,286 7.454,988 6,923,564 6,375,071 Total Operating Expenses 7,236,286 7,454,988 6,923,564 6,375,071 Operating Income or Loss 4,263,954 4,416,209 4,218,193 3,987,426 Interest Expense 61,095 59,086 64,839 64,295 Total Other Income/Expenses Net -36,122 -99,250 Income Before Tax 4,258,486 4,406,183 4,173,211 3,856,588 Income Tax Expense 1,129,545 1,133,990 1,113,413 1,248,640 Income from Continuing Operations 3.128.941 3,272,193 3,059,798 2,607,948 Net Income 3,128,941 3,272,193 3,059,798 2,607,948 Net Income available to common S... 3.128.941 3,272,193 3,059,798 2,607,948 Basic EPS 2.48 2.06 Diluted EPS 2.43 2.02 Basic Average Shares 1,217,183 1,256,018 Diluted Average Shares 1,259,252 1,292,210 EBITDA 5,332,572 5.057,705 4,646,840 ction... Cash Flow Al a nd Get access to 40 years of historical data with Yahoo Finance Premium. Learn more TTM 1/31/2020 1/31/2019 1/31/2013 Cashflows from operating activ Netcome 3.272 193 3.272.193 2.050798 Depreciation amortization 967303 867303 319 SS Deferred income es 6.223 BBEN 137.440 Shadbased compensation 124957 103.557 201362 124957 144059 Cangiwa 15975 42.995 23.532 Inventory 296.541 296.541 4429 450177 29.338 29.338 198.212 20111 Other wong capital 2.841424 2.543,424 62.675 2.963,320 20,414 Other non-cachem 53.675 Net cash provided by operatin.. 4.066540 406540 4.088,459 3.005.624 Cash flows from investing activi Investments in property, planta.. 1.223.116 -1.223,116 - 1,125,139 Acquisitions.net 230,156 230,156 Purchases of investments 28.838 28.838 161,625 861.256 Sales Maurities of investments 12.720 12.720 636 560 906 137 Other investing activites 7,419 7419 26.652 Net cash used for investing act... -1.461,971 -1.461.971 623,552 -1,012,736 Cash flow from financing activ... Debt repayment -7.115 Common stock issued 232.106 232106 13167 255,241 2.406,997 Common stock repurchased 1.551.992 -1.551,992 -1,644,581 Dividends Paid 1.071,562 -1.071,562 972 596 754.040 Other financing activites 23.423 -16.014 1974 Net cash used privided by use... 23.423 2.434,871 186.523 -2,414,71 3.097,481 2.297,346 Net change in cash 196.523 171172 Cachat beginning of period 3.030.229 3.030.229 271752 2.758,477 3.030.229 2009 49 Cachat end of period 3.216,752 326752 Free Cash Flow Cortinho 4.EE 540 4.EE 540 4088,459 3.025.524 Capital Expenditure 1221115 -1.273 115 -1125129 1057 517 Free Cashow 2.843.44 2843,424 2961220 BOOT Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 2/28/2019 2/28/2018 2/28/2017 > Assets 656,290 772,319 843,082 Liabilities and stockholders' eq... Liabilities Current Liabilities Current Debt 2.000 2,000 2.000 Accounts Payable 121,969 71,279 68,981 Taxes payable 302 2.301 26.058 Accrued liabilities 85,811 81,854 106,048 Deferred revenues 37,655 55,281 60,398 Total Current Liabilities 269,465 237,129 291,303 Non-current liabilities Long Term Debt 245,624 197,906 199,077 Deferred revenues 1.933 2,516 3.522 Other long term liabilities 37.923 38,686 35,851 Total non-current liabilities 297.296 257,620 259,751 Total Liabilities 566,761 494,749 551,054 Stockholders' Equity Common Stock 125 125 125 Retained Earnings 534,419 726,232 737,165 Accumulated other comprehe.. -7,861 -7,477 -7,414 Total stockholders' equity 89.529 277.570 292,028 Total liabilities and stockholde... 656,290 772,319 843,082 Cash Flow Alumbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 vCash flows from operating activ... Net Income -310,021 - 198,833 11.626 30.129 Depreciation & amortization 57.499 59.523 61,430 60.504 Deferred income taxes 627 -3.071 6,012 -19.645 Stock based compensation 2.337 2.756 3.809 8.228 Change in working capital 12.048 33,043 -21.596 20.095 Inventory 59.398 -540 53.536 4.883 Accounts Payable -53.588 32.249 -33.829 -5.597 Other working capital -221.346 -135.242 12.557 71.557 Other non-cash items 9.986 3,615 2.111 8,301 Net cash provided by operatin... -206,308 -98,798 65.806 115.738 Cash flows from investing activi... Investments in property, plant a... -15,038 -36.444 -53,249 -44,181 Purchases of investments - 1.126 -6,927 -26,082 -2.375 Sales/Maturities of investments 3.812 12,063 27.562 3.409 Net cash used for investing act... -11.399 -29,250 -51.609 -43.073 Cash flows from financing activi. Debt repayment -157.000 -2,000 -40.000 Common stock repurchased 0 -10,000 -10.000 -22.294 -10.566 Dividends Paid -22.501 Other financing activites -1.170 -1.291 312 Net cash used privided by (use... 157.926 48,230 -33.278 -33,426 Net change in cash -60,032 -80,501 -19,081 39,239 Cash at beginning of period 71.109 135.379 154.460 115.221 Cash at end of period 11328 54.878 135,379 154,460 Free Cash Flow Operating Cash Flow -206,308 -98,798 65,806 115.738 Capital Expenditure -15.038 -36.444 -53.249 -44.181 Free Cash Flow -221346 -135.242 12.557 71.557 Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 Total Revenue 1,389.836 1,552.938 1,798,522 1.828.446 Cost of Revenue 1,043.142 1,102.035 1.140.372 1.131.138 Gross Profit 346,694 450.903 658,150 697,308 Operating Expenses Selling General and Administrati. 584,977 587,459 576,878 587.843 Total Operating Expenses 634,960 638,988 630,481 642,446 Operating Income or Loss -288,266 188,085 27,669 54,862 Interest Expense 20.507 15,294 12.362 12,073 Income Before Tax -307,291 -201,379 17,897 45,259 Income Tax Expense 2,730 -2,546 6,271 15.130 Income from Continuing Operations -310,021 -198,833 11,626 30.129 Net Income -310,021 -198,833 11,626 30.129 Net Income available to common s... -310,021 198,833 11.626 30.129 Basic EPS -49.20 2.80 7.40 Diluted EPS -49.20 2.80 7.40 Basic Average Shares 4,035 4,011 4,046 Diluted Average Shares 4,035 4,013 4.049 EBITDA -126,562 91,689 117.836 Liabilities and stockholders' eq.. Liabilities Current Liabilities Accounts Payable 2,672.557 2,644,143 2,488,373 2.230,904 Taxes payable 24,700 154,155 114,203 206,288 Accrued liabilities 909.588 812,666 811,547 772,800 Other Current Liabilities 883,684 770,269 626,086 547,523 Total Current Liabilities 7,150,247 5.531,374 5,125,537 4,757,656 Non-current liabilities Long Term Debt 2,236,625 2.233,616 2.230,607 2.227,599 Deferred taxes liabilities 397,541 393,658 277,810 350.713 Other long-term liabilities 28,743 27,278 33,248 34,140 Total non-current liabilities 11,046,544 3,746,049 3,784,169 3,615,553 Total Liabilities 18,196,791 9,277,423 8.909,706 8,373,209 Stockholders' Equity Common Stock 1,199,100 1,217,183 628,009 646,319 Retained Earnings 5.422,283 4,461,744 4,962,159 4,558,506 Accumulated other comprehe... -673,171 -630,321 -441,859 -694,226 Total stockholders' equity 5.948,212 5.048,606 5.148,309 4,510,599 Total liabilities and stockholde... 24.145,003 14,326,029 14,058,015 12.883,808 20 19 18 7 Balance Sheet All numbers in thousands & Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Assets Current Assets Cash Cash And Cash Equivalents 3.216.752 3,030.229 2.758,477 2.929.849 Other Short Term Investme.. 506,165 543.242 Total Cash 3,216,752 3.030.229 3,264.642 3.473.091 Net Receivables 386,261 346,298 327.166 258,831 Inventory 4,872,592 4,579,033 4.187.243 3,644,959 Total Current Assets 8.890,622 8,469,222 8,485.727 7.750.774 Non-current assets Property, plant and equip... Gross property, plant and e. 20.432.610 10.729.119 9.968,308 9,003,403 Accumulated Depreciation -6,047.230 -5,473,911 -4.962.255 -4,470.509 Net property, plant and e... 14.385,380 5.255.208 5.006.053 4.532.894 Goodwill 95,546 97,552 100.069 195,871 Other long-term assets 761,323 497.580 459,608 398,076 Total non-current assets 15,254,381 5,856,807 5,572.288 5,133,034 Total Assets 24,145,003 14,326,029 14.058,015 12.883,808 Tunce Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 1/31/2020 1/31/2019 1/31/2018 Total Revenue 40,637,855 41,716,977 38,972,934 35,864,664 Cost of Revenue 29,137,615 29.845,780 27,831,177 25,502,167 Gross Profit 11,500,240 11,871,197 11,141,757 10,362,497 Operating Expenses Selling General and Administrati... 7,236,286 7.454,988 6,923,564 6,375,071 Total Operating Expenses 7,236,286 7,454,988 6,923,564 6,375,071 Operating Income or Loss 4,263,954 4,416,209 4,218,193 3,987,426 Interest Expense 61,095 59,086 64,839 64,295 Total Other Income/Expenses Net -36,122 -99,250 Income Before Tax 4,258,486 4,406,183 4,173,211 3,856,588 Income Tax Expense 1,129,545 1,133,990 1,113,413 1,248,640 Income from Continuing Operations 3.128.941 3,272,193 3,059,798 2,607,948 Net Income 3,128,941 3,272,193 3,059,798 2,607,948 Net Income available to common S... 3.128.941 3,272,193 3,059,798 2,607,948 Basic EPS 2.48 2.06 Diluted EPS 2.43 2.02 Basic Average Shares 1,217,183 1,256,018 Diluted Average Shares 1,259,252 1,292,210 EBITDA 5,332,572 5.057,705 4,646,840 ction... Cash Flow Al a nd Get access to 40 years of historical data with Yahoo Finance Premium. Learn more TTM 1/31/2020 1/31/2019 1/31/2013 Cashflows from operating activ Netcome 3.272 193 3.272.193 2.050798 Depreciation amortization 967303 867303 319 SS Deferred income es 6.223 BBEN 137.440 Shadbased compensation 124957 103.557 201362 124957 144059 Cangiwa 15975 42.995 23.532 Inventory 296.541 296.541 4429 450177 29.338 29.338 198.212 20111 Other wong capital 2.841424 2.543,424 62.675 2.963,320 20,414 Other non-cachem 53.675 Net cash provided by operatin.. 4.066540 406540 4.088,459 3.005.624 Cash flows from investing activi Investments in property, planta.. 1.223.116 -1.223,116 - 1,125,139 Acquisitions.net 230,156 230,156 Purchases of investments 28.838 28.838 161,625 861.256 Sales Maurities of investments 12.720 12.720 636 560 906 137 Other investing activites 7,419 7419 26.652 Net cash used for investing act... -1.461,971 -1.461.971 623,552 -1,012,736 Cash flow from financing activ... Debt repayment -7.115 Common stock issued 232.106 232106 13167 255,241 2.406,997 Common stock repurchased 1.551.992 -1.551,992 -1,644,581 Dividends Paid 1.071,562 -1.071,562 972 596 754.040 Other financing activites 23.423 -16.014 1974 Net cash used privided by use... 23.423 2.434,871 186.523 -2,414,71 3.097,481 2.297,346 Net change in cash 196.523 171172 Cachat beginning of period 3.030.229 3.030.229 271752 2.758,477 3.030.229 2009 49 Cachat end of period 3.216,752 326752 Free Cash Flow Cortinho 4.EE 540 4.EE 540 4088,459 3.025.524 Capital Expenditure 1221115 -1.273 115 -1125129 1057 517 Free Cashow 2.843.44 2843,424 2961220 BOOT Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 2/28/2019 2/28/2018 2/28/2017 > Assets 656,290 772,319 843,082 Liabilities and stockholders' eq... Liabilities Current Liabilities Current Debt 2.000 2,000 2.000 Accounts Payable 121,969 71,279 68,981 Taxes payable 302 2.301 26.058 Accrued liabilities 85,811 81,854 106,048 Deferred revenues 37,655 55,281 60,398 Total Current Liabilities 269,465 237,129 291,303 Non-current liabilities Long Term Debt 245,624 197,906 199,077 Deferred revenues 1.933 2,516 3.522 Other long term liabilities 37.923 38,686 35,851 Total non-current liabilities 297.296 257,620 259,751 Total Liabilities 566,761 494,749 551,054 Stockholders' Equity Common Stock 125 125 125 Retained Earnings 534,419 726,232 737,165 Accumulated other comprehe.. -7,861 -7,477 -7,414 Total stockholders' equity 89.529 277.570 292,028 Total liabilities and stockholde... 656,290 772,319 843,082 Cash Flow Alumbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 vCash flows from operating activ... Net Income -310,021 - 198,833 11.626 30.129 Depreciation & amortization 57.499 59.523 61,430 60.504 Deferred income taxes 627 -3.071 6,012 -19.645 Stock based compensation 2.337 2.756 3.809 8.228 Change in working capital 12.048 33,043 -21.596 20.095 Inventory 59.398 -540 53.536 4.883 Accounts Payable -53.588 32.249 -33.829 -5.597 Other working capital -221.346 -135.242 12.557 71.557 Other non-cash items 9.986 3,615 2.111 8,301 Net cash provided by operatin... -206,308 -98,798 65.806 115.738 Cash flows from investing activi... Investments in property, plant a... -15,038 -36.444 -53,249 -44,181 Purchases of investments - 1.126 -6,927 -26,082 -2.375 Sales/Maturities of investments 3.812 12,063 27.562 3.409 Net cash used for investing act... -11.399 -29,250 -51.609 -43.073 Cash flows from financing activi. Debt repayment -157.000 -2,000 -40.000 Common stock repurchased 0 -10,000 -10.000 -22.294 -10.566 Dividends Paid -22.501 Other financing activites -1.170 -1.291 312 Net cash used privided by (use... 157.926 48,230 -33.278 -33,426 Net change in cash -60,032 -80,501 -19,081 39,239 Cash at beginning of period 71.109 135.379 154.460 115.221 Cash at end of period 11328 54.878 135,379 154,460 Free Cash Flow Operating Cash Flow -206,308 -98,798 65,806 115.738 Capital Expenditure -15.038 -36.444 -53.249 -44.181 Free Cash Flow -221346 -135.242 12.557 71.557 Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 Total Revenue 1,389.836 1,552.938 1,798,522 1.828.446 Cost of Revenue 1,043.142 1,102.035 1.140.372 1.131.138 Gross Profit 346,694 450.903 658,150 697,308 Operating Expenses Selling General and Administrati. 584,977 587,459 576,878 587.843 Total Operating Expenses 634,960 638,988 630,481 642,446 Operating Income or Loss -288,266 188,085 27,669 54,862 Interest Expense 20.507 15,294 12.362 12,073 Income Before Tax -307,291 -201,379 17,897 45,259 Income Tax Expense 2,730 -2,546 6,271 15.130 Income from Continuing Operations -310,021 -198,833 11,626 30.129 Net Income -310,021 -198,833 11,626 30.129 Net Income available to common s... -310,021 198,833 11.626 30.129 Basic EPS -49.20 2.80 7.40 Diluted EPS -49.20 2.80 7.40 Basic Average Shares 4,035 4,011 4,046 Diluted Average Shares 4,035 4,013 4.049 EBITDA -126,562 91,689 117.836
