PaybackFunction - 250 300-450 CumOufl-500-500-500-950...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Payback and Modified Payback Customer-Defined Function Developed by Sergei Vasilievich Cheremushkin To calculate the payback just type =payback(CashFlow) To calculate the modified payback just type =mpayback(CashFlow) The modified payback function is used to cash flow that contains cash outflows at the end in the The functions have two arguments - Cash Flow Range and Payback Type Payback Type allows to to use one of the following timing of the cash flow assumptions: 0 - the cash flows take place strictly at the end of the period; 1 (or above) - the cash flows are fulfilled evenly within every period. t 0 1 2 3 CF -100 -5 120 4550 Cum CF -100 -105 15 4565 Payback Period #MACRO? #MACRO? t 0 1 2 3 CF -500
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 250 300-450 CumOufl-500-500-500-950 TotalOutfl-2450 ModifCumCF-2450-2200-1900-1900 Modified Payback Period #MACRO? #MACRO? this assumption may be useful when it's known that the cash flows are re the end of the period (e.g. for bonds, contrac this assumption may be useful for other cases, especially for extended p on a monthly basi 2/11/2009 ns e midst of the project's horizon 4 5 6 456 2133 452 5021 7154 7606 4 5 6 7 8 390 1000 1223 2500-1500-950-950-950-950-2450-1510-510 713 3213 3213 received and paid in a sole amounts at a specified date at cts with payments schedule). periods (e.g. for years, when actual cash flows are made is)....
View Full Document

This note was uploaded on 04/26/2009 for the course BUSINESS 341 taught by Professor Miller during the Spring '10 term at Baltimore City.

Page1 / 9

PaybackFunction - 250 300-450 CumOufl-500-500-500-950...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online