All Amounts Are Indicated in Philippine Pesos (PHP)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 22

Sweet Escape Company

Income Statement
2014-2018
all amounts are indicated in Philippine Pesos (PHP)

2014
Revenue:
Sales
Less: Cost of Goods Sold
Raw Materials used
Beginning balance
Purchases of Raw Materials
Raw Materials Available
Ending balance
Total Material used
Direct Labor
Variable Overhead
Fixed Overhead
Total Manufacturing Costs
Work in Process, beg
Work in Process, end
Cost of Goods Manufactured
Finished goods Inventory, beg
Cost of Goods Available for Sale
Finished goods Inventory, end
Cost of Goods Sold
Gross Profit
Administrative Expenses:
Office Supplies Expense
Store Supplies Expense
Depreciation Expense - f&f
Depreciation Expense - Kitchen
Depreciation Expense - Store
Depreciation Expense - Office
Gas and Oil Expense
Rent Expense
Utilities Expense
Miscellaneous Expense
Salaries Expense
Advertising Expense
Legal fees expense
Withholding Tax expense
SSS Contribution expense
PhilHealth Contribution expense
Home Dev't Fund expense

2015
9025603

0
1,537,288.25
1,537,288.25
39,899.75
1,497,388.50
700,321.50
1050482.25
800,000
4,048,192.25
0.00
242891.535
3,805,300.72
426,160
4,231,461
18403.85

39,899.75
1,518,858.71
1,558,758.46
29,924.81
1,528,833.65
668,876.35
1293407.81
800,000
4,291,117.81
242,891.54
200051.2263
4,333,958.12
18,403.85
4,352,361.97
38076
4,213,057
4,812,546

7,541
164,017.73
13,982
31,906
15,476
2,400
10,800
300,000
168,000
8,490
1388181.55
10,000
9,948.70
15,300
91,560
17,850
14,400

7,699
167,461.90
13,982
31,906
15,476
2,400
10,800
306,300
168,176.40
6,871
1388181.55
2,976
9,948.70
15,300
91,560
17,850
14,400

Total Administrative Expenses


Finance Charges - Interest Expense
Net Income before tax
Less: Income Tax Expense
Net Income After Tax

2,269,853
160,000
2,382,693
714807.861
1,667,885

Sweet Escape Company


Income Statement
2014-2018

2015

2016

9297395.68

2017

9575033.996

29,924.81
1,550,964.23
1,580,889.04
19,949.88
1,560,939.16
636,770.84
1184959.43
800,000
4,182,669.43
208,358.88
197643.313
4,193,385.00
38,076.00
4,231,461.00
56522.47
4,314,285.97
4,983,109.71

9862501.679

19,949.88
1,583,743.94
1,603,693.82
9,974.94
1,593,718.88
603,991.12
1278754
800,000
4,276,464.00
214,560.04
195184.834
4,295,839.21
56,522.47
4,352,361.68
69388.71
4,174,938.53
5,400,095.47

7,861
170,978.60
13,982
31,906
15,476
2,400
10,800
312,732.30
168,356.50
7,015
1388181.55
3,038
9,948.70
15,300
91,560
17,850
14,400

2018
10158505.21

9,974.94
1,622,199.52
1,632,174.46
4,987.48
1,627,186.98
570,523.02
1377782.37
800,000
4,375,492.37
221,024.65
192674.73
4,403,842.29
69,388.71
4,473,231.00
72872.33
4,282,972.97
5,579,528.71

8,026
174,569.14
13,982
31,906
15,476
2,400
10,800
319,299.49
168,540.39
7,163
1388181.55
7,102
9,948.70
15,300
91,560
17,850
14,400

4,400,358.67
5,758,146.54

8,195
178,235.10
13,982
31,906
15,476
2,400
326,004.78
168,728.14
7,313
1388181.55
3,167
9,948.70
15,300
91,560
17,850
14,400

