老外做的漂亮的EXCEL
Company Name
Profit & Loss Statement
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
YTD Jan
FY
Revenue/ Sales Application Maintenance 100,000100,000100,000300,000110,000110,000110,000330,000120,000120,000120,000360,000130,000130,000130,000390,000100,0001,380,000Software Licenses 100,000100,000100,000300,000110,000110,000110,000330,000120,000120,000120,000360,000130,000130,000130,000390,000100,0001,380,000Software Customization 50,00050,00050,000150,00060,00060,00060,000180,00070,00070,00070,000210,00080,00080,00080,000240,00050,000780,000Software Support 60,000
60,000
60,000180,00070,00070,00070,000210,00080,00080,00080,000240,00090,00090,00090,000270,00060,000900,000Services 100,000100,000100,000300,000110,000110,000110,000330,000120,000120,000120,000360,000130,000130,000130,000390,000100,0001,380,000Other Sales 50,00050,000
50,000150,00060,00060,00060,000180,00070,00070,00070,000210,00080,00080,00080,000240,00050,000780,000Other Sales 60,00060,00060,000180,00070,00070,00070,000210,00080,00080,00080,000240,00090,00090,00090,000270,00060,000900,000Other Sales 10,00010,00010,00030,00020,00020,00020,00060,00030,00030,00030,00090,00040,00040,00040,000120,00010,000300,000Other Sales 5,0005,0005,00015,00015,00015,00015,00045,00025,00025,00025,00075,00035,00035,00035,000105,0005,000240,000Total Revenue 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
Cost of Goods Sold Salary 60,00060,00060,000180,00065,00065,00065,000195,00070,00070,00070,000210,00075,00075,00075,000225,00060,000810,000Benefits 10,00010,00010,00030,00015,00015,00015,00045,00020,00020,00020,00060,00025,00025,00025,00075,00010,000210,000Travel
10,00010,00010,00030,00015,00015,00015,00045,00020,00020,00020,00060,00025,00025,00025,00075,00010,000210,000Software Development 20,000
20,000
20,00060,00025,00025,00025,00075,00030,00030,00030,00090,00035,00035,00035,000105,00020,000330,000Contractor cost 30,00030,00030,00090,00035,00035,00035,000105,00040,00040,00040,000120,00045,00045,00045,000135,00030,000450,000Other Cost of Sales 20,00020,000
20,00060,00020,00020,00020,00060,00020,00020,00020,00060,00020,00020,00020,00060,00020,000240,000Other Cost of Sales 10,00010,00010,00030,00010,00010,00010,00030,00010,00010,00010,00030,00010,00010,00010,00030,00010,000120,000Other Cost of Sales 20,00020,00020,00060,00020,00020,00020,00060,00020,00020,00020,00060,00020,00020,00020,00060,00020,000240,000Other Cost of Sales 3,0003,0003,0009,0003,0003,0003,0009,0003,0003,0003,0009,0003,0003,0003,0009,0003,00036,000Total Cost 183,000183,000183,000549,000208,000208,000208,000624,000233,000233,000233,000699,000258,000258,000258,000774,000183,0002,646,000Gross Profit 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 Salary expenses 5,0005,0005,00015,00010,00010,00010,00030,00015,00015,00015,00045,00020,00020,00020,00060,0005,000150,000Payroll Taxes 15,00015,00015,00045,00015,00015,00015,00045,00015,00015,00015,00045,00015,00015,00015,00045,00015,000180,000Advertising 50,00050,00050,000150,00065,00065,00065,000195,00080,00080,00080,000240,00095,00095,00095,000285,00050,000870,000Maintanence 4,000
4,000
4,00012,0004,0004,0004,00012,0004,0004,0004,00012,0004,0004,0004,00012,0004,00048,000Accounting/Finance 5,0005,0005,00015,0005,0005,0005,00015,0005,0005,0005,00015,0005,0005,0005,00015,0005,00060,000Travel 4,0004,0004,00012,000
4,0004,0004,00012,000
4,0004,0004,00012,000
4,0004,0004,00012,000
4,000
48,000
Depreciation 000000
Rent/Lease 10,000
10,000
10,000
30,00010,000
10,000
10,000
30,00010,000
10,000
10,000
30,00010,000
10,000
10,000
30,00010,000
120,000Delivery Expenses 5005005001,5005005005001,5005005005001,5005005005001,5005006,000Utilities/Telephone 4004004001,2004004004001,2004004004001,2004004004001,2004004,800Insurance 1,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,00012,000Property Taxes 1,5001,5001,5004,5001,5001,5001,5004,5001,5001,5001,5004,5001,5001,5001,5004,5001,50018,000Interest 5005005001,5005005005001,5005005005001,5005005005001,5005006,000Office Expenses 4004004001,200
4004004001,200
4004004001,200
4004004001,200
4004,800
Amortization 000000Vehicle Expenses 1,5001,5001,5004,5001,5001,5001,5004,5001,5001,5001,5004,5001,5001,5001,5004,5001,50018,000Contractor Labor 5,0005,0005,00015,0005,0005,0005,00015,0005,0005,0005,00015,0005,0005,0005,00015,0005,00060,000Bad Debts 1,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,00012,000Other expenses 1,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,0001,0001,0003,0001,00012,000Other expenses 4,0004,0004,00012,0004,0004,0004,00012,0004,0004,0004,00012,0004,0004,0004,00012,0004,00048,000Other expenses 3,0003,0003,0009,0003,0003,0003,0009,0003,0003,0003,0009,0003,0003,0003,0009,0003,00036,000Total Expenses 112,800112,800112,800338,400132,800132,800132,800398,400152,800152,800152,800458,400172,800172,800172,800518,400112,8001,713,600Net Profit
239,200
239,200
239,200
717,600
284,200
284,200
284,200
852,600
329,200
329,200
329,200
987,600
374,200
374,200
374,200
1,122,600
239,200
3,680,400
January // 2010
Demo : First three revenue
lines are unlocked Demo : Spreadsheet is password protected in Demo version
Demo : First three cost
lines are unlocked Demo : First three expense lines are unlocked