Are you able to complete this assignment; spreadsheet attached.
Short-term debt:
– Bank loans: 1-3%
– Commercial paper (CP): 0.5-2.0%
– Treasury bills (T-bills): 0.1-1.5%
Long-term debt:
– Bonds: 1-10%
Equity:
– Preferred shares: 5-15%
– Common stocks/shares: 8%-12%.