need equations in excel for each column of information based on inputs, use solutions as reference

Calibn Paste a.A. cipbourd fort a Alignment Number 5 styles (3) UPDAIES AVAILAULE Updates for OIfice are ready to be installed but fint we need to close some apss. Update now C10 fx=co(1$cs4) A. B D EF Calculated from numbers on left Inputs \begin{tabular}{|l|c|} \hline House Price & $500,000 \\ \hline Deposit: & $80,000 \\ \hline interest Rate & 6.00% \\ \hline Mortgage length & 30 \\ \hline \end{tabular} Loan Size Mortgase PMT Calculated from table below TotolPaid Iotal interest 545 che TAB File Home Insert Draw Page Layout Formulas Data Review View Help (1) UPDAIES AVALABLE Updates tor Office are ready to be installed but first we need to dose sameands. Update now C9 :Xfx420000 A B. c0 E F G H 1 Inputs Calculated from numbers on left \begin{tabular}{|l|c|} \hline House Price & $00,000 \\ \hline Deposit & $80,000 \\ \hline Leterest Rate & 6.00% \\ \hline Mortpage length & 30 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Loan Sizo & $420,000 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Mortpape PMI $2,518.11 \\ \hline \end{tabular} Calculated from table below years \begin{tabular}{|l|l|} \hline Total Paid & $906,520 \\ \hline Total interest & $486,$20 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Date & MontgageBalance & Payment & Interest & Principlepaid & EndofMonthBalance & Percentinterest & PercentPrinciplet \\ \hline 1/1/2024 & $420,000 & $2518 & $2,100 & \$418 & S419,582 & 83.40% & 16.6006 \\ \hline 2/1/2024 & $419,582 & $2,518 & $2,098 & S420 & $419,162 & 83.31% & 16.69% \\ \hline 3/1/2024 & $419,162 & 52,518 & $2,096 & $422 & $418,739 & 83.23\% & 16.77K \\ \hline 4/1/2024 & $418,739 & 52,518 & $2,094 & \$424 & 5418,315 & 83.15% & 16.85k \\ \hline 5/1/2024 & $418,315 & $2,518 & $2,092 & $427 & $417,888 & 83.06% & 16.94% \\ \hline 6/1/2024 & $417,2888 & 52518 & $2,089 & $429 & $417,460 & 82.988 & 17.028 \\ \hline 7/1/2024 & $417,460 & $2,518 & $2,087 & $431 & $417,029 & 82.896 & 17.11x \\ \hline 8/1/2024 & $417,029 & $2,518 & $2,0s & $433 & 5416,596 & 82.81x & 17.19x \\ \hline 9/1/2024 & $416,596 & $2,518 & $2,083 & 5435 & $416,161 & 82.72k & 17.288 \\ \hline 10/1/2024 & $416,161 & $2,518 & $2,081 & $437 & 5415,724 & 82.6336 & 17,37x \\ \hline 11/1/2024 & 5,415,224 & $2518 & $2,079 & sa39 & 5415,284 & 82.55% & 17.45% \\ \hline 12/1/2024 & $415,284 & $2518 & $2,076 & sin & S414,842 & 182.465 & 17.54% \\ \hline 1/1/2005 & S414,842 & $2.518 & $2,074 & 5444 & 5414,398 & 87.37x & 17.6386 \\ \hline 2/1/2025 & SA14,306t. & 52518 & $2,072 & 5446 & S413,952 & 82.283 & 11.72x \\ \hline \end{tabular}