Financial Plan Siap

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 10

FINANCIAL PLAN

STREET TRUCK
Project Implementation Cost

Capital Expenditure Cost Sources of Financing


Land & Building 150,000 Existing asset
Truck 600,000 Hire-purchase
Cash
Cash
Cash
signboard 3,500 Cash
Cash
Cash
Cash
casher machine 2,000 Cash
kitchen equipment 20,000 Loan
Cash
Cash
Working Capital 1 months
Sales & Marketing Costs (monthly) 1,000 Cash
General & Administrative Costs (monthly) 55,200 Loan
Operations & Technical Costs (monthly) 77,656 Loan
Pre-Operating & Incorporation Costs (one-off) 27,000 Cash
Other Expenditure (annually) 3,200 Cash
Privision for
Cash
Contingencies
TOTAL 939,556
Sources of Project Financing
Own Contributions
Hire-
Capital Expenditure Cost Existing F. Loan
Purchase
Cash Assets
150,
Land & Building
000 150,000
600,
Truck
000 600,000

-
3,50
signboard
0 3,500

-
2,00
casher machine
0 2,000
20,0
kitchen equipment
00 20,000

-
Working Capital
Sales & Marketing Costs 1,00
(monthly) 0 1,000
General & Administrative Costs 55,2
(monthly) 00 55,200
Operations & Technical Costs 77,6
(monthly) 56 77,656
Pre-Operating & Incorporation 27,0
Costs (one-off) 00 27,000
3,20
Other Expenditure (annually)
0 3,200
Privision for Contingencies
-
939,
TOTAL 36,700 150,000 152,856 600,000
556
Depreciation of fixed assets

Type of Fixed Type of Fixed


Asset casher machine Asset kitchen equipment
Cost (RM) 2,000 Cost (RM) 20,000
Depreciation Depreciation
Method Straight Line Method Straight Line
Economic Life Economic Life
(yrs) 5 (yrs) 5
Ye Annual Accumulated Ye Annual Accumulated
Book Value Book Value
ar Depreciation Depreciation ar Depreciation Depreciation

- - 2,000 - - 20,000

1 400 400 1,600 1 4,000 4,000 16,000

2 400 800 1,200 2 4,000 8,000 12,000

3 400 1,200 800 3 4,000 12,000 8,000

4 400 1,600 400 4 4,000 16,000 4,000

5 400 2,000 - 5 4,000 20,000 -

6 0 0 - 6 0 0 -

7 0 0 - 7 0 0 -

8 0 0 - 8 0 0 -

9 0 0 - 9 0 0 -

10 0 0 - 10 0 0 -

Type of Fixed Asset Truck


Cost (RM) 600,000
Depreciation Method Straight Line
Economic Life (yrs) 5
Annual Accumulated
Year Book Value
Depreciation Depreciation

- - 600,000
1 120,000 120,000 480,000
2 120,000 240,000 360,000
3 120,000 360,000 240,000
4 120,000 480,000 120,000
5 120,000 600,000 -
6 0 0 -
7 0 0 -
8 0 0 -
9 0 0 -
10 0 0 -
Type of Fixed Asset signboard
Cost (RM) 3,500
Depreciation Method Straight Line
Economic Life (yrs) 5
Annual Accumulated
Year Book Value
Depreciation Depreciation

- - 3,500

1 700 700 2,800

2 700 1,400 2,100

3 700 2,100 1,400

4 700 2,800 700

5 700 3,500 -

6 0 0 -

7 0 0 -

8 0 0 -

9 0 0 -

10 0 0 -
LOAN AMORTIZATION SCHEDULE
Amount (RM) 152,856
Interest Rate 6%
Duration (yrs) 10
Method Annual Rest
Instalment Payments
Year Principal Balance
Principal Interest Annual Payments
- - - 152,856
1 11,597 9,171 20,768 141,259
2 12,293 8,476 20,768 128,966
3 13,030 7,738 20,768 115,936
4 13,812 6,956 20,768 102,124
5 14,641 6,127 20,768 87,483
6 15,519 5,249 20,768 71,964
7 16,450 4,318 20,768 55,514
8 17,437 3,331 20,768 38,076
9 18,484 2,285 20,768 19,593
10 19,593 1,176 20,768 0
11 0 0 0 0

