A finance calculate case work (excel needed)
zhang1123
case2financials.xlsIS actual
| Premier Paper | |||||
| Income Statements | |||||
| 2013 | 2014 | 2015 | |||
| Net Sales | $ 28,255,000 | $ 37,340,000 | $ 54,670,000 | ||
| Cost of Goods Sold | 16,741,100 | 24,084,300 | 35,672,175 | ||
| Gross profit | 11,513,900 | 13,255,700 | 18,997,825 | ||
| SG&A | 5,580,350 | 8,028,100 | 11,890,725 | ||
| Depreciation | 2,775,000 | 2,915,000 | 3,513,000 | ||
| EBIT | 3,158,550 | 2,312,600 | 3,594,100 | ||
| Interest Expense | 325,000 | 512,000 | 623,000 | ||
| Earnings before taxes | 2,833,550 | 1,800,600 | 2,971,100 | ||
| Taxes (40%) | 1,133,420 | 720,240 | 1,188,440 | ||
| Net income | $ 1,700,130 | $ 1,080,360 | $ 1,782,660 |
BS actual
| Premier Paper | ||||
| Balance Sheets | ||||
| 2013 | 2014 | 2015 | ||
| Assets | ||||
| Cash | $ 856,000 | $ 968,000 | $ 1,225,000 | |
| Accounts receivable | 2,225,000 | 2,525,000 | 3,758,000 | |
| Inventories | 3,850,000 | 4,950,000 | 6,013,000 | |
| Current assets | 6,931,000 | 8,443,000 | 10,996,000 | |
| Gross fixed assets | 18,875,000 | 22,491,000 | 28,996,000 | |
| Accumulated depreciation | (5,000,000) | (7,915,000) | (11,428,000) | |
| Net fixed assets | 13,875,000 | 14,576,000 | 17,568,000 | |
| Total assets | $ 20,806,000 | $ 23,019,000 | $ 28,564,000 | |
| Liabilities & Shareholders' Equity | ||||
| Accounts payable | $ 425,000 | $ 478,000 | $ 518,000 | |
| Accruals | 495,000 | 567,000 | 694,000 | |
| Notes payable | 150,000 | 180,000 | 160,980 | |
| Current liabilities | 1,070,000 | 1,225,000 | 1,372,980 | |
| Long-term debt | 5,250,000 | 6,714,140 | 9,000,000 | |
| Common stock | 11,800,000 | 11,450,000 | 12,950,000 | |
| Retained earnings | 2,686,000 | 3,629,860 | 5,241,020 | |
| Total liabilities & shareholders' equity | $ 20,806,000 | $ 23,019,000 | $ 28,564,000 |
