Cap Sim Round 6 Excel
Cap Sim Round 6 Excel
Cap Sim Round 6 Excel
Net cash from operations $3,556 $30,358 $12,092 $26,542 $15,149 $18,511
Cash from long term debt issued $0 $40,000 $0 $20,000 $7,000 $14,000
Net cash from financing activities $0 $4,203 ($22,847) $8,234 $7,000 $10,500
Net change in cash position ($5,444) $10,361 $14,255 $586 ($251) $26,611
Variable Costs (Labor, Material, Carry) $98,370 $68,411 $73,221 $80,230 $97,159 $107,240
SGA (R&D, Promo, Sales, Admin) $12,868 $26,945 $7,913 $24,880 $26,558 $24,141
Other (Fees, Writeoffs, TQM, Bonuses) $0 $20,330 ($10,637) $17,782 $350 $3,700
Interest (Short term, Long term) $4,188 $3,180 $4,851 $6,991 $6,549 $3,640