HIRE-PURCHASE REPAYMENT SCHEDULE


Amount
(RM) 600,000
Interest
Rate 5%
Duration
(yrs) 5

Bayaran Ansuran
Tahun Baki Pokok
Pokok Faedah BayaranTahunan

- - - 600,000

1 120,000 30,000 150,000 480,000

2 120,000 30,000 150,000 360,000

3 120,000 30,000 150,000 240,000

4 120,000 30,000 150,000 120,000

5 120,000 30,000 150,000 -


6 0 0 - -
2015 MONTHLY CASH FLOW

February March April May June July August September October November December

30,000 31,100 31,100 31,200 31,300 31,000 31,200 31,150 31,250 31,250 31,300
124,800 276,000 274,400 279,900 280,300 281,200 280,500 279,800 280,600 280,750 281,250

154,800 307,100 305,500 311,100 311,600 312,200 311,700 310,950 311,850 312,000 312,550

1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000

55,200 55,200 55,200 55,200 55,200 55,200 55,200 55,200 55,200 55,200 55,200

72,769 77,656 77,656 77,656 77,656 77,656 77,656 77,656 77,656 77,656 77,656

10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000

2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500

966 966 966 966 966 966 966 966 966 966 966

764 764 764 764 764 764 764 764 764 764 764

143,199 148,087 148,087 148,087 148,087 148,087 148,087 148,087 148,087 148,087 148,087

11,601 159,013 157,413 163,013 163,513 164,113 163,613 162,863 163,763 163,913 164,463

26,744 38,345 197,358 354,771 517,785 681,298 845,411 1,009,025 1,171,888 1,335,651 1,499,565

38,345 197,358 354,771 517,785 681,298 845,411 1,009,025 1,171,888 1,335,651 1,499,565 1,664,028
2015 2016 2017 2018 2019

36,700

152,856
373,050 374,000 374,900 375,000 375,500
2,919,500 3,367,617 3,373,050 3,374,883 3,378,917

3,482,106 3,741,617 3,747,950 3,749,883 3,754,417

27,000
12,000 12,000 12,000 12,000 12,000
662,400 662,400 662,400 662,400 662,400

917,210
462,682 345,384 345,384 345,384
3,200
3,200 3,200 3,200 3,200
25,500

120,000
120,000 120,000 120,000 120,000
30,000
30,000 30,000 30,000 30,000

11,597
12,293 13,030 13,812 14,641
9,171
8,476 7,738 6,956 6,127
0 0 0 0
1,818,078 1,311,050 1,193,752 1,193,752 1,193,752
1,664,028 2,430,567 2,554,198 2,556,131 2,560,664
1,664,028 4,094,595 6,648,793 9,204,924
1,664,028 4,094,595 6,648,793 9,204,924 11,765,588
STREET TRUCK
Pro-forma Income Statement

Years 2015 2016 2017 2018 2019


Sales 3,730,500 3,740,000 3,749,000 3,750,000 3,755,000
Less: Cost of Sales (Notes 1 & 2) 588,888 2,400 2,400 2,400 2,400
Gross Profit 3,141,612 3,737,600 3,746,600 3,747,600 3,752,600

Less: Expenditure
Pre-Operating & Incorporation Expenditure 17,000
General & Administrative Expenditure 662,400 662,400 662,400 662,400 662,400
Sales & Marketing Expenditure 12,000 12,000 12,000 12,000 12,000
Operations & Technical Expenditure 342,984 342,984 342,984 342,984 342,984
Other Expenditure 3,200 3,200 3,200 3,200 3,200
Interest on Hire-Purchase 30,000 30,000 30,000 30,000 30,000
Interest on Loan 9,171 8,476 7,738 6,956 6,127
Depreciation of Fixed Assets 125,100 125,100 125,100 125,100 125,100
Total Expenditure 1,201,855 1,184,160 1,183,422 1,182,640 1,181,811
Net Income Before Tax 1,939,757 2,553,440 2,563,178 2,564,960 2,570,789
Tax 0 0 0 0 0
Net Income After Tax 1,939,757 2,553,440 2,563,178 2,564,960 2,570,789
Accumulated Net Income 1,939,757 4,493,197 7,056,375 9,621,335 12,192,123

