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 rev-variable 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
- 12.5K For AAT students
- 319 NEW! Qualifications 2022
- 157 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership