Amortization Schedule You will be creating an amortization schedule for a house on the market. To do so, you will need the principal amount, the interest rate, and the amount of years you will borrow the loan. The amount you put as a down payment is up to you, but it can range from a minimum of 3.5% for an FHA loan or 5% for a traditional loan to a maximum of whatever. Traditionally you only need to go as high as 20% to avoid any extra fees or mortgage insurance from a low down payment. So, pick a number from 3.5% to 20% for your schedule.

Requirements: An amortization schedule with years from 15 to 30. The schedule should be made in excel. Research and find a house on a real estate website. Include a link to the house or a screenshot of its price in the submission screen. Research banks and find the current mortgage rate for your 15 or 30 year loan. Include a link or screenshot in the submission screen. Formulas used for finding numbers. All rows should be made until the payments would be complete. Include the same information above the schedule as seen in the sample schedule.