Hi, I have tried writing a program in VBA for excel for this problem statement with almost no luck at all. I'm not able to get my input boxes to loop correctly, and then have the values calculated from there. I keep running into the problem where the output value has numbers and units, and when I pull the data from the cell to calculate it, the data can not be pulled because it contains characters too. I would appreciate any help greatly!!!

Interest Rate Interest rates are useful for determining how much an investment may grow over time and may be useful for a company looking to purchase something expensive in the future (like a design project recommendation!) The equation for finding the interest rate given present cash and the desired future value is shown below. i=na 1] Where the representation is as follows Symbol Physical Meaning Interest rate Future desired value of investment Present value Number of times interest is compounded per time unit time Units unitless Dollars Dollars Unitless P years Create a sub program that will calculate the interest rate required given a present investment, the desired future value, the number of years for this investment, and the number of times this interest is compounded. Take user inputs via an input box. Check that the input values are numeric and positive. If they are not, show a message box asking for the user to input numeric values. Round the output to two decimal places. Include units when writing the user inputs to the Excel document. Worksheet Calculations Interest Rate Uniform Series Present/Future Worth Clear Cells Input Desired value 9001 dollars Present value 7500 dollars Times compounded per year 4 time 3 years Output interest rate 0.06 (6%)