please post excel formulas thank you!

(Please list formula with stated cell in spreadsheet)

if you zoom in on the screen the spreadsheet maximizes and becomes more clear, sorry for the inconvenience.

AutoSave OFF BESU- ARM Excel Assignment Module 6 Attempt 1 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Times New Roman V 12 = = "Ai > X LG General V WE 480 5 V Paste A V $ %) IX Delete A Format 8 V Sensitivity 100 Conditional Format Cell Formatting as Table Styles 0 Find & Select Sort & Filter Analyze Data 0 H 1 J K L M N 0 P P Q R S T U V 3 J37 4x fx A B D E F G 1 Adjustable Rate Mortgage Excel Assignment 2 Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate 4 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% 6 and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume the following forecast of 7 index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this Excel workbook other than 8 entering information needed in the yellow and pink highlighted cells and your answer calculation in the green highlighted cells. Only the 9 green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all decimal values). 10 11 12 13 Index Rate Composite 14 Year Forecast Rate 15 0 1.80% 16 1 2.25% 17 2 2.50% % 18 3.3 3.75% 19 5.75% 10 20 7.50% wer 21 5.50% 5.1070 22 4.00% 23 3.25% 24 4.10% 25 26 1. What is the payment in months 1 through 12? 28 Loan Balance Payment 29 Loan Term (years) 30 Payments per Year 31 Index 32 Margin 33 Annual cap 34 Lifetime cap 35 Teaser 36 Composite Rate 37 38 39 2. What is the balance at the EOY 1? 40 Payment Balance ARM + 4 5 6 U 7 8 9 | - @ A + 100% AutoSave OFF BESU- ARM Excel Assignment Module 6 Attempt 1 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Times New Roman V 12 = = "Ai > X LO 2 General V WE 480 5 V Paste A V 9X Delete A Format $ % ) V Conditional Format Cell Formatting as Table Styles Sensitivity 0 Find & Select Sort & Filter Analyze Data H23 4x fx A B D E F G H 1 I J K L M N 0 P O R S T V Payment 33 Annual cap Balance 26 27 1. What is the payment in months 1 through 12? 28 Loan Balance 29 Loan Term (years) 30 Payme 30 Payments per Year 31 Index 32 Margin 33 34 Lifetime cap 35 Teaser ac 36 Composite Rate 37 3 JO 38 39 2. What is the balance at the EOY 1? 40 Payment 41 Composite Rate 42 Remaining Loan Term (years) Payments per Year 44 45 46 3. What is the payment in months 13 through 24? 47 Loan Balance 48 Remaining Loan Term (years) 49 Payments per Year 50 Composite Rate 51 52 53 4. What is the balance at the EOY 2? 54 Payment 55 Composite Rate 56 Remaining Loan Term (years) 57 Payments per Year 58 59 60 5. What is the payment in months 25 through 36? 61 Loan Balance 62 Remaining Loan Term (years) 63 Payments per Year 64 Composite Rate 65 66 > ARM + Payment Balance Payment 2 @ A + 100%