1. From the mini case, Bourgeois Vin, please prepare answers for 4c and 4d using an excel spreadsheet. - Use the column method to first derive duration. Be sure to calculate the modified duration as well. - Calculate duration using the equation in class. 1 Please assume that you have annual compounding. - Calculate duration using the formula already provided in excel. - Use $1000 as the face value rather than the notational value in the mini case