Term structure in Excel

The goal of this assignment is to become familiar with using Excel to (1) construct a zero- coupon spot curve from an empirical on-the-run (par) curve and (2) price off the zero-coupon curve. The assignment will be graded out of ten (10) points. Important: SHOW YOUR...