Excel tax questions

The questions are:

a) The business will earn £100,000 in its first year. You can claim tax relief against purchase of computers and printers. Calculate the relief based on total equipment costs over three years: first year at 100%, second year at 50%, and third year at 25%

b) The remainder after tax relief is profit taxed at 21%. Calculate the tax liability.

The cost of computers where £3000, and the cost of the printers where £1000

I had to calculate the costs for setting up a business and the PMT, PPMT and IPMT for taking a loan from the bank. Heres a screenshot of my excel sheet. http://imgur.com/WAuYtCJ

Anyone know how to do this or know a place where I can find out? I'm using excel for the first time and i'm so confused
Asked Dec 01, 2014

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.