In year $3,$ I get loan value of $216,791$ based on the above formula? However, I dont follow why you continue to take the outstanding loan balance and divide it by $30$ each time as this makes your amortization period longer than $30$ year as at a minimum you need $8$k per year of principal as there is no interest rate noted