Please answer both questions

Exercise 26-17A Using Excel to compute IRR LO P4 Following is information on two alternative investments being considered by Jolee Company. The company requires a 11% return from its investments. Project A $ (198,000) Project B $ (143,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 49,500 65,500 89,795 99,900 74,500 41,500 59,500 75,500 75,500 75,500 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) IRR % Project A Project B % Exercise 26-9 Computing net present value LO P3 B2B Co. is considering the purchase of equipment that would allow the company to add a new product to its line. The equipment is expected to cost $369,600 with a 6-year life and no salvage value. It will be depreciated on a straight-line basis. The company expects to sell 147,840 units of the equipment's product each year. The expected annual income related to this equipment follows. $ 231,000 Sales Costs Materials, labor, and overhead (except depreciation on new equipment) Depreciation on new equipment Selling and administrative expenses Total costs and expenses Pretax income Income taxes (40%) Net income 81,000 61,600 23, 100 165,700 65,300 26, 120 $ 39,180 If at least an 10% return on this investment must be earned, compute the net present value of this investment. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Chart Values are Based on: n = 6 101% Amount PV Factor = Select Chart Present Value of an Annuity of 1 Present Value $ 0 Present value of cash inflows Present value of cash outflows (369,600) Net present value