The instruction to the question is given below Questions 1. The monthly lease payment, Pmt, of a

The instruction to the question is given below

Transcribed Image Text:

Questions 1. The monthly lease payment, Pmt, of a new car can be calculated by: Pmt = Pu (1+1/12) (144/12) N 1/12 where Pu and Fu are the present value and the future value (at the end of the lease) of the car, respectively. N is the duration of the lease in months, and i is the interest rate per year. (a) Write an anonymous function to calculate the monthly lease payment. [2] (b) Given a data file 'data.xlsx' (the 1st column is the Pu and 2nd is the Fu), READ the data into MATLAB and Calculate the monthly lease payment when N = 24 and i = 0.05 by calling the anonymous function in a) and store the monthly lease payment to the 'data.xlsx'. Keep two decimal places. [4] (c) Consider yearly interest rate given is a vector, re-write the anonymous function using elementwise operation to calculate the monthly lease payment for a car with pu = 3500, fv = 800, N = 36 and i= [0.02, 0.03, 0.04, 0.05, 0.06, 0.07]. Keep two decimal places. [4] Questions 1. The monthly lease payment, Pmt, of a new car can be calculated by: Pmt = Pu (1+1/12) (144/12) N 1/12 where Pu and Fu are the present value and the future value (at the end of the lease) of the car, respectively. N is the duration of the lease in months, and i is the interest rate per year. (a) Write an anonymous function to calculate the monthly lease payment. [2] (b) Given a data file 'data.xlsx' (the 1st column is the Pu and 2nd is the Fu), READ the data into MATLAB and Calculate the monthly lease payment when N = 24 and i = 0.05 by calling the anonymous function in a) and store the monthly lease payment to the 'data.xlsx'. Keep two decimal places. [4] (c) Consider yearly interest rate given is a vector, re-write the anonymous function using elementwise operation to calculate the monthly lease payment for a car with pu = 3500, fv = 800, N = 36 and i= [0.02, 0.03, 0.04, 0.05, 0.06, 0.07]. Keep two decimal places. [4]