Make a worksheet in Excel with the following Assumption (Also name the cells so they can be referenced later):

A.) Holding Period = 5 Years B.) Total Funds Available = $250,000

Here is the problem that you need to solve, Find the current loan terms for the three types of loans listed. Add the information in the new worksheet using a table like this one. It does not have to be exactly like this one.

Current Financing Terms Type Interest Rate Loan-to-Value Term (in years) Up-Front Financing Costs Periods/Year \begin{tabular}{|r|c|c|c|} No Loan & FixedRate & InterestOnly & ARM \\ \hline 0% & & & \\ \hline 0 & & & \\ \hline 0 & & & \\ \hline 0% & & & \\ \hline 1 & & & \\ \hline \end{tabular} Current Financing Terms Type Interest Rate Loan-to-Value Term (in years) Up-Front Financing Costs Periods/Year \begin{tabular}{|r|c|c|c|} No Loan & FixedRate & InterestOnly & ARM \\ \hline 0% & & & \\ \hline 0 & & & \\ \hline 0 & & & \\ \hline 0% & & & \\ \hline 1 & & & \\ \hline \end{tabular}