Your spreadsheet should include the same basic formatting including shading, lines, bold and regular text, etc as shown below. The input cells are represented by the blue shading. All other cells should be formula-based and derive the correct answers.

My work need to look like this:

This is my work so far below, I am stuck on debt service and how to find the answers after that.

\begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Property Valuation } \\ \hline NOI & & $ & 1,417,765 \\ \hline Cap Rate & 6.00% & & 6.00% \\ \hline Value & & $23 & 629,416.67 \\ \hline \multicolumn{4}{|l|}{ Financing } \\ \hline Value & & $23 & 629,416.67 \\ \hline Loan to Value Ratio & 70.00% & & 70.00% \\ \hline Loan Amount & & $16 & ,540,591.67 \\ \hline Equity Investment & & $7 & 088,825.00 \\ \hline \multicolumn{4}{|c|}{ Property Cash Flows, Lender Metrics, and Equity Return } \\ \hline NOI & & $ & 1,417,765 \\ \hline Interest rate & 4.50% & & \\ \hline Loan Term & 30 & & \\ \hline \multicolumn{4}{|l|}{ Debt Service (annual) } \\ \hline \multicolumn{4}{|l|}{ Year 1 interest on loan } \\ \hline \multicolumn{4}{|l|}{ Year 1 principal amoritized } \\ \hline \multicolumn{4}{|l|}{ Cash Flow after Financing } \\ \hline Debt Coverage Ratio & & & \#DIV/0! \\ \hline Debt Yield & & & 8.57% \\ \hline Return on Equity (Equity Dividend) & & $ & 0.00 \\ \hline \multicolumn{4}{|l|}{ Equity Build Up (\% of Equity) } \\ \hline Return on Equity and Equity Build-up & & $ & 0.00 \\ \hline \end{tabular}