Year 016 Year 017 Year 018 Year 019 Year 020 TOTAL

Sales Projection 600,000 825,000 1,080,000 1,400,000 1,540,000 5,445,000

Units 4 5 6 7 7 29
COGS Projection 360,000 495,000 648,000 840,000 924,000 3,267,000
0
Gross Profit 240,000 330,000 432,000 560,000 616,000 2,178,000
Percentage of sales 40% 40% 40% 40% 40% 40%
Project Expenses

Rent & Outgoings 75,000 75,000 75,000 75,000 75,000 375,000

Wages - Office 10,800 10,800 10,800 12,000 12,000 56,400
Wages - Mktg 14,400 14,400 14,400 15,800 15,800 74,800
Additional Wages & Oncost Eng *1 28,800 28,800 28,800 31,600 31,600 149,600
Wages oncosts Techn * 4 57,600 57,600 57,600 63,400 63,400 299,600
Foreman 16,800 16,800 16,800 18,500 18,500 87,400
0
0
Electricity 12,000 12,000 12,001 12,002 12,003 60,006
Insurance - Incl W/Compn 2,200 2,200 2,200 2,200 2,200 11,000
Legal Fees 3,000 3,000 3,000 3,000 3,000 15,000
Auditing 4,000 4,000 4,000 4,000 4,000 20,000
Printings & Stationaries 6,000 6,000 6,000 6,000 6,000 30,000
Fuel & Maintenance 2 cars 6,000 6,000 6,000 6,000 6,000 30,000
Telephone 8,500 8,500 8,500 8,500 8,500 42,500
Travel & entertainment 5,000 5,000 5,000 5,000 5,000 25,000
0
Total Exps 250,100 250,100 250,101 263,002 263,003 1,276,306

Less Depreciation 5,000 5,000 5,000 5,000 5,000 25,000

Income Tax 10,935 26,385 43,800 52,200 133,319
Contingency cost 4,000 2,000 1,000 0 0 7,000
Cash Inflow (Outflow) (19,100) 61,965 149,514 248,198 295,797 736,375

% of projected sales Ratios

Operating Expense 19% 14% 11% 8% 8% 0.065647
Labour Expense 54% 39% 30% 25% 23% 7%
Total Property Rent 31% 23% 17% 13% 12% 0.402486
Net Profit/(Loss) before tax -8% 19% 35% 44% 48% 0.013607
Break Even 4.17 3.79 3.47 3.29 2.99

Vision:
Owner will contribute to the calculation of the COGS and the gross Profit %
Provides sales projection taking into accounts all sensitive market factors including competition and risks mentioned in the analysis.
Sensitivity Analysis
Should allow a provision for incertain variables like:
Interest rates changes
Inflation Rates
Head Counts
Budgeted operating expenses
Currency Exchange rates
 Year 016 Year 017 Year 018 Year 019 Year 020
Sales Projection 600,000 825,000 1,080,000 1,400,000 1,760,000
Units 4 5 6 7 7
COGS Projection 360,000 495,000 648,000 840,000 1,056,000

Gross Profit 240,000 330,000 432,000 560,000 704,000

Percentage of sales 40% 40% 40% 40% 40%
Project Expenses

Rent & Outgoings 75,000 75,000 75,000 75,000 75,000

Wages - Office 13,660 13,660 13,660 15,000 15,000
Wages - Mktg 16,676 16,676 16,676 18,500 18,500
Additional Wages & Oncost Eng *1 30,760 30,760 30,760 34,800 34,800
Wages oncosts Techn * 4 71,504 71,504 71,504 78,750 78,750
Foreman 19,548 19,548 19,548 21,500 21,500

Electricity 12,000 12,000 12,000 12,000 12,000

Insurance - Incl W/Compn 4,000 4,000 4,000 4,000 4,000
Legal Fees 3,000 3,000 3,000 3,000 3,000
Auditing 4,000 4,000 4,000 4,000 4,000
Printings & Stationaries 6,000 6,000 6,000 6,000 6,000
Fuel & Maintenance 2 cars 6,000 6,000 6,000 6,000 6,000
Telephone 5,000 5,000 5,000 5,000 5,000
Travel & entertainment 5,000 5,000 5,000 5,000 5,000

