Payback Time Analysis using Spreadsheet
as of 18 April 2010

Payback Time Analysis OCPS Initial Value 3 OCPS Initial Value 4 EPS Initial Value 1 EPS Current Value 2 Sales Initial Value 5 Sales Current Value 6 BVPS Initial Value 7 BVPS Current Value 8 NOPAT 9 Long Term Debt 10 Equity 11 Equity 13 Net Income 12 Long Term Debt 10 Net Income 12 EPS TTM Earnings Growth Rate 15 Future P/E Multipier 16

Original Documets from Google Finance Stock Screener

Google Stock Screnner 1 Garmin GRMN.pdf

Google Stock Screnner 2 Garmin GRMN.pdf

Original Documets from Investools

Balance Sheet Garmin GRMN.pdf

Cash Flow Garmin GRMN.pdf

Income Statement Garmin GRMN.pdf

Trend Analysis Garmin GRMN.pdf

Valuation Analysis Garmin GRMN.pdf

Payback Time Spreadsheet ORIGINAL

Payback Time Spreadsheet Original for Open Office Calc Format

Payback Time Spreadsheet Example for Apple Inc. APPL as of May-26-2010

It is Strongly Suggest that you Download Open Office and use it for the Payback Time Spread Sheet

Download Open Office ver. 3.2 here (153MB)

Virtual Investing Club

Go Back Home
Home