Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    Balance Sheet

    Uploaded by

    baron medina
    1) This document projects the balance sheet, income statement, and cash flow statement for a company from 2023-2027. 2) It shows increasing current assets, sales, net income, and cash flow over the 5 year period as the company grows. 3) By 2027, the company is projected to have over $21.7 million in cash and cash equivalents, $3.06 billion in annual sales, and $696,859 in net income.

    Copyright:

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

    Balance Sheet

    Uploaded by

    baron medina
    66 views7 pages
    1) This document projects the balance sheet, income statement, and cash flow statement for a company from 2023-2027. 2) It shows increasing current assets, sales, net income, and cash flow over the 5 year period as the company grows. 3) By 2027, the company is projected to have over $21.7 million in cash and cash equivalents, $3.06 billion in annual sales, and $696,859 in net income.

    Original Title

    balance-sheet (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) This document projects the balance sheet, income statement, and cash flow statement for a company from 2023-2027. 2) It shows increasing current assets, sales, net income, and cash flow over the 5 year period as the company grows. 3) By 2027, the company is projected to have over $21.7 million in cash and cash equivalents, $3.06 billion in annual sales, and $696,859 in net income.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    66 views7 pages

    Balance Sheet

    Uploaded by

    baron medina
    1) This document projects the balance sheet, income statement, and cash flow statement for a company from 2023-2027. 2) It shows increasing current assets, sales, net income, and cash flow over the 5 year period as the company grows. 3) By 2027, the company is projected to have over $21.7 million in cash and cash equivalents, $3.06 billion in annual sales, and $696,859 in net income.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 7

    PROJECTED BALANCE SHEET

    2023 2024 2025 2026


    Current Assets
    Cash in Bank 350,000 700,000 1,050,000 1,400,000
    Inventories 535,884.36 728,858.40 951,622.56 1,171,042.68
    Total Current Assets 885,884.36 1,428,858.40 2,001,622.56 2,571,042.68
    Non Current Assets
    Office Equipment & supplies 31,112 31,112 31,112 31,112
    Accumulated Depreciation 6,222.40 12,444.80 18,667.20 24,889.60
    Total 24,889.60 18,667.20 12,444.80 6,222.40
    Machinery & Equipment 21,085 21,085 21,085 21,085
    Accumulated Depreciation 4,217.00 8,434.00 12,651.00 16868
    Total 16,958.00 12,651.00 8,434 4,217
    Furniture and Fixtures 16,550 16,550 16,550 16,550
    Accumulated Depreciation 3,310.00 6,620 9,930 13,240
    Total 13,240.00 9,930.00 6,620 3,310
    Kitchen tools 1,512 1,512 1,512 1,512
    Accumulated Depreciation 302.4 604.8 907.2 1,209.60
    Total 1,210.00 907.2 604.8 302.4
    Total Non Current Assets 56,297.90 42,155.40 28,103.60 14,051.80

    Total Assets 942,182.26 1,471,013.80 2,029,726.16 2,585,094.48


    L&E
    2027 2023 2024 2025
    Accounts Payable 94,822.66 106,722.87 114,935
    1,750,000 Taxes and Licenses 13,199 8,199 11,199
    1,490,836.92 Salaries and Wages 20,880.00 21,924 23,020.20
    3,240,836.92 128,901.66 136,845.87 149,154

    31,112
    31,112 Equity 2023 2024 2025
    0.00 Almira 162,656.12 266,833.59 334,114.43
    21,085 Ando 162,656.12 266,833.59 334,114.43
    21,085 Jomocan 162,656.12 266,833.59 334,114.43
    0 Medina 162,656.12 266,833.59 334,114.43
    16,550 Obra 162,656.12 266,833.59 334,114.43
    16,550
    0
    1,512
    1,512
    0
    0

    3,240,836.92
    2026 2027
    125,030.00 138,270.89
    8,199 13,199
    24,171.21 25,379.77
    157,400.21 176,849.66

    2026 2027
    485,538.85 612,797.45
    485,538.85 612,797.45
    485,538.85 612,797.45
    485,538.85 612,797.45
    485,538.85 612,797.45
    2023 2024 2025
    Sales 1,362,060 1,728,117.70 2,130,459.06
    Cost of Good Sold 535,884.36 728,858.40 951,622.56
    Gross Profit 826,175.64 999,259.30 1,178,836.50
    Less: Operating Expenses (fr overhead cost; prod cost)
    Safety Material Fees 5,133.06 6,253.00 7,350
    Advertising Fees 16,188.12 17,988.12 18,708.00
    Packaging Fees 13,507.20 15,510.10 18,420.20
    Transportation fees 1,055.88 1,590.00 2,124.12
    Taxes and Licenses 13,199 8,199 11,199
    Employee Benefits 25,411.20 31,132.45 33,000.39
    Salaries and wages 20,880.00 21,924 23,020.20
    Office Supplies 1,444.00 2,166.00 3,249.00
    Other Expense 32,083.20 32,083.20 32,083.20

    Total 108,021.66 136,845.87 149,154


    Net Operating Income 718,153.98 862,413.43 1,029,682.39
    Income Tax Expense 179,538.50 215,603.36 257,421
    Net Income for the year 538,615.49 646,810.07 772,261.79

    Net Income (Loss) 359,076.99 431,206.71 514,840.79


    2026 2027
    2,573,963.07 3,061,406.38
    1,171,042.68 1,490,836.92
    1,402,920.39 1,570,569.46

    8,590.50 10,550.20
    20,388.00 21,588.00
    20,440.00 23,950.00
    2,658.24 3,192.36
    8,199 13,199
    35,997.24 39,596.96
    24,171.21 25,379.77
    4,873.50 7,310.25
    32,083.20 32,083.20

    157,400.89 176,849.74
    1,245,519.50 1,393,719.72
    311,379.88 348,429.93
    934,139.63 1,045,289.79

    622,759.75 696,859.86
    2023
    Cash flow from operating Activities
    Net Income before tax 2,834,872.78
    Depreciation Expense 14,051.80
    Operating Income before working capital change 2,848,924.58
    Increase (Decrease) in Current Assets
    Non-Current Assets:
    Increase (Decrease) in Current Liabilities 128,901.66
    Net Cash Provided (used) by operating activities
    Add: Cash Balance, Beginning 0
    Cash and Cash Equivalent at Beginning of year 2,977,826.24
    2024 2025 2026 2027

    3,505,551.93 4,224,956.06 5,062,381.17 5,847,770.43


    14,051.80 14,051.80 14,051.80 14,051.80
    3,519,603.73 4,239,007.86 5,076,432.97 5,861,822.23

    7,944.21 12,308.33 8,246.01 19,449.45


    3,527,547.94 4,251,316.19 5,084,678.98 5,881,271.68
    2,977,826.24 6,505,374.18 10,756,690.37 15,841,369.35
    6,505,374.18 10,756,690.37 15,841,369.35 21,722,641.03

    You might also like