2,271,289
120,000
2,591,820
777546.1411
1,814,274

2,281,786
80,000
3,038,309
911492.7066
2,126,816

2,296,505
40,000
3,243,024
972907.2185
2,270,117

2,292,648
3,465,499
1039649.639
2,425,849

Sweet Escape Company


Statement of changes in Equity
For the Years ended 2014-2018
all amounts are indicated in Philippine Pesos (PHP)

Capital Balances, beg


Net Income (Loss) - shared equally
Less; Withdrawals
Capital Balances, end

2014
800,000
238,269.29
-150,000
888,269.3

Samonte, Capital
2015
2016
2017
888,269.3
997,451.3 1,151,282.24
259,182
303,830.90
324,302
-150,000
-150,000
-150,000
997,451.3 1,151,282.24 1,325,584.64

2018
1,325,584.64
346,550
-150,000
1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

2015
888,269.3
259,182
-150,000
997,451.3

Capile, Capital
2016
997,451.3
303,830.90
-150,000
1,151,282.24

Buc
2017
2018
1,151,282.24 1,325,584.64
324,302
346,550
-150,000
-150,000
1,325,584.64 1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

Bucaneg, Capital
2015
2016
2017
2018
888,269.3
997,451.3
1,151,282.2 1,325,584.6
259,182
303,830.90
324,302
346,550
-150,000
-150,000
-150,000
-150,000
997,451.33 1,151,282.24 1,325,584.64 1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

Tampus, Capital
2015
2016
888,269.3
997,451.3
259,182
303,830.90
-150,000
-150,000
997,451.33 1,151,282.24

pus, Capital
2017
2018
1,151,282.2 1,325,584.6
324,302
346,550
-150,000
-150,000
1,325,584.64 1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

Almasin, Capital
2015
2016
2017
2018
888,269.3
997,451.3
1,151,282.2 1,325,584.6
259,182
303,830.90
324,302
346,550
-150,000
-150,000
-150,000
-150,000
997,451.33 1,151,282.24 1,325,584.64 1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

2015
888,269.3
259,182
-150,000
997,451.33

Adino, Capital
2016
2017
997,451.3 1,151,282.2
303,830.90
324,302
-150,000
-150,000
1,151,282.24 1,325,584.64

Manzano, Capit
2018
1,325,584.6
346,550
-150,000
1,522,134.52

2014
800,000
238,269.29
-150,000
888,269.3

2015
888,269.3
259,182
-150,000
997,451.33

Manzano, Capital
2016
2017
997,451.3
1,151,282.2
303,830.90
324,302
-150,000
-150,000
1,151,282.24
1,325,584.64

2018
1,325,584.6
346,550
-150,000
1,522,134.52

Sweet Escape Compa


Statement of Financial P
As of the year ended 2014, 2015, 20
all amounts are indicated in Philippine Pesos (PHP)

2014

2015

Assets
Current Assets:
Cash
Accounts Receivable
Raw Materials Inventory
Work-in-Process Inventory
Finished goods Inventory
Office Supplies
Store Supplies
Total Current Assets
Non-current Assets
Furniture and Fixtures
Accumulated Depreciation- f&f
Kitchen Equipment
Accumulated Depreciation
Store Equipment
Accumulated Depreciation
Office Equipment
Accumulated Depreciation
Leasehold Improvements
Total Non-current Assets
TOTAL ASSETS
Liabilities
Current Liabilities
Accounts Payable
Withholding Tax payable
SSS Contribution Payable
PhilHealth Contribution Payable
Home Dev't Fund Payable
Vat Payable
Loan Payable, current
Total Current Liabilities
Non-Current Liability
Loan Payable
Total Non-Current Liabiliy
TOTAL LIABILITIES

5,906,783.66
2,239,252.10
39,899.75
242,891.54
18,403.85
6,205.00
2,812.47

