Module 5: Portfolio Milestone
Balance Sheet 12/31/1812/31/1712/31/1612/31/15 Current Assets Cash And Cash Equivalents8,719,00010,607,0009,157,0009,095,000 Short Term Investments270,0008,897,0006,966,0002,912,000 Net Receivables7,140,0007,021,0006,693,0006,436,000 Inventory3,126,0002,944,0002,722,0002,719,000 Other Current Assets2,042,00043,00031,000730,000 Total Current Assets21,297,00029,512,00025,569,00021,892,000 Long Term Investments2,407,0002,039,0001,949,0002,310,000 Property Plant and Equipment17,587,00017,237,00016,590,00016,316,000 Goodwill14,806,00014,741,00014,429,00014,176,000 Intangible Assets15,823,00013,835,00013,432,00013,080,000 Other Assets5,122,000910,000635,000749,000 Total Assets77,042,00078,274,00072,604,00068,523,000 Current Liabilities Accounts Payable7,211,0006,724,0006,157,0005,545,000 Short/Current Long Term Debt3,951,0004,017,0004,400,0003,108,000 Other Current Liabilities6,601,0004,112,0003,870,0003,882,000 Total Current Liabilities17,763,00014,853,00014,427,00012,535,000 Long Term Debt28,293,00033,793,00030,052,00029,591,000 Other Liabilities12,611,00014,522,00011,102,00010,466,000 Total Liabilities58,667,00063,168,00055,581,00052,592,000 Stockholders' Equity Total Stockholder Equity18,375,00015,106,00017,023,00015,931,000 Income Statement 12/31/1812/31/1712/31/1612/31/15 Revenue Total Revenue51,728,00057,902,00056,519,10056,488,000 Cost of Revenue23,502,00025,340,00025,399,80025,283,000 Gross Profit28,226,00032,562,00031,119,30031,205,000 Operating Expenses Selling General and Administrative19,184,00020,706,00021,225,60020,736,000 Operating Income or Loss9,042,00011,856,0009,893,70010,469,000 Income from Continuing Operations Other Income/Expenses Net-1,148,000-1,507,000-1,508,400-2,256,000 Interest Expense1,220,0001,288,0001,207,800853,000 Income Before Tax6,674,0009,061,0007,177,5007,360,000 Income Tax Expense2,696,0004,130,0001,956,6001,708,000 Net Income3,978,0004,931,0005,220,9005,652,000 Projects Year 0Year 1Year 2Year 3Year 4 Project A-100,00050,00030,00030,00020,000 Project B-250,000100,000100,00050,00050,000 Project C-500,000400,00050,00050,00050,000