Team Member Guide

  Capstone Spreadsheet Simulation Rules

Finance

To get accurate projections of financial demands, companies should enter all decision data on the other spreadsheets.

Brokers charge a 5% fee for issuing Stock and Bonds.

Brokers charge a 1.5% fee to buy back Stock and retire Bonds early.

The following transactions always occur on the same day (January 1)- paying off debt, issuing Stock, borrowing short term (Current Debt), and borrowing Long Term (Bonds).

If companies buy back bonds prior to maturation they pay street value. If companies allow them to mature they pay the face value.

Bond ratings are a function of total debt (the more companies owe, the lower the rating and the higher the interest).

If companies do not adequately cover their financial needs (either because they failed to raise money or their sales did not go as forecasted) they will take an Emergency Loan. An Emergency Loan is an above-market-rate loan that will cover cash shortfall until the next round, at which time it converts to a short term loan (Current Debt).