bisness plan( financial) akmar

7
PRO FORMA Financial statement Cash flow statement (Monthly) MONTH PRE- OPERA TIONS 1 2 3 4 5 6 7 8 9 10 11 12 YEAR 1 CASH INFLOWS Beginning cash balance 0  4500 0 6211 0.77 79,221 .54 96,3 32.3 1 11 3, 44 3. 08 13 0,5 53. 85 147, 664. 62 164 ,77 5.3 9 181 ,88 6.1 6 198, 996. 93 21 6,1 07. 70 23 3,2 18. 47 0 Equity Cash 100,00 0 100,00 0 Term Loan 80,000  80,000 Cash sales  70,00 0 70,00 0 70, 000 70, 0 00 70 ,0 00 70, 00 0 70,0 00 70, 000 70, 000 70,0 00 70, 00 0 70, 00 0 840,00 0 Total Cash Infows 80,000 70,00 0 70,00 0 70, 000 70, 0 00 70 ,0 70, 00 70,0 00 70, 000 70, 000 70,0 00 70, 00 70, 00 920,00 0

Upload: anonymous-m7xjslu

Post on 20-Feb-2018

213 views

Category:

Documents


0 download

TRANSCRIPT

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 1/7

PRO FORMA Financial statement

Cash flow statement (Monthly)

MONTH PRE-

OPERA

TIONS

1 2 3 4 5 6 7 8 9 10 11 12 YEAR 1

CASH INFLOWS

Beginning cash

balance

0   4500

0

6211

0.77

79,221

.54

96,3

32.3

1

11

3,

44

3.08

13

0,5

53.

85

147,

664.

62

164

,77

5.3

9

181

,88

6.1

6

198,

996.

93

21

6,1

07.

70

23

3,2

18.

47

0

Equity Cash 100,00

0

100,00

0

Term Loan 80,000   80,000

Cash sales   70,00

0

70,00

0

70,000 70,0

00

70

,0

00

70,

00

0

70,0

00

70,

000

70,

000

70,0

00

70,

00

0

70,

00

0

840,00

0

Total Cash

Infows

80,000 70,00

0

70,00

0

70,000 70,0

00

70

,0

70,

00

70,0

00

70,

000

70,

000

70,0

00

70,

00

70,

00

920,00

0

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 2/7

00 0 0 0

CASH

OUTFLOWS

Operational

Expenditure

Raw materials 10,00

5

10,00

5

10,005 10,0

05

10

,0

05

10,

00

5

10,0

05

10,

005

10,

005

10,0

05

10,

00

5

10,

00

5

120,06

0

Direct Labor 9790 9790 9790 979

0

97

90

97

90

979

0

979

0

979

0

979

0

97

90

97

90

117,48

0

Operational

oer!ea"s

2500 2500 2500 250

0

25

00

25

00

250

0

250

0

250

0

250

0

25

00

25

00

30,000

Marketing

Expensive:

#ales commission 6000 6 000 6 000 600

0

60

00

60

00

600

0

600

0

600

0

600

0

60

00

60

00

72000

$ntertainment

allowance

4000 4000 4000 400

0

40

00

40

00

400

0

400

0

400

0

400

0

40

00

40

00

48,000

 Administrative

Expenditure:

#alaries % &a'es 4094.

50

4094.

50

4094.5

0

409

5.50

40

94

40

94.

409

4.50

409

4.5

409

4.5

409

4.5

409

4.5

40

94.

49,134

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 3/7

.5

0

50 0 0 0 0 50

$() % #O*#O 5,000 5,000 5,000 5,00

0

5,

00

0

5,0

00

5,00

0

5,0

00

5,0

00

5,0

00

5,0

00

5,0

00

60,000

+"ministratie

oer!ea"s

9750 9750 9750 975

0

97

50

97

50

975

0

975

0

975

0

975

0

975

0

97

50

117,00

0

Loan

