solve the picture

Instructions Problem 1 Problem 2 Problem 3 Problem 4 Please show all your work in order to receive credits. You can show the calculations by listing how you input in a financial calculator, or use Excel. Grading is based on effort. Instructions Problem 1 Problem 2 Problem 3 Problem 4 The following table provides market values for the balance sheet of a Savings and Loan. Calculate the duration for its asset and liability (highlighted cells). Market Value (Sm) Duration 0 10 120 170 2 8 Assets Cash Auto loans Mortgages Total Assets Liabilities Checking and savings CDs Long term financing Total Liabilities Owener Equity Total Liabilities and Equity 0 120 90 75 1 12 15