Program an Excel Spreadsheet to complete a Fixed Payment LoanAmortization Schedule based on the 5 inputs (see 1a below). Thisspreadsheet should work for any scenario chosen using the 5 inputsbelow that does not exceed 360 periods. You may start with any 5inputs as these will be changed multiple times during grading. Allcells with number format should have no decimal places. All cellswith accounting format should have 2 decimal places. All cells withpercentage format should have 3 decimal places. Formulas must useappropriate cell addressing and be efficiently copied to completethe schedule. Every number within the spreadsheet must be positive.If you are given a template, you must use the given template andfollow the directions within the template. The required part ofthis assignment is All of Objective I: Building a basicamortization schedule. The spreadsheet should have the followingcharacteristics in a logical order:

Objective I: Building a basic amortization schedule

1. A data table must appear at the top left that includes: a.Inputs for:

   • Purchase Price – accounting format
   • Down Payment – accounting format
   • Number of Years – number format
   • Compounding periods per year – numberformat • Annual Interest Rate – percentage format

   b. Formulas for:
   • Principle – accounting format • Payment –accounting format

2. A summarization table must appear at the top right thatincludes: a. Formulas for:

   • Total Amount Paid – accounting format • TotalInterest Paid – accounting format

3. An amortization table able to accommodate any scenario mustappear at the bottom containing 6 columns and 360 rows of numbersand formulas with the following titles:
   a. Period Number – number format
   b. Beginning Balance – accounting format, dollar sign in first rowonly

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

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

Answer rating: 100% (QA)

To program an Excel spreadsheet to complete a fixed payment loan amortization schedule you can follo... View the full answer