© Copyright, 1999, JaxWorks, Inc., All Rights Reserved.
Key Pages
Charts
Ratios
St
Analysis Sheets
Business Planning
Summary Analyses
© Copyright, 1999, Jaxworks, Inc., All Rights Reserved
© Copyright, 1999, JaxWorks, Inc., All Rights Reserved.
© Copyright, 1999, JaxWorks, Inc., All Rights Reserved.
Investment Payback Analysis
Enter Tax Rate Here: 36%
Year: Relevant benefits: Incremental Value of New Business Relevant controllable costs: Excecutive Salaries & Bonus Direct Labor Costs Materials Costs Sales Salary Advertising New General Manager Market research expenses Incremental maintenance Other Costs Total costs EBITDA Less: Depreciation Income before taxes Less: Taxes Net income Plus: Depreciation Minus: Investment Net Cash Flow Cumulative Net Cash Flow Undiscounted payback period:
1 $50,000
2 $150,000
3 $200,000
4 $300,000
5 $500,000
6 $1,000,000
7 $1,500,000
8 $2,000,000
9 $2,500,000
10 $3,000,000
$50,000 $112,000 $55,000 $50,000 $100,000 $55,000 $75,000 $0 $6,000 $503,000 ($453,000) $50,000 ($503,000) ($181,080) ($321,920) $50,000 $500,000 ($771,920) ($771,920) 7.75 Years
$50,000 $136,000 $61,000 $50,000 $50,000 $61,000 $72,000 $5,000 $6,000 $491,000 ($341,000) $50,000 ($391,000) ($140,760) ($250,240) $50,000 $0 ($200,240) ($972,160)
$50,000 $160,000 $65,000 $60,000 $25,000 $65,000 $69,000 $5,000 $6,000 $505,000 ($305,000) $50,000 ($355,000) ($127,800) ($227,200) $50,000 $0 ($177,200) ($1,149,360)
$75,000 $184,000 $70,000 $75,000 $25,000 $70,000 $66,000 $5,000 $6,000 $576,000 ($276,000) $50,000 ($326,000) ($117,360) ($208,640) $50,000 $0 ($158,640) ($1,308,000)
$100,000 $208,000 $77,000 $100,000 $25,000 $77,000 $63,000 $5,000 $8,000 $663,000 ($163,000) $50,000 ($213,000) ($76,680) ($136,320) $50,000 $0 ($86,320) ($1,394,320)
$100,000 $208,000 $84,000 $100,000 $25,000 $84,000 $60,000 $6,000 $10,000 $677,000 $323,000 $50,000 $273,000 $98,280 $174,720 $50,000 $0 $224,720 ($1,169,600)
$100,000 $208,000 $91,000 $100,000 $25,000 $91,000 $57,000 $7,000 $12,000 $691,000 $809,000 $50,000 $759,000 $273,240 $485,760 $50,000 $0 $535,760 ($633,840)
$100,000 $208,000 $98,000 $100,000 $25,000 $98,000 $54,000 $8,000 $14,000 $705,000 $1,295,000 $50,000 $1,245,000 $448,200 $796,800 $50,000 $0 $846,800 $212,960
$100,000 $208,000 $105,000 $100,000 $25,000 $105,000 $51,000 $9,000 $16,000 $719,000 $1,781,000 $50,000 $1,731,000 $623,160 $1,107,840 $50,000 $0 $1,157,840 $1,370,800
$100,000 $208,000 $112,000 $100,000 $25,000 $112,000 $48,000 $10,000 $18,000 $733,000 $2,267,000 $50,000 $2,217,000 $798,120 $1,418,880 $50,000 $0 $1,468,880 $2,839,680
Enter Discount Rate Here: 10%
Discounted Cash Flow Cumulative Discounted Cash Flow Discounted payback period: ($701,745) #N/A 9.78 Years ($165,488) #N/A ($133,133) #N/A ($108,353) #N/A ($53,598) #N/A $126,849 #N/A $274,930 ($701,745) $395,038 ($701,745) $491,037 ($701,745) $566,317 ($701,745)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalu Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis.
If you are involved in financial analysis at any level, or want to learn more about MS Excel and site is invaluable.
JaxWorks Small Business Spreadsheet Factory
and spreadsheets, and associated MS Word, PDF and HTML unctions. These are invaluable small business tools.
se guides are in
r financial
ctivity analysis,
more about MS Excel and other applications in the Office suite this
ess Spreadsheet Factory