build an amortization table in Excel and submit the Excel file. There is an XLS file in this module that contains the Rubric and you can build the table on that file if you like. There is also a PDF of what the final output should look like. Your table should contain links and formulas as specified in the rubric.

The loan balance will be equal to your student's 4% ID number (excluding any letters of course) 36m For example, use 100000 as the beginning balance The interest rate is your birth month. My birth month is November.

Spelling Counts (I suggest spell check before you submit)

Start with an assumptions area at the top left

Assumptions area should be outlined

Assumptions should include input cells that are colored yellow

The payment cell should be a formula that calculates the periodic payment for the loan. This allows the payment to be recalculated every time you change the assumptions (loan amount, rate, term)

Column Headings will be titled similarly to this example

Column Headings will be Bold, underlined, and centered

Starting value in the amortization table will be linked to the input cell for a loan amount

The first interest calculation will be calculated using the starting value for the month multiplied by the interest rate (remember to convert to a monthly interest rate by dividing by 12)

The first payment will be linked to the payment calculated in the assumptions box

All numbers in the amortization table will be formatted with commas and will be rounded to two decimal places. No dollar signs

The final loan balance in the table will be zero and that should occur in the month corresponding to the number of payments in the assumption box

For the number of months, you can choose any number of months from 24 months to 60 months. The table should be built in a way that allows it to update for any number of periods up to 60 months