6,233,676.07
2,306,683.87
29,924.81
200,051.23
38,076.00
6,853
1,636.85
8,456,248.37

87,200
-13,982
375,628
-31,906
138,728
-15,476
17,750
-2,400
67,005

87,200
-27964
375,628
-63812
138,728
-30952
17,750
-4800
67,005
622,547
9,078,795.37

138728
15,300
91,560
17,850
14,400
1,083,072
500,000

138728
15,300
91,560
17,850
14,400
1,115,687.48
500,000
1,860,910

1,000,000

500,000
1,000,000
2,860,910

Equity
Samonte, Capital
Capile, Capital
Bucaneg, Capital
Tampus, Capital
Almasin, Capital
Adino, Capital
Manzano, Capital
Total Equity
TOTAL LIABILITIES AND CAPITAL

888,269.3
888,269.3
888,269.3
888,269.3
888269.287
888269.287
888269.287

997,451.33
997,451.33
997,451.33
997,451.33
997,451.33
997,451.33
997,451.33
6,217,885.0
9,078,795.4

Sweet Escape Company


Statement of Financial Position
As of the year ended 2014, 2015, 2016,2017 and 2018

2015

2016

2017

6,831,797
2,375,565.93
19,949.88
197,643.31
56,522.47
8229
1,091.24
8,816,901.82

7,578,880.23
2,446,886.67
9,974.94
195,184.83
69,388.71
8315
545.92
9,490,798.73

87,200
-41,946
375,628
-95,718
138,728
-46,428
17,750
-7,200
67,005
558,783
9,375,684.82

10,309,176.30

87,200
-55,928
375,628
-127,624
138,728
-61,904
17,750
-9,600
67,005
495,019
9,985,817.73

138728
15,300
91,560
17,850
14,400
1,149,004.08
500,000

431,255
10,740,431.30

138728
15,300
91,560
17,850
14,400
1,183,500.20

1893525.482

1926842.08

1461338.201

500,000
2,393,525

0
1,926,842

0
1,461,338

1,151,282.24
1,151,282.24
1,151,282.24
1,151,282.24
1,151,282.24
1,151,282.24
1,151,282.24
6,982,159.3
9,375,684.8

1,325,584.64
1,325,584.64
1,325,584.64
1,325,584.64
1,325,584.64
1,325,584.64
1,325,584.64
8,058,975.7
9,985,817.7

9,279,092.5
10,740,430.7

2018

8,984,838.24
2,520,325.14
4,987.48
192,674.73
72,872.33
8339
272.96
11,784,309.88

87,200
-69,910
375,628
-159,530
138,728
-77,380
17,750
-12,000
67,005
367,491
12,151,800.88

138728
15,300
91,560
17,850
14,400
1,219,020.63
1496858.625

0
1,496,859

1,522,134.52
1,522,134.52
1,522,134.52
1,522,134.52
1,522,134.52
1,522,134.52
1,522,134.52
10,654,941.7
12,151,800.3

Sweet Escape Comp


Statement of Cash Fl
For the years ended 201
all amouns are indicated in Philippine Pesos (PHP)

2014

Cash flows from Operating Activities:


Profit before income tax
Adjustments for:
Depreciation
Interest Expense
Decrease (Increase) in Accounts Receivable
Decrease (Increase) in Raw Materials Inventory
Decrease (Increase) in Work in Process Inventory
Decrease (Increase) in Finished Goods Inventory
Decrease (Increase) in Store Supplies
Decrease (Increase) in Office Supplies
Increase (Decrease) in Current Liabilities
Cash Generated from Operations
Interest paid
Income Taxes paid
Net cash generated (used) for operating activities
Cash flows from Investing Activities:
Acquisition of Kitchen Equipment
Acquisition of Store Equipment
Acquisition of Furniture and Fixture
Acquisition of office equipment
Payments for Leasehold Improvements
Net cash generated (used) for investing activities
Cash flows from Financing Activities:
Proceeds from loan
Repayment of loans payable
Investment by the owners
Withdrawals by the owners
Net cash generated (used) for financing activities
Cash balance, January 1
Cash balance, December 31

