Please

complete

ttached in excel, 5, 7, 9 and 16. Thank you

W 5. Assume that an Investor desires to earn a real rate of return of-7% on a loan. a. If the expected rate of Ination Is 12% per year. what nominal rate of tntcrcst should the investor set on the loan? ' - b. The ltgilstor sets the nominal rate Indicated In part (a). but t rate of Ination was lOSt. What was the actual .real rate 0 earned on the loan for one year? ' he actual l' Interest 7. You are trying to dectde when: to invest $10,000 for one yeatz'l'here are tvim t The other does not. alternatives. One alternattve provides tax-exempt tnteres m? ls 15%.What Inter The rate of interest on the alternative that ls not tax-ext: est rate on the tax-exempt loan would leave you indg'erent to the two alter- natives. ammlng that they are similar In every respect accept taxablllty of Interest. given the following tax rates: '- 10\" b. 60% 9. On a given day. the following ylelds were 'observcd lnxhe nancial markets: ' Yield-to-Maturity 7.55% 8'9 9.38% ., $.15!) . \"a? _ .m 1252.5... . "$338 Badeu n5. 3 antenna. 32. 3.3 353.8 3: 5% 33 a no .a as .n Sn .I \"BE H3 3.36:8 95 a9... 5825 we hiss. E038 gonna: .695 5 525 2a was. as: 58.53 .553. $8? 03.. on. 2 EEKNQS so. 282 2:2; 55. 3830.qu 82 no 3a.. an. L35 3:382 m. \"Gauguin. 8: 3 =5 \"SEESs 2: co \"no.6\": uo 2.: 9:. go: 83. .650 2:. 3825 3505*\". magnum 02353.\" 25 .nuzuno 33 a... 805$? 28 H8 892 32.5 8 833. 938.. 8 5.5 2.. as, .n . two. 26 .5. 5o. 8: .8 .853 333:. .3 SE .3... .25\" 2: an: it; .22 as? .553 .8 BE 1.38 0:. =5 .3 SE 5 3.86:. 3: 35:8: us. an\" .5 .3: 2F .3 . . ~56. on. so .8 3:25 9: 2.6 .3825 Eon sakes you an. 2 5.33 no 0:: usuumnu as\" a .u .6 BE .3. :20 E3\"... .8 21.. Ru. a .50 S 2.8. banana: 5 "=5. wig .m .32 a co