Quantitative Techniques In Financial Valuation Problem Set

Instructions:2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropriate).Week 5 Individual AssignmentPrincipalRateTimeSimple Interest (SI)Maturity ValueFind the interest paid on a loan of $1,200 for three years at a simple interest rate of 5% per year.How much money will you pay after three years?Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year.-- Please make sure that the time periods for Time and Rate match.Find the simple interest rate of a loan of $5,000 that is made for three years and requires $1,762.50 in interest. SIA loan of $16,840 is borrowed at 9% simple interest and is repaid with $4,167.90 interest. What is the duration of the loan?How much money is borrowed if the interest rate is 9.25% simple interest and the loan is made for 3.5 years and has $904.88 interest? interest rate. The loan was made on March 15 and is due May 15.Loan dateLoan Due DateExact timedaysFind the ordinary and exact interest for a loan of $1000 at a