Excel File Edit View Insert Format Tools Data Window Help 100% DA, Sun 2:30 PM a solomon Titman_Problem 9-1 Start a Search Sheet Home Insert Page Layout Formulas Data Review View 2+ Share Cut |Times New R.. ,: 14 . A-Ar Copy Fill ?? .. Mergn & Center. $. % , +0.0 conditional Format Cell insert Delete tormat Merge & Center% A, Sort & Filter Format Clear E12 old fir z finating rst that was 3? basis periats( 30 perezm over arindex haed an LIBOR ln adlition de la" sdjaed weekly based on the cksing val of te indx for tho previous wck and had a mximuenual rto of 22 pcrcent and a mimimum of L.5 peroent. Calleretheute of interest Ie Weals2 througt 10. Gisea Data: Loen flooting Maximumat Mnimim aie over LIBOR 0.30% Weck 4 Weck 5 Weck & 1.60% Weck Weck 9 Start Excol acell E12 by uing hsolure and relaive cell e, calcue LIBOR plus the spread comeapondingt LBOR in cel. D11. Lve eells E6and D11. Cugy coma ruelE12duwe eoluraeeill E20. (pL ln cell F12, hy ???rg ah olute and relative cell re erences, calcul ne te los, ranc for Week 2 The loan rete i, equal to the LIBOR phus groaditLIBOR in Wock I spocitod in ocll D11 is borwoon the values in cells E nd Es. The value ofcell E must be shown if LIBOR plus the spead in oell E 12 ls above?e mnimm nie. The value ofoell Es mus: be abown ir 3 wher loxcal tert chocks if the value in cell E12 is greater than the vale in col E7 vale A2 tre is the Icserner tn cell FR valve sis the referarca to cell E12 Note gioal nsre andogicas2 cater the expressions deacring the elurionhps berween the cells gtve above Equivalent oams will otbe graded Copy the formala from cell F12 down the colin to cllF2. 6pt) 9-1 Ready 8