I need help with how caculate Net Present Value of Net Operating profit !!!

I also need help With IRR of Net Operating Profit !!!!

If there are forumulas thats can be provided for excel give it to me as well and provide some explanations

If there are any assumptions that can be added let me know as well?

B27 X V fx A B C D E F G H Fill in thee blank cells W N P Year 1 Year 2 Year 3 Year 4 Year 5 ASSUMPTIONS Incremental port revenue $0.00 | $ 136,932 |$ 287,557 |$ 234,154 $ 91,881 Port margin 61% 51% 51% Capital Investments $300 in Year 1 and $469 in Year 2 Port Profit Contribution 83,529 175,410 142,834 56,047 Depreciation Over 4 Years (25% per year) Tax Rate 38% Revenue - SW Upgrades $0.00 10,000 22,000 22,000 2,000 Cost of Capital / Discount Rate 18% 9 SW Margin 85% 85%% 35% 85% Development Fixed Increment caculation years 3, 4 and 5 year 2 - year =3708 10 SW Profit Contribution $0.00 3,500 18,700 18,700 1,700 11 12 Total revenue $0.00 $146,932.00 $309,557.00 $256,154.00 $93,881.00 13 Total Profit contribution $0.00 $92,028.52 $194,109.77 $161,533.94 $57,747.41 14 Effective Margin percent (profit/revenue) 0% 62.63% 62.71% 63.06%% 51.51% 15 16 Depreciation expense 75 192.25 192.25 117.25 117.25 17 Manufacturing overhead 0 20,540 43,134 35,123 13,782 18 Corporate overhead 24,922 52,335 12,616 16,722 19 Development expense 7,918 11,626 15,334 19,042 22,750 20 Maintenance expense 0 0 500 500 500 21 TOTAL EXPENSE 7,993 57,280 111,495 97,398 53,871 22 Pre-tax operating profit (7,993) 34,748 82,615 64,136 3,876 23 Taxes (3,037.34) 13,204.34 31,393.52 24,371.56 1,472.94 24 Net Operating Profit (4,955.66) 21,543.93 51,221.00 39,764.13 2,403.22 25 26 ANSWER THE FOLLOWING QUESTIONS 27 Net Present Value of Net Operating Profit 28 IRR of Net Operating Profit 29 30 31