profitability analysis 1.0
TRANSCRIPT
Input SummaryGeneral Information
Process Title:Product:
Plant Site Location:Site Factor: 1.00
Operating Hours per Year: 0Operating Days per Year: 0
Operating Factor: 0.0000
Chronology
Year ActionStart Year 2003 Design 100.0% 100.0% 0.0% #VALUE!
2004 Construction 0.0% #VALUE!2005 Production 45.0% 20.0%2006 Production 67.5% 32.0%2007 Production 90.0% 19.2%2008 Production 90.0% 11.5%2009 Production 90.0% 11.5%2010 Production 90.0% 5.8%2011 Production 90.0% #VALUE!2012 Production 90.0% #VALUE!2013 Production 90.0% #VALUE!2014 Production 90.0% #VALUE!2015 Production 90.0% #VALUE!2016 Production 90.0% #VALUE!2017 Production 90.0% #VALUE!2018 Production 90.0% #VALUE!
End Year 2019 Production 90.0% #VALUE!
Product InformationThe Process will yield: a 0 of per hour.
a 0 of per day.a 0 of per year.
The Price per of is: $ 0.00000
Raw Materials
Equipments Costs
IPE Specifications
Total Direct Materials and Labor Costs: $0Miscellaneous Installation Costs: $0
Material and Labot G&A Overhead and Contractor Fees: $0Contractor Engineering Costs: $0
Indirect Costs: $0
Distribution of Total Permanent Investment
Distribution of Total Working Capital
Production Capacity (% of Design Capacity)
Percentage of Total Capital Investment for
Depreciation
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
*Derived Bare Module Factor
Total Permanent InvestmentCost of Site Preparations: 5.0% of Total Bare Module CostsCost of Service Facilities: 5.0% of Total Bare Module Costs
Allocated Costs for utility plants and related facilities: $0Cost of Contingencies and Contractor Fees: 18.0% of Direct Permanent Investment
Cost of Land: 2.0% of Total Depreciable CapitalCost of Royalties: $0
Cost of Plant Start-Up: 10.0% of Total Depreciable Capital
Working Capital
Accounts Receivable a 30 DaysCash Reservces a 30 DaysAccounts Payable a 30 Days
Utilities
Byproducts - no Byproducts -
Other Variable CostsGeneral Expenses
Selling / Transfer Expenses: 3.00% of SalesDirect Research: 4.80% of Sales
Allocated Research: 0.50% of SalesAdministrative Expense: 2.00% of Sales
Management Incentive Compensation: 1.25% of Sales
Fixed CostsOperations
Operators per Shift: 1 (Assuming 5 Shifts)Direct Wages and Benefits: $30.00 per Operator Hour
Direct Salaries and Benefits: 15.00% of Direct Wages and BenefitsOperating Supplies and Services: 6.00% of Direct Wages and Benefits
Technical Assistance to Manufacturing: $0.00 per year, for each Operator per ShiftControl Laboratory: $0.00 per year, for each Operator per Shift
Maintenance Wages and Benefits: 4.50% of Total Depreciable CapitalSalaries and Benefits: 25.00% of Maintenance Wages and Benefits
Materials and Services: 100.00% of Maintenance Wages and BenefitsMaintenance Overhead: 5.00% of Maintenance Wages and Benefits
Operating Overhead
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
CLICK HERE FOR MENU
General Plant Overhead: 7.10% of Maintenance and Operations Wages and BenefitsMechanical Department Services: 2.40% of Maintenance and Operations Wages and BenefitsEmployee Relations Department: 5.90% of Maintenance and Operations Wages and Benefits
Business Services: 7.40% of Maintenance and Operations Wages and Benefits
Property Taxes and InsuranceProperty Taxes and Insurance: 2.00% of Total Depreciable Capital
Straight Line DepreciationDirect Plant: 8.00% of Total Depreciable Capital, less1.18 times the Allocated Costs for Utility Plants and Related Facilities
Allocated Plant: 6.00% of 1.18 times the Allocated Costs for Utility Plants and Related Facilities
Depletion AllowanceAnnual Depletion Allowance: $0.00
CLICK HERE FOR MENU
Cash Flow SummaryMay, 2014 0
Year Sales Capital Costs Working Capital Variable Costs Fixed Costs Taxable Income Net Earnings
2003 0.0% Design #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2004 0.0% #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2005 45.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2006 67.5% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2007 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2008 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2009 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2010 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2011 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2012 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2013 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2014 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2015 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2016 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2017 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2018 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2019 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2020 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2021 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2022 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2023 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2024 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2025 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2026 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2027 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2028 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2029 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2030 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2031 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2032 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2033 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2034 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2035 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2036 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2037 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2038 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2039 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2040 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2041 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!2042 90.0% $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! $0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Percentage of Design Capacity
Depreciation Allowance
Depletion Allowance
Income Tax Costs
Annual Cash Flow
Cumulative Net Present Value
at 15.0%
IRR Analysis - Two VariableMay, 2014 0
Product Prices vs Variable CostsVariable Costs
Prod
uct P
rices
$17,689,500 $18,209,800 $18,730,100 $19,250,400 $19,770,600 $0.46 17.98% 12.43% 6.18% -1.20% Out of Range $0.47 23.51% 18.52% 13.10% 7.04% -0.04% $0.49 28.55% 23.94% 19.04% 13.74% 7.86% $0.50 33.21% 28.88% 24.35% 19.54% 14.36% $0.51 37.58% 33.47% 29.21% 24.74% 20.03% $0.53 41.71% 37.78% 33.73% 29.52% 25.13% $0.54 45.64% 41.86% 37.97% 33.98% 29.83% $0.55 49.39% 45.74% 42.00% 38.17% 34.22% $0.57 52.99% 49.44% 45.83% 42.14% 38.35% $0.58 56.44% 53.00% 49.49% 45.92% 42.27% $0.59 59.77% 56.42% 53.01% 49.54% 46.01% $0.61 62.99% 59.71% 56.39% 53.02% 49.59%
$0.62 66.10% 62.90% 59.66% 56.37% 53.03%17689520 18209800 18730080 19250360 19770640
Product Prices vs Fixed CostsFixed Costs
Prod
uct P
rices
$972,100 $1,000,700 $1,029,300 $1,057,900 $1,086,400 $0.44 Out of Range Out of Range Out of Range Out of Range Out of Range $0.46 Out of Range Out of Range Out of Range Out of Range Out of Range $0.47 Out of Range Out of Range Out of Range Out of Range Out of Range $0.48 -0.03% -0.53% -1.03% -1.54% -2.05% $0.49 7.00% 6.57% 6.15% 5.72% 5.28% $0.51 12.92% 12.54% 12.15% 11.77% 11.38% $0.52 18.13% 17.78% 17.42% 17.07% 16.71% $0.53 22.86% 22.53% 22.19% 21.85% 21.52% $0.55 27.23% 26.91% 26.58% 26.26% 25.94% $0.56 31.32% 31.00% 30.69% 30.38% 30.07% $0.57 35.18% 34.87% 34.57% 34.27% 33.96% $0.59 38.85% 38.55% 38.25% 37.96% 37.66%
$0.60 42.35% 42.06% 41.77% 41.48% 41.19%972086.35 1000677.125 1029267.9 1057858.675 1086449.45
Product Prices vs Initial InvestmentInitial Investment (TPI)
Prod
uct P
rices
$2,176,000 $2,240,000 $2,304,000 $2,368,000 $2,432,000 $0.44 Out of Range Out of Range Out of Range Out of Range Out of Range $0.46 Out of Range Out of Range Out of Range Out of Range Out of Range $0.47 Out of Range Out of Range Out of Range Out of Range Out of Range $0.48 -1.62% -1.73% -1.84% -1.95% Out of Range
Prod
uct P
rices $0.49 6.04% 5.87% 5.71% 5.55% 5.39%
$0.51 12.43% 12.21% 12.00% 11.79% 11.59% $0.52 18.01% 17.75% 17.50% 17.25% 17.00% $0.53 23.06% 22.76% 22.46% 22.17% 21.88% $0.55 27.70% 27.36% 27.03% 26.70% 26.38% $0.56 32.04% 31.66% 31.29% 30.93% 30.57% $0.57 36.13% 35.72% 35.31% 34.92% 34.53% $0.59 40.01% 39.56% 39.13% 38.70% 38.28%
$0.60 43.72% 43.24% 42.77% 42.31% 41.87%2176000 2240000 2304000 2368000 2432000
Product Prices vs InflationInflation
Prod
uct P
rices
0.00% 0.00% 0.00% 0.00% 0.00% $0.44 Out of Range Out of Range Out of Range Out of Range Out of Range $0.46 Out of Range Out of Range Out of Range Out of Range Out of Range $0.47 Out of Range Out of Range Out of Range Out of Range Out of Range $0.48 Out of Range Out of Range Out of Range Out of Range Out of Range $0.49 5.09% 5.09% 5.09% 5.09% 5.09% $0.51 11.20% 11.20% 11.20% 11.20% 11.20% $0.52 16.53% 16.53% 16.53% 16.53% 16.53% $0.53 21.33% 21.33% 21.33% 21.33% 21.33% $0.55 25.75% 25.75% 25.75% 25.75% 25.75% $0.56 29.88% 29.88% 29.88% 29.88% 29.88% $0.57 33.78% 33.78% 33.78% 33.78% 33.78% $0.59 37.47% 37.47% 37.47% 37.47% 37.47%
$0.60 41.00% 41.00% 41.00% 41.00% 41.00%0 0 0 0 0
Variable vs. Fixed CostsFixed Costs
Varia
ble
Cos
ts
$972,100 $1,000,700 $1,029,300 $1,057,900 $1,086,400 $17,017,000 43.77% 43.46% 43.15% 42.84% 42.54% $17,517,500 39.85% 39.54% 39.23% 38.91% 38.60% $18,018,000 35.83% 35.51% 35.20% 34.88% 34.56% $18,518,500 31.68% 31.36% 31.04% 30.72% 30.40% $19,019,000 27.39% 27.06% 26.73% 26.40% 26.07% $19,519,500 22.89% 22.55% 22.21% 21.87% 21.53% $20,020,000 18.13% 17.78% 17.42% 17.07% 16.71% $20,520,500 13.02% 12.64% 12.26% 11.88% 11.51% $21,021,000 7.39% 6.98% 6.57% 6.15% 5.73% $21,521,500 0.98% 0.52% 0.05% -0.42% -0.90% $22,022,000 Out of Range Out of Range Out of Range Out of Range Out of Range $22,522,500 Out of Range Out of Range Out of Range Out of Range Out of Range
$23,023,000 Out of Range Out of Range Out of Range Out of Range Out of Range972086.35 1000677.125 1029267.9 1057858.675 1086449.45
Variable Costs vs. Initial InvestmentInitial Investment (TPI)
Varia
ble
Cos
ts $2,176,000 $2,240,000 $2,304,000 $2,368,000 $2,432,000
$17,017,000 44.56% 44.04% 43.53% 43.04% 42.56% $17,517,500 40.40% 39.93% 39.46% 39.01% 38.57% $18,018,000 36.13% 35.70% 35.28% 34.87% 34.47% $18,518,500 31.74% 31.35% 30.97% 30.60% 30.24% $19,019,000 27.17% 26.82% 26.49% 26.16% 25.84% $19,519,500 22.38% 22.08% 21.79% 21.51% 21.23% $20,020,000 17.31% 17.05% 16.81% 16.56% 16.33% $20,520,500 11.82% 11.62% 11.41% 11.22% 11.02% $21,021,000 5.75% 5.59% 5.43% 5.28% 5.13% $21,521,500 -1.23% -1.34% -1.44% -1.55% -1.65% $22,022,000 Out of Range Out of Range Out of Range Out of Range Out of Range $22,522,500 Out of Range Out of Range Out of Range Out of Range Out of Range
$23,023,000 Out of Range Out of Range Out of Range Out of Range Out of Range2176000 2240000 2304000 2368000 2432000
Variable Costs vs. InflationInflation
Varia
ble
Cos
ts
0.00% 0.00% 0.00% 0.00% 0.00% $17,017,000 41.63% 41.63% 41.63% 41.63% 41.63% $17,517,500 37.71% 37.71% 37.71% 37.71% 37.71% $18,018,000 33.69% 33.69% 33.69% 33.69% 33.69% $18,518,500 29.54% 29.54% 29.54% 29.54% 29.54% $19,019,000 25.22% 25.22% 25.22% 25.22% 25.22% $19,519,500 20.68% 20.68% 20.68% 20.68% 20.68% $20,020,000 15.87% 15.87% 15.87% 15.87% 15.87% $20,520,500 10.65% 10.65% 10.65% 10.65% 10.65% $21,021,000 4.84% 4.84% 4.84% 4.84% 4.84% $21,521,500 -1.85% -1.85% -1.85% -1.85% -1.85% $22,022,000 Out of Range Out of Range Out of Range Out of Range Out of Range $22,522,500 Out of Range Out of Range Out of Range Out of Range Out of Range
$23,023,000 Out of Range Out of Range Out of Range Out of Range Out of Range0 0 0 0 0
Fixed Costs vs Initial InvestmentInitial Investment (TPI)
Fixe
d C
osts
$2,176,000 $2,240,000 $2,304,000 $2,368,000 $2,432,000 $972,100 19.72% 19.44% 19.17% 18.90% 18.64%
$1,000,700 19.35% 19.07% 18.80% 18.54% 18.28% $1,029,300 18.97% 18.70% 18.43% 18.17% 17.92% $1,057,900 18.59% 18.32% 18.06% 17.81% 17.55% $1,086,400 18.21% 17.95% 17.69% 17.44% 17.19% $1,115,000 17.83% 17.57% 17.32% 17.07% 16.83% $1,143,600 17.45% 17.20% 16.95% 16.70% 16.46% $1,172,200 17.07% 16.82% 16.57% 16.33% 16.10%
Fixe
d C
osts
$1,200,800 16.69% 16.44% 16.20% 15.96% 15.73% $1,229,400 16.31% 16.06% 15.82% 15.59% 15.36% $1,258,000 15.93% 15.69% 15.45% 15.22% 14.99% $1,286,600 15.54% 15.30% 15.07% 14.84% 14.62%
$1,315,200 15.16% 14.92% 14.69% 14.47% 14.25%2176000 2240000 2304000 2368000 2432000
Fixed Costs vs. InflationInflation
Fixe
d C
osts
0.00% 0.00% 0.00% 0.00% 0.00% $972,100 18.13% 18.13% 18.13% 18.13% 18.13%
$1,000,700 17.78% 17.78% 17.78% 17.78% 17.78% $1,029,300 17.42% 17.42% 17.42% 17.42% 17.42% $1,057,900 17.07% 17.07% 17.07% 17.07% 17.07% $1,086,400 16.71% 16.71% 16.71% 16.71% 16.71% $1,115,000 16.35% 16.35% 16.35% 16.35% 16.35% $1,143,600 16.00% 16.00% 16.00% 16.00% 16.00% $1,172,200 15.64% 15.64% 15.64% 15.64% 15.64% $1,200,800 15.27% 15.27% 15.27% 15.27% 15.27% $1,229,400 14.91% 14.91% 14.91% 14.91% 14.91% $1,258,000 14.55% 14.55% 14.55% 14.55% 14.55% $1,286,600 14.19% 14.19% 14.19% 14.19% 14.19%
$1,315,200 13.82% 13.82% 13.82% 13.82% 13.82%0 0 0 0 0
Initial Investment vs InflationInflation
Initi
al In
vest
men
t (TP
I)
0.00% 0.00% 0.00% 0.00% 0.00% $2,176,000 17.31% 17.31% 17.31% 17.31% 17.31% $2,240,000 17.05% 17.05% 17.05% 17.05% 17.05% $2,304,000 16.81% 16.81% 16.81% 16.81% 16.81% $2,368,000 16.56% 16.56% 16.56% 16.56% 16.56% $2,432,000 16.33% 16.33% 16.33% 16.33% 16.33% $2,496,000 16.09% 16.09% 16.09% 16.09% 16.09% $2,560,000 15.87% 15.87% 15.87% 15.87% 15.87% $2,624,000 15.64% 15.64% 15.64% 15.64% 15.64% $2,688,000 15.42% 15.42% 15.42% 15.42% 15.42% $2,752,000 15.21% 15.21% 15.21% 15.21% 15.21% $2,816,000 15.00% 15.00% 15.00% 15.00% 15.00% $2,880,000 14.79% 14.79% 14.79% 14.79% 14.79%
$2,944,000 14.59% 14.59% 14.59% 14.59% 14.59%
IRR Analysis - Two Variable0
Variable Costs
$20,290,900 $20,811,200 $21,331,500 $21,851,800 $22,372,000 $22,892,300 $23,412,600 Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
1.06% Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range8.64% 2.09% Out of Range Out of Range Out of Range Out of Range Out of Range
14.96% 9.39% 3.06% Out of Range Out of Range Out of Range Out of Range20.50% 15.53% 10.10% 3.98% Out of Range Out of Range Out of Range25.51% 20.95% 16.09% 10.79% 4.86% -2.05% Out of Range30.13% 25.87% 21.39% 16.62% 11.45% 5.69% -0.95%34.45% 30.42% 26.23% 21.82% 17.14% 12.08% 6.48%38.53% 34.68% 30.71% 26.57% 22.24% 17.65% 12.70%42.40% 38.71% 34.91% 30.98% 26.91% 22.64% 18.13%46.10% 42.53% 38.88% 35.13% 31.26% 27.24% 23.04%
49.64% 46.19% 42.66% 39.05% 35.34% 31.52% 27.56%20290920 20811200 21331480 21851760 22372040 22892320 23412600
Fixed Costs
$1,115,000 $1,143,600 $1,172,200 $1,200,800 $1,229,400 $1,258,000 $1,286,600 Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
-2.57% -3.10% -3.63% Out of Range Out of Range Out of Range Out of Range4.85% 4.41% 3.96% 3.52% 3.07% 2.62% 2.16%
11.00% 10.61% 10.21% 9.82% 9.43% 9.03% 8.63%16.35% 16.00% 15.64% 15.27% 14.91% 14.55% 14.19%21.18% 20.84% 20.50% 20.16% 19.83% 19.49% 19.14%25.62% 25.29% 24.97% 24.65% 24.32% 24.00% 23.68%29.76% 29.45% 29.13% 28.82% 28.51% 28.20% 27.88%33.66% 33.36% 33.05% 32.75% 32.45% 32.15% 31.84%37.36% 37.07% 36.77% 36.48% 36.18% 35.88% 35.59%
40.90% 40.61% 40.32% 40.03% 39.74% 39.45% 39.16%1115040.225 1143631 1172221.775 1200812.55 1229403.325 1257994.1 1286584.875
Initial Investment (TPI)
$2,496,000 $2,560,000 $2,624,000 $2,688,000 $2,752,000 $2,816,000 $2,880,000 Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range -2.36% -2.46% -2.56% -2.66% -2.75%
5.24% 5.09% 4.94% 4.79% 4.65% 4.51% 4.37%11.39% 11.20% 11.01% 10.82% 10.63% 10.45% 10.27%16.76% 16.53% 16.29% 16.07% 15.85% 15.63% 15.42%21.61% 21.33% 21.07% 20.80% 20.55% 20.29% 20.05%26.06% 25.75% 25.45% 25.16% 24.87% 24.58% 24.31%30.22% 29.88% 29.55% 29.22% 28.90% 28.59% 28.28%34.15% 33.78% 33.41% 33.06% 32.71% 32.36% 32.03%37.87% 37.47% 37.08% 36.69% 36.32% 35.95% 35.58%
41.43% 41.00% 40.58% 40.17% 39.76% 39.37% 38.98%2496000 2560000 2624000 2688000 2752000 2816000 2880000
Inflation
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
5.09% 5.09% 5.09% 5.09% 5.09% 5.09% 5.09%11.20% 11.20% 11.20% 11.20% 11.20% 11.20% 11.20%16.53% 16.53% 16.53% 16.53% 16.53% 16.53% 16.53%21.33% 21.33% 21.33% 21.33% 21.33% 21.33% 21.33%25.75% 25.75% 25.75% 25.75% 25.75% 25.75% 25.75%29.88% 29.88% 29.88% 29.88% 29.88% 29.88% 29.88%33.78% 33.78% 33.78% 33.78% 33.78% 33.78% 33.78%37.47% 37.47% 37.47% 37.47% 37.47% 37.47% 37.47%
41.00% 41.00% 41.00% 41.00% 41.00% 41.00% 41.00%0 0 0 0 0 0 0
Fixed Costs
$1,115,000 $1,143,600 $1,172,200 $1,200,800 $1,229,400 $1,258,000 $1,286,600 42.23% 41.92% 41.61% 41.30% 40.99% 40.68% 40.37%38.29% 37.98% 37.67% 37.35% 37.04% 36.73% 36.42%34.25% 33.93% 33.62% 33.30% 32.98% 32.66% 32.35%30.07% 29.75% 29.43% 29.11% 28.78% 28.46% 28.14%25.74% 25.41% 25.08% 24.74% 24.41% 24.08% 23.75%21.19% 20.84% 20.50% 20.16% 19.82% 19.47% 19.13%16.35% 16.00% 15.64% 15.27% 14.91% 14.55% 14.19%11.12% 10.74% 10.35% 9.97% 9.58% 9.19% 8.80%5.31% 4.89% 4.46% 4.04% 3.60% 3.17% 2.73%
-1.38% -1.87% -2.36% -2.85% -3.36% Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range1115040.225 1143631 1172221.775 1200812.55 1229403.325 1257994.1 1286584.875
Initial Investment (TPI)
$2,496,000 $2,560,000 $2,624,000 $2,688,000 $2,752,000 $2,816,000 $2,880,000 42.09% 41.63% 41.17% 40.73% 40.30% 39.88% 39.46%38.13% 37.71% 37.30% 36.89% 36.49% 36.11% 35.73%34.07% 33.69% 33.31% 32.94% 32.58% 32.23% 31.88%29.88% 29.54% 29.20% 28.86% 28.54% 28.22% 27.91%25.52% 25.22% 24.92% 24.62% 24.33% 24.05% 23.77%20.95% 20.68% 20.42% 20.16% 19.91% 19.66% 19.42%16.09% 15.87% 15.64% 15.42% 15.21% 15.00% 14.79%10.83% 10.65% 10.46% 10.28% 10.11% 9.93% 9.76%4.99% 4.84% 4.70% 4.56% 4.43% 4.29% 4.16%
-1.75% -1.85% -1.95% -2.04% -2.14% -2.23% -2.32%Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range2496000 2560000 2624000 2688000 2752000 2816000 2880000
Inflation
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%41.63% 41.63% 41.63% 41.63% 41.63% 41.63% 41.63%37.71% 37.71% 37.71% 37.71% 37.71% 37.71% 37.71%33.69% 33.69% 33.69% 33.69% 33.69% 33.69% 33.69%29.54% 29.54% 29.54% 29.54% 29.54% 29.54% 29.54%25.22% 25.22% 25.22% 25.22% 25.22% 25.22% 25.22%20.68% 20.68% 20.68% 20.68% 20.68% 20.68% 20.68%15.87% 15.87% 15.87% 15.87% 15.87% 15.87% 15.87%10.65% 10.65% 10.65% 10.65% 10.65% 10.65% 10.65%4.84% 4.84% 4.84% 4.84% 4.84% 4.84% 4.84%
-1.85% -1.85% -1.85% -1.85% -1.85% -1.85% -1.85%Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of RangeOut of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range
Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range Out of Range0 0 0 0 0 0 0
Initial Investment (TPI)
$2,496,000 $2,560,000 $2,624,000 $2,688,000 $2,752,000 $2,816,000 $2,880,00018.38% 18.13% 17.89% 17.65% 17.41% 17.18% 16.95%18.03% 17.78% 17.54% 17.30% 17.06% 16.84% 16.61%17.67% 17.42% 17.18% 16.95% 16.72% 16.49% 16.27%17.31% 17.07% 16.83% 16.60% 16.37% 16.15% 15.93%16.95% 16.71% 16.48% 16.25% 16.03% 15.81% 15.59%16.59% 16.35% 16.12% 15.90% 15.68% 15.46% 15.25%16.23% 16.00% 15.77% 15.55% 15.33% 15.12% 14.91%15.86% 15.64% 15.41% 15.19% 14.98% 14.77% 14.56%
15.50% 15.27% 15.05% 14.84% 14.63% 14.42% 14.22%15.13% 14.91% 14.70% 14.48% 14.28% 14.07% 13.87%14.77% 14.55% 14.34% 14.13% 13.92% 13.72% 13.52%14.40% 14.19% 13.98% 13.77% 13.57% 13.37% 13.17%
14.04% 13.82% 13.62% 13.41% 13.21% 13.02% 12.83%2496000 2560000 2624000 2688000 2752000 2816000 2880000
Inflation
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%18.13% 18.13% 18.13% 18.13% 18.13% 18.13% 18.13%17.78% 17.78% 17.78% 17.78% 17.78% 17.78% 17.78%17.42% 17.42% 17.42% 17.42% 17.42% 17.42% 17.42%17.07% 17.07% 17.07% 17.07% 17.07% 17.07% 17.07%16.71% 16.71% 16.71% 16.71% 16.71% 16.71% 16.71%16.35% 16.35% 16.35% 16.35% 16.35% 16.35% 16.35%16.00% 16.00% 16.00% 16.00% 16.00% 16.00% 16.00%15.64% 15.64% 15.64% 15.64% 15.64% 15.64% 15.64%15.27% 15.27% 15.27% 15.27% 15.27% 15.27% 15.27%14.91% 14.91% 14.91% 14.91% 14.91% 14.91% 14.91%14.55% 14.55% 14.55% 14.55% 14.55% 14.55% 14.55%14.19% 14.19% 14.19% 14.19% 14.19% 14.19% 14.19%
13.82% 13.82% 13.82% 13.82% 13.82% 13.82% 13.82%0 0 0 0 0 0 0
Inflation
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%17.31% 17.31% 17.31% 17.31% 17.31% 17.31% 17.31%17.05% 17.05% 17.05% 17.05% 17.05% 17.05% 17.05%16.81% 16.81% 16.81% 16.81% 16.81% 16.81% 16.81%16.56% 16.56% 16.56% 16.56% 16.56% 16.56% 16.56%16.33% 16.33% 16.33% 16.33% 16.33% 16.33% 16.33%16.09% 16.09% 16.09% 16.09% 16.09% 16.09% 16.09%15.87% 15.87% 15.87% 15.87% 15.87% 15.87% 15.87%15.64% 15.64% 15.64% 15.64% 15.64% 15.64% 15.64%15.42% 15.42% 15.42% 15.42% 15.42% 15.42% 15.42%15.21% 15.21% 15.21% 15.21% 15.21% 15.21% 15.21%15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00%14.79% 14.79% 14.79% 14.79% 14.79% 14.79% 14.79%
14.59% 14.59% 14.59% 14.59% 14.59% 14.59% 14.59%
Variable Costs
$23,932,900 Out of RangeOut of RangeOut of RangeOut of RangeOut of RangeOut of RangeOut of RangeOut of Range
0.08%7.25%
13.28%18.60%
23.42%23932880
Fixed Costs
$1,315,200 Out of RangeOut of RangeOut of RangeOut of Range
1.70%8.23%
13.82%18.80%23.35%27.57%31.54%35.29%
38.87%1315175.65
Initial Investment (TPI)
$2,944,000 Out of RangeOut of RangeOut of Range
-2.85%
4.24%10.10%15.21%19.81%24.03%27.98%31.70%35.23%
38.60%2944000
Inflation
0.00%Out of RangeOut of RangeOut of RangeOut of Range
5.09%11.20%16.53%21.33%25.75%29.88%33.78%37.47%
41.00%0
Fixed Costs
$1,315,200 40.06%36.11%32.03%27.82%23.42%18.78%13.82%8.40%2.29%
Out of RangeOut of RangeOut of Range
Out of Range1315175.65
Initial Investment (TPI)
$2,944,000 39.06%35.35%31.54%27.60%23.50%19.18%14.59%9.60%4.03%
-2.41%Out of RangeOut of Range
Out of Range2944000
Inflation
0.00%41.63%37.71%33.69%29.54%25.22%20.68%15.87%10.65%4.84%
-1.85%Out of RangeOut of Range
Out of Range0
Initial Investment (TPI)
$2,944,00016.73%16.39%16.05%15.72%15.38%15.04%14.70%14.36%
14.02%13.67%13.33%12.98%
12.64%2944000
Inflation
0.00%18.13%17.78%17.42%17.07%16.71%16.35%16.00%15.64%15.27%14.91%14.55%14.19%
13.82%0
Inflation
0.00%17.31%17.05%16.81%16.56%16.33%16.09%15.87%15.64%15.42%15.21%15.00%14.79%
14.59%