Docstoc

Cashflow_Worksheet

Document Sample
Cashflow_Worksheet Powered By Docstoc
					Sample Pictures Ltd. Cash Flow Projection

Prepared: December 7, 2008 Description Events

M o n t h s 1 2 April '00 May

3 June

4 July

5 August

6 September Scrnply 1

7 October

8 November Director 1

9 December

10 January '01 Scrnply 2

11 February

12 March Director 2 AFM

1st Year Totals

13 April

14 May

15 June Scrnply 3

16 July

Cannes US Theatrical Release Cash Receipts Investment Funds Production Sale Picture Participations Total Cash Receipts Expenses Brokerage Fees Literary Rights Acquisition Writers' Fees Director Retainer Talent Retainers Unit Production Mngr Publicist Attorney, Entrtnmnt Foreign Rep Picture Artwork Picture Promo Production Rent Telephone Office Equipment Printing Supplies Pstg / Dlvry Service Eagle i, Variety, CelebSrvc Exhibitor Relations Motion Picture Sftwr Advertising, Trade Travel / Markets Fees Dvlpmnt Directors, 2 Dvlpmnt Assistant Operations Director Payroll Taxes Readers Contingency Total Expenses Limited Partners Participation Total Limited Partner Participation Monthly Balance (expense) Cmltv Cash Flow

Mifed

Cannes Sell Pic 1

5,000,000 5,000,000

-

-

-

-

-

-

-

-

-

-

-

5,000,000 5,000,000

3,000,000 3,000,000

-

-

-

500,000 3,000 3,500 1,000 6,000 780 15,428 529,708 4,470,292 4,470,292

5,000 7,000 12,000 3,000 7,000 6,000 2,000 16,400 7,000 800 700 344 3,400 10,000 10,000 12,000 1,500 3,500 2,210 500 3,311 113,665 (113,665) 4,356,627

3,000 3,000 3,000 2,000 160 700 900 2,000 3,000 12,000 4,500 3,500 2,600 500 1,226 42,086 (42,086) 4,314,541

2,000 3,000 3,000 3,000 2,000 160 700 300 900 2,000 3,000 12,000 3,000 3,500 2,405 500 1,244 42,709 (42,709) 4,271,832

2,000 3,000 3,000 3,000 2,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 1,208 41,473 (41,473) 4,230,359

200,000 2,000 5,000 7,000 3,000 10,000 10,000 3,000 2,000 5,000 160 700 1,900 250 7,500 3,000 12,000 3,000 3,500 2,405 500 8,457 290,372 (290,372) 3,939,987

50,000 2,000 7,000 1,000 3,000 3,000 5,000 3,000 2,000 5,000 160 700 7,500 17,500 12,000 3,000 3,500 2,405 500 3,848 132,113 (132,113) 3,807,874

50,000 300,000 2,000 3,000 7,000 3,000 7,000 5,000 3,000 2,000 5,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 12,428 426,693 (426,693) 3,381,181

50,000 150,000 2,000 3,000 1,000 3,000 3,000 2,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 7,238 248,503 (248,503) 3,132,678

200,000 150,000 2,000 5,000 7,000 3,000 10,000 10,000 3,000 2,000 5,000 160 700 7,500 3,000 12,000 3,000 3,500 2,405 500 12,893 442,658 (442,658) 2,690,020

50,000 150,000 2,000 3,000 5,000 3,000 5,000 3,000 2,000 3,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 7,598 260,863 (260,863) 2,429,157

50,000 300,000 2,000 7,000 7,000 3,000 10,000 5,000 3,000 2,000 8,000 160 700 10,000 12,000 12,000 3,000 3,500 2,405 500 13,238 454,503 (454,503) 1,974,654

500,000 400,000 250,000 600,000 450,000 23,000 52,000 47,000 33,000 47,000 40,000 36,000 25,500 16,400 38,000 2,400 8,700 2,244 550 5,200 54,500 63,500 138,000 33,000 38,500 27,235 5,500 88,117 3,025,346 1,974,654 1,974,654

50,000 150,000 2,000 420 5,000 3,000 3,000 2,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 7,281 249,966 2,700,000 50,034 2,024,689

