A project requires an initial investment of $100,000 and is expected to produce a cash inow before tax of $28,000 per 1year for ve years. Company A...

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 inflow before tax of $28,000 per 1year for fiveyears. 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 inflation. 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 flows for each company? {Do not round intermediate calculations. Enter your answers as apercent rounded to 1 decimal places}