Discussion FIN317

profilecnhunt88
FINANCECAFEGRILL.xlsx

Sheet1

Pro forma balance sheet as at 31st december 2019
Café Gril
Assets Liabilities
Cash at hand 6000000 rent 3000000
Sales 20000000 labor costs 27350000
Gnerator 400000
Tables and chairs 2250000
Air conditioners 500000
cooking tools 1200000
Total 30350000 30350000
Proforma income statement
Cash receipts
january february mrch april june july august septmber october november december
5000000 6000000 6000000 8000000 10000000 10000000 12000000 12000000 15000000 16000000 18000000
Total 118000000
cash payments
january february march april may june july august september october november december
2000000 2000000 3000000 2000000 4000000 5000000 5000000 5000000 6000000 6000000 7000000 8000000
Total 55000000
Proforma cash budget
Total cash receipts = receipts 118000000
Toital cash payments 55000000

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Pro forma balance sheet as at 31st december 2019

Café Gril

Assets

Cash at hand

6000000

Sales

20000000

Gnerator

400000

Tables and chairs

2250000