profitability analysis 1.0

17

Click here to load reader

Upload: l7ani

Post on 09-May-2017

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Profitability Analysis 1.0

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

Page 2: Profitability Analysis 1.0

*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

Page 3: Profitability Analysis 1.0

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

Page 4: Profitability Analysis 1.0

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%

Page 5: Profitability Analysis 1.0
Page 6: Profitability Analysis 1.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

Page 7: Profitability Analysis 1.0

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

Page 8: Profitability Analysis 1.0

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%

Page 9: Profitability Analysis 1.0

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%

Page 10: Profitability Analysis 1.0

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%

Page 11: Profitability Analysis 1.0

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

Page 12: Profitability Analysis 1.0

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%

Page 13: Profitability Analysis 1.0

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%

Page 14: Profitability Analysis 1.0

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%

Page 15: Profitability Analysis 1.0

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

Page 16: Profitability Analysis 1.0

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%

Page 17: Profitability Analysis 1.0

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%