A B. c D 138 Payment 139 Composite Rate Balance 140 Remaining Loan Term (ycars) 141 Payments per Year 142 143 144 17. What is the payment in months 97 through 108 ? 145 I.oan 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 154 Remaining Loan Term (years) 155 Payments per Year 156 58 19. What is the payment in months 109 through 120 ? 59 Loan Balaner Payment 20. What is the yicld to the lender if this loan is beld to maturity? 74 7. What is the payment in months 37 through 48 ? 75 Loan Balance 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 889 . 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 102 11. What is the payment in months 61 through 72 ? 103 Loan Balance D 104 Remaining Loan Term (years) Payment 105 Payments per Yeat 106 Composite Rate 107 108 109 12. What is the balance at the EOY 6 ? 110 Payment 111 Composite Rate 112. Remaining Loan Term (years) 113 Payments per Year 114 115 11613 . What is the payment in menths 73 through 84 ? 117 Loan Balance Payment 118 Remaining Loan Term (yeurs) 119 Payments per Year 120 Composite Rate 121 122 123 14. What is the balanee at the EOY 7 ? 124 Payment Balance F. G H CDEFGHI 125 Composite Rate 126 Remaining Loan Term (years) 127 Pavments ner Year ARM ider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as sprate. Larz is considering an ARM loan offered by a local kender. 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 caleulation in the i highlighted eells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all nal values) A B. c D 138 Payment 139 Composite Rate Balance 140 Remaining Loan Term (ycars) 141 Payments per Year 142 143 144 17. What is the payment in months 97 through 108 ? 145 I.oan 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 154 Remaining Loan Term (years) 155 Payments per Year 156 58 19. What is the payment in months 109 through 120 ? 59 Loan Balaner Payment 20. What is the yicld to the lender if this loan is beld to maturity? 74 7. What is the payment in months 37 through 48 ? 75 Loan Balance 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 889 . 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 102 11. What is the payment in months 61 through 72 ? 103 Loan Balance D 104 Remaining Loan Term (years) Payment 105 Payments per Yeat 106 Composite Rate 107 108 109 12. What is the balance at the EOY 6 ? 110 Payment 111 Composite Rate 112. Remaining Loan Term (years) 113 Payments per Year 114 115 11613 . What is the payment in menths 73 through 84 ? 117 Loan Balance Payment 118 Remaining Loan Term (yeurs) 119 Payments per Year 120 Composite Rate 121 122 123 14. What is the balanee at the EOY 7 ? 124 Payment Balance F. G H CDEFGHI 125 Composite Rate 126 Remaining Loan Term (years) 127 Pavments ner Year ARM ider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as sprate. Larz is considering an ARM loan offered by a local kender. 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 caleulation in the i highlighted eells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all nal values)