payback peroid & net present value (COSTING)
mattyboy01
Registered Posts: 4 New contributor ?
Hi all,
Wondering if any one can help me because im doing late revision and have forgotten how to work out the payback peroid and net present value!!
I am working through all the past papers and although I have the answers I dont no how they got these figures! aahh!
Working on december 2003 costing and year the data is:
year 0 year 1 year 2 year 3 year 4
capital ex 500    
sales rev  200 500 800 200
variable costs  140 350 480 120
10% present 1.000 0.909 0.826 0.751 0.683
what is the payback peroid? i no the answer is 2.9 years but could I have a formula please some one!
and final question NET PRESENT VALUE
year 0 year 1 year 2 year 3 year 4
net cash flows (500) ? 60 ?150 ?320 ?80
present value fact 1.000 0.909 0.826 0.751 0.683
present values ?(500) ?54.54 ?123.90 ?240.32 ?54.64
net present value ?(26.60)
where theres question markes these are the answers and I just want to no the formulas for these!!
If any one can show me i really appreciate this!
thanks
Wondering if any one can help me because im doing late revision and have forgotten how to work out the payback peroid and net present value!!
I am working through all the past papers and although I have the answers I dont no how they got these figures! aahh!
Working on december 2003 costing and year the data is:
year 0 year 1 year 2 year 3 year 4
capital ex 500    
sales rev  200 500 800 200
variable costs  140 350 480 120
10% present 1.000 0.909 0.826 0.751 0.683
what is the payback peroid? i no the answer is 2.9 years but could I have a formula please some one!
and final question NET PRESENT VALUE
year 0 year 1 year 2 year 3 year 4
net cash flows (500) ? 60 ?150 ?320 ?80
present value fact 1.000 0.909 0.826 0.751 0.683
present values ?(500) ?54.54 ?123.90 ?240.32 ?54.64
net present value ?(26.60)
where theres question markes these are the answers and I just want to no the formulas for these!!
If any one can show me i really appreciate this!
thanks
0
Comments

Ok.. for the payback period.. the cash flows each year (sales revvariable costs) would be
Year 0 (500) which is the initail cash outlay
Year 1 60
Year 2 150
Year 3 320
Year 4 80
If you add these together, the comany would break even between year 2 and 3. So 2 years + (290/320) = 2.9 years
As for the NPV you add all the present values together (500)+54.54+123.90+240.32+54.64 = (26.60)
Hope this helps!0 
hi thanks for the reply I can kinda see how you do it now however im still confused !!
i can see now where you break even is between year 2 and year 3 but that (290/320 does not come to 2.9 years still dont understand that and aswell the npv how do you work out the present values ?!
thanks again if you could reply!0 
290/320 = 0.9
2 years + 0.9 = 2.9 years!
To get the present values you times the present cash flow by the factor.
(500) x 1.000 = (500)
60 x 0.909 = 54.54
150 x 0.826 = 123.9
320 x 0.751 = 240.32
80 x 0.683 = 54.64
Any clearer?0 
i understand now what you have said for payback but where did you get 290 from ??!!! lol cheers0

hi thanks for helping me out, still dont understand where the 290 has come from but i have found that break even is 500. and its was 30 over (530) so i just done 30/320 = 0.09 so 2.9 years hope i can use this formula!0

year cost cumulative
0 500 500
1 60 440
2 150 290
3 320 30
pay back somewhere between years 2 and 3 290/320 =0.9
I put a box around the two figures i have to divide to remind me
what to do0 
I had to tell myself a little story to get this formula in my hea
I am using esme's figs here....
Year 0 (500) which is the initail cash outlay
Year 1 60
Year 2 150
Year 3 320
Year 4 80
(500) + 60.00 = (440) at end of year 1
(440) + 150.00 = (290) at end of year 2
(290) + 320 = 30 at end of year 3
If you only needed an extra £290 at the end of year 2 before it was paid back  then you need £290 out of Year 3's £320  hence 290/320 (this is added to the 2 years you have already established.
The only problem with this is  who the hell says 2.9 years!
Therefore if you calculate (290/320) x 12 months in a year = 10.87 MONTHS
i.e Payback occurs just under 2 years 11 months0 
My tutor also worked out 2.9 years and I have been wondering where 2.9 comes from I too got 10.87. Tutor says 290/320 x 12 which gives you 10.87 months. Thought I was going mad.0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 251 NEW! Qualifications 2022
 139 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 35 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 137 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership