publicty trade

profilehelpneeded2016
selectapubliclytradedcompanyandperformacomprehensiv.zip
Home>Business & Finance homework help>Accounting homework help>publicty trade

20191107001222percentage_of_sales_ge_example_only.xlsx

Sheet1

Period Ending 30-Dec-09 30-Dec-10 30-Dec-11 Assumptions Inputs 2012 2013 2014 2015 2016 Sensitivity Analysis EFN12 EFN13 EFN14 EFN15 EFN16
Total Revenue 154,438,000 149,593,000 147,300,000 average of IGR&SGR 1.6%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's historical growth rate from prior years is negative. A negative growth rate is detrimental to the company's longterm survival. This projected growth rate is the mean growth rate of IGR, SGR, HGR and industry average GR. However, a growth rate of 1.6% for GE's future growth is still relatively low because this growth rate may not even cover the expected future inflation rate. GE needs to find better growth opportunities so as to create better shareholder value.		 149,683,844 152,106,268 154,567,895 157,069,360 159,611,307 Receivables 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Cost of Revenue 78,938,000 74,725,000 71,190,000 48% 48% 71,848,245 73,011,009 74,192,589 75,393,293 76,613,428 100% 154579335 156062799 157512067 158925904 160303044
Gross Profit 75,500,000 74,868,000 76,110,000 77,835,599 79,095,259 80,375,305 81,676,067 82,997,880 110% 154579335 156062799 157512067 158925904 160303044
Operating Expenses 120% 154579335 156062799 157512067 158925904 160303044
Research Development - - - 130% 154579335 156062799 157512067 158925904 160303044
Selling General and Administrative 37,354,000 38,054,000 37,384,000 25% 25% 37,420,961 38,026,567 38,641,974 39,267,340 39,902,827 140% 154579335 156062799 157512067 158925904 160303044
Non Recurring 10,585,000 7,176,000 4,083,000 3% 3% 4,490,515 4,563,188 4,637,037 4,712,081 4,788,339 150% 154579335 156062799 157512067 158925904 160303044
Others - - 0 0% 0% - 0 - 0 - 0 - 0 - 0 160% 154579335 156062799 157512067 158925904 160303044
Earnings Before Interest And Taxes 27,561,000 29,638,000 34,643,000 35,924,123 36,505,504 37,096,295 37,696,646 38,306,714 170% 154579335 156062799 157512067 158925904 160303044
Interest Expense 17,697,000 15,553,000 14,545,000 IntR ofDebt 3.5%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's interest rate is estimated from GE's long-term bond yields (see finra.org) 		16,027,527 13,983,263 14,033,987 14,083,472 14,131,672 180% 154579335 156062799 157512067 158925904 160303044
Income Before Tax 9,864,000 14,085,000 20,098,000 19,896,596 22,522,241 23,062,307 23,613,175 24,175,042 190% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Income Tax Expense -1,142,000 1,033,000 5,732,000 35% 35% 6,963,809 7,882,784 8,071,808 8,264,611 8,461,265 200% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Minority Interest -200,000 -535,000 -292,000 -0.2% -0.20% (299,368) (304,213) (309,136) (314,139) (319,223) 210% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Non-recurring Events 0.00% 0% - 0 - 0 - 0 - 0 - 0 220% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Discontinued Operations 219,000 -873,000 77,000 0% 0% - 0 - 0 - 0 - 0 - 0 230% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Extraordinary Items - - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 240% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Effect Of Accounting Changes - - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 250% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Other Items - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 260% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Net Income 11,025,000 11,644,000 14,151,000 12,633,420 14,335,244 14,681,364 15,034,425 15,394,555
Preferred Stock And Other Adjustments -300,000 -300,000 -1,031,000 -0.70% -0.70% (1,047,787) (1,064,744) (1,081,975) (1,099,486) (1,117,279)
Net Income Applicable To Common Shares 10,725,000 11,344,000 13,120,000 11,585,633 13,270,500 13,599,389 13,934,939 14,277,276 Growthrate EFN12 EFN13 EFN14 EFN15 EFN16
Dividend -8,986,000 -4,790,000 -6,458,000 -49% -49% (5,676,960) (6,502,545) (6,663,700) (6,828,120) (6,995,865) 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
RE 1,739,000 6,554,000 6,662,000 5,908,673 6,767,955 6,935,688 7,106,819 7,281,411 0% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
0.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Balance Sheet 1% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Assets 1.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Current Assets 2% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Cash And Cash Equivalents 70,488,000 78,943,000 84,501,000 57.37% plugIf-statement 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 2.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Short Term Investments 51,343,000 43,938,000 47,374,000 32.16% 32.16% 48,140,682 48,919,771 49,711,469 50,515,980 51,333,510 3% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Net Receivables 30,514,000 329,204,000 307,470,000 208.74% 208.74%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's Receivables level is too high. This indicates that GE is not efficient in collecting the payments for its sales. From the Sensitivity Analysis, such a high level of Receivables creates a problem that may cause EFN to rise. Suggestion: Speed up collecting the payments and reduce receivables level to about 30%.		 312,445,971 317,502,472 322,640,805 327,862,295 333,168,287 3.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Inventory 11,987,000 11,526,000 13,792,000 9.36% 9.36% 14,015,204 14,242,021 14,472,508 14,706,725 14,944,733 4% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Other Current Assets - - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 4.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Long Term Investments 319,247,000 - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 5% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Property Plant and Equipment 103,081,000 103,099,000 66,450,000 45.11% 45.11% 67,525,400 68,618,204 69,728,694 70,857,155 72,003,879 5.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Goodwill 65,076,000 64,388,000 72,625,000 Carry forward 72625000 72625000 72625000 72625000 72625000 72625000 6% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Intangible Assets 11,751,000 9,971,000 12,068,000 8.19% 8.19% 12,263,304 12,461,768 12,663,444 12,868,384 13,076,641 6.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Accumulated Amortization - - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 7% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Other Assets 118,414,000 106,724,000 112,962,000 76.69% 76.69% 114,790,132 116,647,849 118,535,632 120,453,965 122,403,344 7.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Deferred Long Term Asset Charges - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 8% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Total Assets 781,901,000 747,793,000 717,242,000 711,805,693 721,017,086 730,377,552 739,889,504 749,555,394 8.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
9% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Liabilities 9.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Current Liabilities 10% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Accounts Payable 32,860,000 56,943,000 58,373,000 %sales 39.63% 59,317,685 60,277,659 61,253,168 62,244,465 63,251,805
Short/Current Long Term Debt 129,869,000 147,977,000 166,869,000 Plug If-Statement 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Other Current Liabilities 50,788,000 67,328,000 59,891,000 carry forward 59,891,000 59,891,000 59,891,000 59,891,000 59,891,000 59,891,000
Long Term Debt 336,172,000 293,323,000 243,459,000 carryforward 243,459,000 243,459,000 243,459,000 243,459,000 243,459,000 243,459,000
Other Liabilities 104,995,000 55,271,000 70,647,000 carryforward 70,647,000 70,647,000 70,647,000 70,647,000 70,647,000 70,647,000
Deferred Long Term Liability Charges 2,081,000 2,753,000 -131,000 carryforward -131,000 -131,000 -131,000 -131,000 -131,000 -131,000
Minority Interest 7,845,000 5,262,000 1,696,000 carryforward 1,696,000 1,696,000 1,696,000 1,696,000 1,696,000 1,696,000
Negative Goodwill - - - carryforward - - - - - -
Total Liabilities 664,610,000 628,857,000 600,804,000 589,459,021 591,902,458 594,327,236 596,732,369 599,116,848
Stockholders' Equity
Misc Stocks Options Warrants - - - carryforward - - - - - -
Redeemable Preferred Stock - - - carryforward - - - - - -
Preferred Stock - - - carryforward - - - - - -
Common Stock 702,000 702,000 702,000 carryforward 702,000 702,000 702,000 702,000 702,000 702,000
Retained Earnings 126,363,000 131,137,000 137,786,000 PriorY+NewRE 137,786,000 143694672.692662 150,462,628 157,398,316 164,505,135 171,786,546
Treasury Stock -32,238,000 -31,938,000 -31,769,000 carryforward -31,769,000 -31,769,000 -31,769,000 -31,769,000 -31,769,000 -31,769,000
Capital Surplus - - - carryforward - - - - - -
Other Stockholder Equity 22,464,000 19,035,000 9,719,000 carryforward 9,719,000 9,719,000 9,719,000 9,719,000 9,719,000 9,719,000
Total Stockholder Equity 117,291,000 118,936,000 116,438,000 122,346,673 129,114,628 136,050,316 143,157,135 150,438,546
Total Liabs&E 781,901,000 747,793,000 717,242,000 711,805,693 721,017,086 730,377,552 739,889,504 749,555,394
b 16.21% 57.78% 50.78% Trial Assets 641,805,693 651,017,086 660,377,552 669,889,504 679,555,394
ROA 1.37% 1.52% 1.83% Trial Liabs&E 557,226,358 564,954,287 572,865,485 580,963,600 589,252,351
ROE 9.14% 9.54% 0.1127 Trial Plug 84,579,335 86,062,799 87,512,067 88,925,904 90,303,044
IGR 0.22% 0.88% 0.9% MinCash 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000
SGR 1.50% 5.83% 6.1% Plug 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
HGR -3.14% -1.5%
Industry GR -2.00% 1.0%
D/E 4.82 4.58 4.37 4.17 3.98

