5 Calculating annuity values - Excel FORMULAS DATA REVIEW VIEW Sign FILE HOME INSERT PAGE LAYOUT % Calibri Cells Editing Paste BIU- Cell A Alignment Number Conditional Format as Formatting Table Styles - Styles pboard Font A1 So B D E F G H 1 2 3 Dinero Bank offers you a five-year loan for $50,000 at an annual interest rate of 7.5 percent. What will your annual loan payment be? 4 5 6 $ 7 8 Loan amount Number of years Interest rate 50,000 5 7.50% 9 10 11 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. 12 13 Loan payment 14 15 16 17 Sheet1 READY Attempt o