Total Exps 272,148 272,148 272,148 288,550 288,550

Less Depreciation 5,000 5,000 5,000 5,000 5,000

Income Tax 0 7,628 23,078 39,968 48,368
Contingency cost 4,000 2,000 1,000 0 0
Cash Inflow (Outflow) (41,148) 43,224 130,774 226,483 362,083

% of projected sales Ratios

Operating Expense 19% 14% 10% 8% 6%
Labour Expense 63% 46% 35% 30% 24%
Total Property Rent 31% 23% 17% 13% 11%
Net Profit/(Loss) before tax -17% 13% 30% 40% 51%

Break Even 4.54 4.12 3.78 3.61 2.87

Vision:
Owner will contribute to the calculation of the COGS and the gross Profit %
Provides sales projection taking into accounts all sensitive market factors including competition and risks men
Sensitivity Analysis
Should allow a provision for incertain variables like:
Interest rates changes
Inflation Rates
Head Counts
Budgeted operating expenses
Currency Exchange rates
 TOTAL
5,665,000
29
3,399,000
0
2,266,000
40%

375,000
70,980
87,028
161,880
372,012
101,644
0
0
60,000
20,000
15,000
20,000
30,000
30,000
25,000
25,000

1,393,544

25,000
119,041
7,000
721,415

0
70%
86%
ding competition and risks mentioned in the analysis.
 Year 016 Year 017 Year 018 Year 019 Year 020 TOTAL
Sales Projection 900,000 1,320,000 1,800,000 2,400,000 3,300,000 9,720,000
Units 6 8 10 12 15 51
COGS Projection 540,000 858,000 1,260,000 1,800,000 2,475,000 6,933,000
0
Gross Profit 360,000 462,000 540,000 600,000 825,000 2,787,000
Percentage of sales 40% 35% 30% 25% 25% 29%
Project Expenses

Rent & Outgoings 75,000 75,000 75,000 75,000 75,000 375,000

Wages - Office 13,660 13,660 13,660 15,000 15,000 70,980
Wages - Mktg 16,676 16,676 16,676 18,500 18,500 87,028
Additional Wages Oncost Eng *1 30,760 30,760 30,760 34,800 34,800 161,880
Wages Oncosts Techn * 4 71,504 71,504 71,504 78,750 78,750 372,012
Foreman 19,548 19,548 19,548 21,500 21,500 101,644
0
0
Electricity 12,000 12,000 12,000 12,000 12,000 60,000
Insurance - Incl W/Compn 4,000 4,000 4,000 4,000 4,000 20,000
Legal Fees 4,000 4,000 4,000 4,000 4,000 20,000
Auditing 4,000 4,000 4,000 4,000 4,000 20,000
Printings & Stationaries 6,000 6,000 6,000 6,000 6,000 30,000
Fuel & Maintenance 2 cars 6,000 6,000 6,000 6,000 6,000 30,000
Telephone 5,000 5,000 5,000 5,000 5,000 25,000
Travel & entertainment 10,000 10,000 10,000 10,000 10,000 50,000
0
Total Exps 278,148 278,148 278,148 294,550 294,550 1,423,544

Less Depreciation 5,000 5,000 5,000 5,000 5,000 25,000

Income Tax 10,928 26,528 38,378 45,068 78,818 199,718
Contingency cost 4,000 2,000 1,000 0 0 7,000
Cash Inflow (Outflow) 61,924 150,324 217,474 255,383 446,633 1,131,738
% of projected sales Ratios
Operating Expense 14% 11% 9% 9% 6%
Labour Expense 42% 33% 28% 28% 20%
Total Property Rent 21% 16% 14% 13% 9%
Net Profit/(Loss) before tax 17% 33% 40% 43% 54%

Break Even 4.64 4.82 5.15 5.89 5.36

