For this assignment it is important that the final product is linked to your original input cells. For example, if I change the interest rate or down payment amount in your inputs, all of the outputs should change automatically. We are purchasing a $250,000.00 house using a down payment that's equivalent to 20% of the value, and will be financing the balance. The loan will be for 15 years, at 4.5% with monthly payments. In excel, create a section for your inputs. (purchase price, down payment percentage, interest rate, loan duration, etc.) Create an amortization table that shows the initial balance at month zero, and the ending balance at the end of the month. To do this, you'll need to calculate the interest that accrues during the month, the mortgage payment, and include a placeholder for any 'extra' payments above and beyond the required mortgage payment (you'll probably want this in an input cell as well). With that you can calculate the initial and ending balance for the each month You should be able to copy these formulas to generate the entire amortization table until the loan is paid off. I.e., once you've structured the first few rows of