Final Project for Capsim simulation
Financial Historical Summaries for Andrews
Cash Flow Statement (in thousands)
Rd 1 | Rd 2 | Rd 3 | Rd 4 | Rd 5 | Rd 6 | Rd 7 | Rd 8 | |
Net Income | 2,234 | 1,077 | - 14,922 | - 23,594 | - 59,022 | - 27,659 | - 33,133 | - 45,679 |
Depreciation | 1,080 | 1,080 | 1,524 | 1,924 | 2,057 | 2,057 | 2,057 | 2,057 |
Gain Loss Write offs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | - 123 | 2,122 | 1,072 | - 558 | - 2,656 | - 2,712 | 0 | 2,831 |
Inventory | - 2,673 | 4,908 | - 35,355 | - 31,708 | - 31,353 | 25,538 | 0 | - 28,879 |
Accounts Receivable | - 42 | - 4,585 | 7,749 | - 101 | 32 | - 2,977 | 3,277 | - 700 |
Cash Flow From Operations | 476 | 4,602 | - 39,933 | - 54,036 | - 90,942 | - 5,752 | - 27,799 | - 70,369 |
Plant Improvements | - 1,800 | 0 | - 6,660 | - 6,000 | - 2,000 | 0 | 0 | 0 |
Dividends | - 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Stock Issue | 50 | 500 | 1,000 | 414 | 476 | 571 | 686 | 823 |
Stock Retire | - 50 | - 100 | - 500 | - 104 | 0 | 0 | 0 | 0 |
Long Term Debt Issue | 2,480 | 0 | 579 | 5,842 | 3,261 | 2,554 | 0 | 0 |
Long Term Debt Retire | 0 | - 867 | 0 | - 1,733 | 0 | - 2,600 | 0 | 0 |
Change In Current Debt | 0 | 867 | 34,253 | 55,617 | 89,205 | 5,227 | 27,113 | 69,546 |
Cash From Financing | 1,980 | 400 | 35,332 | 60,036 | 92,942 | 5,752 | 27,799 | 70,369 |
Change In Cash | 656 | 5,002 | - 11,260 | 0 | 0 | 0 | 0 | 0 |
Closing Cash | 6,258 | 11,260 | 0 | 0 | 0 | 0 | 0 | 0 |
Balance Sheet (in thousands)
Rd 1 | Rd 2 | Rd 3 | Rd 4 | Rd 5 | Rd 6 | Rd 7 | Rd 8 | |
Cash | 6,258 | 11,260 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Receivable | 3,395 | 7,980 | 232 | 333 | 300 | 3,277 | 0 | 700 |
Inventory | 5,025 | 118 | 35,472 | 67,180 | 98,533 | 72,995 | 72,995 | 101,874 |
Total Current Assets | 14,679 | 19,358 | 35,704 | 67,512 | 98,833 | 76,272 | 72,995 | 102,574 |
Plant & Equipment | 16,200 | 16,200 | 22,860 | 28,860 | 30,860 | 30,860 | 30,860 | 30,860 |
Accumulated Depreciation | - 5,880 | - 6,960 | - 8,484 | - 10,408 | - 12,465 | - 14,523 | - 16,580 | - 18,637 |
Total Fixed assets | 10,320 | 9,240 | 14,376 | 18,452 | 18,395 | 16,337 | 14,280 | 12,223 |
Total Assets | 24,999 | 28,598 | 50,080 | 85,964 | 117,228 | 92,609 | 87,275 | 114,797 |
Accounts Payable | 2,731 | 4,853 | 5,925 | 5,367 | 2,712 | 0 | 0 | 2,831 |
Current Debt | 0 | 867 | 35,120 | 90,737 | 179,942 | 185,169 | 212,282 | 281,828 |
Long Debt | 7,680 | 6,813 | 7,392 | 11,501 | 14,762 | 14,716 | 14,716 | 14,716 |
Total Liabilities | 10,411 | 12,533 | 48,437 | 107,605 | 197,415 | 199,885 | 226,998 | 299,375 |
Common Stock | 2,364 | 2,845 | 3,732 | 3,938 | 4,414 | 4,985 | 5,670 | 6,493 |
Retained Earnings | 12,224 | 13,220 | - 2,090 | - 25,578 | - 84,601 | - 112,260 | - 145,393 | - 191,072 |
Total Equity | 14,588 | 16,065 | 1,642 | - 21,641 | - 80,187 | - 107,275 | - 139,723 | - 184,579 |
Total Liab And Equity | 24,999 | 28,598 | 50,080 | 85,964 | 117,228 | 92,609 | 87,275 | 114,797 |
Income Statement (in thousands)
Rd 1 | Rd 2 | Rd 3 | Rd 4 | Rd 5 | Rd 6 | Rd 7 | Rd 8 | |
Sales | 41,310 | 48,548 | 1,410 | 2,024 | 3,653 | 39,872 | 0 | 8,513 |
Direct Labor | 12,475 | 15,870 | 355 | 475 | 778 | 12,137 | 0 | 2,862 |
Direct Material | 18,077 | 18,562 | 335 | 468 | 859 | 13,401 | 0 | 2,702 |
Inventory Carry | 603 | 14 | 4,257 | 8,062 | 11,824 | 8,759 | 8,759 | 12,225 |
Total Variable Cost | 31,155 | 34,447 | 4,946 | 9,004 | 13,462 | 34,297 | 8,759 | 17,789 |
Contribution Margin | 10,154 | 14,101 | - 3,536 | - 6,981 | - 9,809 | 5,575 | - 8,759 | - 9,275 |
Depreciation | 1,080 | 1,080 | 1,524 | 1,924 | 2,057 | 2,057 | 2,057 | 2,057 |
R and D | 1,904 | 234 | 1,249 | 2,861 | 2,743 | 458 | 192 | 0 |
Promo | 1,000 | 4,500 | 5,000 | 2,600 | 11,500 | 2,700 | 0 | 400 |
Sales Budget | 1,000 | 4,500 | 5,000 | 3,900 | 11,500 | 2,700 | 0 | 400 |
Admin | 647 | 1,198 | 1,002 | 772 | 675 | 1,464 | 0 | 2,689 |
Total Period Costs | 5,630 | 11,513 | 13,775 | 12,057 | 28,475 | 9,380 | 2,250 | 5,546 |
Net Margin | 4,524 | 2,588 | - 17,311 | - 19,038 | - 38,284 | - 3,805 | - 11,009 | - 14,822 |
Other | 127 | 27 | 86 | 314 | 19,687 | 5,156 | 1,534 | 5,041 |
EBIT | 4,397 | 2,562 | - 17,398 | - 19,352 | - 57,971 | - 8,961 | - 12,543 | - 19,863 |
Interest Short Term Debt | 0 | 77 | 4,704 | 15,522 | 30,975 | 31,732 | 36,571 | 48,552 |
Interest Long Term Debt | 889 | 794 | 855 | 1,424 | 1,858 | 1,860 | 1,860 | 1,860 |
Taxes | 1,228 | 592 | - 8,035 | - 12,704 | - 31,781 | - 14,893 | - 17,841 | - 24,596 |
Profit Sharing | 46 | 22 | 0 | 0 | 0 | 0 | 0 | 0 |
Net Profit | 2,234 | 1,077 | - 14,922 | - 23,594 | - 59,022 | - 27,659 | - 33,133 | - 45,679 |