2,382,693
63,764
160,000
-2,239,252
-39,899.75
-242,891.54
-18,403.85
-2,812.47
-6,205.00
1,222,182
1,279,175
160,000
714,807.86
404,366.660

-375,628
0
-87,200
-17,750
-67,005
-547,583

2,000,000
-500,000
5,600,000
-1,050,000
6,050,000
0
5,906,784

Sweet Escape Company


Statement of Cash Flows
For the years ended 2014-2018

2015

2016

2017

2,591,820

3,038,309

3,243,024

63,764
120,000
-67,431.76
9,974.94
42,840.31
-19,672.15
1,175.62
-648
32,615
2,774,439
120,000
777,546.14

63,764
80,000
-68,882.07
9,974.93
2,407.91
-18,446.47
545.61
-1376
33,317
3,139,614
80,000
911,492.71

63,764
40,000
-71,320.73
9,974.94
2,458.48
-12,866.24
545.92
-86
34,496
3,309,991
40,000
972,907

1,876,892.406

0
0
0
0
0

2,148,120.830

0
0
0
0
0
0

0
-500,000
0
-1,050,000

0
0
0
0
0
0

0
-500,000
0
-1,050,000
-1,550,000
5,906,784
6,233,676

2,297,083

0
-500,000
0
-1,050,000
-1,550,000
6,233,676
6,831,797

-1,550,000
6,831,797
7,578,880

2018

3,465,499
63,764
0
-73,438.48
4,987.46
2,510.10
-3,483.62
272.96
-24
35,520
3,495,608
0
1,039,649.64
2,455,958.01

0
0
0
0
0
0

0
0
0
-1,050,000
-1,050,000
7,578,880
8,984,838

Sweet Escape Company


Financial Ratios
2014-2018
Ratio

Average Total Assets*


Rate of Return on Assets
Rate of Return on Sales
Asset Turn-over
Gross Profit Ratio
Operating Ratio
Rate of Return on Current Assets
Current Ratio
Quick Ratio
Current Assets to Total Assets
Debt to Equity Ratio
Equity to Debt Ratio

* in Philippine Pesos (PHP)

2014

4,539,397.68
0.3674
0.1848
1.9883
0.5332
0.7183
0.3945
4.5441
4.3774
0.9314
0.4601
2.1734

2015

9,227,240.09
0.1966
0.1951
1.0076
0.5360
0.7083
0.2101
4.6563
4.5103
0.9404
0.3428
2.9171

2016

9,680,751.28
0.2197
0.2221
0.9891
0.5640
0.6743
0.2323
4.9256
4.7785
0.9504
0.2391
4.1825

2017

10,363,124.52
0.2191
0.2302
0.9517
0.5657
0.6671
0.2293
7.0546
6.8607
0.9598
0.1575
6.3497

2018

11,446,116.09
0.2119
0.2388
0.8875
0.5668
0.6589
0.2196
7.8727
7.6862
0.9698
0.1405
7.1182

Loans Payable
date
01/01/14
12/31/14
12/31/15
12/31/16
12/31/2017

Sales
VAT Rate
VAT liability

payment

principal

660,000.00
620,000.00
580,000.00

540,000

2014
9,025,603
12%
1083072.36

interest

carrying value

500,000.00
500,000.00
500,000.00
500,000.00

160,000.00
120,000.00
80,000.00
40,000.00

2,000,000.00
1,500,000.00
1,000,000.00
500,000.00
-

VAT Payable
2015
9297395.68
12%
1115687.482

2016
9575033.996
12%
1149004.08

2017
9862501.679
12%
1183500.201

Variable Overhead is 150% of Direct Labor

2018
10158505.2
12%
1219020.63

You might also like