a task i have to do is slightly confusing (prob cos i have no accounting experience)
i have to create a spreadsheet which will cope with up to 12 equal time periods over which cash flows may arise,and assess the potential of an investment project by..
a)straight payback
b)discounted payback
c)internal rate of return
im guessing a is using the pmt function so u input a total amount and repayment periods
eg 12 ..and it tells u the repayment amount...does this sound right?
i have to create a spreadsheet which will cope with up to 12 equal time periods over which cash flows may arise,and assess the potential of an investment project by..
a)straight payback
b)discounted payback
c)internal rate of return
im guessing a is using the pmt function so u input a total amount and repayment periods
eg 12 ..and it tells u the repayment amount...does this sound right?