Calculate Tax Rebate Automatically

Hi guys,

I need help on calculating tax rebate. The intuition is that the investment amount in cell D15 can be used offset corporate tax amount in row 18 and utility in row 17 but the rebate is only eligible for 5 year. It would be helpful if anyone can help with the formula in row 19 to calculate the rebate and automatically the rebate to be "gone"/0 after 5 years. I tried using IFs but couldn't come up with a solution

Try

Please Login or Register  to view this content.