can you help me inputing the exact inputs into excel, I Know the hardcode formula but not how to exactly input in execl. The probelm in excel is modifed from the book. Thank you

5-35. (Calculating an EAR) (Related to Checkpoint 5.7 on page 147) After examining the various personal loan rates available to you, you find that you can borrow funds from a finance company at 12 percent compounded monthly or from a bank at 13 percent compounded annually. Which alternative is the more attractive? A B C F G H M 1 2 3 P5-35 Modified (also include a choice of borrowing at 12.25% compounded semiannually) After examining the various personal loan rates available to you, you find that you can borrow funds from a finance company at 12 percent compounded monthly or from a bank compounded annually. Also, include a choice of borrowing at 12.25% compounded semiannually. Which alternative is more attractive? Hint: to solve for EAR you can use either equation 5-4 on page 146 or the Excel EFFECT formula 1 m EAR 1 4 S 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 m EAR 0 m EAR