Build a model that shows the details of the 20-year mortgage when the loan amount, APR, and loan date are given. Assume that payments are made on the third workday of each month (disregarding federal holidays).

The model is very simple.

We have a mortgage, which is our total payment or principal. The APR is the interest rate. The term is 20 years.

With this information, we can build an amortization schedule, with the following elements:

Period: the period of the payment. The first payment corresponds to the first period, the second payment corresponds to thes second period, and so on.

Principal: the amount of money from the payment that goes to the principal.

Interest: the amount of money from the payment that goest to interest.

Payment: principal + interest of the period added.

Balance: total payment minus the principal payment of the period.

With this model, a simple amortization shcedule can be built, either manually, or on a computer spreadsheet like EXCEL.

you will have $2593.74 in 10 years if you set aside $1,000 at 10%

you will have $9321.91 in 20 years if you set aside $2000 at 8%

you will have $1469.32 in 5 years if you set aside $1000 at 8%

you will have $1296.87 in 10 years if you set aside $500 at 10%

you will have $239.66 in 15 years if you set aside $100 at 6%

you will have $4660.96 in 20 years if you set aside $1000 at 8%

answer; windows embedded;