You decide to invest in a 201 day, $4,250,000.00 T-Bill, quoted at 5.16%. You purchase the T-Bill for $

At maturity you will receive

Thereby earning interest of $

The money market yield is %

and the straight yield is %

Can you solve this out on Excel, please?

A B D E F G H J K 82 83 84 85 86 87 You decide to invest in a 201 day, $4,250,000.00 T-Bill, quoted at 5.16%. You purchase the T-Bill for 88 89 $ 90 At maturity you will receive 91 92 thereby earning interest of $ 93 The money market yield is % 94 and the straight yield is % 95 96 97 98 99 100