Program an Excel Spreadsheet to complete a Fixed Payment Loan Amortization Schedule based on the 5 inputs (see 1a below). This spreadsheet should work for any scenario chosen using the 5 inputs below that does not exceed 360 periods. You may start with any 5 inputs as these will be changed multiple times during grading. All cells with number format should have no decimal places. All cells with accounting format should have 2 decimal places. All cells with percentage format should have 3 decimal places. Formulas must use appropriate cell addressing and be efficiently copied to complete the schedule. Every number within the spreadsheet must be positive. You must use the given template and follow the directions within the template.

1. Cells appear at the top left that include:

   1. Inputs for:

      • Purchase Price accounting format

      • Down Payment accounting format

      • Number of Years number format

      • Compounding periods per year number format

      • Annual Interest Rate percentage format

   2. Formulas for:

      • Principle accounting format

      • Payment accounting format

2. Cells appear at the top right that include formulas for:

   • Total Amount Paid accounting format

   • Total Interest Paid accounting format

3. An amortization schedule able to accommodate any scenario appears at the bottom containing 6 columns and up to 360 rows of numbers and formulas with the following titles: a. Period Number number format b. Beginning Balance accounting format, dollar sign in first row only

   c. Payment accounting format, dollar sign in first row only d. Interest accounting format, dollar sign in first row only e. Principle Repaid accounting format, dollar sign in first row only f. Ending Balance accounting format, dollar sign in first row only

4. Using logic and the Excel capabilities, format the spreadsheet as follows. When a number of periods smaller than 360 are required, all rows below the last significant row must be blank (i.e. no rows visible beyond the total number of periods, no negative or extremely large and unnecessary numbers).

AutoSave OFF HES 5 = Loan Amortization Template Home Insert Draw Page Layout Formulas Data Review View Tell me Share o Comments X Calibri (Body) 11 - AP = = General Insert v 28v O 5 Delete v Paste B I a. A v E $ %) OOO Conditional Format Formatting as Table Cell Styles Sort & Filter Find & Select Ideas A Format v Sensitivity F3 X fx 206611 A B C D E F G H T J K Loan Amortization Project Template Last Name First Name ID Do not insert, delete, move, merge or name any rows, columns, or range. Do all of your work using formulas in the ranges of B6, B8, F7:F8, B11:F11 and A12:F370 Do no work outside of those ranges, except to enter input values in B1:B5. Total Amount Paid Total Interest Paid Beg Bal Payment Interest Principal Repaid End Bal 1 Purchase Price 2 Down Payment 3 Years 4 PAY 5 APR 6 Loan Amount 7 8 Payment 9 10 Period 11 1 12 13 14 15 16 17 18 19 20 21 A Instr Loan Ready + 160% AutoSave OFF HES 5 = Loan Amortization Template Home Insert Draw Page Layout Formulas Data Review View Tell me Share o Comments X Calibri (Body) 11 - AP = = General Insert v 28v O 5 Delete v Paste B I a. A v E $ %) OOO Conditional Format Formatting as Table Cell Styles Sort & Filter Find & Select Ideas A Format v Sensitivity F3 X fx 206611 A B C D E F G H T J K Loan Amortization Project Template Last Name First Name ID Do not insert, delete, move, merge or name any rows, columns, or range. Do all of your work using formulas in the ranges of B6, B8, F7:F8, B11:F11 and A12:F370 Do no work outside of those ranges, except to enter input values in B1:B5. Total Amount Paid Total Interest Paid Beg Bal Payment Interest Principal Repaid End Bal 1 Purchase Price 2 Down Payment 3 Years 4 PAY 5 APR 6 Loan Amount 7 8 Payment 9 10 Period 11 1 12 13 14 15 16 17 18 19 20 21 A Instr Loan Ready + 160%