Repayment  :

(rincipal 833.3

0

833.3

0

833.30 833.

30

83

3.

30

83

3.3

0

833.

30

833

.30

833

.30

833

.30

833

.30

83

3.3

0

10,000

nterest 416.70

416.70

416.70 416.70

416.

70

416.7

0

416.70

416.70

416.70

416.70

416.70

416.7

0

5,000

Hire purchase

repayment:

20,000   20,000

Down pa-ment 5,000 5,000

(rincipal 333 333 333 333 33

3

33

3

333 333 333 333 333 33

3

4,000

nterest 166.7

0

166.7

0

166.70 166.

70

16

6.

16

6.7

166.

70

166

.70

166

.70

166

.70

166

.70

16

6.7

2,000

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 4/7

70 0 0

Capital

Expenditure:

ac!iner- %

$/ipment

24,000 24,000

)rnitre %

)itres

8,000 8,000

Lan" % bil"in' 46000 46000

e!icle an 26000 26000

Renoation 4,000 4,000

Preoperational

Expenditure

2000 2000

Total Cash

Outfows

135000 5288

9.23

5288

9.23

52889.

23

528

89.2

3

52

88

9.

23

52

88

9.2

3

528

89.2

3

528

89.

23

528

89.

23

528

89.

23

528

89.

23

52

88

9.2

3

769,67

4

Cash Surplus/

(Dect!

45000 17,11

0.77

17,11

0.77

17,110

.77

17,1

10.7

7

17

,1

10

.7

7

17,

11

0.7

7

17,1

10.7

7

17,

110

.77

17,

110

.77

17,

110

.77

17,

110

.77

17,

11

0.7

7

150,32

6

"n#n$ Cash 45000 6211 79,22 96,332 113, 13 14 164, 181 198 216 233 25 250,32

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 5/7

%alance   0.77 1.54 .31 443.

08

0,

55

3.

85

7,6

64.

62

775.

39

,88

6.1

6

,99

6.9

3

,10

7.7

0

,21

8.4

7

0,3

29.

24

9.24

(ro orma *as! ow statement annall-

 &ear &ear ' &ear &ear )

A CASH INFLOWS

%e$nnn$ cash *alance   0 250,329.24   876,000

$/it- *as!   100,000   0 0

 erm Loan 80,000 0 0

*as! sales 840,000 876,000 890,000

% Total Cash Infows   920,000 876,000 890,000

C CASH OUTFLOWS

Operational Epen!iture

Raw materials 120,060 122,100 125,200

Direct labor 117,480 119,500 125,200

Operational oer!ea" 30,000 32,000 34,000

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 6/7

"ar#eting Epen!iture:

#ales commission 72000 +,-... +-0..

$ntertainment allowance   48,000   48,000 48,000

 $!ministrati%e Epen!iture

#alaries % &a'es 49,134 52,100 55,200

$() % #O*#O 60,000 60,600 62,000

+"ministratie oer!ea"s 117,000 124,000 126,500

Loan &epayment:

(rincipal 10,000 10,000 10,000

nterest 5,000 4,200 3,700

'ire(purchase repayment:

Down pa-ment 5,000 0 0

(rincipal 4,000 4,000 4,000

nterest 2,000 2,000 2,000

Capital Epen!iture:

ac!iner- % $/ipment 24,000 0 0

)rnitre % )itres 8,000 0 0

7/24/2019 Bisness Plan( Financial) Akmar

http://slidepdf.com/reader/full/bisness-plan-financial-akmar 7/7

Lan" % bil"in' 46000 0 0

e!icle an 26000 0 0

Renoation 4,000 0 0

1re2operatonal"3pen#ture

2000 1,500 1,500

D Total Cash Outfows   769,674 622,000 673,800

" Cash Surplus/ (Dect!   150,326 254,000 216,200

F "n#n$ Cash %alance   250,329.24 876,000 890,000