SPP Formula query

Start
Prev
1
Next
End

Hamza Ali
Topic Author

25 Jul 2022 08:16 - 25 Jul 2022 23:06 #11284 by Hamza Ali

SPP Formula query was created by Hamza Ali

Hello,

Can u tell me which Formula SAM is using to calculate simple payback period SPP? I am really confused! can anybody tell me simple and exact formula for SPP which SAM is using.

Explain this formula please.

Last edit: 25 Jul 2022 23:06 by pgilman.

Please Log in or Create an account to join the conversation.

pgilman

25 Jul 2022 23:24 #11287 by pgilman

Replied by pgilman on topic SPP Formula query

Hi Hamza Ali,

Please see the "Payback Period" topic in SAM's Help system: samrepo.nrelcloud.org/help/mtf_payback.htm

If you are running a Windows version of SAM, you can also see the calculation in Excel by clicking Send to Excel with equations from the Cash Flow tab on the Results page. We have also posted versions of this Excel workbook on the SAM website at sam.nrel.gov/financial-models/residential-and-commercial.html.

Best regards,
Paul.

Please Log in or Create an account to join the conversation.

Hamza Ali
Topic Author

05 Aug 2022 03:59 #11321 by Hamza Ali

Replied by Hamza Ali on topic SPP Formula query

Sir, I am unable to understand Excel sheet formula (IF function) for Simple Payback Period. Can u please teach me how to calculate payback period? can you please write the formula here with explanation? Please.

Please Log in or Create an account to join the conversation.

pgilman

05 Aug 2022 23:26 #11323 by pgilman

Replied by pgilman on topic SPP Formula query

Dear Hamza Ali,

The equations are described in the Help topic I provided a link to above. Please also see the Short (1995) publication mentioned at the beginning of that topic.

Best regards,
Paul.

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Moderators: pgilman