Question One. (10 marks) Using Ms Excel, appraise the following two projects. Calculate NPV (Using the PV method) and NPV (Using the Ms Excel Built-in method) and also calculate the IRR of the projects. Which one of the two projects is a viable investment and state your reasons? Project North Investment Cost BWP135,000.00, Interest rate of 10%, Operation cost BWP 40,000 per year and Rental cost of BWP 25,000.00 in year 1 and then increases by 5% per year up to the end of the project. Scrap value BWP45,000.00 Year Revenue B WP90,000.00 B WP95,000,00 B WP80,000.00 UIAWN B WP85,000.00 B WP75,000.00 Project South Investment Cost BWP115,000.00, Interest rate of 7%, Operation cost BWP 25,000 per year and Rental cost of BWP 20,000.00 in year 1 and then increases by 6% per year up to the end of the project. Scrap value BWP35,000.00 Year Revenue B WP85,000.00 B WP95,000.00 UIAWNG B WP90,000.00 B WP75,000.00 BWP65,000.00Question One. (10 marks) Using Ms Excel, appraise the following two projects. Calculate NPV (Using the PV method) and NPV (Using the Ms Excel Built-in method) and also calculate the IRR of the projects. Which one of the two projects is a viable investment and state your reasons? Project North Investment Cost BWP135,000.00, Interest rate of 10%, Operation cost BWP 40,000 per year and Rental cost of BWP 25,000.00 in year 1 and then increases by 5% per year up to the end of the project. Scrap value BWP45,000.00 Year Revenue B WP90,000.00 B WP95,000,00 B WP80,000.00 UIAWN B WP85,000.00 B WP75,000.00 Project South Investment Cost BWP115,000.00, Interest rate of 7%, Operation cost BWP 25,000 per year and Rental cost of BWP 20,000.00 in year 1 and then increases by 6% per year up to the end of the project. Scrap value BWP35,000.00 Year Revenue B WP85,000.00 B WP95,000.00 UIAWNG B WP90,000.00 B WP75,000.00 BWP65,000.00