can you help somve these ARM excel plss??? any help is appreciated

9. What is the payment in months 49 through 60 ? Loan Balance Remaining Loan Term (years) Payments per Year Composite Rate 11. What is the payment in months 61 through 72 ? 3 Loan Balance 04 Remaining Loan Term (years) 05 Payments per Year 06 Composite Rate 12. What is the balance at the EOY 6 ? 12. What Payment Balance Payments per Year 11 Composite Rate 12 Remaining Loan Term (years) 113 Payments per Year 117 Loan Balance \begin{tabular}{l|l} 118 & Remaining Loan Term (years) \\ 119 & Payments per Year \\ 120 & Composite Rate \\ 121 & \\ 122 & \\ 123 & 14 . What is the balance at th \\ 124 & Payment \\ 125 & Composite Rate \\ 126 & Remaining Loan Term (years) \end{tabular} 127 Payments per Year 128 129 130 15. What is the payment in months 85 through 96 ? 131 Loan Balance 132 Remaining Loan Term (years) 133 Payments per Year 134 Composite Rate Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 years. The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume the following forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this Excel workbook other than entering information needed in the yellow and pink highlighted cells and your answer calculation in the green highlighted cells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all decimal values) 9. What is the payment in months 49 through 60 ? Loan Balance Remaining Loan Term (years) Payments per Year Composite Rate 11. What is the payment in months 61 through 72 ? 3 Loan Balance 04 Remaining Loan Term (years) 05 Payments per Year 06 Composite Rate 12. What is the balance at the EOY 6 ? 12. What Payment Balance Payments per Year 11 Composite Rate 12 Remaining Loan Term (years) 113 Payments per Year 117 Loan Balance \begin{tabular}{l|l} 118 & Remaining Loan Term (years) \\ 119 & Payments per Year \\ 120 & Composite Rate \\ 121 & \\ 122 & \\ 123 & 14 . What is the balance at th \\ 124 & Payment \\ 125 & Composite Rate \\ 126 & Remaining Loan Term (years) \end{tabular} 127 Payments per Year 128 129 130 15. What is the payment in months 85 through 96 ? 131 Loan Balance 132 Remaining Loan Term (years) 133 Payments per Year 134 Composite Rate Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 years. The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume the following forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this Excel workbook other than entering information needed in the yellow and pink highlighted cells and your answer calculation in the green highlighted cells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all decimal values)