you will need to use excel to solve

Two investments have the following pattern of expected returns: Investment A requires an outlay of $122,000 and Investment B requires an outlay of $132,000. Required: a. What is the BTIRR on each investment? b. If the BTIRR were partitioned based on BTCF0 and BTCF5. what proportions of the BTIRR would be represented by each? c. Which investment would be preferable? Complete this question by entering your answers in the tabs below. What is the BTIRR on each investment? (Round your answers to 2 decimal places.) Two investments have the following pattern of expected returns: Investment A requires an outlay of $122,000 and Investment B requires an outlay of $132,000. Required: a. What is the BTIRR on each investment? b. If the BTIRR were partitioned based on BTCF0 and BTCF5. what proportions of the BTIRR would be represented by each? c. Which investment would be preferable? Complete this question by entering your answers in the tabs below. If the BTIRR were partitioned based on BTCF and BTCF5. What proportions of the BTIRR would be represented by each? (Do not round intermediate calculations. Round your answers to the nearest whole number.)