Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Financial Statement

    Uploaded by

    Viejay Castillo
    financial statement

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Financial Statement

    Uploaded by

    Viejay Castillo
    19 views4 pages
    financial statement

    Original Title

    financial statement

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    financial statement

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    19 views4 pages

    Financial Statement

    Uploaded by

    Viejay Castillo
    financial statement

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    CARAFROZ ICE CREAM HOUSE

    PART III. FINANCIAL DOCUMENTS

    Summary of Financial Needs

    To run the business, the estimated capital is PHP 844,148.92. Therefore, a total of PHP
    930,000.00 will be needed capital. Shown below is the contribution per shareholder:

    Shareholders Contribution (PHP) Share (%)


    Viejay Castillo 140,000.00 14
    Sheena Manalili 140,000.00 14
    Ericka Jane David 140,000.00 14
    Joanna Valerie Santos 140,000.00 14
    Francis Rowenn Devis 140,000.00 14
    Percy Castillo 80,000.00 8
    Leopolda Estabillo 53,000.00 5.30
    Delia Surbano 37,000.00 3.98
    TOTAL 1,000,000 100

    THREE (3) YEAR PRO-FORMA INCOME STATEMENT (PHP)

    INCOME Assumption 2025 2026 2027


    STATEMENT
    Sales Revenue 25% 1,760,500 2,020,981.48 2,384,990.26
    Cost of Sales 30% 528,150 606,294.44 715,497.08
    Gross Margin 70% 1,232,350 1,414,687.04 1,669,493.18
    Research and 5,000 10,000 15,000
    Development
    General - 843,874.92 886,068.66 928,262.41
    Administrative
    Sales and 5,500 11,000 16,500
    Marketing

    Security 3,000 6,000 9,000

    Depreciation – 40,320 40,320 40,320


    Leasehold Rights
    and Improvements
    Depreciation – 14,058.60 14,058.60 14,058.60
    Appliances and
    Equipment
    Depreciation – 10,500 10,500 10,500
    Furniture and
    Fixtures
    TOTAL OPERATING 922,253.52 977,947.26 1,033,641.01
    EXPENSES
    Income before tax 310,097 426,239.78 635,852.17
    Income tax 30% 93,029.10 127,871.93 190,755.65
    expense
    Net Income 217,067.90 298,367.85 445,096.52
    Profit Margin 20% 22% 24%

    THREE (3) YEAR PRO-FORMA BALANCE SHEET

    PRO-FORMA OPENING 2025 2026 2027


    BALANCE SHEET BALANCE
    ASSETS
    Current Assets
    Cash 800,000 1,116,000 1,302,000 1,488,000
    Inventory 7,207 19,699 29,699 39,699
    Materials 1,540 60,293 35,000 20,000
    Total Current 808,747 1,195,992 1,366,699 1,547,699
    Assets
    Long-term assets
    Ice Cream 47,999 47,999 47,999 47,999
    Churner
    Accumulated (9,599.80) (19,199.60) (28,799.4)
    Depreciation
    Freezer 5,499 5,499 5,499 5,499
    Accumulated (1,099.80) (2,199.60) (3,299.40)
    Depreciation
    Air-Conditioner 16,795 16,795 16,795 16,795
    Accumulated (3,359) (6,718) (10,077)
    Depreciation
    Leasehold Rights 120,960 120,960 120,960 120,960
    and
    Improvements
    Accumulated (40,320) (80,640) (120,960)
    Depreciation
    Total Long-term 191,253 136,838.40 82,423 28,009.20
    Assets
    Total Assets 1,000,000 1,332,830.40 1,449,122 1,575,708.20

    LIABILITIES
    Other Liabilities - - - -
    Current Liabilities - - - -
    Total Liabilities - - - -

    Owner’s Equity
    Capital 1,000,000 1,000,000 1,000,000 1,000,000
    Retained Earnings - 322,290.40 478,802.80 645,708.20
    Total Equity 1, 322,290.40 1, 478,802.80 1, 645,708.20
    Total Liabilities 1,000,000 1, 322,290.40 1, 478,802.80 1, 645,708.20
    and Owner’s
    Equity

    THREE (3) YEAR PRO-FORMA CASH FLOW

    PRO-FORMA CASH 2025 2026 2027


    FLOW STATEMENT
    Net Income 217,067.90 298,367.85 445,096.52
    Add back depreciation 4,341.36 4,341.36 4,341.36
    Changes in working 221,409.46 302,709.21 449,437.88
    capital
    Account Receivable - - -
    Inventory 19,699 29,699 39,699
    Accounts Payable - - -
    Other liabilities - - -
    Cash flow from 221,409.46 302,709.21 449,437.88
    operating activities

    Amount paid for long - - -


    term assets
    Cash flow from - - -
    investing activities

    Proceeds from long - - -


    term debts
    Repayment of long- - - -
    term debt
    Cash flow from - - -
    financing activities
    Cash flow 221,409.46 302,709.21 449,437.88
    Beginning cash balance 808,747 1,195,992 1,366,699
    Ending cash balance 1,030,156.46 1,498,701.21 1,816,136.88

    BREAK-EVEN ANALYSIS

    Break-even analysis refers to the point at which total costs and total revenue are equal. A break-
    even point analysis is used to determine the number of units or pesos of revenue needed to cover total
    costs. By assessing the abovementioned financial statements, the business’ break-even point is
    explained below:

    2025 2026 2027


    Fixed Cost %
    922,253.52 977,947.26 1,033,641.01
    Gross Margin 70% 1,232,350 1,414,687.04 1,669,493.18
    Break-even Point 310,096.48 436,739.78 665,852.17
    (In Sales)

    You might also like