Excel模板-利润及亏损管理_第1页
Excel模板-利润及亏损管理_第2页
Excel模板-利润及亏损管理_第3页
Excel模板-利润及亏损管理_第4页
Excel模板-利润及亏损管理_第5页
已阅读5页,还剩2页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

,CompanyName,,,,,,,,,,,,,,,,,,,,,,,,,January,2010,,CurrentMonth,,January//2010,YTD,YTD(columns)

,,,,,,,,,,,,,,,,,,,,,,,,,,1,7,,1,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,January,2004,,January,,,January,1

,Profit&LossStatement,,Jan//10,Feb//10,Mar//10,1Q//10,Apr//10,May//10,Jun//10,2Q//10,Jul//10,Aug//10,Sep//10,3Q//10,Oct//10,Nov//10,Dec//10,4Q//10,YTDJan,FY,,,,,,February,2005,,Jan,,,February,2

,,,,,,,,,,,,,,,,,,,,,,,,,,March,2006,,,,,March,3

,Revenue/Sales,,,,,,,,,,,,,,,,,,,,,,,,,April,2007,,,,,April,5

,ApplicationMaintenance,,"100,000","100,000","100,000","300,000","110,000","110,000","110,000","330,000","120,000","120,000","120,000","360,000","130,000","130,000","130,000","390,000","100,000","1,380,000",,,,,,May,2008,,,,,May,6

,SoftwareLicenses,,"100,000","100,000","100,000","300,000","110,000","110,000","110,000","330,000","120,000","120,000","120,000","360,000","130,000","130,000","130,000","390,000","100,000","1,380,000",,,,,,June,2009,,,,,June,7

,SoftwareCustomization,,"50,000","50,000","50,000","150,000","60,000","60,000","60,000","180,000","70,000","70,000","70,000","210,000","80,000","80,000","80,000","240,000","50,000","780,000",,,,,,July,2010,,,,,July,9

,SoftwareSupport,,"60,000","60,000","60,000","180,000","70,000","70,000","70,000","210,000","80,000","80,000","80,000","240,000","90,000","90,000","90,000","270,000","60,000","900,000",,,,,,August,2011,,,,,August,10

,Services,,"100,000","100,000","100,000","300,000","110,000","110,000","110,000","330,000","120,000","120,000","120,000","360,000","130,000","130,000","130,000","390,000","100,000","1,380,000",,,,,,September,2012,,,,,September,11

,OtherSales,,"50,000","50,000","50,000","150,000","60,000","60,000","60,000","180,000","70,000","70,000","70,000","210,000","80,000","80,000","80,000","240,000","50,000","780,000",,,,,,October,2013,,,,,October,13

,OtherSales,,"60,000","60,000","60,000","180,000","70,000","70,000","70,000","210,000","80,000","80,000","80,000","240,000","90,000","90,000","90,000","270,000","60,000","900,000",,,,,,November,2014,,,,,November,14

,OtherSales,,"10,000","10,000","10,000","30,000","20,000","20,000","20,000","60,000","30,000","30,000","30,000","90,000","40,000","40,000","40,000","120,000","10,000","300,000",,,,,,December,2015,,,,,December,15

,OtherSales,,"5,000","5,000","5,000","15,000","15,000","15,000","15,000","45,000","25,000","25,000","25,000","75,000","35,000","35,000","35,000","105,000","5,000","240,000",,,,,,,,,,,,,

,TotalRevenue,,"535,000","535,000","535,000","1,605,000","625,000","625,000","625,000","1,875,000","715,000","715,000","715,000","2,145,000","805,000","805,000","805,000","2,415,000","535,000","8,040,000",,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,CostofGoodsSold,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,Salary,,"60,000","60,000","60,000","180,000","65,000","65,000","65,000","195,000","70,000","70,000","70,000","210,000","75,000","75,000","75,000","225,000","60,000","810,000",,,,,,,,,,,,,

,Benefits,,"10,000","10,000","10,000","30,000","15,000","15,000","15,000","45,000","20,000","20,000","20,000","60,000","25,000","25,000","25,000","75,000","10,000","210,000",,,,,,,,,,,,,

