老外做的漂亮的EXCEL
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
852,600
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
329,200
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
10,000 15,000 65,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
Net Profit
Demo: Spreadsheet is password protected in Demo version
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
5,000
5,000
5,000
15,000
15,000
15,000
50,000
50,000
50,000
4,000
4,000
4,000
5D,0e0m0 o: First t5h,r0e0e0expense5,000 4,000lines are4u,n00lo0cked 4,000
10,000 500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
417,000
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
417,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
329,200
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
482,000
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
482,000
717,600
10,000 15,000 65,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
10,000 15,000 65,000
4,000 5,000 4,000
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
195,000 45,000 45,000 75,000
105,000 60,000 30,000 60,000 9,000
624,000
417,000 1,251,000
60,000 10,000 10,000 20,000 30,000 20,000 10,000 20,000
3,000 183,000
810,000 210,000 210,000 330,000 450,000 240,000 120,000 240,000
36,000 2,646,000
352,000 5,394,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
225,000 75,000 75,000
105,000 135,000
60,000 30,000 60,000
9,000 774,000
547,000 1,641,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
330,000 330,000 180,000 210,000 330,000 180,000 210,000
60,000 45,000 1,875,000
120,000 120,000
60,000
60,000
60,000
10,000
10,000
10,000
5,000
5,000
5,000
535,000
535,000
535,000
300,000 300,000 150,000 180,000 300,000 150,000 180,000
30,000 15,000 1,605,000
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
Leabharlann Baidu
210,000 60,000 60,000 90,000
120,000 60,000 30,000 60,000 9,000
699,000
482,000 1,446,000
360,000 360,000 210,000 240,000 360,000 210,000 240,000
90,000 75,000 2,145,000
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
547,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
547,000
10,000
10,000
20,000
20,000
20,000
3,000
3,000
3,000
183,000
183,000
183,000
180,000 30,000 30,000 60,000 90,000 60,000 30,000 60,000 9,000
549,000
352,000
352,000
352,000 1,056,000
1,500 5,000 1,000 1,000 4,000 3,000 112,800
239,200
239,200
239,200
15,000 45,000 150,000 12,000 15,000 12,000
0 30,000
1,500 1,200 3,000 4,500 1,500 1,200
0 4,500 15,000 3,000 3,000 12,000 9,000 338,400
Nov//10
Dec//10
4Q//10
YTD Jan
FY
100,000
100,000
100,000
100,000
100,000
100,000
50,000
50,000
50,000
60,000
60,000
60,000
100D,e0m00o: Firs1t 0th0r,e0e00revenu1e00,000 50,000lines are5u0n,0lo0c0ked 50,000
Gross Profit
Expenses Salary expenses Payroll Taxes Advertising Maintanence Accounting/Finance Travel Depreciation Rent/Lease Delivery Expenses Utilities/Telephone Insurance Property Taxes Interest Office Expenses Amortization Vehicle Expenses Contractor Labor Bad Debts Other expenses Other expenses Other expenses Total Expenses
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
120,000 120,000
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
120,000 120,000
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
100,000 100,000
50,000 60,000 100,000 50,000 60,000 10,000
5,000 535,000
1,380,000 1,380,000
780,000 900,000 1,380,000 780,000 900,000 300,000 240,000 8,040,000
Cost of Goods Sold Salary Benefits Travel Software Development Contractor cost Other Cost of Sales Other Cost of Sales Other Cost of Sales Other Cost of Sales Total Cost
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
390,000 390,000 240,000 270,000 390,000 240,000 270,000 120,000 105,000 2,415,000
Company Name
January // 2010
Profit & Loss Statement
Revenue/ Sales Application Maintenance Software Licenses Software Customization Software Support Services Other Sales Other Sales Other Sales Other Sales Total Revenue
60,000
60,000
60,000
10,000
10,000
10,000
10,000
10,000
10,000
20,000
20,000
20,000
30,0D0e0mo: Firs3t0t,h0r0e0e cost 30,000 20,000lines are2u0n,0lo0c0ked 20,000
10,000
110,000 110,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
110,000 110,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
110,000 110,000
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
30,000 45,000 195,000 12,000 15,000 12,000
0 30,000
1,500 1,200 3,000 4,500 1,500 1,200
0 4,500 15,000 3,000 3,000 12,000 9,000 398,400
1,000 1,500
500 400
10,000 500 400
1,000 1,500
500 400
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 112,800
1,500 5,000 1,000 1,000 4,000 3,000 112,800
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
329,200
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
10,000 15,000 65,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
Net Profit
Demo: Spreadsheet is password protected in Demo version
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
5,000
5,000
5,000
15,000
15,000
15,000
50,000
50,000
50,000
4,000
4,000
4,000
5D,0e0m0 o: First t5h,r0e0e0expense5,000 4,000lines are4u,n00lo0cked 4,000
10,000 500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
417,000
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
417,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 152,800
329,200
15,000 15,000 80,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
482,000
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
482,000
717,600
10,000 15,000 65,000
4,000 5,000 4,000
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
10,000 15,000 65,000
4,000 5,000 4,000
65,000 15,000 15,000 25,000 35,000 20,000 10,000 20,000
3,000 208,000
195,000 45,000 45,000 75,000
105,000 60,000 30,000 60,000 9,000
624,000
417,000 1,251,000
60,000 10,000 10,000 20,000 30,000 20,000 10,000 20,000
3,000 183,000
810,000 210,000 210,000 330,000 450,000 240,000 120,000 240,000
36,000 2,646,000
352,000 5,394,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
225,000 75,000 75,000
105,000 135,000
60,000 30,000 60,000
9,000 774,000
547,000 1,641,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
330,000 330,000 180,000 210,000 330,000 180,000 210,000
60,000 45,000 1,875,000
120,000 120,000
60,000
60,000
60,000
10,000
10,000
10,000
5,000
5,000
5,000
535,000
535,000
535,000
300,000 300,000 150,000 180,000 300,000 150,000 180,000
30,000 15,000 1,605,000
70,000 20,000 20,000 30,000 40,000 20,000 10,000 20,000
3,000 233,000
Leabharlann Baidu
210,000 60,000 60,000 90,000
120,000 60,000 30,000 60,000 9,000
699,000
482,000 1,446,000
360,000 360,000 210,000 240,000 360,000 210,000 240,000
90,000 75,000 2,145,000
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
547,000
75,000 25,000 25,000 35,000 45,000 20,000 10,000 20,000
3,000 258,000
547,000
10,000
10,000
20,000
20,000
20,000
3,000
3,000
3,000
183,000
183,000
183,000
180,000 30,000 30,000 60,000 90,000 60,000 30,000 60,000 9,000
549,000
352,000
352,000
352,000 1,056,000
1,500 5,000 1,000 1,000 4,000 3,000 112,800
239,200
239,200
239,200
15,000 45,000 150,000 12,000 15,000 12,000
0 30,000
1,500 1,200 3,000 4,500 1,500 1,200
0 4,500 15,000 3,000 3,000 12,000 9,000 338,400
Nov//10
Dec//10
4Q//10
YTD Jan
FY
100,000
100,000
100,000
100,000
100,000
100,000
50,000
50,000
50,000
60,000
60,000
60,000
100D,e0m00o: Firs1t 0th0r,e0e00revenu1e00,000 50,000lines are5u0n,0lo0c0ked 50,000
Gross Profit
Expenses Salary expenses Payroll Taxes Advertising Maintanence Accounting/Finance Travel Depreciation Rent/Lease Delivery Expenses Utilities/Telephone Insurance Property Taxes Interest Office Expenses Amortization Vehicle Expenses Contractor Labor Bad Debts Other expenses Other expenses Other expenses Total Expenses
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
120,000 120,000
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
120,000 120,000
70,000 80,000 120,000 70,000 80,000 30,000 25,000 715,000
100,000 100,000
50,000 60,000 100,000 50,000 60,000 10,000
5,000 535,000
1,380,000 1,380,000
780,000 900,000 1,380,000 780,000 900,000 300,000 240,000 8,040,000
Cost of Goods Sold Salary Benefits Travel Software Development Contractor cost Other Cost of Sales Other Cost of Sales Other Cost of Sales Other Cost of Sales Total Cost
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
130,000 130,000
80,000 90,000 130,000 80,000 90,000 40,000 35,000 805,000
390,000 390,000 240,000 270,000 390,000 240,000 270,000 120,000 105,000 2,415,000
Company Name
January // 2010
Profit & Loss Statement
Revenue/ Sales Application Maintenance Software Licenses Software Customization Software Support Services Other Sales Other Sales Other Sales Other Sales Total Revenue
60,000
60,000
60,000
10,000
10,000
10,000
10,000
10,000
10,000
20,000
20,000
20,000
30,0D0e0mo: Firs3t0t,h0r0e0e cost 30,000 20,000lines are2u0n,0lo0c0ked 20,000
10,000
110,000 110,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
110,000 110,000
60,000 70,000 110,000 60,000 70,000 20,000 15,000 625,000
110,000 110,000
1,500 5,000 1,000 1,000 4,000 3,000 132,800
284,200
30,000 45,000 195,000 12,000 15,000 12,000
0 30,000
1,500 1,200 3,000 4,500 1,500 1,200
0 4,500 15,000 3,000 3,000 12,000 9,000 398,400
1,000 1,500
500 400
10,000 500 400
1,000 1,500
500 400
10,000 500 400
1,000 1,500
500 400
1,500 5,000 1,000 1,000 4,000 3,000 112,800
1,500 5,000 1,000 1,000 4,000 3,000 112,800