The solution is in excel

2. Find out the NPV, IRR for the information given below using excel program. Calculate NPV using discounted cash flow and direct NPV formula application. (16 Mark) Year Cash flows A Cash flows BCash flows Cash flows D 0 -2000000 -2000000 -2000000 -2000000 $500,000 $600,000 $1,000,000 $300,000 S500,000 $600,000 $800,000 $500.000 3 $500,000 $600,000 $600,000 $700,000 4 $500,000 S600,000 $400,000 $900,000 5 $500,000 $600,000 $200,000 $1,100,000 5% Discount factor 9% 15% 22% 1 2 Sum of Discounted Cash Flows* Kall Year wise calculation to be shown in Excel sheet) NPV IRR Note: All calculation's for PV of cash flows, NPV and IRR answers should be up to 3 decimals. Note**. Answer the Questions Using excel sheet and save it with your Name& ID and send it to me by mail. Print this copy and fill your answer that you have calculated using excel sheet. If you don't have printer, then write your answers on a plain white A4 paper, take photo and send on mail with excel sheet soft copy with your name and ID. Time for exam is 1 hours only including the upload time, so I must receive your mail by 9:15 a.m. after that it will be accepted with 10% penalty for every 5 minutes delay