1.You are looking at a one-year loan of $15,000. The interest rate is quoted as 10 percent plus 5 points. A point on a loan is simply 1 percent (one percentage point) of the loan amount. Quotes similar to this one are very common with home mortgages. The interest rate quotation in this example requires the borrower to pay 5 points to the lender up front and repay the loan later with 10 percent interest. What is the actual rate you are paying on this loan?

2.The Design Team just decided to save $1,400 a month for the next 5 years as a safety net for recessionary periods. The money will be set aside in a separate savings account which pays 4.5 percent interest compounded monthly. The first deposit will be made today. What would today's deposit amount have to be if the firm opted for one lump sum deposit today that would yield the same amount of savings as the monthly deposits after 5 years?

Plz do it in Excel formula