Vision:
Owner will contribute to the calculation of the COGS and the gross Profit %
Provides sales projection taking into accounts all sensitive market factors including competition and risks mentioned in the analysis.
Sensitivity Analysis
Should allow a provision for incertain variables like:
Interest rates changes
Inflation Rates
Head Counts
Budgeted operating expenses
Currency Exchange rates
MENU
BACK TO INPUTS
FORWARD TO RETURN ON INVESTMENT

This sheet summaries income, expenses and net profit. There are no inputs on this sheet

Gross Sales
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
Salsa $0 $700,000 $735,000 $771,750 $810,338 $850,854 $893,397
B $0 $0 $0 $0 $0 $0 $0
C $0 $0 $0 $0 $0 $0 $0
D $0 $0 $0 $0 $0 $0 $0

Total $0 $700,000 $735,000 $771,750 $810,338 $850,854 $893,397

Expenses
Variable $0 $580,900 $600,709 $621,416 $643,065 $665,703 $689,377
Fixed $0 $91,711 $120,434 $96,863 $80,438 $71,341 $66,745
Other $65,000 $30,000 $30,300 $30,603 $30,909 $31,218 $31,530

Total Expenses $65,000 $702,611 $751,443 $748,882 $754,413 $768,261 $787,652

Before Tax Profit ($65,000) ($2,611) ($16,443) $22,868 $55,925 $82,593 $105,745

Tax $ - $ - $ - $ 6,860 $ 16,777 $ 24,778 $ 31,724

After Tax Profit ($65,000) ($2,611) ($16,443) $16,007 $39,147 $57,815 $74,022

Estimate of Cash Flows

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
After Tax Profits $ (65,000.00) $ (2,611) $ (16,443) $ 16,007 $ 39,147 $ 57,815 $ 74,022
Depreciation $ - $ 47,115 $ 76,815 $ 54,311 $ 39,049 $ 31,217 $ 27,998
Principle $ - $ 16,275 $ 17,496 $ 18,808 $ 20,219 $ 21,735 $ 23,365
Cash Flow $ (65,000) $ 28,228 $ 42,876 $ 51,510 $ 57,977 $ 67,296 $ 78,654
(does not consider increases or decreases in working capital loan)
 Year 7 Year 8 Year 9 Year 10
$938,067 $984,970 $1,034,219 $1,085,930
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0

$938,067 $984,970 $1,034,219 $1,085,930

$714,138 $740,041 $767,141 $795,497

$62,073 $50,614 $39,037 $37,124
$31,846 $32,164 $32,486 $32,811

$808,057 $822,819 $838,664 $865,431

$130,010 $162,151 $195,555 $220,499

$ 39,003 $ 48,645 $ 58,666 $ 66,150

$91,007 $113,506 $136,888 $154,349

Year 7 Year 8 Year 9 Year 10

$ 91,007 $ 113,506 $ 136,888 $ 154,349
$ 24,823 $ 14,989 $ 5,177 $ 5,177
$ 25,118 $ 27,002 $ 29,027 $ 31,204
$ 90,712 $ 101,493 $ 113,038 $ 128,322
INPUT CAPITAL STRUCTURE AND
EXPENSE INFORMATION
Percent Financed 50.00%
Long Term Interest Rate 8%
Loan Term 10
Total Plant Property & Equip $20,000
Loan Amount $10,000
Working Capital $50,000
Short Term Interest Rate 6%

Tax Information
Property Tax as % of Prop and Plant 0.50%
Income Tax Rate 30.00%

Payroll Information
% of Payroll Tax to Salaries 5.00%
% of Retirement Tax to Salaries 15.00%
% of Employee INS Tax to Salaries 10.00%
Benefits as % of Salaries 30.00%
Wage Inflation 1.00%

Utilities There are also inputs on the "Personnel Expense", "Dep

Electricity/month $ 1,000
Water/month $ 250
Gas/month $ 1,000
Telephone/month $ 200
Total Utilities $ 2,450

