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.

Tri fecta, a partnership, had revenues of $369,000 in its first year of operations. the partnership has not collected on $45,000 of its sales and still owes $39,500 on $155,000 of merchandise it purchased. there was no inventory on hand at the end of the year. the partnership paid $27,000 in salaries. the partners invested $48,000 in the business and $23,000 was borrowed on a five-year note. the partnership paid $2,070 in interest that was the amount owed for the year and paid $9,500 for a two-year insurance policy on the first day of business. compute net income for the first year for tri fecta.