Create a spreadsheet to examine the impact of interest on a loan your company needs to support investment in new equipment. You need $$245,000$ today and you have the following options:

Short Term Loan: Quarterly Compounding, i$=3\%,$ Total Period $=2$ years

Medium Term Loan: Semi$-$annual Compound, i$=5\%,$ Total Period $=5$ years

Long Term Loan: Annual Compounding, i$=8\%,$ Total Period$=10$ years