Note 1
Cost of Sales
Opening inventory 0
Add: Total Purchases 586,488
Carriage Inwards & Duty 2,400 2,400 2,400 2,400 2,400
Less: Ending Inventory
588,888 2,400 2,400 2,400 2,400
STREET TRUCK
Pro-forma Balance Sheet
2015 2016 2017 2018 2019
ASSETS

Non-Current Assets (Book


Value)
Land & Building 150,000 150,000 150,000 150,000 150,000
Other Fixed Assets -
500,400 375,300 250,200 125,100
Other Assets
Deposit 10,000 10,000 10,000 10,000 10,000
660,400 535,300 410,200 285,100 160,000
Current Assets

Inventory
Accounts Receivable 437,950 436,333 437,383 437,500 438,083
Cash Balance 1,664,028 4,094,595 6,648,793 9,204,924 11,765,588
2,101,978 4,530,928 7,086,176 9,642,424 12,203,671

TOTAL ASSETS 2,762,378 5,066,228 7,496,376 9,927,524 12,363,671

Owners' Equity
Capital 186,700 186,700 186,700 186,700 186,700
Accumulated Income 1,939,757 4,493,197 7,056,375 9,621,335 12,192,123
2,126,457 4,679,897 7,243,075 9,808,035 12,378,823
Long-Term Liabilities
Loan Balance 141,259 128,966 115,936
102,124 87,483
Hire-Purchase Balance 480,000 360,000 240,000 120,000
621,259 488,966
355,936 222,124 87,483
Current Liabilities
Accounts Payable 14,662 (102,635) (102,635) (102,635) (102,635)

TOTAL EQUITY &


2,762,378 5,066,228 7,496,376 9,927,524 12,363,671
LIABILITIES
FINANCIAL PERFORMANCE ANALYSIS

Financial Ratio Analysis 2015 2016 2017 2018 2019

LIQUIDITY
Current Ratio 143 (44) (69) (94) (119)
Quick Ratio (Acid Test) 143 (44) (69) (94) (119)

EFFICIENCY
Receivable Turnover 8 8 8 8 8
Inventory Turnover #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

PROFITABILITY
Gross Profit Margin 84.21% 99.94% 99.94% 99.94% 99.94%
Net Profit Margin 52.00% 68.27% 68.37% 68.40% 68.46%
Return on Assets 70.22% 50.40% 34.19% 25.84% 20.79%
Return on Equity 91.22% 54.56% 35.39% 26.15% 20.77%

SOLVENCY
Debt to Equity 29.91% 8.26% 3.50% 1.22% -0.12%
Debt to Assets 23.02% 7.63% 3.38% 1.20% -0.12%
Time Interest Earned 211 300 330 368 419

Break-even Analysis 2015 2016 2017 2018 2019

Total projected sales(RM)


3,730,500 3,740,000 3,749,000 3,750,000 3,755,000
Total variable costs (cost of
sales) 588,888 2,400 2,400 2,400 2,400
Contribution margin
3,141,612 3,737,600 3,746,600 3,747,600 3,752,600
Contribution margin ratio 84% 100% 100% 100% 100%
Fixed costs
1,201,855 1,184,160 1,183,422 1,182,640 1,181,811
Total costs
1,790,743 1,186,560 1,185,822 1,185,040 1,184,211
Net Profit
1,939,757 2,553,440 2,563,178 2,564,960 2,570,789
Break-even sales
1,427,140 1,184,920 1,184,180 1,183,398 1,182,567
Percentage of break-even to
38% 32% 32% 32% 31%
sales

You might also like