Other
Expense Inflation Rate 1.00%
Maintenance as % of Plant & Equip 3%
Insurance as % of Plant & Equip 2%
Discount rate for NPV calculation 12%
 INPUT PRODUCTS, INITIAL VOLUME, MARGIN PER UNIT AND
ANTICIPATED SALES GROWTH RATE
Product Name Salsa
Units cases
Initial Volume 20,000
Sales growth 5%
Price/unit $ 35.00

Product Name C
Units lbs
Initial Volume 0
Sales growth 0%
Price/unit $ -

VARIABLE COST OF PRODUCTION PER UNIT

Product Unit VC/unit
Salsa cases $ 17.50
B lbs $ -
C lbs $ -
D lbs $ -

There are also inputs on the "Personnel Expense", "Depreciation", & "Expense Projection" sheets

MENU
FORWARD TO PERSONNEL EXPENSE
FORWARD TO DEPRECIATION
FORWARD TO EXPENSE PROJECTION
FORWARD TO OPERATIONS SUMMARY
FORWARD TO RETURN ON INVESTMENT
BACK TO INTRODUCTION
 Product Name B
Units lbs
Initial Volume 0
Sales growth 1%
Price/unit $ 100.00

Product Name D
Units lbs
Initial Volume 0
Sales growth 0%
Price/unit $ -

nse Projection" sheets

MENU
BACK TO INPUTS
FORWARD TO RETURN ON INVESTMENT
FORWARD TO OPERATIONS SUMMARY
Sales Projections
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
Salsa cases 20,000 21,000 22,050 23,153 24,310 25,526
B lbs 0 0 0 0 0 0
C lbs 0 0 0 0 0 0
D lbs 0 0 0 0 0 0
20,000 21,000 22,050 23,153 24,310 25,526
Gross Sales Projection
This sheet summaries the volume and price and sales growth information from the input page. There is no input on th

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6

Salsa
Total Volume 20,000 21,000 22,050 23,153 24,310 25,526
Price/Unit $35.00 $35.00 $35.00 $35.00 $35.00 $35.00
Gross Sales $700,000 $735,000 $771,750 $810,338 $850,854 $893,397

B
Total Volume 0 0 0 0 0 0
Price/Unit $100.000 $100.000 $100.000 $100.000 $100.000 $100.000
Gross Sales $0 $0 $0 $0 $0 $0

C
Total Volume 0 0 0 0 0 0
Price/Unit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0

D
Total Volume 0 0 0 0 0 0
Price/Unit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0

TOTAL GROSS SALES $700,000 $735,000 $771,750 $810,338 $850,854 $893,397

Production Expense
Salsa $ 350,000 $ 367,500 $ 385,875 $ 405,169 $ 425,427 $ 446,699
B $ - $ - $ - $ - $ - $ -
C $ - $ - $ - $ - $ - $ -
D $ - $ - $ - $ - $ - $ -
TOTAL VARIABLE EXP. $ 350,000 $ 367,500 $ 385,875 $ 405,169 $ 425,427 $ 446,699
 Year 7 Year 8 Year 9 Year 10
26,802 28,142 29,549 31,027
0 0 0 0
0 0 0 0
0 0 0 0
26,802 28,142 29,549 31,027

There is no input on this page.

Year 7 Year 8 Year 9 Year 10

26,802 28,142 29,549 31,027

$35.00 $35.00 $35.00 $35.00
$938,067 $984,970 $1,034,219 $1,085,930

0 0 0 0
$100.000 $100.000 $100.000 $100.000
$0 $0 $0 $0

0 0 0 0
$0.00 $0.00 $0.00 $0.00
$0 $0 $0 $0

0 0 0 0
$0.00 $0.00 $0.00 $0.00
$0 $0 $0 $0

$938,067 $984,970 $1,034,219 $1,085,930

$ 469,033 $ 492,485 $ 517,109 $ 542,965

$ - $ - $ - $ -
$ - $ - $ - $ -
$ - $ - $ - $ -
$ 469,033 $ 492,485 $ 517,109 $ 542,965
MENU
BACK TO INPUTS
FORWARD TO RETURN ON INVESTMENT
FORWARD TO OPERATIONS SUMMARY

