Scribd
Upload
414 views10 pages

Financial Study Table 5.1 Pre-Operation Statement of Financial Position

The document contains projected financial statements for BUYong Online Grocery Application from 2021 to 2025. It includes projected statements of financial position which show increasing assets and liabilities over the years. It also includes a statement of changes in partners' equity showing the partners' initial capital contributions of $1 million each, their share of annual net income being reinvested, and capital withdrawals over the years.

Uploaded by

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

Financial Study Table 5.1 Pre-Operation Statement of Financial Position

The document contains projected financial statements for BUYong Online Grocery Application from 2021 to 2025. It includes projected statements of financial position which show increasing assets and liabilities over the years. It also includes a statement of changes in partners' equity showing the partners' initial capital contributions of $1 million each, their share of annual net income being reinvested, and capital withdrawals over the years.

Uploaded by

Ronna Mae Mendoza
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 10

Financial Study

Table 5.1 Pre-operation Statement of Financial Position


BUYong Online Grocery Application
Pre- Operating Statement of Financial Position
ASSETS
CURRENT ASSETS Note
Cash and Cash Equivalents 1 ₱ 3,186,969.44
Operating Supplies 2 505,914.00
Office Supplies 3 10,407.51
Prepaid Expense 4 450,000.00
Total Current Assets ₱ 4,153,290.95
NONCURRENT ASSETS
Leasehold Improvements 5 500,000
Machinery and Equipment 6 64,975.00
Office Equipment 7 48,082.05
Furniture and Fixtures 8 21,152.00
Other Asset (Security Deposit ) 212,500.00
Total Non-current Assets ₱ 846,709.05

TOTAL ASSETS ₱ 5,000,000.00


LIABILITIES

CURRENT LIABILITIES
Total Current Liabilities 0
NONCURRENT LIABILITIES
Total Non-Current Liabilities 0
TOTAL LIABILITIES 0

EQUITY
Gabriel, Capital 1,000,000.00
Galleno, Capital 1,000,000.00
Mendoza, Capital 1,000,000.00
Munder, Capital 1,000,000.00
Gani, Capital 1,000,000.00
TOTAL PARTNERS’ EQUITY 5,000,000.00

TOTAL LIABILITIES AND EQUITY 5,000,000.00


Table 5.2 Projected Statement of Financial Position

BUYong Online Grocery Application


