[go: up one dir, main page]

0% found this document useful (0 votes)
2 views10 pages

CHAPTER FIVE

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

CHAPTER FIVE

5.0. FINANCIAL PLAN

This is the cost estimated before the business operations begin. It is illustrated in the table

5.1. PRE – OPERATIONAL EXPENSES


ITEMS AMOUNT

Advertisement 12000

Trade promotion 5000

Transport 30000

Invest 90000

Rent deposit 5000

TOTAL 131200

5.2 BALANCE SHEET


5.2.1 BALANCE SHEET 2023
ITEMS AMOUNT ITEM AMOUNT

FIXED ASSETS LONG TERM LIABILITIES


Premises 60000 Purchases 40000
Raw materials 108000 Insurance 19200
CURRENT ASSETS CURRENT LIABILITIES
Debtors 30000 Creditors 120000
Cash in hand 3390000 Bank overdraft 12000
Cash at bank 1550000
stock

TOTAL ASSETS 138000 138000


5.2.2 BALANCE SHEET 2023
ITEMS AMOUNT ITEM AMOUNT

FIXED ASSETS SH LONG TERM LIABILITIES


Motherboard 140000 Purchases 830000
Computers 24000 Insurance 199200
Printers 100000 CURRENT LIABILITIES
Projectors 80000 Creditors 500000
Cupboards 24000
Bank overdraft 540000
Filling cabinet 2500

Office trolleys 60000

Table 20000

Office desks 17500

Chair 20000

CURRENT ASSETS
Debtors 30000
Cash in hand 100000
Cash at bank 120000

TOTAL ASSETS 981200 981200

5.3 ESTIMATION OF WORKING CAPITAL


This is the amount of money needed to run the business on a daily basis.

CURRENT ASSETS COST

Stock of raw materials 108000

Cash at hand 20000

Cash at bank 10000

Debtors 30000

TOTAL 258000
CURRENT LIABILITIES

creditors 120000

Bank overdraft 12000

Salaries 16500

TOTAL 148500

Working capital = general assets – current liabilities


= 258000 – 148500 = 109500
5.4CASH FLOW STATEMENT
5.4.1 PRE – OPERATONAL OF CASH FLOW CHART 2023
MONTHS JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL

Opening 30000 30000 40000 35000 25000 25000 30000 40000 20000 40000 30000 3390000
stock 0 0 0 0 0 0 0 0 0 0

Cash sales 20000 20000 20000 30000 15000 25000 25000 15000 30000 12000 12000 20000 2480000
0 0 0 0 0 0 0 0 0 0 0 0

Account 10000 15000 10000 12000 15000 10000 12000 14000 15000 14000 15000 15000 1550000
Reliable 0 0 0 0 0 0 0 0 0 0 0 0

TOTAL 60000 65000 60000 92000 62000 65000 45000 43200 87600 50000 75000 65000 7970000
00 00 00 00 00 00 00 00 00 00 00 00 00

Cash out - - - -
flow

Advertise 12000 1200 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 144000
ment

Promotion 5000 4000 4000 13000

Salaries 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 240000

Electricity 2000 3000 2000 3000 1000 1500 3000 1000 2000 3000 3000 3000 26500

Transport 30000 20000 30000 15000 20000 20000 30000 12000 20000 15000 2000 20000 250000

Purchase 40000 50000 80000 70000 60000 70000 10000 90000 60000 12000 90000 330000
0 0 0 0 0 0 0 0 0 0 0

Invest 90000 90000 10000 80000 90000 75000 70000 60000 50000 80000 90000 60000 1005000
0

Others 50000 60000 80000 70000 75000 65000 70000 65000 70000 65000 70000 60000 288000

Taxes 80000 80000 80000 70000 65000 70000 70000 80000 65000 75000 70000 65000 515000

Rent 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 60000
deposit

Closing 33700 53300 44200 60200 48200 48300 61350 79040 32400 34200 32400 87300
stock 0 0 0 0 0 0 0 0 0 0 0 0
5.5 THE INCOME STATEMENT OF RUTH COMPUMBER ASSEMBLING
ENTERPRISES AS AT 31ST DEC 2023
ITEM 2023 2024 2025

Advertisement 144000 144000 144000

Trade promotion 13000 18000 18500

Salaries 240000 240000 240000

Electricity 26500 26500 26500

Transport 250000 260000 27000

Purchase 830000 830000 830000

Invest 1005000 1000000 1001000

Taxes 515000 515000 51500

Rent deposit 60000 60000 60000

Others 28800 28800 28800

Sales 2480000 2290000 2390000

Gross profit 1650000 1460000 1560000

Total expenses 2258450 2268450 2627000

5.6 BREAK EVEN ANALYSIS 2023

DESCRIPTION KSH

FIXED COST

Rent 60000

Salaries 240000

Licenses 10000

Loan payment 600000

TOTAL 9100000

VARIABLE COST

Water bill 7200


Transport 250000

interest 10000

Repair and maintenance 29000

Miscellaneous 144000

TOTAL 579200

Sales 2480000

Les purchase 830000

Gross profit 1650000

5.6.1 BREAK ANALYSIS 2023


DESCRIPTION KSH

FIXED COST

Rent 60000

Salaries 240000

Licenses 10000

Loan payment 120000

TOTAL 430000

VARIABLE COST

Water bill 7000

Transport 250000

Advertisement 144000

Repair and maintenance 2600

Miscellaneous 100000

TOTAL 530100

Sales 2420000

Les purchase 830000


Gross profit 1590000

5.6.2 BREAK ANALYSIS 2023


DESCRIPTION KSH

FIXED COST

Rent 60000

Salaries 240000

Licenses 10000

Loan payment 110000

TOTAL 420000

VARIABLE COST

Water bill 6000

Transport 270000

Advertisement 144000

Repair and maintenance 20000

Miscellaneous 90000

TOTAL 314000

Sales 2290000

Les purchase 830000

Gross profit 1460000

1. Total contribution margin = sales – total valable


22190000 – 314000 =21876000
2. Year 1% contribution margin
Contribution margin X 100/sales
1900800 X 100/2480000 = 76.645%
3. Year 2% contribution
1889900 X 100/2420000
= 78.095%
4. Year 3% contribution margin
21876000 X 100/2290000
= 95.528%

5.7 DESIRED FINANCING


YEAR 1 YEAR 2 YEAR 3

G.p margin= 6.p*100/sales G.p margin= 6.p*100/sales G.p margin= 6.p*100/sales


=(165000X100)/24800
00
=1590000 X100/2420000 160000 X100/2290000

N.P margin =(N.p*100)sales N.P margin =(N.p*100)sales N.P margin =(N.p*100)sales


100000 X 100/2480000 1590000 X 100/2420000 200000 X 100/2290000

Rate of stock= Rate of stock= Rate of stock=


Cost of sales / average Cost of sales / average Cost of sales / average
2480000/399000 2420000/399000 2290000/399000

5.8 PROFITABILITY RATIOS

YEAR 1
Working capital= CA – CL
300000 – 150000
=150000
Current ratio= CA – CL
300000/150000
2:1
YEAR 2
Working capital= CA – CL
367000 – 167000 =200000
Current ratio= CA – CL
367000/167000
2:1

5.9 EXPECTED PROFITABILITY RATIOS FOR THE YEAR 2023

Gross profit margin=gross profit/sales*100%


=250000/3000000*100
=83.33%
Return on investment=net profit/capital employed*100%
=300000/400000*100%
=75%
Net profit margin=net profit/sales*100%
=300000/3000000*100%
=10%

You might also like