Please include all formulas and show work via Excel.?A project requires an initial investment of $100,000 and is expected to produce a cash in?ow before tax of $28,000 per 1year for ?veyears. Company A has substantial accumulated ta): losses and is unlikely to pay taxes in the foreseeable future. Company B payscorporate taxes at a rate of 21% and can claim 100% bonus depreciation on the investment. Suppose the opportunity cost of capital is1196. Ignore in?ation. a. Calculate project NPV for each company. [Do not round intermediate calculations. Round your answers to the nearest wholedollar amountj Company ACompany E! b. 1u’ulhat is the IRR of the after-tax cash ?ows for each company? {Do not round intermediate calculations. Enter your answers as apercent rounded to 1 decimal places}