The assignment is to put together three spreadsheet templates to use in computing mortgage loan payments. You are given detailed cell formulas to enter. The loans are: 1) Fixed interest rate mortgage loan (FRM), with an amortization period of 30 years (the most straightforward of the three, and thus probably the one to start with) 2) Fixed interest rate mortgage loan (FRM) that allows for an amortization period of up to 30 years (the most complex of the three, because you need IF statements to tell the program whether to keep computing relevant dollar amounts or to stop) 3) 5/25 Hybrid mortgage loan, with an interest rate that stays the same for the first 5 years and then changes annually in the remaining 25 years of a 30-year amortization period. We identify an interest rate for years 1-5 together, one for year 6, and one for year 7 (to reinforce the point that rates are reset annually after year 5). Then to keep things from getting too messy we just treat the year 8-30 interest rates as being identical to year 7's.