I had played CAPSIM as a team, and we placed 4th out of 5 teams. At the end of the round 8, the stock price was $27.83 which is very low. So I want to find out what was wrong with finance. I attached the financial summaries of all 8 rounds, so please let me know what was the problem with financial decisions.
Balance Sheet (in thousands) Rd 4. Rd 1 8,047 4,084 Rd 3 7,123 5,670 Rd 7 11,623 4,817 Rd 8 13,140 4,970 891 385 Cash Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed assets Total Assets Accounts Payable Current Debt Long Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liab And Equity Rd 2 0 4,769 9,451 14,219 32,800 - 8,127 24,673 38,893 4,029 6,453 6,333 16,815 13,178 36,000 - 10,527 25,473 38,651 2,677 Rd 5 8,412 5,302 6,576 20,289 55,200 - 17,607 37,593 57,883 3,054 5,642 7,115 12,758 51,000 - 13,927 37,073 49,831 3,654 4,292 9,100 17,047 14,323 18,461 32,785 49,831 13,022 21,300 -5,940 15,360 28,382 2,933 2,500 5,200 10,633 4,323 13,425 17,749 28,382 Rd 6 6,135 4,130 5,957 16,222 55,400 - 19,079 36,321 52,543 1,295 191 9,500 10,986 17,989 23,568 41,557 52,543 16,440 59,400 - 23,039 36,361 52,801 1,193 18,111 59,400 - 26,999 32,401 50,512 1,369 0 0 8,833 11,510 9,323 17,818 27,141 38,651 12,100 15,154 19,323 23,406 42,729 57,883 7,141 8,334 16,771 27,696 44,467 52,801 7,141 8,511 15,545 26,456 42,001 50,512 14,254 22,077 38,893 Cash Flow Statement in thousands) Rd 2 828 2,187 Rd 3 3,564 2,400 Rd 4 644 3,400 Rd 5 4,944 3,680 Rd 8 6,356 3,960 0 141 Rd 1 2,895 1,140 0 80 1,461 - 730 4,846 - 6,900 - 1,352 9,065 - 901 12,776 - 3,200 977 -6,730 27 - 1,681 - 15,000 - 601 539 341 8,904 - 4,200 Net Income Depreciation Gain Loss Write offs Accounts Payable Inventory Accounts Receivable Cash Flow From Operations Plant Improvements Dividends Stock Issue Stock Retire Long Term Debt Issue Long Term Debt Retire Change In Current Debt Cash From Financing Change In Cash Closing Cash 177 0 - 153 10,339 Rd 7 5,724 3,960 141 -102 5,957 - 687 14,993 -4,0000 0 Rd 6 1,779 3,693 - 170 - 1,759 619 1,172 5,333 - 2,160 0 0 -2,950 0 -2,691 191 -5,450 -2,277 6,135 - 5,572 1,096 - 8,560 - 685 -5,134 - 11,500 O 3,500 0 2,000 - 867 3,953 8,587 - 8,047 1,500 2,000 0 0 5,000 5,000 0 3,000 -3,250 0 2,500 0 2,500 4,500 2,446 8,047 - 6,453 - 2,453 7,123 7,123 2,000 - 1,733 4,292 9,559 - 7,123 - 4,292 3,708 8,412 8,412 -2,814 0 -2,5000 - 1910 -5,505 5,487 11,623 -8,822 1,518 13,140 Balance Sheet (in thousands) Rd 4. Rd 1 8,047 4,084 Rd 3 7,123 5,670 Rd 7 11,623 4,817 Rd 8 13,140 4,970 891 385 Cash Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Total Fixed assets Total Assets Accounts Payable Current Debt Long Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liab And Equity Rd 2 0 4,769 9,451 14,219 32,800 - 8,127 24,673 38,893 4,029 6,453 6,333 16,815 13,178 36,000 - 10,527 25,473 38,651 2,677 Rd 5 8,412 5,302 6,576 20,289 55,200 - 17,607 37,593 57,883 3,054 5,642 7,115 12,758 51,000 - 13,927 37,073 49,831 3,654 4,292 9,100 17,047 14,323 18,461 32,785 49,831 13,022 21,300 -5,940 15,360 28,382 2,933 2,500 5,200 10,633 4,323 13,425 17,749 28,382 Rd 6 6,135 4,130 5,957 16,222 55,400 - 19,079 36,321 52,543 1,295 191 9,500 10,986 17,989 23,568 41,557 52,543 16,440 59,400 - 23,039 36,361 52,801 1,193 18,111 59,400 - 26,999 32,401 50,512 1,369 0 0 8,833 11,510 9,323 17,818 27,141 38,651 12,100 15,154 19,323 23,406 42,729 57,883 7,141 8,334 16,771 27,696 44,467 52,801 7,141 8,511 15,545 26,456 42,001 50,512 14,254 22,077 38,893 Cash Flow Statement in thousands) Rd 2 828 2,187 Rd 3 3,564 2,400 Rd 4 644 3,400 Rd 5 4,944 3,680 Rd 8 6,356 3,960 0 141 Rd 1 2,895 1,140 0 80 1,461 - 730 4,846 - 6,900 - 1,352 9,065 - 901 12,776 - 3,200 977 -6,730 27 - 1,681 - 15,000 - 601 539 341 8,904 - 4,200 Net Income Depreciation Gain Loss Write offs Accounts Payable Inventory Accounts Receivable Cash Flow From Operations Plant Improvements Dividends Stock Issue Stock Retire Long Term Debt Issue Long Term Debt Retire Change In Current Debt Cash From Financing Change In Cash Closing Cash 177 0 - 153 10,339 Rd 7 5,724 3,960 141 -102 5,957 - 687 14,993 -4,0000 0 Rd 6 1,779 3,693 - 170 - 1,759 619 1,172 5,333 - 2,160 0 0 -2,950 0 -2,691 191 -5,450 -2,277 6,135 - 5,572 1,096 - 8,560 - 685 -5,134 - 11,500 O 3,500 0 2,000 - 867 3,953 8,587 - 8,047 1,500 2,000 0 0 5,000 5,000 0 3,000 -3,250 0 2,500 0 2,500 4,500 2,446 8,047 - 6,453 - 2,453 7,123 7,123 2,000 - 1,733 4,292 9,559 - 7,123 - 4,292 3,708 8,412 8,412 -2,814 0 -2,5000 - 1910 -5,505 5,487 11,623 -8,822 1,518 13,140
