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.

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d