Discussion FIN317
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