AP's Kitchen FS
AP's Kitchen FS
Pre-operating Expenses
Lease 3 month's rent Err:509
Licenses and Permits 15,207
Training 10,000
Uniform 4,000
Promotional expenses 7,500
Office supplies- 3 months 8,350
Office cleaning supplies - 3 months 470
Total Err:509
Working Capital
Funds direct for Lending 3,000,000
Reserve (Deposit to Depository Bank) 2,220,423
Total 5,220,423
-1-
SCHEDULES
No. of Employees
Training 2 10,000.00
Uniforms 2 4,000.00
Total 7,500.00
Kitchen equipment
Food storage 2 doz 80.00 160.00
Muriatic 2 75.00 150.00
Doormat 2 40.00 80.00
Broom 1 80.00 80.00
Total 470.00
Office Equipment
Quantity Cost Amount
Steel Cabinet 1 8,500.00 8,500.00
Desktop Computer 1 26,000.00 26,000.00
Printer-Epson L355 Series 1 6,000.00 6,000.00
Telephone 1 2,500.00 2,500.00
Total 43,000.00
Transportation Equipment
Quantity/Unit Cost Amount
1 Unit Close type multi-cab 1 300,000.00 300,000.00
Total 300,000.00
Working Capital
From the owner 2,500,000.00
Contingency funding 2,677,423.00
Total Start-Up Cost 5,565,950.00
Amount No. Total
Polo 300 1 600.00
slacks 700 1 1,400.00 466.66667
Blouse and Skirt 1000 1 2,000.00 1000
Year 3 4,000.00
500
-
800
400
-
200
5,000
2,500
307
-
500
-
-
-
-
-
-
10,207.00
1 1466.6667
3 1066.6667
2
AP's KITCHEN
-6-
MACC Micro Lending
INTEREST INCOME
Interest Income on Loans 7 1,312,500 1,443,750 1,586,250
Interest Income on Deposits 7 4,441 12,225 12,246
Total 1,316,941 1,455,975 1,598,496
Other Income
Service charge/ fees 2&8 175,000 192,500 211,500
Penalties 8 - 6,000 4,500
Total Other Income 175,000 198,500 216,000
Total Gross Income 1,491,941 1,654,475 1,814,496
Less: Provision for Credit Losses 3 2,000 2,500
Net Income After Provision 1,491,941 1,652,475 1,811,996
OPERATING EXPENSES consolidated bank:
Salaries and Benefits 9 584,218 579,718
19,500 2 mos 604,918
advance 1 mos
Director's & Committee Honorarium 10 30,400 deposit 31,200 32,800
Insurance Expense 11 10,660 10,980 11,309
Rental Expense 12 78,000 78,000 78,000
Office Supplies 13 19,900 20,497 21,112
Repairs and Maintenance 14 5,616 5,784 5,958
Power, Light and Water 15 31,200 32,136 33,100
Taxes, fees and licenses 16 15,207 9,707 10,207
Communication Expense 17 6,000 6,000 6,000
Management and Other Professional fees 18 140,000 151,600 164,360
Traveling Expense 19 6,000 6,180 6,365
Fuel and Lubricants 20 27,180 27,995 28,835
Advertising Fee 21 5,000 5,150 5,305
Depreciation-Leasehold Improvement 4 40,000 40,000 40,000
Depreciation-Office Equipment 4 76,333 76,333 76,333
Depreciation-Furniture & Fixtures 4 40,000 40,000 40,000
Depreciation-Transportation Equipment 4 17,000 17,000 17,000
Total Operating Expense 1,132,714 1,138,281 1,181,603
-7-
INCOME FROM LOANS - SUMMARY
INTEREST ON DEPOSITS
BANKS Deposit Product Amount Rate
Year 1 Interest on DFOB Savings 2,220,423 0.25%
Total
Total, Net of Tax
Savings
Time Deposit
TOTAL
DFOB Year 2
DFOB Year 3
MACC MICRO LENDING
For the period December 31
SCHEDULE
No. of
Interest Service
Year 1 Interest Other Income Accounts
Rate charge Serve
Income
Month Loan Release Total Loan Releases 8,750,000
Less: Collection 5,105,175
January 625,000 15% 93,750 2% 12,500 25 Portfolio Balance 3,644,825
February 500,000 15% 75,000 2% 10,000 20
March 500,000 15% 75,000 2% 10,000 20 5,250,000.00 390
April 625,000 15% 93,750 2% 12,500 25 20
May 625,000 15% 93,750 2% 12,500 25 410
June 625,000 15% 93,750 2% 12,500 30 20
July 875,000 15% 131,250 2% 17,500 35 consolidated bank: consolidated bank: 430
August 750,000 15% 112,500 2% 15,000 20 Borrower's availedBorrower's availed
twice when in a year
twice when in a year
September 875,000 15% 131,250 2% 17,500 35 when they fully thewhen they fully the 1,050,000.00
October 1,000,000 15% 150,000 2% 20,000 40 amount within 6 amount within 6 1,225,000.00
mos. or when theymos. or when they
November 750,000 15% 112,500 2% 15,000 30 paid 50% of their paid 50% of their
December 1,000,000 15% 150,000 2% 20,000 40 loan they can availloan they can avail 875,000.00
renewal renewal
TOTAL 8,750,000 1,312,500 175,000 345.00 13.8
358.8
Assumptions: Target Market is 195 or 30% of the total establishments in Bangkerohan of 650. 40
10%
Cash Collection
Weekly
Amount Collectio Collection in a Loan Balance
n Month
January 500,000.00 0 0 ### 362
February 625,000.00 ### 83,333.33 ### 17.25
March 625,000.00 ### 187,500.00 ###
April 500,000.00 ### 312,500.00 ###
May 750,000.00 ### 375,000.00 ###
June 750,000.00 ### 500,000.00 ###
July 875,000.00 ### 625,000.00 ###
August 375,000.00 ### 687,500.00 ###
September 375,000.00 ### 645,833.33 ###
October 750,000.00 ### 604,166.67 ###
November 375,000.00 ### 645,833.33 ###
December 250,000.00 ### 583,333.33 ###
### 5,250,000.00 ###
No. of
Interest Service
Year 2 Interest Other Income Accounts
Rate charge Serve
Income
Month Loan Release Total Loan Releases 9,625,000
Less: Collection 6,186,351
January 875,000 15% 131,250 2% 17,500 35 Portfolio Balance 3,438,649
February 875,000 15% 131,250 2% 17,500 35
March 750,000 15% 112,500 2% 15,000 30
April 875,000 15% 131,250 2% 17,500 35 362
May 750,000 15% 112,500 2% 15,000 30
June 875,000 15% 131,250 2% 17,500 35
July 875,000 15% 131,250 2% 17,500 35 consolidated bank:
August 625,000 15% 93,750 2% 12,500 25 Borrower's availed
twice when in a year
when they fully the
amount within 6
mos. or when they
paid 50% of their
loan they can avail
renewal
consolidated bank:
Borrower's availed
twice when in a year
September 875,000 15% 131,250 2% 17,500 35 when they fully the
October 750,000 15% 112,500 2% 15,000 30 amount within 6
mos. or when they
November 750,000 15% 112,500 2% 15,000 30 paid 50% of their
December 750,000 15% 112,500 2% 15,000 30 loan they can avail
renewal
TOTAL 9,625,000 1,443,750 192,500 385 15.4
Assumptions: Number of clients who availed loan increase by 10% and 18% increase in loan portfolio.
Cash Collection
Weekly
Amount Collectio Collection in a Loan Balance
n Month
January 750,000.00 0 0 ###
February 750,000.00 ### 125,000.00 ###
March 750,000.00 ### 250,000.00 ###
April 625,000.00 ### 375,000.00 ###
May 875,000.00 ### 479,166.67 ###
June 750,000.00 ### 625,000.00 ###
July 750,000.00 ### 750,000.00 -
August 625,000.00 ### 750,000.00 ###
September 625,000.00 ### 729,166.67 ###
October 625,000.00 ### 708,333.33 ###
November 625,000.00 ### 708,333.33 ###
December 500,000.00 ### 666,666.67 ###
### 6,166,666.67 ###
No. of
Interest Service
Year 3 Interest Other Income Accounts
Rate charge Serve
Income
Month Loan Release Total Loan Releases 10,575,000
Less: Collection 7,014,721
January 925,000 15% 138,750 2% 18,500 37 Portfolio Balance 3,560,279
February 875,000 15% 131,250 2% 17,500 35
March 1,000,000 15% 150,000 2% 20,000 40 0
April 875,000 15% 131,250 2% 17,500 35
May 1,000,000 15% 150,000 2% 20,000 40 0
June 875,000 15% 131,250 2% 17,500 35
July 875,000 15% 131,250 2% 17,500 35 consolidated bank:
August 750,000 15% 112,500 2% 15,000 30 Borrower's availed
twice when in a year
September 750,000 15% 112,500 2% 15,000 30 when they fully the
October 900,000 15% 135,000 2% 18,000 36 amount within 6
mos. or when they
November 750,000 15% 112,500 2% 15,000 30 paid 50% of their
December 1,000,000 15% 150,000 2% 20,000 30 loan they can avail
renewal
TOTAL 10,575,000 1,586,250 211,500 413
Assumptions: Number of clients who availed loan increase by 10% and 10% increase in loan portfolio.
Cash Collection
Weekly
Amount Collectio Collection in a Loan Balance
n Month
January 750,000.00 0 0 ###
February 875,000.00 ### 125,000.00 ###
March 625,000.00 ### 270,833.33 ###
April 750,000.00 ### 395,833.33 ###
May 875,000.00 ### 500,000.00 ###
June 875,000.00 ### 645,833.33 ###
July 875,000.00 ### 791,666.67 ###
August 750,000.00 ### 812,500.00 ###
September 625,000.00 ### 791,666.67 ###
October 750,000.00 ### 791,666.67 ###
November 625,000.00 ### 791,666.67 ###
December 750,000.00 ### 750,000.00 -
### 6,666,666.67 ###
-
3,149,086.00 4,948,533.46
9,750,000.00
10,237,500.00
10,749,375.00
9,625,000.00
875,000.00
9,625,000.00
Year 1 Year 2 Year 3
Interest Income loans 1,487,500 1,642,250 1,802,250
Interest Income-deposit 4,441 12,225 12,246
Total 1,491,941 1,654,475 1,814,496
Divided 12 12 12
Monthly Income 124,328 137,873 151,208
Year 2
SSS PHIC HDMF
13th Month
Position Salary Cash Gift Employer Employer Employer Healthcare
Pay
Share Share Share
President/ Office
1
In-charge 15,000 2,000 15,000 1,230 206 100 3,700
Account Officer/
2 Collector 13,000 2,000 13,000 1,090 179 100 3,700
3 Loans Clerk 11,500 2,000 11,500 930 158 100 3,700
TOTAL 39,500 6,000 39,500 3,250 543 300 11,100
Multiplied 12 1 1 12 12 12 1
474,000 6,000 39,500 39,000 6,518 3,600 11,100
TOTAL EXPENSES 579,718
Year 3
SSS PHIC HDMF
13th Month
Position Salary Cash Gift Employer Employer Employer Healthcare Clothing
Pay
Share Share Share
1 President/ Office
In-charge 15,450 3,000 15,450 1,230 212 100 3,700 2,200
Account Officer/
2 Collector 13,390 3,000 13,390 1,090 184 100 3,700 2,200
3 Loans Clerk 11,845 3,000 11,845 930 163 100 3,700 2,200
TOTAL 40,685 9,000 40,685 3,250 559 300 11,100 6,600
No. of Months 12 1 1 12 12 12 1 1
488,220 9,000 40,685 39,000 6,713 3,600 11,100 6,600
TOTAL EXPENSES 604,918.03
Assumptions:
3% in salary rate
2% increase in clothing allowance
Member 2
TOTAL - - -
* Audit committee honararium will inc to 5% and 10% on the 2nd and 3rd yr respectively
Credit Committee will meet as often as necessary for loans approval
* CRECOM is entitled for a monthly honararium of P1500.00 on the first year and increase to 5% for year and 10% inc on the 3rd year
Year 1 3%
Power, Lights and Water Monthly No.of Mos.
Lights 1,800.00 12 21,600 54
Water 300.00 12 3,600 9
Cable 500.00 12 6,000 15
Total 31,200
Communication Expenses
Load 500.00 12 6,000.00
Information Technology Expense
Monthly Year 1 3%
Fuel and Lubricants 2,265.00 12.00 27,180.00 815.40
3%
Advertising Fee 5,000.00 150.00
50 200 10,000.00
20000
Year 2 3% Year 3
Year 2 0 Year 3
Year 2 3% Year 3
5,784 174 5,958
Year 2 3% Year 3
13,750 13,938
7,500 7,500
- 6,250 188 6,438
13,750 13,938
6,000.00 6,000.00
10%
88,000.00 8800 96,800.00
39,600.00 3960 43,560.00
24,000.00 24,000.00
151,600.00 164,360.00
Year 2 3% Year 3
6,180 185 6,365
Year 2 3% Year 3
27,995.40 839.86 28,835.26
3%
5,150.00 154.50 5,304.50
Office Equipment
Estimated
Furniture and Fixtures Cost Depreciation Net (per year)
Life (Yrs)
Cost (Per Year)
Aircon-ceiling 25,000 3 8,333 16,667
Table Office 18,000 3 6,000 12,000
Office Chair 13,500 3 4,500 9,000
Venetian Blinds 25,000 3 8,333 16,667
Fire extinguisher 2,500 3 833 1,667
Computer Table 5,000 3 1,667 3,333
Visitor chair 21,000 3 7,000 14,000
Television 10,000 3 3,333 6,667
Total 120,000 40,000 80,000
Transportation Equipment
Motorcycle XRM-125 85,000.00 5 17,000.00 68,000.00
Total 85,000.00 17,000.00 68,000.00
GRAND TOTAL 634,000.00 173,333.33 460,666.67
434000
Net
120,000.00
40,000.00
160,000.00
No. of Business Establishments in Bangkerohan 650
COMMON SHAREHOLDINGS
As of December 31
No. Name Shares Paid-in Amount Ratio
1 Charlane Jade Alinsub 800 800,000 13%
2 Angelita D. Dungog 800 800,000 13%
3 Chona Escatron 800 800,000 13%
4 Melanie Sayawan 800 800,000 13%
5 Marlon Aliscad 600 600,000 10%
6 Richie Cervantes 600 600,000 10%
7 Jeaneth A. Magdua 400 400,000 7%
8 Lezardo Franca 400 400,000 7%
9 Rose Marie N. Torculas 400 400,000 7%
10 Merry Jo-anne L. Carreon 400 400,000 7%
TOTAL 6,000 6,000,000 100%
MACC Micro Lending
- 38 -
MACC Micro Lending
As of January 1
Paid-in Capital Stock 6,000,000 6,000,000 6,000,000
- 39 -
Distribution of Cash Dividend
Year 2 Year 3
Net income 455,646.14 542,794.98
Distributable Net Surplus
Distributed as follows:
Dividend 70% 318,952.30 379,956.49
Retained Earnings 30% 136,693.84 162,838.49
70% of the net income will be distributed in the form of cash dividend
30% will be charged to Retained Earning
1 Liquidity Ratio
Year 1 Year 2 Year 3
Current Assets 2,220,423 2,557,805 2,601,626
Current Liabilities 4,093 4,093 4,093
Working Capital 2,216,330 2,553,711 2,597,533
Current Assets 2,220,423 2,557,805 2,601,626
Current Liabilities 4,093 4,093 4,093
Current Ratio 542.48 624.90 635.61
Quick Assets 2,220,423 2,557,805 2,601,626
Current Liabilities 4,093 4,093 4,093
Quick Ratio 542.48 624.90 635.61
2 Solvency Ratio
Year 1 Year 2 Year 3
Total Liabilities 4,093 4,093 4,093
Total Assets 6,325,915 6,475,120 6,645,072
Debt Ratio 0.06% 0.06% 0.06%
Total Equity 6,337,382 6,474,075 6,636,914
Total Assets 6,325,915 6,475,120 6,645,072
Equity Ratio 100.18% 99.98% 99.88%
Total Liabilities 4,093 4,093 4,093
Total Equity 6,337,382 6,636,914 6,636,914
Debt- Equity Ratio 0.06% 0.06% 0.06%
3 Profitability Ratio
Year 1 Year 2 Year 3
Gross Interest Income 1,316,941 1,455,975 1,598,496
Total Income 1,491,941 1,654,475 1,814,496
Gross Profit Ratio 88.27% 88.00% 88.10%
Net Income 337,382 455,646 542,795
Total Income 1,491,941 1,654,475 1,814,496
Net Profit Ratio 22.61% 27.54% 29.91%
Total Income 1,491,941 1,654,475 1,814,496
Total Assets 6,325,915 6,475,120 6,645,072
Asset Turnover 23.58% 25.55% 27.31%
Net Income 337,382 455,646 542,795
Average Equity 6,337,382 6,405,729 6,555,495
Return on Investment 5.32% 7.11% 8.28%
Break-even analysis
Year 1 Year 2
Amount % Amount
Revenue 1,316,941 100% 1,455,975
Variable Costs 767,314 58% 774,110
Contribution Margin 549,627 42% 681,865
Fixed Costs
Net Income
Payback Period
Initial
Year Cash Flow
Investment
0 -6,000,000
1 2,220,423 -3,779,577
2 337,382 -3,442,195
3 43,821 -3,398,374
2,601,625.75
0.43
Cost of Funds
Year 1
% Cost
Sources:
Capital Stock 6,000,000 94.62% 0.00%
Other Liabilities 4,093 0.06% 0.00%
Retained earnings 337,382 5.32% 0.00%
6,341,475
Uses of funds
Cash 2,220,423 35.10% 0.25%
Current loans 3,644,825 57.62% 30.00%
Past due - 0.00% 0.00%
Other assets 460,667 7.28% 0.00%
6,325,915
1,132,714
2,269,972.37
64,750.71
35.06
Year 2 Year 3
% Amount %
100% 1,598,496 100%
53% 814,289 51%
47% 784,207 49%
Year 2 Year
Cost Mix % Cost Cost Mix