Excel模板-利潤及虧損管理_第1頁
Excel模板-利潤及虧損管理_第2頁
Excel模板-利潤及虧損管理_第3頁
Excel模板-利潤及虧損管理_第4頁
Excel模板-利潤及虧損管理_第5頁
已閱讀5頁,還剩2頁未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進(jìn)行舉報或認(rèn)領(lǐng)

文檔簡介

,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. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

最新文檔

評論

0/150

提交評論