Sheet2

Sheet3

20191107001222percentage_of_sales_ge_example_only (1).xlsx

Sheet1

Period Ending 30-Dec-09 30-Dec-10 30-Dec-11 Assumptions Inputs 2012 2013 2014 2015 2016 Sensitivity Analysis EFN12 EFN13 EFN14 EFN15 EFN16
Total Revenue 154,438,000 149,593,000 147,300,000 average of IGR&SGR 1.6%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's historical growth rate from prior years is negative. A negative growth rate is detrimental to the company's longterm survival. This projected growth rate is the mean growth rate of IGR, SGR, HGR and industry average GR. However, a growth rate of 1.6% for GE's future growth is still relatively low because this growth rate may not even cover the expected future inflation rate. GE needs to find better growth opportunities so as to create better shareholder value.		 149,683,844 152,106,268 154,567,895 157,069,360 159,611,307 Receivables 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Cost of Revenue 78,938,000 74,725,000 71,190,000 48% 48% 71,848,245 73,011,009 74,192,589 75,393,293 76,613,428 100% 154579335 156062799 157512067 158925904 160303044
Gross Profit 75,500,000 74,868,000 76,110,000 77,835,599 79,095,259 80,375,305 81,676,067 82,997,880 110% 154579335 156062799 157512067 158925904 160303044
Operating Expenses 120% 154579335 156062799 157512067 158925904 160303044
Research Development - - - 130% 154579335 156062799 157512067 158925904 160303044
Selling General and Administrative 37,354,000 38,054,000 37,384,000 25% 25% 37,420,961 38,026,567 38,641,974 39,267,340 39,902,827 140% 154579335 156062799 157512067 158925904 160303044
Non Recurring 10,585,000 7,176,000 4,083,000 3% 3% 4,490,515 4,563,188 4,637,037 4,712,081 4,788,339 150% 154579335 156062799 157512067 158925904 160303044
Others - - 0 0% 0% - 0 - 0 - 0 - 0 - 0 160% 154579335 156062799 157512067 158925904 160303044
Earnings Before Interest And Taxes 27,561,000 29,638,000 34,643,000 35,924,123 36,505,504 37,096,295 37,696,646 38,306,714 170% 154579335 156062799 157512067 158925904 160303044
Interest Expense 17,697,000 15,553,000 14,545,000 IntR ofDebt 3.5%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's interest rate is estimated from GE's long-term bond yields (see finra.org) 		16,027,527 13,983,263 14,033,987 14,083,472 14,131,672 180% 154579335 156062799 157512067 158925904 160303044
Income Before Tax 9,864,000 14,085,000 20,098,000 19,896,596 22,522,241 23,062,307 23,613,175 24,175,042 190% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Income Tax Expense -1,142,000 1,033,000 5,732,000 35% 35% 6,963,809 7,882,784 8,071,808 8,264,611 8,461,265 200% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Minority Interest -200,000 -535,000 -292,000 -0.2% -0.20% (299,368) (304,213) (309,136) (314,139) (319,223) 210% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Non-recurring Events 0.00% 0% - 0 - 0 - 0 - 0 - 0 220% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Discontinued Operations 219,000 -873,000 77,000 0% 0% - 0 - 0 - 0 - 0 - 0 230% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Extraordinary Items - - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 240% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Effect Of Accounting Changes - - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 250% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Other Items - 0 0.00% 0% - 0 - 0 - 0 - 0 - 0 260% 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Net Income 11,025,000 11,644,000 14,151,000 12,633,420 14,335,244 14,681,364 15,034,425 15,394,555
Preferred Stock And Other Adjustments -300,000 -300,000 -1,031,000 -0.70% -0.70% (1,047,787) (1,064,744) (1,081,975) (1,099,486) (1,117,279)
Net Income Applicable To Common Shares 10,725,000 11,344,000 13,120,000 11,585,633 13,270,500 13,599,389 13,934,939 14,277,276 Growthrate EFN12 EFN13 EFN14 EFN15 EFN16
Dividend -8,986,000 -4,790,000 -6,458,000 -49% -49% (5,676,960) (6,502,545) (6,663,700) (6,828,120) (6,995,865) 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
RE 1,739,000 6,554,000 6,662,000 5,908,673 6,767,955 6,935,688 7,106,819 7,281,411 0% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
0.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Balance Sheet 1% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Assets 1.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Current Assets 2% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Cash And Cash Equivalents 70,488,000 78,943,000 84,501,000 57.37% plugIf-statement 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 2.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Short Term Investments 51,343,000 43,938,000 47,374,000 32.16% 32.16% 48,140,682 48,919,771 49,711,469 50,515,980 51,333,510 3% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Net Receivables 30,514,000 329,204,000 307,470,000 208.74% 208.74%
Boasson, Vigdis Wangchao: Dr. Boasson: GE's Receivables level is too high. This indicates that GE is not efficient in collecting the payments for its sales. From the Sensitivity Analysis, such a high level of Receivables creates a problem that may cause EFN to rise. Suggestion: Speed up collecting the payments and reduce receivables level to about 30%.		 312,445,971 317,502,472 322,640,805 327,862,295 333,168,287 3.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Inventory 11,987,000 11,526,000 13,792,000 9.36% 9.36% 14,015,204 14,242,021 14,472,508 14,706,725 14,944,733 4% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Other Current Assets - - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 4.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Long Term Investments 319,247,000 - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 5% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Property Plant and Equipment 103,081,000 103,099,000 66,450,000 45.11% 45.11% 67,525,400 68,618,204 69,728,694 70,857,155 72,003,879 5.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Goodwill 65,076,000 64,388,000 72,625,000 Carry forward 72625000 72625000 72625000 72625000 72625000 72625000 6% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Intangible Assets 11,751,000 9,971,000 12,068,000 8.19% 8.19% 12,263,304 12,461,768 12,663,444 12,868,384 13,076,641 6.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Accumulated Amortization - - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 7% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Other Assets 118,414,000 106,724,000 112,962,000 76.69% 76.69% 114,790,132 116,647,849 118,535,632 120,453,965 122,403,344 7.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Deferred Long Term Asset Charges - 0 0.00% 0.00% - 0 - 0 - 0 - 0 - 0 8% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Total Assets 781,901,000 747,793,000 717,242,000 711,805,693 721,017,086 730,377,552 739,889,504 749,555,394 8.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
9% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Liabilities 9.50% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Current Liabilities 10% 154579335.328423 156062799.09247 157512067.481421 158925903.861682 160303043.566252
Accounts Payable 32,860,000 56,943,000 58,373,000 %sales 39.63% 59,317,685 60,277,659 61,253,168 62,244,465 63,251,805
Short/Current Long Term Debt 129,869,000 147,977,000 166,869,000 Plug If-Statement 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
Other Current Liabilities 50,788,000 67,328,000 59,891,000 carry forward 59,891,000 59,891,000 59,891,000 59,891,000 59,891,000 59,891,000
Long Term Debt 336,172,000 293,323,000 243,459,000 carryforward 243,459,000 243,459,000 243,459,000 243,459,000 243,459,000 243,459,000
Other Liabilities 104,995,000 55,271,000 70,647,000 carryforward 70,647,000 70,647,000 70,647,000 70,647,000 70,647,000 70,647,000
Deferred Long Term Liability Charges 2,081,000 2,753,000 -131,000 carryforward -131,000 -131,000 -131,000 -131,000 -131,000 -131,000
Minority Interest 7,845,000 5,262,000 1,696,000 carryforward 1,696,000 1,696,000 1,696,000 1,696,000 1,696,000 1,696,000
Negative Goodwill - - - carryforward - - - - - -
Total Liabilities 664,610,000 628,857,000 600,804,000 589,459,021 591,902,458 594,327,236 596,732,369 599,116,848
Stockholders' Equity
Misc Stocks Options Warrants - - - carryforward - - - - - -
Redeemable Preferred Stock - - - carryforward - - - - - -
Preferred Stock - - - carryforward - - - - - -
Common Stock 702,000 702,000 702,000 carryforward 702,000 702,000 702,000 702,000 702,000 702,000
Retained Earnings 126,363,000 131,137,000 137,786,000 PriorY+NewRE 137,786,000 143694672.692662 150,462,628 157,398,316 164,505,135 171,786,546
Treasury Stock -32,238,000 -31,938,000 -31,769,000 carryforward -31,769,000 -31,769,000 -31,769,000 -31,769,000 -31,769,000 -31,769,000
Capital Surplus - - - carryforward - - - - - -
Other Stockholder Equity 22,464,000 19,035,000 9,719,000 carryforward 9,719,000 9,719,000 9,719,000 9,719,000 9,719,000 9,719,000
Total Stockholder Equity 117,291,000 118,936,000 116,438,000 122,346,673 129,114,628 136,050,316 143,157,135 150,438,546
Total Liabs&E 781,901,000 747,793,000 717,242,000 711,805,693 721,017,086 730,377,552 739,889,504 749,555,394
b 16.21% 57.78% 50.78% Trial Assets 641,805,693 651,017,086 660,377,552 669,889,504 679,555,394
ROA 1.37% 1.52% 1.83% Trial Liabs&E 557,226,358 564,954,287 572,865,485 580,963,600 589,252,351
ROE 9.14% 9.54% 0.1127 Trial Plug 84,579,335 86,062,799 87,512,067 88,925,904 90,303,044
IGR 0.22% 0.88% 0.9% MinCash 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000
SGR 1.50% 5.83% 6.1% Plug 154,579,335 156,062,799 157,512,067 158,925,904 160,303,044
HGR -3.14% -1.5%
Industry GR -2.00% 1.0%
D/E 4.82 4.58 4.37 4.17 3.98