,Travel,,"10,000","10,000","10,000","30,000","15,000","15,000","15,000","45,000","20,000","20,000","20,000","60,000","25,000","25,000","25,000","75,000","10,000","210,000",,,,,,,,,,,,,

,SoftwareDevelopment,,"20,000","20,000","20,000","60,000","25,000","25,000","25,000","75,000","30,000","30,000","30,000","90,000","35,000","35,000","35,000","105,000","20,000","330,000",,,,,,,,,,,,,

,Contractorcost,,"30,000","30,000","30,000","90,000","35,000","35,000","35,000","105,000","40,000","40,000","40,000","120,000","45,000","45,000","45,000","135,000","30,000","450,000",,,,,,,,,,,,,

,OtherCostofSales,,"20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","240,000",,,,,,,,,,,,,

,OtherCostofSales,,"10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","120,000",,,,,,,,,,,,,

,OtherCostofSales,,"20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","20,000","20,000","60,000","20,000","240,000",,,,,,,,,,,,,

,OtherCostofSales,,"3,000","3,000","3,000","9,000","3,000","3,000","3,000","9,000","3,000","3,000","3,000","9,000","3,000","3,000","3,000","9,000","3,000","36,000",,,,,,,,,,,,,

,TotalCost,,"183,000","183,000","183,000","549,000","208,000","208,000","208,000","624,000","233,000","233,000","233,000","699,000","258,000","258,000","258,000","774,000","183,000","2,646,000",,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,GrossProfit,,"352,000","352,000","352,000","1,056,000","417,000","417,000","417,000","1,251,000","482,000","482,000","482,000","1,446,000","547,000","547,000","547,000","1,641,000","352,000","5,394,000",,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,Expenses,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,Salaryexpenses,,"5,000","5,000","5,000","15,000","10,000","10,000","10,000","30,000","15,000","15,000","15,000","45,000","20,000","20,000","20,000","60,000","5,000","150,000",,,,,,,,,,,,,

,PayrollTaxes,,"15,000","15,000","15,000","45,000","15,000","15,000","15,000","45,000","15,000","15,000","15,000","45,000","15,000","15,000","15,000","45,000","15,000","180,000",,,,,,,,,,,,,

,Advertising,,"50,000","50,000","50,000","150,000","65,000","65,000","65,000","195,000","80,000","80,000","80,000","240,000","95,000","95,000","95,000","285,000","50,000","870,000",,,,,,,,,,,,,

,Maintanence,,"4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","48,000",,,,,,,,,,,,,

,Accounting/Finance,,"5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","60,000",,,,,,,,,,,,,

,Travel,,"4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","4,000","4,000","12,000","4,000","48,000",,,,,,,,,,,,,

,Depreciation,,,,,0,,,,0,,,,0,,,,0,0,0,,,,,,,,,,,,,

,Rent/Lease,,"10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","10,000","10,000","30,000","10,000","120,000",,,,,,,,,,,,,

,DeliveryExpenses,,500,500,500,"1,500",500,500,500,"1,500",500,500,500,"1,500",500,500,500,"1,500",500,"6,000",,,,,,,,,,,,,

,Utilities/Telephone,,400,400,400,"1,200",400,400,400,"1,200",400,400,400,"1,200",400,400,400,"1,200",400,"4,800",,,,,,,,,,,,,

,Insurance,,"1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","12,000",,,,,,,,,,,,,

,PropertyTaxes,,"1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","18,000",,,,,,,,,,,,,

,Interest,,500,500,500,"1,500",500,500,500,"1,500",500,500,500,"1,500",500,500,500,"1,500",500,"6,000",,,,,,,,,,,,,

,OfficeExpenses,,400,400,400,"1,200",400,400,400,"1,200",400,400,400,"1,200",400,400,400,"1,200",400,"4,800",,,,,,,,,,,,,

,Amortization,,,,,0,,,,0,,,,0,,,,0,0,0,,,,,,,,,,,,,

,VehicleExpenses,,"1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","1,500","1,500","4,500","1,500","18,000",,,,,,,,,,,,,

,ContractorLabor,,"5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","5,000","5,000","15,000","5,000","60,000",,,,,,,,,,,,,

,BadDebts,,"1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","12,000",,,,,,,,,,,,,

,Otherexpenses,,"1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000","1,000","1,000","3,000","1,000",

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论