AsSignMent $-3$: FinanCiAl PriORItization

This assignment is due on Tuesday April $30.$

The following table represents the revenues and costs of developing the overnight service theme for the WebPayroll System. Start by completing the one missing cell $($Net Cash Flow in Quarter $5).$

$\backslash$table$[[$Q$,$Dev Cost,$\backslash$table$[[$New$],[$Revenue$]],\backslash$table$[[$Incr$.],[$Revenue$]],\backslash$table$[[$Retained$],[$Revenue$]],\backslash$table$[[$Oper$.],[$Efficiencies$]],\backslash$table$[[$Net Cash$],[$Flow$]]],[1,-$$$90,000,$$$0,$$$0,$$$1,000,$$$0,-$$$89,000],[2,-$$$30,000,$$$2,500,$$$1,600,$$$2,000,$$$0,-$$$23,900],[3,,$$$3,750,$$$5,000,$$$3,000,$$$0,$$$11,750],[4,,$$$3,750,$$$7,500,$$$4,000,$$$0,$$$15,250],[5,,$$$7,500,$$$10,000,$$$5,000,$$$7,500,],[6,,$$$7,500,$$$10,000,$$$6,000,$$$7,500,$$$31,000],[7,,$$$7,500,$$$10,000,$$$7,000,$$$7,500,$$$32,000],[8,,$$$7,500,$$$10,000,$$$8,000,$$$7,500,$$$33,000]]$

Now we would like to evaluate the financial return of this theme using the four financial measures discussed in class. Assuming the opportunity cost of our company is $20\%$ per year, calculate the NPV$,$ IRR, payback period, and discounted payback period for this theme. Note:

Do not just submit the answers; show all the work$/$tables used in deriving the four measures.

Be careful when rounding numbers because it could make a difference in hundreds of dollars.

All final answers should be rounded to the nearest dollar