Sheet2

Sheet3

20191107001208wal_mart (1).xlsx

Sheet1

Walmart (WMT)
Income Statment
Breakdown
Period Ending YTTM 1/31/19 1/31/18 1/31/17 1/31/16
Total Revenue 517,989,000 514,405,000 500,343,000 485,873,000 482,130,000
Cost of Revenue 388,980,000 385,301,000 373,396,000 361,256,000 360,984,000
Gross Profit 129,009,000 129,104,000 126,947,000 124,617,000 121,146,000
Operating Expenses
Research Development - - - - -
Selling General and Administrative 107,428,000 107,147,000 106,510,000 101,853,000 97,041,000
Total Operating Expenses 107,428,000 107,147,000 106,510,000 101,853,000 97,041,000
Operating Income or Loss 21,581,000 21,957,000 20,437,000 22,764,000 24,105,000
Interest Expense 2,576,000 2,346,000 2,330,000 2,367,000 2,548,000
Total Other Income/Expenses Net -922,000 -8,368,000 -3,136,000 0 0
Income Before Tax 18,310,000 11,460,000 15,123,000 20,497,000 21,638,000
Income Tax Expense 5,094,000 4,281,000 4,600,000 6,204,000 6,558,000
Income from Continuing Operations 13,216,000 7,179,000 10,523,000 14,293,000 15,080,000
Net Income 12,849,000 6,670,000 9,862,000 13,643,000 14,694,000
Net Income available to common shareholders 12,849,000 6,670,000 9,862,000 13,643,000 14,694,000
Reported EPS
Basic - 2.28 3.29 4.4 4.58
Diluted - 2.26 3.28 4.38 4.57
Weighted average shares outstanding - 2,929,000 2,995,000 3,101,000 3,207,000
Basic
Diluted - 2,945,000 3,010,000 3,112,000 3,217,000
EBITDA - 24,484,000 27,982,000 32,944,000 33,640,000
https://finance.yahoo.com/premium-marketing?ncid=qspfinancials_ahh8df4hjzo