Question
Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Lary is considering an ARM loan
Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Lary is considering an ARM loan offered by a local lender. The loan amount is $385,000. The term of the loan is 10 years. The index today is 1.1%. 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%. 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 the 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). Please provide the answer with the excel function thank you
21. Build an amortization schedule for the loan in this assignment and select the data needed for the two charts below (charts are hand graded for 10 points) (Be sure to include legends and titles in your charts). Month Payment Interest Principal Balance 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 21. Build an amortization schedule for the loan in this assignment and select the data needed for the two charts below (charts are hand graded for 10 points) (Be sure to include legends and titles in your charts). Month Payment Interest Principal Balance 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started