Cashflow Worksheet for Filmmaking 
Cashflow Worksheet for Filmmaking.
Sample Pictures Ltd. Cash Flow Projection Prepared: January 30, 2008 M o n t h s 1 2 3 4 5 6 7 8 9 10 11 12 1st Year 13 14 15 16 Description April '00 May June July August September October November December January '01 February March Totals April May June July Events Scrnply 1 Scrnply 2 Scrnply 3 Director 1 Director 2 Cannes Mifed AFM Cannes Sell Pic 1 US Theatrical Release Cash Receipts Investment Funds 5,000,000 -----------5,000,000 ----Production Sale -------------3,000,000 ---Picture Participations -----------------Total Cash Receipts 5,000,000 -----------5,000,000 3,000,000 ---Expenses Brokerage Fees 500,000 -----------500,000 ----Literary Rights Acquisition -----200,000 ---200,000 --400,000 --200,000 -Writers' Fees ------50,000 50,000 50,000 -50,000 50,000 250,000 50,000 --50,000 Director Retainer -------300,000 ---300,000 600,000 ----Talent Retainers --------150,000 150,000 150,000 -450,000 150,000 150,000 150,000 -Unit Production Mngr -5,000 -2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 23,000 2,000 2,000 2,000 2,000 Publicist 3,000 7,000 3,000 3,000 3,000 5,000 7,000 3,000 3,000 5,000 3,000 7,000 52,000 420 420 2,420 420 Attorney, Entrtnmnt -12,000 ---7,000 1,000 7,000 1,000 7,000 5,000 7,000 47,000 5,000 -7,000 -Foreign Rep -3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 33,000 3,000 3,000 3,000 3,000 Picture Artwork -7,000 ---10,000 3,000 7,000 -10,000 -10,000 47,000 -7,000 10,000 -Picture Promo Production -----10,000 5,000 5,000 -10,000 5,000 5,000 40,000 --10,000 5,000 Rent -6,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000 3,000 3,000 3,000 3,000 Telephone 3,500 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25,500 2,000 2,000 2,000 2,000 Office Equipment -16,400 ----------16,400 ----Printing -7,000 ---5,000 5,000 5,000 -5,000 3,000 8,000 38,000 --5,000 5,000 Supplies -800 160 160 160 160 160 160 160 160 160 160 2,400 160 160 160 160 Pstg /Dlvry Service 1,000 700 700 700 700 700 700 700 700 700 700 700 8,700 700 700 700 700 Eagle i, Variety, CelebSrvc -344 ---1,900 ------2,244 ----Exhibitor Relations ---300 -250 ------550 ----Motion Picture Sftwr -3,400 900 900 --------5,200 ----Advertising, Trade -10,000 2,000 2,000 2,000 7,500 7,500 2,000 2,000 7,500 2,000 10,000 54,500 2,000 10,000 10,000 2,000 Travel /Markets -10,000 3,000 3,000 3,000 3,000 17,500 3,000 3,000 3,000 3,000 12,000 63,500 3,000 10,000 3,000 3,000 Fees Dvlpmnt Directors, 2 6,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 138,000 12,000 12,000 12,000 12,000 Dvlpmnt Assistant -1,500 4,500 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 33,000 3,000 3,000 3,000 3,000 Operations Director -3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 38,500 3,500 3,500 3,500 3,500 Payroll Taxes 780 2,210 2,600 2,405 2,405 2,405 2,405 2,405 2,405 2,405 2,405 2,405 27,235 2,405 2,405 2,405 2,405 Readers -500 500 500 500 500 500 500 500 500 500 500 5,500 500 500 500 500 Contingency 15,428 3,311 1,226 1,244 1,208 8,457 3,848 12,428 7,238 12,893 7,598 13,238 88,117 7,281 6,291 12,891 2,931 Total Expenses 529,708 113,665 42,086 42,709 41,473 290,372 132,113 426,693 248,503 442,658 260,863 454,503 3,025,346 249,966 215,976 442,576 100,616 Limited Partners Participation Total Limited Partner Participation -------------2,700,000 ---Monthly Balance (expense) 4,470,292 (113,665) (42,086) (42,709) (41,473) (290,372) (132,113) (426,693) (248,503) (442,658) (260,863) (454,503) 1,974,654 50,034 (215,976) (442,576) (100,616) Cmltv Cash Flow 4,470,292 4,356,627 4,314,541 4,271,832 4,230,359 3,939,987 3,807,874 3,381,181 3,132,678 2,690,020 2,429,157 1,974,654 1,974,654 2,024,689 1,808,713 1,366,137 1,265,522 Sample Pictures Ltd. Cash Flow Projection Prepared: January 30, 2008 Description Events 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 Y e a r s 17 18 19 20 21 22 23 24 4/01 -3/02 4/02 -3/03 4/03 -3/04 4/04 -3/05 August September October November December January '02 February March 2 3 4 5 Director 3 Mifed AFM Sell Pic 2 Sell Pic 3 1:3/02 2:7/02, 3:12/02 ------------3,000,000 ----3,000,000 --9,000,000 ---349,852 ---151,860 ---501,712 3,539,590 3,678,976 -3,349,852 ---151,860 3,000,000 --9,501,712 3,539,590 3,678,976 ---------------------200,000 ---50,000 50,000 ------200,000 ---300,000 -------300,000 ----150,000 150,000 150,000 ----900,000 ---2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000 24,000 24,000 24,000 420 420 420 420 420 420 420 420 7,040 5,040 5,040 5,040 7,000 -------19,000 10,000 10,000 10,000 3,000 3,000 ------18,000 9,000 9,000 9,000 7,000 -3,000 ----3,000 30,000 5,000 5,000 5,000 5,000 -------20,000 5,000 5,000 5,000 3,000 3,000 1,500 1,500 1,500 1,500 1,500 1,500 27,000 6,000 600 240 2,000 2,000 1,000 1,000 1,000 1,000 1,000 1,000 18,000 2,000 2,000 2,000 ------------5,000 -------15,000 1,000 1,000 1,000 160 160 80 80 80 80 80 80 1,440 160 160 160 700 700 350 350 350 350 350 350 6,300 300 300 300 ------------------------------------2,000 2,000 10,000 1,000 1,000 1,000 1,000 2,500 44,500 10,000 10,000 10,000 3,000 3,000 17,500 3,000 3,000 3,000 3,000 12,000 66,500 ---12,000 12,000 6,000 6,000 6,000 6,000 6,000 6,000 108,000 ---3,000 3,000 1,500 1,500 1,500 1,500 1,500 1,500 27,000 ---3,500 3,500 1,750 1,750 1,750 1,750 1,750 1,750 31,500 ---2,405 2,405 1,203 1,203 1,203 1,203 1,203 1,203 21,645 ---500 500 500 500 500 500 500 500 6,000 ---12,351 7,131 5,904 5,109 609 609 609 1,014 62,728 2,325 2,163 2,152 424,036 244,816 202,707 175,412 20,912 20,912 20,912 34,817 2,153,653 79,825 74,263 73,892 3,014,867 ---136,674 148,460 -1,379,203 7,379,203 1,729,882 1,802,356 -(89,050) (244,816) (202,707) (175,412) (5,726) 2,830,629 (20,912) (1,414,019) (31,144) 1,729,882 1,802,356 (73,892) 1,176,472 931,656 728,949 553,538 547,812 3,378,441 3,357,530 1,943,510 1,943,510 3,673,393 5,475,749 5,401,857