投資測算-影院-購物中心影院投資分析報告表.xls
下載文檔
上傳人:職z****i
編號:1169745
2024-09-13
1頁
35.50KB
1、項項目目投投資資預預測測(單單位位:元元)2010020100811811項項目目20*120*120*220*220*320*320*420*420*520*520*620*620*720*720*820*820*820*820*20*營業時間(月)12121212121212121212座位數1560156015601560156015601560156015601560平均票價(元)33333333333535353535日均場次6666666666上座率18%20%22%24%26%28%30%30%30%30%觀眾數614,952683,280751,608819,936888,262、4956,5921,024,9201,024,9201,024,9201,024,920票房20,293,41622,548,24024,803,06427,057,88829,312,71233,480,72035,872,20035,872,20035,872,20035,872,200收收入入20*120*120*220*220*320*320*420*420*520*520*620*620*720*720*820*820*820*820*20*票房總收入(a)20,293,41622,548,24024,803,06427,057,88829,312,71233,480,72035,83、72,20035,872,20035,872,20035,872,200扣票房稅金及電影基金(b)=(a)*8.3%1,684,3541,871,5042,058,6542,245,8052,432,9552,778,9002,977,3932,977,3932,977,3932,977,393凈凈票票房房收收入入(a)-(b)(a)-(b)18,609,06218,609,06220,676,73620,676,73622,744,41022,744,41024,812,08324,812,08326,879,75726,879,75730,701,82030,701,82032,894,84、0732,894,80732,894,80732,894,80732,894,80732,894,80732,894,80732,894,807扣票房分賬c=(a)-(b)*48%8,932,3509,924,83310,917,31711,909,80012,902,28314,736,87415,789,50815,789,50815,789,50815,789,508影院所得票房收入(d)=(a)-(b)-c9,676,71210,751,90311,827,09312,902,28313,977,47415,964,94717,105,30017,105,30017,105,300175、,105,300小賣部收入(e)=(a)*13%2,638,1442,931,2713,224,3983,517,5253,810,6534,352,4944,663,3864,663,3864,663,3864,663,386電影衍生產品收入(f)=(a)*3%608,802676,447744,092811,737879,3811,004,4221,076,1661,076,1661,076,1661,076,166廣告等其他收入(g)=(a)*5%1,014,6711,127,4121,240,1531,352,8941,465,6361,674,0361,793,6101,793,616、01,793,6101,793,610影影院院總總收收入入(h)=(d)+(e)+(f)+(g)(h)=(d)+(e)+(f)+(g)13,938,33013,938,33015,487,03315,487,03317,035,73617,035,73618,584,44018,584,44020,133,14320,133,14322,995,89822,995,89824,638,46224,638,46224,638,46224,638,46224,638,46224,638,46224,638,46224,638,462直直接接花花費費20*120*120*220*220*320*327、0*420*420*520*520*620*620*720*720*820*820*820*820*20*營業稅(i)=(e)+(f)+(g)*5%213,081236,757260,432284,108307,783351,548376,658376,658376,658376,658小賣部成本(j)=(e)*35%923,3501,025,9451,128,5391,231,1341,333,7281,523,3731,632,1851,632,1851,632,1851,632,185電影衍生品成本(k)=(f)*40%243,521270,579297,637324,695351,758、3401,769430,466430,466430,466430,466廣告成本(l)=(g)*60%608,802676,447744,092811,737879,3811,004,4221,076,1661,076,1661,076,1661,076,166直接花費總計1,988,7552,209,7282,430,7002,651,6732,872,6463,281,1113,515,4763,515,4763,515,4763,515,476毛毛利利潤潤11,949,57511,949,57513,277,30613,277,30614,605,03614,605,03615,932,9、76715,932,76717,260,49717,260,49719,714,78719,714,78721,122,98621,122,98621,122,98621,122,98621,122,98621,122,98621,122,98621,122,986間間接接費費用用20*120*120*220*220*320*320*420*420*520*520*620*620*720*720*820*820*820*820*20*提成租金2,233,0872,481,2082,729,3293,225,5713,494,3683,991,2374,605,2734,605,2734,60510、,2734,934,221實際租金3,300,0003,300,0003,300,0003,630,0003,630,0003,991,2374,605,2734,605,2734,605,2734,934,221小賣部收入分賬263,814293,127322,440351,753381,065435,249466,339466,339466,339466,339物業費及推廣費1,948,8001,948,8001,948,8001,948,8001,948,8001,948,8001,948,8001,948,8001,948,8001,948,800人工、水電及日常營運費影院總收入的3011、%4,181,4994,646,1105,110,7215,575,3326,039,9436,898,7697,391,5397,391,5397,391,5397,391,539期期間間費費用用總總計計9,694,1139,694,11310,188,03710,188,03710,681,96110,681,96111,505,88411,505,88411,999,80811,999,80813,274,05513,274,05514,411,95014,411,95014,411,95014,411,95014,411,95014,411,95014,740,89814,740,8912、8經營利潤2,255,4623,089,2693,923,0754,426,8825,260,6896,440,7326,711,0366,711,0366,711,0366,382,088折舊3,588,0003,588,0003,588,0003,588,0003,588,0005,188,0005,188,0005,188,0005,188,0005,188,000所得稅(稅率24%)0080,418201,332401,445300,656365,529365,529365,529286,581凈凈利利潤潤-1,332,538-1,332,538-498,731-498,731254,13、657254,657637,551637,5511,271,2441,271,244952,076952,0761,157,5071,157,5071,157,5071,157,5071,157,5071,157,507907,507907,507凈凈利利率率-9.56%-9.56%-3.22%-3.22%1.49%1.49%3.43%3.43%6.31%6.31%4.14%4.14%4.70%4.70%4.70%4.70%4.70%4.70%3.68%3.68%投投資資收收益益分分析析20*120*120*220*220*320*320*420*420*520*520*620*620*72014、*720*820*820*820*820*20*現金流出-35,880,000-8,000,000凈利潤-1,332,538-498,731254,657637,5511,271,244952,0761,157,5071,157,5071,157,507907,507折舊3,588,0003,588,0003,588,0003,588,0003,588,0005,188,0005,188,0005,188,0005,188,0005,188,000凈現金流量-33,624,5383,089,2693,842,6574,225,5514,859,244-1,859,9246,345,5076,345,5076,345,5076,095,507若每座投入2.3萬,按照1560個座位,總投資額約3588萬。第6年初投入800萬元進行裝修翻新等支出。其它商業條件,如租金,物業費,小賣部分成等按照目前提供的條件。計算的靜態投資回收期為9.1年左右。