Excel Tax Questions

[john97]

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

[Baldric]

Duplicate

http://www.theanswerbank.co.uk/Business-and-Finance/Question1383536.html