0% found this document useful (0 votes)
10 views16 pages

Funeral Service Financial Overview

The document provides a detailed financial overview of a business, including schedules for service income, cost of services, utilities expenses, permits and licenses, advertising expenses, salaries and wages, liabilities, office supplies, depreciation, repair and maintenance, rent expenses, and owner's equity for the years 2022 to 2026. It highlights the service income growth from 14,040,000 in 2022 to 20,555,964 in 2026, alongside a breakdown of operating expenses and net income after tax. The document serves as a comprehensive financial statement for the business operations over the specified period.

Uploaded by

yelfajardo07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views16 pages

Funeral Service Financial Overview

The document provides a detailed financial overview of a business, including schedules for service income, cost of services, utilities expenses, permits and licenses, advertising expenses, salaries and wages, liabilities, office supplies, depreciation, repair and maintenance, rent expenses, and owner's equity for the years 2022 to 2026. It highlights the service income growth from 14,040,000 in 2022 to 20,555,964 in 2026, alongside a breakdown of operating expenses and net income after tax. The document serves as a comprehensive financial statement for the business operations over the specified period.

Uploaded by

yelfajardo07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

NOTE 1 : SCHEDULE OF SERVICE INCOME

Product Quantity Unit


Casa Funeraria Package 1/2 1 pc
Casa Funeraria Package 3 1 pc
Casa Funeraria Package 4 1 pc
Casa Funeraria Package 5 1 pc
Casa Funeraria Package 6 1 pc
TOTAL 5

NOTE 2 : SCHEDULE OF COST OF SERVICES


2022 2023
Beginning Inventory 340,600.00 408,720.00
Add: Purchases 3,746,600.00 4,121,260.00
Total Goods Available for Sale 4,087,200.00 4,529,980.00
Less: Ending Inventory 408,720.00 452,998.00
Cost of Goods Solds 3,678,480.00 4,076,982.00

NOTE 3 : SCHEDULE OF UTILITIES EXPENSE


2022 2023
Electricity 48,000.00 49,440.00
Gas 144,000.00 21,012.00
Water 54,000.00 55,620.00
TOTAL 246,000.00 126,072.00

NOTE 4: PERMITS AND LICENSES