Projected Statem ent of Financial Statem ent
As the end of Notes 2021 2022 2023 2024 2025
ASSETS
Current Assets
Cash and Cash Equivalent 1 ₱9,625,406.93 ₱11,167,295.68 ₱12,981,308.06 ₱14,921,937.35 ₱ 16,922,399.60
Prepaid Expense 4 450,000.00 450,000.00 450,000.00 450,000.00 450,000.00
Total Current Assets ₱9,175,406.93 ₱10,717,295.68 ₱12,531,308.06 ₱14,471,937.35 ₱ 16,472,399.60
Noncurrent Assets
Machinery and Equipment 6 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00
Less: Accumulated depreciation - Machinery and
6 Equipment10,995.00 21,990.00 32,985.00 43,980.00 54,975.00
Office Equipment 7 48,082.05 48,082.05 48,082.05 48,082.05 48,082.05
Less: Accumulated depreciation - Office Equipment
7 9,616.41 19,232.82 28,849.23 38,465.64 48,082.05
Furniture and Fixtures 8 21,152 21,152 21,152 21,152 21,152
Less: Accumulated depreciation - Furniture and
8 Fixtures 4,030 8,061 12,091 16,121 20,151
Leasehold Improvements 5 500,000.00 500,000.00 500,000.00 500,000.00 500,000.00
Less: Accumulated Amortization 5 100,000.00 200,000.00 300,000.00 400,000.00 500,000.00
Other Asset (Security Deposit) 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00
Total Non-current Assets ₱ 709,567.24 ₱ 584,925.43 ₱ 460,284.02 ₱ 335,642.61 ₱ 211,001.20
TOTAL ASSETS ₱9,884,974.17 ₱11,302,221.11 ₱12,991,592.08 ₱14,807,579.96 ₱ 16,683,400.80
LIABILITIES
Current Liabilities
Utilities Payable 9 ₱ 150,000.00 ₱ 154,769.00 ₱ 156,450.00 ₱ 162,002.00 ₱ 170,552.20
Other Current Liabilities 4,741,190.87 5,660,461.21 7,093,206.78 7,520,163.91 8,942,122.95
Total Current Liabilities ₱4,891,190.87 ₱ 5,815,230.21 ₱ 7,249,656.78 ₱ 7,682,165.91 ₱ 9,112,675.15
Non- Current Liabilities 0 0 0 0 0
Total Non-Current Liabilities 0 0 0 0 0
TOTAL LIABILITIES 4,891,190.87 5,815,230.21 7,249,656.78 7,682,165.91 9,112,675.15
PARNERS' EQUITY
Gabriel, Capital(See Changes in Partners' Equity) SCE ₱ 998,756.66 ₱ 1,097,398.18 ₱ 1,148,387.06 ₱ 1,425,082.81 ₱ 1,514,145.13
Galleno, Capital SCE 998,756.66 1,097,398.18 1,148,387.06 1,425,082.81 1,514,145.13
Gani, Capital SCE 998,756.66 1,097,398.18 1,148,387.06 1,425,082.81 1,514,145.13
Munder, Capital SCE 998,756.66 1,097,398.18 1,148,387.06 1,425,082.81 1,514,145.13
Mendoza, Capital SCE 998,756.66 1,097,398.18 1,148,387.06 1,425,082.81 1,514,145.13
TOTAL PARTNERS' EQUITY ₱4,993,783.30 ₱ 5,486,990.90 ₱ 5,741,935.30 ₱ 7,125,414.05 ₱ 7,570,725.65
TOTAL LIABILITIES AND EQUITY ₱9,884,974.17 ₱11,302,221.11 ₱12,991,592.08 ₱14,807,579.96 ₱ 16,683,400.80
Table 5.3
Statement of Changes in Partners’ Equity

BUYong Online Grocery Application


Statement of Changes in Partners' Equity
Gabriel Galleno Gani Munder Mendoza Net Income Totals
Statement of Changes in Equity 2021
Beginning Equity ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 5,000,000.00
Net Income after taxes ₱ 4,997,566.60
Share in Net Income 999,513.32 999,513.32 999,513.32 999,513.32 999,513.32 4,997,566.60
Capital Withdrawal 998,756.66 998,756.66 998,756.66 998,756.66 998,756.66 4,993,783.30
Ending Equity ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 4,993,783.30

Statement of Changes in Equity 2022


Beginning Equity ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 998,756.66 ₱ 4,993,783.30
Net Income after taxes ₱ 5,980,198.50
Share in Net Income 1,196,039.70 1,196,039.70 1,196,039.70 1,196,039.70 1,196,039.70 5,980,198.50
Capital Withdrawal 1,097,398.18 1,097,398.18 1,097,398.18 1,097,398.18 1,097,398.18 5,486,990.90
Ending Equity ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 5,486,990.90

Statement of Changes in Equity 2023


Beginning Equity ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 1,097,398.18 ₱ 5,486,990.90
Net Income after taxes ₱ 6,496,879.70
Share in Net Income 1,299,375.94 1,299,375.94 1,299,375.94 1,299,375.94 1,299,375.94 6,496,879.70
Capital Withdrawal 1,148,387.06 1,148,387.06 1,148,387.06 1,148,387.06 1,148,387.06 5,741,935.30
Ending Equity ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 5,741,935.30

Statement of Changes in Equity 2024


Beginning Equity ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 1,148,387.06 ₱ 5,741,935.30
Net Income after taxes ₱ 8,008,892.75
Share in Net Income 1,601,778.55 1,601,778.55 1,601,778.55 1,601,778.55 1,601,778.55 8,008,892.75
Capital Withdrawal 1,425,082.81 1,425,082.81 1,425,082.81 1,425,082.81 1,425,082.81 7,125,414.05
Ending Equity ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 7,125,414.05

Statement of Changes in Equity 2025


Beginning Equity ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 1,425,082.81 ₱ 7,125,414.05
Net Income after taxes ₱ 8,892,623.20
Share in Net Income 1,778,524.64 1,778,524.64 1,778,524.64 1,778,524.64 1,778,524.64 8,892,623.20
Capital Withdrawal 1,514,145.13 1,514,145.13 1,514,145.13 1,514,145.13 1,514,145.13 7,570,725.65
Ending Equity ₱ 1,514,145.13 ₱ 1,514,145.13 ₱ 1,514,145.13 ₱ 1,514,145.13 ₱ 1,514,145.13 ₱ 7,570,725.65
Table 5.4
Pre-operation Statement of Cash flow
BUYong Online Grocery Application
Pre-operating Statement of Cash Flow
Cash Flows from Operating Activities
Cash Inflows -
Gross Profit -
Other Receipts -
Total Cash Inflows 0
Cash outflows
Cash paid for prepaid rent ₱ 120,000.00
Cash paid for purchase of office supplies 10,407.51
Cash paid for purchase of operating supplies 511,914.00
Cash paid for license and fees 20,000.00
Cash paid hiring expense 10,000.00
Cash paid for advertising expense 300,000.00
Total Cash Outflows ₱ 972,321.51
Net Cash from Operating Activities ₱ 972,321.51
Cash Flows from Investing Activities
Cash Inflows
Initial Investment ₱ 5,000,000.00
Sale of Property, Plant and Equipment -
Total Cash Inflows ₱ 5,000,000.00
Cash outflows
Acquisition of Office Equipment 48,082.05
Acquisition of machinery and equipment 64,975.00
Acquisition of furniture and fixture 21,152.00
Cash paid for Lease Improvement 500,000.00
Cash paid for security rent deposit 200,000.00
Total Cash Outflows ₱ 834,209.05
Net Cash Flows from Investing Activities ₱ 4,165,790.95

Cash Flows from Financing Activities


Cash Inflows -
Loan -
Total Cash Inflows 0
Cash Outflows
Payment of Accrued Income Tax -
Withdrawal -
Total Cash Outflows 0
Net Cash from Financing Activities
Net Increase/(Decrease in Cash & Cash Equivalents ₱ 3,193,469.44
Add: Cash at the Beginning of the Year 0
Cash Balance at the End of the Year ₱ 3,193,469.44
Table 5.5 Note 1: Cash and Cash Equivalent

Cash and Cash Equivalent Pre-operating 2021 2022 2023 2024 2025
Cash in Bank ₱ 3,143,467.44 ₱ 9,575,406.93 ₱11,117,295.68 ₱ 12,931,308.06 ₱14,871,937.35 ₱16,872,399.60
Petty Cash Fund 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00
Change Fund 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00
TOTALS ₱ 3,193,469.44 ₱ 9,625,406.93 ₱11,167,295.68 ₱ 12,981,308.06 ₱14,921,937.35 ₱ 16,922,399.60

Table 5.6 Note 2: Operating Supplies

Purchasing Pre-operating
Operating Supplies/Intangible 2021 2022 2023 2024 2025
Schedule (Yearly)

Back Up Drive Annually ₱ 1,898.00 ₱ 5,694.00 ₱ 5,694.00 ₱ 5,694.00 ₱ 5,694.00 ₱ 5,694.00


Network Router Annually 4,016.00 8,032.00 4,016.00 4,016.00 8,032.00 8,032.00
Application sofware Annually 500,000.00 100,000.00 150,000.00 150,000.00 200,000.00 200,000.00
Total Operating Supplies ₱ 505,914.00 ₱ 113,726.00 ₱159,710.00 ₱ 159,710.00 ₱213,726.00 ₱ 213,726.00

Table 5.7 Note 3: Office Supplies

Purchasing
Office Supplies Pre-operating 2021 2022 2023 2024 2025
Schedule
Ballpen Monthly ₱ 300.00 ₱ 3,600.00 ₱ 1,337.66 ₱ 1,364.41 ₱ 1,391.70 ₱ 1,419.53
Envelope Monthly 116.00 1,392.00 835.20 1,113.60 1,336.32 1,002.24
Puncher Annually 240.22 250.00 245.00 255.00 268.00 245.00
Markers Monthly 49.00 588.00 734.94 783.94 587.96 685.94
Ink Monthly 2,145.00 2,100.00 2,200.00 2,140.00 2,256.00 2,216.00
Scotch Tape Dispenser Annually 230.49 240.00 236.00 250.00 300.00 346.00
Tape Monthly 1,000.00 1,000.00 1,500.00 2,000.00 2,300.00 2,340.00
Stapler Annually 389.30 400.00 420.00 435.00 460.00 475.00
Calculator Annually 950.00 1,000.00 1,200.00 1,100.00 1,150.00 1,750.00
fastener Monthly 187.50 2,250.00 3,150.00 2,475.00 2,925.00 2,925.00
Bond Paper Monthly 4,475.00 4,500.00 4,600.00 4,675.00 4,525.00 4,650.00
Scissors Annually 175.00 175.00 180.00 225.00 200.00 235.00
Staple Wire Monthly 150 200 146 170 180 183
Total Office Supplies ₱ 10,407.51 ₱17,695.00 ₱16,784.80 ₱16,986.95 ₱17,879.98 ₱18,472.71
Table 5.8 Note 4: Prepaid Expenses

Prepaid Expense Pre-operating 2021 2022 2023 2024 2025


Prepaid Rent ₱ 120,000.00 ₱ 120,000.00 ₱ 120,000.00 ₱ 120,000.00 ₱ 120,000.00 ₱ 120,000.00
Prepaid Advertisement 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00
Hiring Expense 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00
License and fees 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00
TOTALS ₱ 450,000.00 ₱ 450,000.00 ₱ 450,000.00 ₱ 450,000.00 ₱ 450,000.00 ₱ 450,000.00

Table 5.9 Note 5: Leasehold Improvements

Leasehold Improvements Pre-operating 2021 2022 2023 2024 2025


Leasehold Improvements ₱ 500,000.00 ₱500,000.00 ₱ 500,000.00 ₱ 500,000.00 ₱ 500,000.00 ₱500,000.00
Less: Accumulated Amortization 0 100,000.00 200,000.00 300,000.00 400,000.00 500,000.00
Carrying Amount: Leasehold
₱ 500,000.00 ₱400,000.00 ₱ 300,000.00 ₱ 200,000.00 ₱ 100,000.00 ₱ -
Improvement

Table 5.10 Note 6: Machinery and Equipment

Machinery and Equipment Pre-operating 2021 2022 2023 2024 2025


Machinery and Equipment ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00 ₱ 64,975.00
Less: Accumulated depreciation
0 10,995.00 21,990.00 32,985.00 43,980.00 54,975.00
- Machinery and Equipment
Carrying Amount: Machinery
₱ 64,975.00 ₱ 53,980.00 ₱ 42,985.00 ₱ 31,990.00 ₱ 20,995.00 ₱ 10,000.00
and Equipment

Table 5.11 Note 7: Office Equipment

Office Equipment Pre-operating 2021 2022 2023 2024 2025


Office Equipment ₱ 48,082.05 ₱ 48,082.05 ₱ 48,082.05 ₱48,082.05 ₱ 48,082.05 ₱ 48,082.05
Less: Accumulated depreciation -
0 9,616.41 19,232.82 28,849.23 38,465.64 48,082.05
Office Equipment
Carrying Amount: Office Equiptment₱ 48,082.05 ₱ 38,465.64 ₱ 28,849.23 ₱19,232.82 ₱ 9,616.41 ₱ -
Table 5.12 Note 8: Furniture and Fixtures

Furnitures and Fixtures Pre-operating 2021 2022 2023 2024 2025


Furniture and Fixtures ₱ 21,152.00 ₱ 21,152.00 ₱ 21,152.00 ₱ 21,152.00 ₱ 21,152.00 ₱ 21,152.00
Less: Accumulated depreciation 4,030 4,030 8,061 12,091 16,121 20,151
Carrying Amount: Leasehold
₱ 17,121.60 ₱ 13,091.20 ₱ 9,061.20 ₱ 5,031.20 ₱ 1,001.20
Improvement

Table 5.12 Note 9: Utilities Payable

Utilities Expense Yearly 2021 2022 2023 2024 2025


Electricity ₱ 72,000.00 ₱ 72,000.00 ₱ 73,966.00 ₱ 74,252.00 ₱ 76,952.00 ₱ 80,678.20
Water 18,000.00 18,000.00 19,350.00 19,998.00 20,658.00 22,978.00
Telephone and Internet Connection 60,000.00 60,000.00 61,453.00 62,200.00 64,392.00 66,896.20
Total ₱ 150,000.00 ₱150,000.00 ₱154,769.00 ₱156,450.00 ₱162,002.00 ₱170,552.40

You might also like