Please Show formulas

Q1) Do the following in a new worksheet in excel: a) Make a Data Table with the following variables: Principal and Duration and calculate the value of annual installment. For interest rate, use data validation (drop down). [6 Marks] Principal Production Duration Interest Case 1 50000 2 Years 9% Case 2 60000 3 Years 10% Case 3 70000 4 Years 11% Case 4 80000 5 Years Case 5 90000 6 Years 13% Case 6 100000 7 Years 14% 12% b) Given below is the sales and Profit Ratio for different items. Use Goal Seek to get the desired value of profits by finding out the sales value for pullovers. [4 Marks] PV Ratio Product Shirts Trousers Socks Jackets Pullovers Jeans Other Information Fixed Cost Net Profit Needed for the Year (Desired value) 12% 18% 10% 30% 40% 15% Sales 300000 600000 80000 800000 To be Calculated 1000000 250000 492000