This sheet calculates loan amortization and interest. There are no inputs on this sheet.

Total Investment $460,500

Long Term Interest Rate 7.50%
Percent Financed 50.00%
Loan Amount $230,250
Loan Term 10

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7

Beginning Balance $230,250 $213,975 $196,478 $177,670 $157,451 $135,716 $112,350
Interest Rate 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50%
Interest $17,269 $16,048 $14,736 $13,325 $11,809 $10,179 $8,426

Annual Payment $33,544 $33,544 $33,544 $33,544 $33,544 $33,544 $33,544

Principal $16,275 $17,496 $18,808 $20,219 $21,735 $23,365 $25,118

Ending Balance $213,975 $196,478 $177,670 $157,451 $135,716 $112,350 $87,233

Working Capital $50,000

Short Term Interest Rate 6.00%
Interest Amount $3,000

Total Interest Expense $20,269 $19,048 $17,736 $16,325 $14,809 $13,179 $11,426
Year 8 Year 9 Year 10
$87,233 $60,231 $31,204
7.50% 7.50% 7.50%
$6,542 $4,517 $2,340

$33,544 $33,544 $33,544

$27,002 $29,027 $31,204

$60,231 $31,204 $0

$9,542 $7,517 $5,340

MENU
BACK TO INPUTS
FORWARD TO RETURN ON INVESTMENT
FORWARD TO OPERATIONS SUMMARY

This Sheet summaries expenses. The only input is for "supplies and miscellaneous" expenses.

Labor Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6

Salaries $ 150,000 $ 151,500 $ 153,015 $ 154,545 $ 156,091 $ 157,652
Benefits $ 45,000 $ 45,450 $ 45,905 $ 46,364 $ 46,827 $ 47,295
Overtime $ 6,500 $ 6,565 $ 6,631 $ 6,697 $ 6,764 $ 6,832

Total Labor $ - $ 201,500 $ 203,515 $ 205,550 $ 207,606 $ 209,682 $ 211,779

Production Expenses $ 350,000 $ 367,500 $ 385,875 $ 405,169 $ 425,427 $ 446,699

Utilities $ 29,400 $ 29,694 $ 29,991 $ 30,291 $ 30,594 $ 30,900

Total Variable $ - $ 580,900 $ 600,709 $ 621,416 $ 643,065 $ 665,703 $ 689,377

Fixed
Maintenance $ 13,215 $ 13,347 $ 13,481 $ 13,615 $ 13,752 $ 13,889

Insurance $ 8,810 $ 8,898 $ 8,987 $ 9,077 $ 9,168 $ 9,259

Property Tax $ 2,303 $ 2,326 $ 2,349 $ 2,372 $ 2,396 $ 2,420

Depreciation $ 47,115 $ 76,815 $ 54,311 $ 39,049 $ 31,217 $ 27,998

Interest $ 20,269 $ 19,048 $ 17,736 $ 16,325 $ 14,809 $ 13,179

Total Fixed $ - $ 91,711 $ 120,434 $ 96,863 $ 80,438 $ 71,341 $ 66,745

Other
Supplies $ 25,000 $ 10,000 $ 10,100 $ 10,201 $ 10,303 $ 10,406 $ 10,510

Miscellaneous $ 40,000 $ 20,000 $ 20,200 $ 20,402 $ 20,606 $ 20,812 $ 21,020

Total Other $ 65,000 $ 30,000 $ 30,300 $ 30,603 $ 30,909 $ 31,218 $ 31,530

Total Expenses $ 65,000 $ 702,611 $ 751,443 $ 748,882 $ 754,413 $ 768,261 $ 787,652

 Year 7 Year 8 Year 9 Year 10
$ 159,228 $ 160,820 $ 162,429 $ 164,053
$ 47,768 $ 48,246 $ 48,729 $ 49,216
$ 6,900 $ 6,969 $ 7,039 $ 7,109

$ 213,896 $ 216,035 $ 218,196 $ 220,378