2022 2023
Barangay Clearance 30.00 30.00
Barangay Business Clearance 300.00 300.00
BIR Registration 500.00 500.00
Business Plate 350.00 350.00
Documentary Stamp 30.00 30.00
DTI Registration 200.00
Garbage Collection 1,000.00 1,000.00
Health & Sanitary Inspection Fee 1,221.00 1,221.00
Municipal Seal/ Sticker 80.00 80.00
Mayor’s Permit 2,400.00 2,400.00
Community Tax Certificate (Cedu 305.00 305.00
Occupation Fee 2,100.00 2,100.00
TOTAL 8,516.00 8,316.00

NOTE 5 : SCHEDULE OF ADVERTISING EXPENSE


2022 2023
Tarp 2,500.00 2,500.00
Flyers 500.00
TOTAL 3,000.00 2,500.00

NOTE 6: Salaries and Wages, 13th Month Pay and Government Contributions
Employee Con
Employee Monthly Salary SSS PhilHealth
Embalmer/make up ar 24,000.00 1,080.00 1,080.00
Embalmer/make up ar 24,000.00 1,080.00 1,080.00
Receptionist 12,000.00 540.00 540.00
Receptionist 12,000.00 540.00 540.00
Receptionist 12,000.00 540.00 540.00
Driver 12,000.00 540.00 540.00
Driver 12,000.00 540.00 540.00
TOTAL 13TH MONT 108,000.00 4,860.00 4,860.00
ANNUAL 1,296,000.00
Employer Con
Embalmer/make up artist 2,280.00 1,080.00
Embalmer/make up artist 2,280.00 1,080.00
Receptionist 1,140.00 540.00
Receptionist 1,140.00 540.00
Receptionist 1,140.00 540.00
Driver 1,140.00 540.00
Driver 1,140.00 540.00
MONTHLY 10,260.00 4,860.00
ANNUAL 123,120.00 58,320.00

Note 7: Schedule of Liabilities


2022 2023
SSS,Phil,Pag Ibig Payable 29,160.00 29,160.00
Income Tax Payable 2,147,687.46 2,527,414.09
2,176,847.46 2,556,574.09

Note 8: Schedule of Office Supplies


2022 2023
Office Supplies 133,831.20 140,522.76
Sanitary Supplies 48,000.00 50,400.00
TOTAL 181,831.20 190,922.76

Note 9 : Depreciation Expense Cost Useful Life


Machineries & Equipment 1,819,729.00 10
Furniture and Fixtures 217,337.00 10
Total 2,037,066.00

Note 10: Schedule of Repair and Maintenance Expense


2022 2023
Repair and Maintenance Expe 120,000.00 126,000.00
TOTAL 120,000.00 126,000.00

Note 11: Schedule of Rent Expense


2022 2023
Rent Expense 180,000.00 180,000.00
TOTAL 180,000.00 180,000.00

Note 12 : Schedule of Owner's Equity


2022 2023
Beginning Capital 2,600,000.00 8,219,604.07
Add: Net Income 5,669,604.07 6,400,911.88
Investment
Total 8,269,604.07 14,620,515.95
Less: Withdrawal 50,000.00 50,000.00
Ending Capital 8,219,604.07 14,570,515.95
2022 2023 2024
Cost Service Income
15000.00 780,000.00 858,000.00 943,800.00
25000.00 1,300,000.00 1,430,000.00 1,573,000.00
50000.00 2,600,000.00 2,860,000.00 3,146,000.00
80000.00 4,160,000.00 4,576,000.00 5,033,600.00
100000.00 5,200,000.00 5,720,000.00 6,292,000.00
14,040,000.00 15,444,000.00 16,988,400.00

2024 2025 2026


452,998.00 498,638.40 548,536.30
4,533,386.00 4,986,724.60 5,485,397.06
4,986,384.00 5,485,363.00 6,033,933.36
498,638.40 548,536.30 603,393.34
4,487,745.60 4,936,826.70 5,430,540.02

2024 2025 2026


50,923.20 52,450.90 54,024.42
21,642.36 22,291.63 22,960.38
57,288.60 59,007.26 60,777.48
129,854.16 133,749.78 137,762.28

2024 2025 2026


30.00 30.00 30.00
300.00 300.00 300.00
500.00 500.00 500.00
350.00 350.00 350.00
30.00 30.00 30.00
-
1,000.00 1,000.00 1,000.00
1,221.00 1,221.00 1,221.00
80.00 80.00 80.00
2,400.00 2,400.00 2,400.00
305.00 305.00
2,100.00 2,100.00 2,100.00
8,316.00 8,316.00 8,011.00

2024 2025 2026


2,500.00 2,500.00 2,500.00

2,500.00 2,500.00 2,500.00

ibutions
Employee Contributions
HDMF Withholding Tax Net Pay
480.00 21,360.00
480.00 21,360.00
240.00
240.00
240.00 10,680.00
240.00 10,680.00
240.00 10,680.00
2,160.00 11,880.00

Employer Contributions
480.00
480.00
240.00
240.00
240.00
240.00
240.00
2,160.00 17,280.00
25,920.00 207,360.00

2024 2025 2026


29,160.00 29,160.00 29,160.00
2,917,316.92 3,347,545.62 3,821,387.10
2,946,476.92 3,376,705.62 3,850,547.10

2024 2025 2026


147,548.90 154,926.34 162,672.66
52,920.00 55,566.00 58,344.30
200,468.90 210,492.34 221,016.96

Salvage Value Annual Depreciation


90,986.45 172,874.26
10,866.85 20,647.02
Total 193,521.27

2024 2025 2026


132,300.00 138,915.00 145,860.75
132,300.00 138,915.00 145,860.75

2024 2025 2026


180,000.00 180,000.00 180,000.00
180,000.00 180,000.00 180,000.00

2024 2025 2026


14,570,515.95 21,645,533.10 29,519,546.39
7,125,017.15 7,924,013.29 8,804,004.62

21,695,533.10 29,569,546.39 38,323,551.00


50,000.00 50,000.00 50,000.00
21,645,533.10 29,519,546.39 38,273,551.00
2025 2026

1,038,180.00 1,141,998.00
1,730,300.00 1,903,330.00
3,460,600.00 3,806,660.00
5,536,960.00 6,090,656.00
6,921,200.00 7,613,320.00
18,687,240.00 20,555,964.00
SUGARLY YOURS
STATEMENT OF OPERATIONS
FOR THE PERIOD ENDED

2022 2023 2024


Service Income Note 1 14,040,000.00 15,444,000.00 16,988,400.00
Less : Cost of Service Income Note 2 3,678,480.00 4,076,982.00 4,487,745.60
Gross Profit ### ### ###
Less: Operating Expenses
Salaries Expense Note 6 1,296,000.00 1,296,000.00 1,296,000.00
Advertising Expense Note 5 3,000.00 2,500.00 2,500.00
Utilities Expenses Note 3 246,000.00 126,072.00 129,854.16
Taxes and Licenses Note 4 8,516.00 8,316.00 8,316.00
Repair and Maintenance Note 10 120,000.00 126,000.00 132,300.00
Rent Expense Note 11. 180,000.00 180,000.00 180,000.00
Employer Contribution Note 6 207,360.00 207,360.00 207,360.00
Office Supplies Note 8 181,831.20 190,922.76 200,468.90
Depreciation Note 9 193,521.27 193,521.27 193,521.27
13th Month pay Note 6 108,000.00 108,000.00 108,000.00
Total Operating Expenses 2,544,228.47 2,438,692.03 2,458,320.33
Net Income (loss) before Tax 7,817,291.53 8,928,325.97 ###
Provisions for Income Tax 2,147,687.46 2,527,414.09 2,917,316.92
Net Income (loss) after Tax 5,669,604.07 6,400,911.88 7,125,017.15
2025 2026
18,687,240.00 20,555,964.00
4,936,826.70 5,430,540.02
### ###

1,296,000.00 1,296,000.00
2,500.00 2,500.00
133,749.78 137,762.28
8,316.00 8,011.00
138,915.00 145,860.75
180,000.00 180,000.00
207,360.00 207,360.00
210,492.34 221,016.96
193,521.27 193,521.27
108,000.00 108,000.00
2,478,854.40 2,500,032.26
### ###
3,347,545.62 3,821,387.10
7,924,013.29 8,804,004.62
SUGARLY YOURS
STATEMENT OF FINANCIAL POSITION
AS OF

ASSETS 2022 2023


Cash 8,144,186.80 15,024,068.58
Inventory Note 3 408,720.00 452,998.00
Property & Equipment(net) 1,843,544.73 1,650,023.46

Total Assets ### ###

Liabilities & Capital


Liabilities 2,176,847.46 2,556,574.09

Equity
Owner's Equity 8,219,604.07 14,570,515.95

Total liabilities & Equity ### ###

- -
Y YOURS
NANCIAL POSITION
OF

2024 2025 2026


22,636,869.43 31,084,734.78 40,451,245.12
498,638.40 548,536.30 603,393.34
1,456,502.19 1,262,980.92 1,069,459.65

### ### ###

2,946,476.92 3,376,705.62 3,850,547.10

21,645,533.10 29,519,546.39 38,273,551.00

### ### ###

- - -
SUGARLY YOURS
CASH FLOWS
FOR THE PERIOD ENDED

2022 2023
FUND SOURCES
Cash was Provided by:

Net Income 5,669,604.07


Add: Depreciation Expense 193,521.27
Total Funds Provided by Operations - 5,863,125.34
(Increase)Decrease in Organization Cost 44,468.60
(Increase) Decrease in Inventory - 68,120.00
Increase ( decrease ) of Accruals 2,176,847.46
Investment 2,600,000.00

Total Cash Inflow 2,600,000.00 8,016,321.40

FUND USES
Cash was used for:
Machineries & Equipment 1,819,729.00
Furnitures and Fixtures 217,337.00
Inventory 340,600.00
Other Organization cost
Permits and Licenses 8,516.00
Office Supplies 11,152.60
Sanitary Supplies 4,000.00
Uniform Expense 2,800.00
Rent Expense 15,000.00
Advertising Expense 3,000.00
Drawings - 50,000.00

Total Cash Outflow 2,422,134.60 - 50,000.00

NET CASH INFLOW 177,865.40 7,966,321.40


Add: Cash Balance Beginning 177,865.40

CASH BALANCE END 177,865.40 8,144,186.80


SUGARLY YOURS
CASH FLOWS
FOR THE PERIOD ENDED

2023 2024 2025 2026

6,400,911.88 7,125,017.15 7,924,013.29 8,804,004.62


193,521.27 193,521.27 193,521.27 193,521.27
6,594,433.15 7,318,538.42 8,117,534.56 8,997,525.89

- 44,278.00 - 45,640.40 - 49,897.90 - 54,857.04


379,726.63 389,902.83 430,228.69 473,841.49

6,929,881.78 7,662,800.85 8,497,865.35 9,416,510.34

- 50,000.00 - 50,000.00 - 50,000.00 - 50,000.00

- 50,000.00 - 50,000.00 - 50,000.00 - 50,000.00

6,879,881.78 7,612,800.85 8,447,865.35 9,366,510.34


8,144,186.80 15,024,068.58 22,636,869.43 31,084,734.78

15,024,068.58 22,636,869.43 31,084,734.78 40,451,245.12


Machineries and Equipment 1,819,729.00
Furniture and Fixtures 217,337.00
Supplies Expense 11,152.60
Sanitary Expense 4,000.00
Permit and Licenses 8,516.00
Advertising Expense 3,000.00
Rent Expense 15,000.00
Inventory 340,600.00
Uniform Expense 2,800.00
Total Pre-Operating Expenses 2,422,134.60
Working Capital 177,865.40
Owner's Capital 2,600,000.00
RETURN ON INVESTED CAPITAL
2022 2023 2024
Net Profit after tax 5,669,604.07 6,400,911.88 7,125,017.15
Total Investment 2,600,000.00 2,600,000.00 2,600,000.00
2.1806169503846 2.4618891848077 2.7403912105769
ROIC 218.06 246.19 274.04
Implication: The ROIC will be on the 1st year of operation to accumulate all the invested capital in the

RETURN ON SALES
2022 2023 2024
Net Profit 5,669,604.07 6,400,911.88 7,125,017.15
Total Sales 14,040,000.00 15,444,000.00 16,988,400.00
0.4038179537749 0.4144594587218 0.41940483786
ROS 40.38 41.45 41.94
Implication: This means that for every P100 sales, the net profit will be P 40.38.

PAYBACK PERIOD
2022 2023 2024
Initial Investment 2,600,000.00 2,600,000.00 2,600,000.00
Net Profit After Tax 5,669,604.07 6,400,911.88 7,125,017.15
PP 0.46 0.41 0.36
Implication: This means that the payback period is 6 months.
2025 2026
7,924,013.29 8,804,004.62
2,600,000.00 2,600,000.00
3.0476974181923 3.3861556213888
304.77 338.62
ate all the invested capital in the business.

2025 2026
7,924,013.29 8,804,004.62
18,687,240.00 20,555,964.00
0.4240333664736 0.4282944169201
42.40 42.83
be P 40.38.

2025 2026
2,600,000.00 2,600,000.00
7,924,013.29 8,804,004.62
0.33 0.30

You might also like