File Home Insert Draw Page Layout Home Formulas Data Review View Help B Share Comments X Insert Calibri 12 ' ' General 28 o !!! | DX Delete Paste B I U Analyze Sensitivity ..... A V $ - %. O o Conditional Format as Formatting Table Cell Styles Format Sort & Find & Filter Select V Data Clipboard Font Is Alignment Number Styles Cells Editing Analysis Sensitivity E14 fi A D E F I J K L M 1 B Single Payment Yield Par Value/Face Value (pf) Purchase Price (PO) Number of days until maturity (n) 1000 900 4 365 7 Single Payment Yield (isp) Discount Yield (id) EAR Nm to 00 of 2 0.11 ((C2-C3)/C3)*(360/C4). 0.09863014 ((C2-C3)/C2)*(360/C4) 0.11111111 (1+C6*((365/360)/(365/C4))^(365/C4)-1 Discount Yield SPY EAR 12 13 14 15 16 17 Discount Yield compared to SPY using EAR Build an excel spreadsheet to convert money market yields Each calculator should have a clearly labeled input section and output section. There should be a note regarding how to use the calculator Money Market Calculators Convert SPY to DY and EAR Convert DY to SPY and EAR Compare DY to SPY using EAR This announcement is closed for comments