$ 469,033 $ 492,485 $ 517,109 $ 542,965

$ 31,209 $ 31,521 $ 31,836 $ 32,154

$ 714,138 $ 740,041 $ 767,141 $ 795,497

$ 14,028 $ 14,168 $ 14,310 $ 14,453

$ 9,352 $ 9,446 $ 9,540 $ 9,635

$ 2,444 $ 2,469 $ 2,493 $ 2,518

$ 24,823 $ 14,989 $ 5,177 $ 5,177

$ 11,426 $ 9,542 $ 7,517 $ 5,340

$ 62,073 $ 50,614 $ 39,037 $ 37,124

$ 10,615 $ 10,721 $ 10,829 $ 10,937

$ 21,230 $ 21,443 $ 21,657 $ 21,874

$ 31,846 $ 32,164 $ 32,486 $ 32,811

$ 808,057 $ 822,819 $ 838,664 $ 865,431

0.00%
0.00%
MENU
BACK TO INPUTS
FORWARD TO RETURN ON INVESTMENT
BACK TO OPERATION SUMMARY

This sheet calculates depreciation. You enter descriptions and values for buildings, equipment and other property.

Depreciation
Buildings 39 year Straight Line
Special Purpose Buildings 10 year Straight Line
Equipment and Heavy Rolling Stock7 Yr MACRS with half year convention
Light Trucks and Vehicles 5 Yr MACRS with half year convention

Buildings Special Purpose Buildings

Description Value Salvage
Processing Plant $ 150,000 $ 30,000 Outbuilding
#2 Storage shed
#3 #3
#4 #4
#5 #5
Total Buildings $ 150,000 $ 30,000 Total Special Purpos

Equipment and Heavy Rolling Stock Light Trucks and Vehicles

Description Value
Vegetable cleaning, prep, cutting, etc. equipment $ 75,000 Delivery truck
Steam-jacketed kettles, pouring, etc. $ 65,000 Company car
Portion-controlled canning, lidding, boxing $ 60,000 #3
Conveying and metering equipment $ 20,000 #4
#5 #5
Total Equip and Heavy Rolling Stock $ 220,000 Total Light Trucks a

Total Plant Property and Equipment $ 440,500

Land $ 20,000
Total Land, Plant Property and Equipment $ 460,500

Annual Total Depreciation

Year 1 2 3 4 5
Buildings $3,077 $3,077 $3,077 $3,077 $3,077
Special Purpose Buildings $1,500 $2,100 $2,100 $2,100 $2,100
Equipment and Heavy Rolling Stock $31,438 $53,878 $38,478 $27,478 $19,646
Light Truck and Vehicles $11,100 $17,760 $10,656 $6,394 $6,394

Total Depreciation $47,115 $76,815 $54,311 $39,049 $31,217

Buildings 39 year Straight Line
Special Purpose Buildings 10 year with percentage from table
Equipment and Heavy Rolling Stock7 year with percentage from table
Light Trucks and Vehicles 5 year with percentage from table

Buildings
Cost $150,000
Life 39
Salvage $30,000
Period 39
Depreciation per year for 39 years $3,077

Special Purpose Buildings

Cost $15,000
Life 10

Year Depreciation Rate

1 $1,500 10%
2 $2,100 14%
3 $2,100 14%
4 $2,100 14%
5 $2,100 14%
6 $2,100 14%
7 $2,100 14%
8 $2,100 14%
9 $2,100 14%
10 $2,100 14%

Equipment and Heavy Rolling Stock

Year Depreciation Rate
1 $31,438 14.29%
2 $53,878 24.49%
3 $38,478 17.49%
4 $27,478 12.49%
5 $19,646 8.93%
6 $19,624 8.92%
7 $19,646 8.93%
8 $9,812 4.46%

Light Trucks and Vehicles

Year Depreciation Rate
1 $11,100 20.00%
2 $17,760 32.00%
3 $10,656 19.20%
4 $6,394 11.52%
5 $6,394 11.52%
6 $3,197 5.76%
pment and other property.

Special Purpose Buildings