150,000 2,000 420 3,000 7,000 3,000 2,000 160 700 10,000 10,000 12,000 3,000 3,500 2,405 500 6,291 215,976 (215,976) 1,808,713

200,000 150,000 2,000 2,420 7,000 3,000 10,000 10,000 3,000 2,000 5,000 160 700 10,000 3,000 12,000 3,000 3,500 2,405 500 12,891 442,576 (442,576) 1,366,137

50,000 2,000 420 3,000 5,000 3,000 2,000 5,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 2,931 100,616 (100,616) 1,265,522

Sample Pictures Ltd. Cash Flow Projection

Prepared: December 7, 2008 Description Events 17 August Director 3 Mifed Sell Pic 2 US Theatrical Release Cash Receipts Investment Funds Production Sale Picture Participations Total Cash Receipts Expenses Brokerage Fees Literary Rights Acquisition Writers' Fees Director Retainer Talent Retainers Unit Production Mngr Publicist Attorney, Entrtnmnt Foreign Rep Picture Artwork Picture Promo Production Rent Telephone Office Equipment Printing Supplies Pstg / Dlvry Service Eagle i, Variety, CelebSrvc Exhibitor Relations Motion Picture Sftwr Advertising, Trade Travel / Markets Fees Dvlpmnt Directors, 2 Dvlpmnt Assistant Operations Director Payroll Taxes Readers Contingency Total Expenses Limited Partners Participation Total Limited Partner Participation Monthly Balance (expense) Cmltv Cash Flow Sell Pic 3 AFM 18 September 19 October 20 November 21 December 22 January '02 23 February 24 March

Y

e a r s 4/01 - 3/02 2

4/02 - 3/03 3

4/03 - 3/04 4

4/04 - 3/05 5

1:3/02

2:7/02, 3:12/02

3,000,000 349,852 3,349,852

-

-

-

151,860 151,860

3,000,000 3,000,000

-

-

9,000,000 501,712 9,501,712

3,539,590 3,539,590

3,678,976 3,678,976

-

50,000 300,000 2,000 420 7,000 3,000 7,000 5,000 3,000 2,000 5,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 12,351 424,036 3,014,867 (89,050) 1,176,472

50,000 150,000 2,000 420 3,000 3,000 2,000 160 700 2,000 3,000 12,000 3,000 3,500 2,405 500 7,131 244,816 (244,816) 931,656

150,000 2,000 420 3,000 1,500 1,000 80 350 10,000 17,500 6,000 1,500 1,750 1,203 500 5,904 202,707 (202,707) 728,949

150,000 2,000 420 1,500 1,000 80 350 1,000 3,000 6,000 1,500 1,750 1,203 500 5,109 175,412 (175,412) 553,538

2,000 420 1,500 1,000 80 350 1,000 3,000 6,000 1,500 1,750 1,203 500 609 20,912 136,674 (5,726) 547,812

2,000 420 1,500 1,000 80 350 1,000 3,000 6,000 1,500 1,750 1,203 500 609 20,912 148,460 2,830,629 3,378,441

2,000 420 1,500 1,000 80 350 1,000 3,000 6,000 1,500 1,750 1,203 500 609 20,912 (20,912) 3,357,530

2,000 420 3,000 1,500 1,000 80 350 2,500 12,000 6,000 1,500 1,750 1,203 500 1,014 34,817 1,379,203 (1,414,019) 1,943,510

200,000 200,000 300,000 900,000 24,000 7,040 19,000 18,000 30,000 20,000 27,000 18,000 15,000 1,440 6,300 44,500 66,500 108,000 27,000 31,500 21,645 6,000 62,728 2,153,653 7,379,203 (31,144) 1,943,510

24,000 5,040 10,000 9,000 5,000 5,000 6,000 2,000 1,000 160 300 10,000 2,325 79,825 1,729,882 1,729,882 3,673,393

24,000 5,040 10,000 9,000 5,000 5,000 600 2,000 1,000 160 300 10,000 2,163 74,263 1,802,356 1,802,356 5,475,749

24,000 5,040 10,000 9,000 5,000 5,000 240 2,000 1,000 160 300 10,000 2,152 73,892 (73,892) 5,401,857


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:87
posted:12/7/2008
language:English
pages:2