Turn on thread page Beta
 You are Here: Home >< Maths

# Tax in excel watch

1. 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. I attached a screenshot of the excel sheet with all the business costs and total costs.

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
Attached Images

2. Hi there,

While you're waiting for an answer, did you know we have 300,000 study resources that could answer your question in TSR's Learn together section?

We have everything from Teacher Marked Essays to Mindmaps and Quizzes to help you with your work. Take a look around.

If you're stuck on how to get started, try creating some resources. It's free to do and can help breakdown tough topics into manageable chunks. Get creating now.

Thanks!

Not sure what all of this is about? Head here to find out more.

Turn on thread page Beta
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: December 2, 2014
Today on TSR

### Cambridge interviews

Find out which colleges are sending invitations

### University open days

• University of East Anglia
UEA Mini Open Day Undergraduate
Fri, 23 Nov '18
• Norwich University of the Arts
Fri, 23 Nov '18
• Edge Hill University
Sat, 24 Nov '18
Poll
Useful resources

## Make your revision easier

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams

Can you help? Study help unanswered threads

## Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE