Question

On January 1, 2021, Strato Corporation borrowed $2 million from a local bank to construct a new building over the next three years. The loan will be paid back in three equal installments of $776,067 on December 31 of each year. The payments include interest at a rate of 8%. Prepare an amortization schedule over the three-year life of the installment note. (Round your final answers to the nearest dollar amount.)

Answer 1

Answer:

Period                           Installment    Interest Paid   Capital Paid   Balance

January 1, 2021                                                                                $2,000,000

December 31, 2021       $776,067       $160,000         $616,067    $1,383,933

December 31, 2021       $776,067         $110,715         $665,352       $718,581

December 31, 2021       $776,067         $57,486          $718,581                     0

Explanation:

Step 1

First clearly identify the parameters of the Loan

PV = $2,000,000

N = 3

PMT = - $776,067

P/YR = 1

i = 8%

FV = $0

Step 2

Since there is no missing parameter, we can then move on to construct our loan amortization schedule.

Period                           Installment    Interest Paid   Capital Paid   Balance

January 1, 2021                                                                                $2,000,000

December 31, 2021       $776,067       $160,000         $616,067    $1,383,933

December 31, 2021       $776,067         $110,715         $665,352       $718,581

December 31, 2021       $776,067         $57,486          $718,581                     0