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
Answer:
The amortization schedule attached, shows beginning balances,interest payments, annual loan repayments as well as the ending balances up until year 3 where the ending balance becomes $0 indicating that the loan principal has been fully amortized(repaid)
Explanation:
In constructing the amortization schedule, the interest payment is the beginning outstanding balance multiplied by the interest rate.
The principal repayment is the annual repayment minus the interest payment whereas the ending balance is the balance at the beginning of the year minus the principal repayment as shown below:
