投资测算-影院-购物中心影院投资分析报告表.xls
下载文档
上传人:地**
编号:1260613
2024-11-21
2页
126KB
该文档所属资源包:
房地产投资成本测算模板excel自动计算带公式
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年左右。
管理运营
上传时间:2024-12-17
190份