Prof B Note: Be sure to download the blank J.2 Excel file for a template to use when solving all of the problems in this assignment. You are required to upload this completed file to the last question of this assignment and will not receive credit on the Excel file unless you begin with the base file given in Canvas. Kathy Myers frequently purchases stocks and bonds, but she is uncertain how to determine the rate of return that she is earning. For example, three years ago she paid $27,500 for 250 shares of Malti Company's common stock. She received a $213 cash dividend on the stock at the end of each year for three years. At the end of three years, she sold the stock for $41,000. Kathy would like to earn a return of at least 17% on all of her investments. She is not sure whether the Malti Company stock provided a 17% return and would like some help with the necessary computations. (Ignore income taxes.) Required: a. Enter the Excel inputs below to be used to calculate the present value of the cash inflows from the investment. A mount 17% Item RATE NPER PMT FVI $ 213 b. Calculate the present value of the cash inflows from the investment and the net present value of the investment. (Any cash outflows should be indicated by a minus sign. Use Microsoft Excel to calculate present values and do not round intermediate calculations.) Amount Item Present Value of Inflows Less Initial Investment Net Present Value of Investment c. Did Kathy Myers earn at least a 17% return on her investment? Yes No c. Did Kathy Myers earn at least a 17% return on her investment? Yes No d. Enter the Excel formula inputs and calculate the Internal Rate of Return for Kathy's investment. Item Amount NPER PMT FV PV Rate of Return Prof B Note: Be sure to download the blank J.2 Excel file for a template to use when solving all of the problems in this assignment. You are required to upload this completed file to the last question of this assignment and will not receive credit on the Excel file unless you begin with the base file given in Canvas. Kathy Myers frequently purchases stocks and bonds, but she is uncertain how to determine the rate of return that she is earning. For example, three years ago she paid $27,500 for 250 shares of Malti Company's common stock. She received a $213 cash dividend on the stock at the end of each year for three years. At the end of three years, she sold the stock for $41,000. Kathy would like to earn a return of at least 17% on all of her investments. She is not sure whether the Malti Company stock provided a 17% return and would like some help with the necessary computations. (Ignore income taxes.) Required: a. Enter the Excel inputs below to be used to calculate the present value of the cash inflows from the investment. A mount 17% Item RATE NPER PMT FVI $ 213 b. Calculate the present value of the cash inflows from the investment and the net present value of the investment. (Any cash outflows should be indicated by a minus sign. Use Microsoft Excel to calculate present values and do not round intermediate calculations.) Amount Item Present Value of Inflows Less Initial Investment Net Present Value of Investment c. Did Kathy Myers earn at least a 17% return on her investment? Yes No c. Did Kathy Myers earn at least a 17% return on her investment? Yes No d. Enter the Excel formula inputs and calculate the Internal Rate of Return for Kathy's investment. Item Amount NPER PMT FV PV Rate of Return