PART $1$: PROBLEM SCENARIO $($LOAN ANALYSIS SHEET$)$: You are a small business owner and have

decided to purchase a building for your operations, but you will have to get a loan. Module $3\text{'}$s financial

functions will help you consider the options available. Use the raw data and also consider the following:

Down Payment: This is the $ amount you will put$-$down at the time you purchase the building. The

bank recommends paying between $10\%$ and up to $20\%$ up front to help keep the pay back amount

lower. The difference between the building purchase price and the down payment is the Loan Value

$($Face Value of the loan or the amount you have to pay back to the bank$).$

Points: These are the additional bank charges on a loan depending on the customer's intent to own

the building long$-$term $($more than five years$),$ or$,$ short$-$term $($less than five years$).$ Long$-$term loans will

have more points which will lower the interest rate. For reference, one$-$point equals $1\%$ of a loan value.

So$,$ one point, or$,1\%$ of a $$10,000$ loan is $$100.$ The worksheet has Points in Column E recorded as

regular numbers. You can use Column E$\text{'}$s number values to calculate points in another column

without changing any of Column E$\text{'}$s raw data. Example: E$6$ is a value of $2,$ but when you use it to

calculate the points paid to the bank for the loan, you just put a $\%$ sign after the cell reference of E$6,$

or$,$ E$6\%.$ E $6$ is $2,$ but if you use a percentage sign like this: E$6\%$ then becomes $2\%.$

Fees: The additional amounts banks sometimes charge the customer for a loan. These amounts vary

by bank and loan type. T