A Short-Term Ladder: Business-Day Maturities, Interest, Liquidity Buckets & a Chart
This lesson is part of the course
In this lesson
You set the maturity dates of five new placements with EDATE and WORKDAY, compute their interest, sort the current holdings into liquidity buckets with SUMIFS and chart how much cash comes back when.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Day Counts: ACT/360 vs ACT/365, Days Between Dates & the Same Rate on Two Bases Locked
- Discount Paper: Discount Amount, Price from a Discount Rate, the Bid for a Target Yield & the Implied Rate Locked
- Yield Conversions: Discount Rate → Money-Market Yield → Bond-Equivalent Yield Locked
- Term Deposits & Certificates: Interest at Maturity, Effective Annual Yield, Early-Withdrawal Penalties & Rolling Locked
- Repos: Collateral, Haircuts, Repo Interest, the Repurchase Price & an Overnight Roll Locked
- Short-Term Company Paper: Issue Proceeds, Dealer Fees & the All-In Cost of Funds Locked
- Cash-Fund Yields: Daily Income per Unit, Fees, the 7-Day Yield & the Compounded Yield Locked
- A Short-Term Ladder: Business-Day Maturities, Interest, Liquidity Buckets & a Chart Locked