Fs 2003 Version
Fs 2003 Version
Fs 2003 Version
Note
Net Sales 4
Less Cost of Goods Sold 5
Gross Profit
Less Expenses:
General and Administrative Expenses 6
Payroll and Related Expenses 7
John Paul C Dela Cruz:
Income before Tax Please add thick border or
bold this row. Applies to all
other 'totals'
Tax of 30%
Net Income After Tax
Assets
Current Assets Note
Cash John Paul C Dela Cruz:
Merchandise Inventory not merchandise inventory.
Other Assets The nature
1 of the business
is not merchandising but
Non-Current Assets rather manufacturing.
Leasehold Improvements Should be raw material
Property Plant and Equipment 2 C Dela Cruz:
John Paul
Total Assets Please make a total and
separate line for current
assets and non-current
Liabilities and Partner's Equity assets.
Current Liability
Trade and Other Payables 3
Partner's Equity
Partners' Capital
Total Liabilities and Partner's Equity
555,524.76 N 548,999.92 N
n Paul C Dela Cruz:
814,415.22 814,415.22
se add thick border or 272,024.81 422,333.86
this row. Applies to all ^
r 'totals'
81,607.44 126,700.16
190,417.37 295,633.70
2018 2019
n Paul C Dela Cruz:
3,139,045.87 CF 3,529,082.77 CF
merchandise inventory. 200,463.00 John Paul C Dela Cruz: 214,495.41
nature of the business 19,080.64 N Input vat is not 19,080.64 N
ot merchandising but captalizable as part the
er manufacturing. asset purchased. Please
uld be raw material 20,400.00 revise. Applies to all except 15,300.00
n Paul C Dela Cruz: 115,466.96 N merchandise inventory 96,849.85 N
se make a total and 3,494,456.47 3,874,808.67
arate line for current
ets and non-current ^
ets.
304,039.10 N 388,757.59 N
3,190,417.37 EQ 3,486,051.07 EQ
3,494,456.47 3,874,808.67
^
2018 2019
n Paul C Dela Cruz: 6,566,400.00 p John Paul C Dela Cruz: 7,026,048.00 p John Paul C Dela Cruz:
all cash paid are for 6,262,686.86 Please show computation 6,636,011.10 Please show computation
enses, please revise 303,713.14 390,036.90
^ ^
(164,667.27) CC
(164,667.27)
^
3,000,000.00
3,000,000.00
nsive Income
2020 2021
6,413,379.43 N 6,542,379.87 N
4,578,538.39 4,662,343.35
1,834,841.04 1,880,036.53
554,610.68 N 561,569.79 N
814,415.22 814,415.22
465,815.14 504,051.52
139,744.54 151,215.46
326,070.60 352,836.06
al Position
2020 2021
3,891,892.43 CF 4,277,703.59 CF
219,286.48 223,697.26
19,080.64 N 19,080.64 N
10,200.00 5,100.00
80,464.11 N 65,118.23 N
4,220,923.65 4,590,699.72
408,801.98 N 425,741.99 N
John Paul C Dela Cruz:
3,812,121.67 EQ 4,164,957.74 Doesn't agree with SCE
4,220,923.65 4,590,699.72
Flows
2020 2021
ul C Dela Cruz: 7,182,984.96 p John Paul C Dela Cruz: 7,327,465.46 p John Paul C Dela Cruz:
how computation 6,820,175.29 Please show computation 6,941,654.30 Please show computation
362,809.67 385,811.16
^ ^
John Paul C Dela Cruz:
p Please change the header
2022 to
6,673,264.11 N [Company name]
4,747,372.11 [FS]
1,925,892.00
569,202.31 N
814,415.22
542,274.47
162,682.34
379,592.13
2022
4,689,701.80 CF
228,172.46
19,080.64 N
-
50,298.77 N
4,987,253.67
442,703.80 N
l C Dela Cruz: John Paul C Dela Cruz:
gree with SCE 4,544,549.87 Doesn't agree with SCE
4,987,253.67
2022
Tio, Capital
Capital, January 1 -
Investment 600,000.00
Add: Net Income 38,083.47
Total 638,083.47
^
Less: Drawings
Capital, December 31 638,083.47
^
Tio, Capital
Capital, January 1 638,083.47
Investment
Add: Net Income 59,126.74
Total 697,210.21
^
Less: Drawings
Capital, December 31 697,210.21
^
Tio, Capital
Capital, January 1 697,210.21
Investment
Add: Net Income 65,214.12
Total 762,424.33
^
Less: Drawings
Capital, December 31 762,424.33
^
Tio, Capital
Capital, January 1 762,424.33
Investment
Add: Net Income 70,834.96
Total 833,259.30
^
Less: Drawings
Capital, December 31 833,259.30
^
^
3,139,045.87 390,036.90
^
3,139,045.87
3,139,045.87 BS 3,529,082.77 BS
^ ^
PROJECTED STATEMENT OF CHANGES IN PARTNER'S EQUITY
For the year Ended Dec. 31, 2018
Tabo, Capital Landong, Capital Duhaylungsod, Capital
- -
600,000.00 600,000.00
38,083.47 38,083.47
638,083.47 638,083.47
^
638,083.47 638,083.47
^
PROJECTED STATEMENT OF CHANGES IN PARTNER'S EQUITY
For the year Ended Dec. 31, 2019
Tabo, Capital Landong, Capital Duhaylungsod, Capital
638,083.47 638,083.47
59,126.74 59,126.74
697,210.21 697,210.21
^
697,210.21 697,210.21
^
PROJECTED STATEMENT OF CHANGES IN PARTNER'S EQUITY
For the year Ended Dec. 31, 2020
Tabo, Capital Landong, Capital Duhaylungsod, Capital
697,210.21 697,210.21
65,214.12 65,214.12
762,424.33 762,424.33
^
762,424.33 762,424.33
^
PROJECTED STATEMENT OF CHANGES IN PARTNER'S EQUITY
For the year Ended Dec. 31, 2021
Tabo, Capital Landong, Capital Duhaylungsod, Capital
762,424.33 762,424.33
70,834.96 70,834.96
833,259.30 833,259.30
^
833,259.30 833,259.30
^
PROJECTED STATEMENT OF CHANGES IN PARTNER'S EQUITY
362,809.67 385,811.16
3,529,082.77 3,891,892.43
3,891,892.43 BS 4,277,703.59 BS
^ ^
GES IN PARTNER'S EQUITY
c. 31, 2018
Duhaylungsod, Capital Cuaresma, Capital
- -
600,000.00 600,000.00
38,083.47 38,083.47
638,083.47 638,083.47
^ ^
638,083.47 638,083.47
^ ^
GES IN PARTNER'S EQUITY
c. 31, 2019
Duhaylungsod, Capital Cuaresma, Capital
638,083.47 638,083.47
59,126.74 59,126.74
697,210.21 697,210.21
^ ^
697,210.21 697,210.21
^ ^
GES IN PARTNER'S EQUITY
c. 31, 2020
Duhaylungsod, Capital Cuaresma, Capital
697,210.21 697,210.21
65,214.12 65,214.12
762,424.33 762,424.33
^ ^
762,424.33 762,424.33
^ ^
GES IN PARTNER'S EQUITY
c. 31, 2021
Duhaylungsod, Capital Cuaresma, Capital
762,424.33 762,424.33
70,834.96 70,834.96
833,259.30 833,259.30
^ ^
833,259.30 833,259.30
^ ^
GES IN PARTNER'S EQUITY
411,998.20
4,277,703.59
4,689,701.80 BS
^
Total
3,000,000.00
190,417.37 IS
3,190,417.37
^
3,190,417.37 3,190,417.37
^
p
Total
3,190,417.37
295,633.70 IS
3,486,051.07
^
3,486,051.07 3,486,051.07
^
p
Total
3,486,051.07
326,070.60 IS
3,812,121.67
^
3,812,121.67 3,812,121.67
^
p
Total
3,812,121.67
352,836.06 IS
4,164,957.74
^
John Paul C Dela Cruz:
4,166,296.49 Please revise
p
Tio, Capital
Capital, January 1 833,259.30
Investment
Add: Net Income 75,918.43
Total 909,177.72
^
Less: Drawings
Capital, December 31 909,177.72
^
Tickmarks Legend:
Tick marks to check references in financial statements and notes:
N Agreed financial statement amount with am
IS Agreed with Income Statement
BS Agreed with balance sheet
CF Agreed with cash flow statement
EQ Agreed with statement of changes in equity
75,918.43 75,918.43
909,177.72 909,177.72
^
909,177.72 909,177.72
^
and notes:
ed financial statement amount with amount in the note
ed with Income Statement
ed with balance sheet
ed with cash flow statement
ed with statement of changes in equity
75,918.43 75,918.43
909,177.72 909,177.72
^ ^
909,177.72 909,177.72
^ ^
Total John Paul C Dela Cruz:
4,166,296.49 Please revise
379,592.13 IS
4,545,888.62
^
John Paul C Dela Cruz:
4,545,888.62 Please revise
^
p
Note 1 - Other Assets 2018
Office Supplies 5389.58 p
Maintenance Supplies 4230.71
Employee Uniforms 2295.70
Factory Supplies 7164.65
TOTAL 19080.64
^
OTHER ASSETS
Office Supplies Unit Cost
Calculator 280.00
Stapler 165.00
Ballpen 348.00
Permanent Marker 35.00
Puncher 45.00
Scotch Tape 25.00
Scissors 48.00
Carbon Copy 150.00
Folder 3.50
Log Book 152.72
Paper Clips 118.99
Bond Paper 231.20
TOTAL
Maintenance Supplies
Wall Clock 199.00
Bulb 158.00
Dustpan 100.00
Broom 110.00
Trash Bin 85.00
Trash Bag 28.00
Floor Mop 1019.71
Dishwashing liquid 45.00
Sponge 10.00
TOTAL
Employee Uniforms
Hairnets 50.55
Aprons 363.60
Uniforms 85.43
TOTAL John Paul C Dela Cruz:
Not PPE? Yung cooking
pot kasi namin more than
Factory Supplies a 2 years na hehe.
Cooking Pot 750.00
2-Cup Glass Measuring Cup 366.66
Plastic Measuring Cup 498.89
Heavy Duty Premium Spatula 392.00
John Paul C Dela Cruz:
TOTAL Not consistent with the
Not consistent with the
asset categorization below
PROPERTY, PLANT AND EQUIPMENT
Process Equipment Unit Cost
John Paul C Dela Cruz:
2 Burner Gas Stove 1998.00
Not consistent with the
Total asset categorization below
Electrical Equipment
Airconditioner 9295.00
Electric fan 1749.99
Refrigerator 11698.00
Desktop computer 19000.00
Telephone 3200.94
Printer 7353.94
Total
Safety Equipment
Fire Extinguisher 950.00
Emergency Light 1299.75
CCTV Camera 12464.00
Total
TOTAL PROPERTY, PLANT AND EQUIPMENT
Depreciation Schedule:
Cost
Machineries and Equipment
2 Burner Gas Stove 3996.00
Office Equipment
Airconditioner 18590.00
Electric fan 5249.97
Refrigerator 23396.00
Desktop computer 38000.00
Telephone 6401.88
Printer 7353.94
Furnitures and Fixtures
Office Table 4400.00
Round Table 3000.00
Monoblock Chair (6’s) 4000.00
Office Chair 1416.48
Total
Depreciation Schedule:
Safety Equipment Cost
Fire Extinguisher 5700.00
Emergency Light 5199.00
CCTV Camera 12464.00
TOTAL
John Paul C Dela Cruz:
Note 2 Property Plant and Equipment Should be Carrying
amount/Book 2018
value
John Paul C Dela Cruz:
Should be carrying amount
Balance 139,167.27
John Paul C Dela Cruz:
Should be current year
Less: Accumulated Depreciation 23,700.31
depreciation expense not
TOTAL 115,466.96
accumulated depreciation.
^
Projected Production
Year Unit Cost Daily
2018 4.64 2280
2019 4.64 2440
2020 4.64 2494
2021 4.64 2544
2022 4.64 2595
Projected Sales
Year Unit Cost Daily
2018 8.00 2280
2019 8.00 2440
2020 8.00 2494
2021 8.00 2544
2022 8.00 2595
p 3 597.00 <
p 10 p 1580.00
p 2 p 200.00
p 2 p 220.00
p 3 p 255.00
p 3 p 84.00
p 1 p 1019.71
p 5 p 225.00
p 5 p 50.00
4230.71
^
p 1 p 50.55 <
p 5 p 1818.00
p 5 p 427.15
aul C Dela Cruz: 2295.70
E? Yung cooking
John Paul C Dela Cruz: ^
namin more than
1 set not 3 units?
s na hehe.
p 4 p 3000.00 <
p 3 1099.98
p 3 p 1496.67
p 4 p 1568.00 John Paul C Dela Cruz:
7164.65 Input vat is not considered?
Please revise. Only a
Input vat is not considered?
^ Please revise. Only a
portion of it should be
capitalize as supplies to be
Quantity Total Cost expensed in the period.
p 2 p 3996.00 <
3996.00
p 2 p 18590.00 <
p 3 p 5249.97
p 2 p 23396.00
p 2 p 38000.00
p 2 p 6401.88
p 1 p 7353.94
98991.79
p 2 p 4400.00 <
p 2 p 3000.00
p 2 p 4000.00
p 2 p 1416.48
12816.48
p 6 p 5700.00 <
p 4 p 5199.00
p 1 p 12464.00
John Paul C Dela Cruz:
Please double check the 23363.00
John Paul C Dela Cruz:
useful life. 139,167.27 Input vat on purchase of
^ PPE is not considered?
Please revise.
Annual
Useful Life Total
Depreciation
8 499.50 CC
10 1,859.00 CC
5 1,049.99
10 2,339.60
10 3,800.00
5 1,280.38
8 919.24
7 628.57 CC
7 428.57
5 800.00
7 202.35
13807.21
2019 2020
200,463.00 PY 214,495.41 PY
4,089,445.20 4,171,234.10
4,289,908.20 4,385,729.51
214,495.41 219,286.48
4,075,412.79 4,166,443.04
CC
Paul C Dela Cruz:
390,031.20 CC 390,031.20 CC
e show computations 22,064.15 22,064.15
4,487,508.14 4,578,538.39
IS 4,487,508.14 IS 4,578,538.39 IS
Annually plus
13th month pay
CC 260,547.30 CC
246,402.00
218,293.92
725,243.22
^
Anually
352734.36 <
7743.6
23940
384417.96
Projected Sales
Monthly Annually Sales
68400 CC 820800 CC 6,566,400.00
73188 878256 7,026,048.00
74823 897873 7,182,984.96
76328 915933 7,327,465.46
77855 934257 7,474,055.81
<
<
<
<
n Paul C Dela Cruz:
t vat on purchase of
is not considered?
se revise.
2021 2022
be 80,464.11 p 65,118.23 p
15,345.88 CC 14,819.46 CC
65,118.23 50,298.77
2022
7,474,055.81
CC 800,791.69 CC
IS 6,673,264.11 IS
^
2021 2022
219,286.48 PY 223,697.26 PY
4,254,658.79 4,339,751.96
4,473,945.26 4,563,449.22
223,697.26 228,172.46
4,250,248.00 4,335,276.76
390,031.20 CC 390,031.20 CC
22,064.15 22,064.15
4,662,343.35 4,747,372.11
4,662,343.35 IS 4,747,372.11 IS
2022
CC 416,106.36 CC
14,319.96
113,760.00
5,100.00
CC 11,915.99 CC
p 8,000.00 p
569,202.31
2021 2022
725,243.22 725,243.22
70,722.00 CC 70,722.00
12,450.00 12,450.00
6,000.00 6,000.00
814,415.22 814,415.22
2022
p 800,791.69 p
520,770.24
280021.46
Financial Ratios
2017 2018 2019
Current Assets #################################
Divide by: Current Liabilities 304,039.10 388,757.59 408,801.98
Current Ratio 11.05 9.68 10.10
Profitability Ratios
2017 2018 2019
Gross Profit #################################
Divide by: Sales 6,566,400 7,026,048 7,182,985
Gross Profit Margin 25.01% 25.42% 25.54%
######################
425,741.99 442,703.80
10.57 11.11
425,741.99 442,703.80
######################
9.27% 8.88%
425,741.99 442,703.80
######################
10.22% 9.74%
2020 2021
######################
7,327,465 7,474,056
25.66% 25.77%
504,051.52 542,274.47
7,327,465 7,474,056
6.88% 7.26%
352,836.06 379,592.13
7,327,465 7,474,056
13.41% 16.97%
352,836.06 379,592.13
######################
7.69% 7.61%
352,836.06 379,592.13
######################
8.47% 8.35%
352,836.06 379,592.13
######################
7.69% 7.61%
Sales
Sales each year increases by 2% due to demand and will be sold through cash only
Purchases
Purchases each year increases by 2%
Pricing
Selling price of each candy is derived from 40% profit margin above cost with
Vat inclusion or Output Tax of 12%
Inventories
Periodic system of accouting for inventories is used.
No Finished Goods recorded due to the fact all goods produced are sold based on production
5% of Raw materials will be allocated as ending inventory
Depreciable Assets
There are no provision for salvage value. Thus, straightline method is used for
Machineries used for Process, Furnitures and Fixtures, Electrical Equipment.
Safety Equipments are depreciated using declining balance method.
Utilities Expense
Utilities Increases 2% every year.
Advertising Expense
Total Advertising Expense is fixed.
Accounting Period
(blank) company will operate on calendar year basis accounting period, ending December 31.