A company invests EUR 50,000 every 6 months for 5 years to purchase a software,The investment will be compounded at an annual interest rate of 5% per annum. The initial investment will be made now, and thereafter, at the beginning of every 6 months.

What is the future value of the cash flow payments, the NPV, the BCR or PI (benefit-to-cost ratio or profitability index), and internal rate of return (IRR)

on excel