Answer:
$212.38
Explanation:
In this question, we use the PMT formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $24,000
Future value = $0
Rate of interest = 6.75% ÷ 12 months = 0.5625%
NPER = 15 years × 12 months = 180 months
The formula is shown below:
= PMT(Rate;NPER;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be $212.38
