Property Value Loan #1: LTV Ratio Interest Rate Term Balloon Payment Monthly Payment 1st Interest Payment 1st Principal Payment 2nd Month Loan Balance Conforming Loan? (Y/N) Loan #2: Original Loan Amount Interest Rate Term Balloon Payment 1st Interest Payment LTV Ratio 8th Month Loan Balance Loan #3: 1st Interest Payment Original Loan Amount Term Balloon Payment Interest Rate LTV Ratio Conforming Loan? (Y/N) Loan #4: LTV Ratio Term Amortization? Interest Rate Monthly Payment 3rd Month Balance 75% 7.5% 20 years 250,000 1,000,000 8.0% 30 years 1,000,000 6,400 900,000 15 years 900,000 60% 30 years Fully amortizing 7.0%

need to calculate using excell formulas

Property Value Loan \#1: \begin{tabular}{|lr|} \hline LTV Ratio & 75% \\ Interest Rate & 7.5% \\ Term & 20 years \\ Balloon Payment & 250,000 \\ \hline Monthly Payment & \\ 1st Interest Payment & \\ 1st Principal Payment & \\ 2nd Month Loan Balance & \\ Conforming Loan? (Y/N) & \\ \hline \end{tabular} Loan \#2: \begin{tabular}{|lr|} \hline Original Loan Amount & 1,000,000 \\ Interest Rate & 8.0%6 \\ Term & 30 years \\ Balloon Payment & 1,000,000 \\ \hline Ist Interest Payment & \\ LTV Ratio & \\ 8th Month Loan Balance & \\ \hline \end{tabular} Loan H3: \begin{tabular}{|lr|} \hline 1st interest Payment & 6,400 \\ Original Loan Amount & 900,000 \\ Term & 15 years \\ Balloon Payment & 900,000 \\ \hline Interest Rate & \\ LrV Ratio & \\ Conforming Loan? (V/N) & \\ \hline \end{tabular} Loan HA: \begin{tabular}{|lr|} \hline LTV Ratio & 605 \\ \hline Term & 30 years \\ Amortization? & Fully y amortizing \\ \hline Interest Rate & 7.059 \\ \hline Monthly Payment & \\ 3rd Month Balance & \\ \hline \end{tabular}