This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
The cells in blue are input cells. Feel free to change the numbers for what-if's. The other cells are calculated from the inputs.
Assumptions
Cash Flow
Cash Flow
Offering Period:
6 months
Date
With Look-Back (1)
Without Look-Back (1)
Purchase Period Starts On
02/01/06
2/1/2006
0
0
Payroll frequency:
Twice a month
2/15/2006
-300
-300
Discount:
5%
2/28/2006
-300
-300
Price @ Start
$49.00
3/15/2006
-300
-300
Price @ End
$50.00
3/31/2006
-300
-300
Price Sold
$50.00
4/15/2006
-300
-300
Contribution per Pay Period:
$300.00
4/30/2006
-300
-300
Commission on sale:
$20.00
5/15/2006
-300
-300
5/31/2006
-300
-300
6/15/2006
-300
-300
6/30/2006
-300
-300
7/15/2006
-300
-300
7/31/2006
-300
-300
8/4/2006
3,847
3,769
XIRR (2)
31.21%
20.82%
(1) A look-back feature allows purchase at a discount to the price at the start OR the price at the end, whichever is lower. Without the look-back feature, the discount is to the price at the end only.
(2) Annualized return. In order to have the same return, a savings account will have to offer an interest rate matching this number.
