excel formulas for all questions, please.

74. 7. What is the payment in months 37 through 48 ? 75 L.oan Balanee 76 Remaining Loan Term (years) 77 Payments per Year 78 Composite Rate 79 80 81 8. What is the balance at the EOY 4 ? 82 Payment 83 Composite Rate C D Payment 84 Remaining Loan Term (years) 85 Payments per Year 86 87 88 9. What is the payment in months 49 through 60 ? 89 Loan Balance Balance 90 Remaining Loan Term (years) 91 Payments per Year 92 Composite Rate 93 94 95 10. What is the balance at the EOY 5 ? 96 Payment Balance 97 Composite Rate 98 Remaining Loan Term (years) 99 Payments per Year ARM A 137 16. What is the balance at the EOY 8 ? B. C D 138 Payment 139 Composite Rate 140 Remaining Loan Tem (years) 141 Payments per Year 142 143 144 17. What is the payment in months 97 through 108 ? 145 Loan Balance 146 Remaining Loan ferm (years) 147 Payments per Year 148 Composite Rate 149 150 151 18. What is the balance at the EOY 9 ? 152 Payment Payment 153 Composite Rate Balance 154 Remaining Loan Term (years) 155 Payments per Year 156 ider the following information and answer each of the questions below using arithmetic, algebra, and Fxcel functions as aprate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual ifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume llowing forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this I workbook other than entering information needed in the yellow and pink highlighted eells and your answer ealeulation in the i highlighted eells. Only the green highlighted eells will be graded. Do not round intermediate calculations (let Excel store all nal values) 102 11. What is the payment in months 61 through 72 ? 103 Loan Balance 104 Remaining L Lan Term (ycars) D C E F Payment los Payments per Year 106 Composite Rate 107 108 109 12. What is the balance at the EOY 6 ? 110 Payment Balance 111 Composite Rate 112. Remaining Loan Term (years) 113 Payments per Year- 114 115 116 13. What is the payment in menths 73 through 84 ? 117 Loan Balance Payment 118 Remaining Loan Term (yeurs) 119 Paymenis per Year 120 Composite Rate 121 122 123 14. What is the balanee at the EOY 7 ? 124 Payment 125 Composite Rate 126 Remaining Loan Term (years) 127 Pavments ner Year ARM 32 D G II 53 4. What is the balance at the EOY 2 ? 54 Payment Balance 55 Composite Rate 56 Remaining Loan Term (years) 57 Payments per Year 58 59 605 . What is the payment in months 25 through 36 ? 61 Loan Balance Payment 62 Remaining Loan Term (years) 63 Payments per Year 64 Composite Rate 65 66 67 6. What is the balance at the EOY 3? 68 Payment 69 Composite Rate 70 Remaining Loan Term (years) 71 Paymentsper Year 72 73 74. What is the payment in months 37 through 48 ? 75 Ioan Balance 76 Remaining Loan Term (years) 77 Payments per Year Balance ARM A. c. 1) 27. What is the payment in mosths 1 through 122 28 Loan Balanoc 29 I oan Term (yoars) 30 Payments per Year 31 Index 32 Margin 33. Armual cap 34 lifectime cap 75 Teaser 36 Composite Rave $585,000.00 10 Payncis 12 525% 3.00% 2.0056 5,0074 17 1.0056 78 19. 2. What is the balases at the EOY 1? 40 Payment Balance 41 Componite Rate 42 Remaining Loan Term (years) 43 Payments per Year 14. 45 46 3. What is the payment in menths 13 through 24 ? 47 Loan Balance Paymeni 48 Remaining Loan Term (Goars) 49. Payments per Year So Componate Rate 51 19. What is the payment in month 109 through 120% D E Payment 20. What is the yield to the lender if this loan is hell to maturity? ider the following information and answer each of the questions below using arithmetic, algebra, and Fxcel functions as aprate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual ifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume llowing forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this I workbook other than entering information needed in the yellow and pink highlighted eells and your answer ealeulation in the i highlighted eells. Only the green highlighted eells will be graded. Do not round intermediate calculations (let Excel store all nal values) A. c. 1) 27. What is the payment in mosths 1 through 122 28 Loan Balanoc 29 I oan Term (yoars) 30 Payments per Year 31 Index 32 Margin 33. Armual cap 34 lifectime cap 75 Teaser 36 Composite Rave $585,000.00 10 Payncis 12 525% 3.00% 2.0056 5,0074 17 1.0056 78 19. 2. What is the balases at the EOY 1? 40 Payment Balance 41 Componite Rate 42 Remaining Loan Term (years) 43 Payments per Year 14. 45 46 3. What is the payment in menths 13 through 24 ? 47 Loan Balance Paymeni 48 Remaining Loan Term (Goars) 49. Payments per Year So Componate Rate 51 74. 7. What is the payment in months 37 through 48 ? 75 L.oan Balanee 76 Remaining Loan Term (years) 77 Payments per Year 78 Composite Rate 79 80 81 8. What is the balance at the EOY 4 ? 82 Payment 83 Composite Rate C D Payment 84 Remaining Loan Term (years) 85 Payments per Year 86 87 88 9. What is the payment in months 49 through 60 ? 89 Loan Balance Balance 90 Remaining Loan Term (years) 91 Payments per Year 92 Composite Rate 93 94 95 10. What is the balance at the EOY 5 ? 96 Payment Balance 97 Composite Rate 98 Remaining Loan Term (years) 99 Payments per Year ARM 32 D G II 53 4. What is the balance at the EOY 2 ? 54 Payment Balance 55 Composite Rate 56 Remaining Loan Term (years) 57 Payments per Year 58 59 605 . What is the payment in months 25 through 36 ? 61 Loan Balance Payment 62 Remaining Loan Term (years) 63 Payments per Year 64 Composite Rate 65 66 67 6. What is the balance at the EOY 3? 68 Payment 69 Composite Rate 70 Remaining Loan Term (years) 71 Paymentsper Year 72 73 74. What is the payment in months 37 through 48 ? 75 Ioan Balance 76 Remaining Loan Term (years) 77 Payments per Year Balance ARM A 137 16. What is the balance at the EOY 8 ? B. C D 138 Payment 139 Composite Rate 140 Remaining Loan Tem (years) 141 Payments per Year 142 143 144 17. What is the payment in months 97 through 108 ? 145 Loan Balance 146 Remaining Loan ferm (years) 147 Payments per Year 148 Composite Rate 149 150 151 18. What is the balance at the EOY 9 ? 152 Payment Payment 153 Composite Rate Balance 154 Remaining Loan Term (years) 155 Payments per Year 156 19. What is the payment in month 109 through 120% D E Payment 20. What is the yield to the lender if this loan is hell to maturity? 102 11. What is the payment in months 61 through 72 ? 103 Loan Balance 104 Remaining L Lan Term (ycars) D C E F Payment los Payments per Year 106 Composite Rate 107 108 109 12. What is the balance at the EOY 6 ? 110 Payment Balance 111 Composite Rate 112. Remaining Loan Term (years) 113 Payments per Year- 114 115 116 13. What is the payment in menths 73 through 84 ? 117 Loan Balance Payment 118 Remaining Loan Term (yeurs) 119 Paymenis per Year 120 Composite Rate 121 122 123 14. What is the balanee at the EOY 7 ? 124 Payment 125 Composite Rate 126 Remaining Loan Term (years) 127 Pavments ner Year ARM