Developing Data Products Project

INTRODUCTION

An amortization schedule is a table detailing repayments towards a loan.

For each period, it shows how the payment is split between interest expense and the loan principal.

It also shows the remaining loan balance after each payment.

HOW THE APP WORKS

1. Solves for one of four parameters based on user inputs of other three:
   • Loan Amount
   • Number of Payment Periods
   • Interest Rate per Period (%)
   • Repayment Amount
2. Based on user inputs and the calculated output:
   • Generates a graphical amortization schedule
   • Generates an amortization table

EXAMPLE: Calculated Output

• Suppose the user wishes to calculate Repayment Amount and inputs:
  1. Loan Amount: 1000
     
  2. Number of Payment Periods: 4
     
  3. Interest Rate per Period (%): 4
     
• The calculated Repayment Amount will be:

## [1] 275.49

EXAMPLE: Amortization Schedule

Besides calculating the desired parameter, the app will also generate a graphical amortization schedule as shown below (feel free to hover over the bars!):

EXAMPLE: Amortization Table

The app will also generate an amortization table as show below (feel free to sort the table!):