create a tax calculation worksheet in Microsoft Excel that can be used to determine the net tax amount (amount payable or refund due) for a resident

create a tax calculation worksheet in Microsoft Excel that can be used to determine the net tax amount (amount payable or refund due) for a resident Australian unmarried taxpayer for the 2017/18 income year.

Set up worksheet so the user can enter totals for the following items:

(i)    taxable income,

(ii)   PAYG paid,

(iii)  non-refundable tax offsets (excluding low income tax offset)

(iv)  refundable tax offsets.