The Projected financial statements should be done in Excel and included with your submission. *You will need to make necessary adjustments for material non-recurring or unusual income or expenses as well as off-balance sheet assets or liabilities, among others as covered in the course. The adjustment will improve comparability and ensure accurate representation of the organization's economic performance. Be sure to identify important assumptions regarding the companies, industry and business environment, and other important assumptions for estimates and forecasts, including their business strategies. Show calculations please of the projected financial Statements for TJ MAXX
Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Assets Current Assets > 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... 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 Liabilities and stockholders' eq... Liabilities > 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 Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Total Revenue 41,716,977 38,972,934 35,864,664 33,183,744 Cost of Revenue 29,845,780 27,831,177 25,502,167 23,565,754 Gross Profit 11,871,197 11,141,757 10,362,497 9,617,990 Operating Expenses Selling General and Administrati... 7,454,988 6,923,564 6,375,071 5,768,467 Total Operating Expenses 7,454,988 6,923,564 6,375,071 5,768,467 Operating Income or Loss 4,416,209 4,218,193 3,987,426 3,849,523 Interest Expense 59,086 64,839 64,295 61,671 Total Other Income/Expenses Net -36,122 -99,250 -82,946 Income Before Tax 4,406,183 4,173.211 3,856,588 3,723,043 Income Tax Expense 1,133,990 1,113,413 1,248,640 1,424,809 Income from Continuing Operations 3,272,193 3,059,798 2,607,948 2,298,234 Net Income 3,272,193 3,059,798 2,607,948 2,298,234 Net Income available to common s... 3,272,193 3,059.798 2,607,948 2,298,234 Basic EPS 2.48 2.06 1.78 Diluted EPS 2.43 2.02 1.73 Basic Average Shares 1,217,183 1,256,018 1,292,638 Diluted Average Shares 1,259,252 1,292,210 1,328,864 EBITDA 5,332,572 5,057,705 4,646,840 4,443,510 Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Assets Current Assets > 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... 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 Liabilities and stockholders' eq... Liabilities > 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 Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Total Revenue 41,716,977 38,972,934 35,864,664 33,183,744 Cost of Revenue 29,845,780 27,831,177 25,502,167 23,565,754 Gross Profit 11,871,197 11,141,757 10,362,497 9,617,990 Operating Expenses Selling General and Administrati... 7,454,988 6,923,564 6,375,071 5,768,467 Total Operating Expenses 7,454,988 6,923,564 6,375,071 5,768,467 Operating Income or Loss 4,416,209 4,218,193 3,987,426 3,849,523 Interest Expense 59,086 64,839 64,295 61,671 Total Other Income/Expenses Net -36,122 -99,250 -82,946 Income Before Tax 4,406,183 4,173.211 3,856,588 3,723,043 Income Tax Expense 1,133,990 1,113,413 1,248,640 1,424,809 Income from Continuing Operations 3,272,193 3,059,798 2,607,948 2,298,234 Net Income 3,272,193 3,059,798 2,607,948 2,298,234 Net Income available to common s... 3,272,193 3,059.798 2,607,948 2,298,234 Basic EPS 2.48 2.06 1.78 Diluted EPS 2.43 2.02 1.73 Basic Average Shares 1,217,183 1,256,018 1,292,638 Diluted Average Shares 1,259,252 1,292,210 1,328,864 EBITDA 5,332,572 5,057,705 4,646,840 4,443,510