DescriptioValue
Outbuilding $ 10,000
Storage shed $ 5,000
#3
#4
#5
Total Special Purpos $ 15,000

Light Trucks and Vehicles

Descriptio Value
Delivery truck $ 30,500
Company car $ 25,000
#3
#4
#5
Total Light Trucks a $ 55,500

6 7 8 9 10
$3,077 $3,077 $3,077 $3,077 $3,077
$2,100 $2,100 $2,100 $2,100 $2,100
$19,624 $19,646 $9,812
$3,197

$27,998 $24,823 $14,989 $5,177 $5,177

0.0613
MENU
BACK TO INPUTS
BACK TO OPERATION SUMMARY

This sheet summaries the feasibility of the project. It provides net present value, benefit cost ratio and internal rate of
The only input is the discount rate.

Discount Rate 12.00%

Year 0 1 2 3 4
Gross Margin $700,000 $735,000 $771,750 $810,338
Discount Factor 1 0.892857 0.797194 0.71178 0.635518
PV of Income $0 $625,000 $585,938 $549,316 $514,984

Total Expense $65,000 $702,611 $702,611 $751,443 $748,882

Less Depreciation and Term Interest $64,384 $92,863 $69,047 $52,374

Cash Expenses $65,000 $638,228 $609,748 $682,396 $696,509

Discount Factor 1 0.892857 0.797194 0.71178 0.635518
PV of Expenses $65,000 $569,846 $486,087 $485,716 $442,644

Benefits Less Costs ($65,000) $61,773 $125,252 $89,354 $113,829

PV Benefits Less PV Costs ($65,000) $55,154 $99,850 $63,600 $72,340

Total PV of Income $4,755,395

Total PV of Expenses $4,042,584
Net Present Value $712,812
Internal Rate of Return 132.0%
PV Benefit/PV Cost Ratio 1.18
Return on Assets -14.12% -0.57% -3.57% 3.48% 8.50%
(after tax income/total PPE investment)

Payback Period (years)

(payback period only displayed if less than 10 years)
tio and internal rate of return

5 6 7 8 9 10
$850,854 $893,397 $938,067 $984,970 $1,034,219 $1,085,930
0.567427 0.506631 0.452349 0.403883 0.36061002 0.321973237
$482,798 $452,623 $424,334 $397,813 $372,950 $349,640

$754,413 $768,261 $787,652 $808,057 $822,819 $838,664

$43,025 $38,176 $33,249 $21,531 $9,694 $7,517

$711,387 $730,085 $754,403 $786,526 $813,125 $831,147

0.567427 0.506631 0.452349 0.403883 0.36061002 0.321973237
$403,660 $369,884 $341,253 $317,665 $293,221 $267,607.07

$139,467 $163,312 $183,664 $198,444 $221,094 $254,783

$79,137 $82,739 $83,080 $80,148 $79,729 $82,033

12.55% 16.07% 19.76% 24.65% 29.73% 33.52%

Waterfront City Business park parking - Dbayeh.
Monthly estimated breakdown of costs

Occupation # of staff USD Monthly USD Yearly

Parking supervisor 12 hour shift 1 $600 $7,200

Valet / Driver 1 1 $450 $5,400

Valet / Driver 2 1 $450 $5,400

Exit / Attendant 1 $450 $5,400

Staff retriever 1 $450 $5,400

Total Personnel Costs $2,400 $28,800

Other Costs

Cleaning cost as per the attached price offer $1,500 $18,000

Insurance $800
Signage $600
Uniforms $600
Pass Cards $0
Thermal papers $840
Internet $300
$21,140

Total Cost $49,940

 SELF PARKING TICKET FEES
Timing Self Parking Ticket Fees
0 Hrs to 1Hr LBP 200,000
1Hr to 2Hr LBP 250,000
2Hr to 3Hr LBP 300,000
3Hr to 4Hr LBP 350,000

EMPLOYEES CARS MEMBERSHIP

Area Number of Cars Membership Fees / Month / Car
Employees Cars Membership 100 LBP 400,000