PROFIT AND LOSS STATEMENT NET INCOME
YEAR COMPANY NAME
Rp.72,450
Line chart showing Gross Profit and Total Operation Expenses is in this cell. Enter data in table below. Gross Profit
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
Income From Operations Rp.14,159 Rp.24,981 Rp.15,642 ($17,560) Rp.17,044 Rp.19,216 Rp.19,082 Rp.134,210
Interest Income (Expense) ($100) ($105) ($110) ($116) ($122) ($128) ($134) ($814)
Income Before Income Taxes Rp.14,059 Rp.24,876 Rp.15,532 ($17,675) Rp.16,922 Rp.19,088 Rp.18,948 Rp.91,750
Income Tax Expense Rp.2,400 Rp.2,500 Rp.2,600 Rp.2,700 Rp.2,900 Rp.3,000 Rp.3,200 Rp.19,300
Net Income Rp.11,659 Rp.22,376 Rp.12,932 ($20,375) Rp.14,022 Rp.16,088 Rp.15,748 Rp.72,450
PROFIT AND LOSS STATEMENT - REVENUE
YEAR COMPANY NAME
Revenue JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
Sales $50,000 $63,098 $55,125 $23,881 $60,775 $63,814 $67,005 $89,000 $472,698
Sales Returns (Reduction) $0 ($500) $0 $0 ($234) $0 $0 ($300) ($1,034)
Sales Discounts (Reduction) ($5,000) ($5,250) ($5,513) ($5,788) ($6,078) ($5,324) ($6,700) ($400) ($40,053)
Other Revenue 1 $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000
Other Revenue 2 $0 $0 $0 $0 $0 $0 $0 $0
Other Revenue 3 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $45,000 $57,348 $49,612 $18,093 $54,463 $58,490 $60,305 $90,300 $433,611
Cost of Goods Sold $20,000 $21,000 $22,050 $23,153 $24,310 $25,526 $26,802 $48,654 $211,494
Gross Profit $25,000 $36,348 $27,562 ($5,060) $30,153 $32,964 $33,503 $41,646 $222,117
Page 2 of 3
PROFIT AND LOSS STATEMENT - OPERATION EXPENSES
YEAR COMPANY NAME
Operation Expenses JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
Salaries & Wages $7,500 $7,875 $8,269 $8,682 $9,116 $9,572 $10,051 $61,065
Depreciation $500 $525 $551 $579 $608 $638 $670 $4,071
Rent $1,500 $1,575 $1,654 $1,736 $1,823 $1,914 $2,010 $12,213
Office Supplies $475 $499 $524 $550 $577 $606 $637 $3,867
Utilities $123 $123 $123 $123 $123 $123 $123 $861
Telephone $68 $68 $68 $68 $68 $68 $68 $476
Insurance $125 $125 $125 $125 $125 $125 $125 $875
Travel $250 $263 $276 $289 $304 $319 $335 $2,036
Maintenance $100 $105 $110 $116 $122 $128 $134 $814
Advertising $200 $210 $221 $232 $243 $255 $268 $1,628
Other 1 $0 $0 $0 $0 $0 $0 $0 $0
Other 2 $0 $0 $0 $0 $0 $0 $0 $0
Other 3 $0 $0 $0 $0 $0 $0 $0 $0
Total Operation Expenses $10,841 $11,367 $11,920 $12,500 $13,109 $13,749 $14,421 $87,907
Page 3 of 3