SweetStudy (HomeworkMarket.com)

0

CAPSIM ASSIGNMENT

baldwin-financial_historical_summary_all_rounds.docx

Home >Business & Finance homework help >Operations Management homework help >CAPSIM ASSIGNMENT

Financial Historical Summary for Baldwin

Cash Flow Statement (in thousands) (Baldwin)

	Rd 1	Rd 2	Rd 3	Rd 4	Rd 5
Net Income	1,777	1,350	7,284	8,724	10,817
Depreciation	1,200	1,992	2,712	4,272	5,468
Gain Loss Write offs	15	0	0	0	1,180
Accounts Payable	322	339	2,740	1,393	- 524
Inventory	2,352	- 0	- 11,323	- 7,880	14,493
Accounts Receivable	- 93	- 345	- 2,756	- 1,979	- 1,364
Cash Flow From Operations	5,573	3,337	- 1,343	4,530	30,071
Plant Improvements	- 6,932	- 12,752	- 17,400	- 12,600	- 26,195
Dividends	0	0	0	- 7,231	0
Stock Issue	4,000	6,000	6,000	7,000	14,000
Stock Retire	0	0	0	- 1,000	- 2,000
Long Term Debt Issue	0	0	7,500	0	2,000
Long Term Debt Retire	- 867	- 14	0	- 1,733	0
Change In Current Debt	0	4,014	986	7,331	- 4,331
Cash From Financing	3,133	10,000	14,486	4,366	9,669
Change In Cash	1,774	585	- 4,257	- 3,703	13,545
Closing Cash	7,376	7,961	3,703	0	13,545

Financial Historical Summary for Baldwin

Balance Sheet (in thousands) (Baldwin)

	Rd 1	Rd 2	Rd 3	Rd 4	Rd 5
Cash	7,376	7,961	3,703	0	13,545
Accounts Receivable	3,446	3,791	6,547	8,526	9,890
Inventory	0	0	11,323	19,202	4,709
Total Current Assets	10,822	11,752	21,573	27,728	28,144
Plant & Equipment	21,332	34,084	51,484	64,084	87,526
Accumulated Depreciation	- 6,000	- 7,992	- 10,705	- 14,977	- 18,872
Total Fixed Assets	15,332	26,092	40,779	49,107	68,654
Total Assets	26,154	37,843	62,352	76,835	96,798
Accounts Payable	3,176	3,515	6,255	7,647	7,124
Current Debt	0	4,014	5,000	12,331	8,000
Long Debt	4,348	4,333	11,833	10,100	12,100
Total Liabilities	7,523	11,863	23,088	30,078	27,224
Common Stock	6,323	12,323	18,323	24,776	37,499
Retained Earnings	12,308	13,657	20,941	21,981	32,075
Total Equity	18,631	25,981	39,264	46,757	69,574
Total Liab & Equity	26,154	37,843	62,352	76,835	96,798

Financial Historical Summary for Baldwin

Income Statement (in thousands) (Baldwin)

	Rd 1	Rd 2	Rd 3	Rd 4	Rd 5
Sales	50,318	55,350	95,587	124,481	144,392
Direct Labor	17,142	18,754	28,740	39,360	49,462
Direct Material	23,847	24,013	36,038	45,803	51,704
Inventory Carry	0	0	1,359	2,304	565
Total Variable Cost	40,990	42,767	66,137	87,468	101,731
Contribution Margin	9,329	12,583	29,450	37,013	42,661
ISDepreciation	1,200	1,992	2,712	4,272	5,468
R & D	1,040	1,709	1,638	1,171	1,784
Promo	1,200	2,200	4,450	5,800	5,600
Sales Budget	1,500	2,500	5,200	7,100	6,600
Admin	824	907	1,702	2,079	2,284
Total Period Costs	5,764	9,309	15,702	20,422	21,736
Net Margin	3,565	3,274	13,748	16,591	20,925
Other	228	300	675	365	2,010
EBIT	3,337	2,974	13,073	16,226	18,915
Interest Short Term Debt	0	309	395	1,495	696
Interest Long Term Debt	548	546	1,243	1,036	1,238
Taxes	976	742	4,002	4,793	5,943
Profit Sharing	36	28	149	178	221
Net Profit	1,777	1,350	7,284	8,724	10,817