Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    FS Squash

    Uploaded by

    Danah Jane Garcia
    This document contains projected financial statements for a squash cinnamon cookie business over 5 years. It shows that the business will have increasing sales, profits, assets and cash flows over this period. Key financial ratios like net profit ratio and return on assets are also projected to decrease gradually each year as the business grows, which is typical as a new business matures. The payback period for initial investments is estimated to be 1 year and 4 months.

    Copyright:

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

    FS Squash

    Uploaded by

    Danah Jane Garcia
    25 views10 pages
    This document contains projected financial statements for a squash cinnamon cookie business over 5 years. It shows that the business will have increasing sales, profits, assets and cash flows over this period. Key financial ratios like net profit ratio and return on assets are also projected to decrease gradually each year as the business grows, which is typical as a new business matures. The payback period for initial investments is estimated to be 1 year and 4 months.

    Original Title

    FS SQUASH (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?

    This document contains projected financial statements for a squash cinnamon cookie business over 5 years. It shows that the business will have increasing sales, profits, assets and cash flows over this period. Key financial ratios like net profit ratio and return on assets are also projected to decrease gradually each year as the business grows, which is typical as a new business matures. The payback period for initial investments is estimated to be 1 year and 4 months.

    Copyright:

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

    FS Squash

    Uploaded by

    Danah Jane Garcia
    This document contains projected financial statements for a squash cinnamon cookie business over 5 years. It shows that the business will have increasing sales, profits, assets and cash flows over this period. Key financial ratios like net profit ratio and return on assets are also projected to decrease gradually each year as the business grows, which is typical as a new business matures. The payback period for initial investments is estimated to be 1 year and 4 months.

    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 10

    SQUASH CINNAMON COOKIES

    PROJECTED FIVE-YEAR STATEMEN T OF FINANCIAL POSITION

    YEAR 1 YEAR 2 YEAR 3 YEAR 4


    ASSET
    Current Asset
    Cash 509,263.94 782,028.35 1,077,612.63 1,404,292.77
    Total Current Asset 509,263.94 782,028.35 1,077,612.63 1,404,292.77

    Non-Current Asset
    Furniture and Fixtures 18,550.00 18,550.00 18,550.00 18,550.00
    Less: Accumulated Depreciation - F&F (3,710.00) (7,420.00) (11,130.00) (14,840.00)
    Cooking Equipment 20,000.00 20,000.00 20,000.00 20,000.00
    Less: Accumulated Depreciation - C.E (4,000.00) (8,000.00) (12,000.00) (16,000.00)
    Delivery Equipment 53,000.00 53,000.00 53,000.00 53,000.00
    Less: Accumulated Depreciation - D.E (10,600.00) (21,200.00) (31,800.00) (42,400.00)
    Total Non-Current Asset 73,240.00 54,930.00 36,620.00 18,310.00
    TOTAL ASSETS 582,503.94 836,958.35 1,114,232.63 1,422,602.77

    LIABILITIES
    Tax Payable 91,130.30 111,478.94 125,404.27 139,927.23
    Total Current Liabilities 91,130.30 111,478.94 125,404.27 139,927.23

    OWNER'S EQUITY 491,373.64 725,479.41 988,828.36 1,282,675.54

    TOTAL LIABILITIES AND OWNER'S EQUITY 582,503.94 836,958.35 1,114,232.63 1,422,602.77


    YEAR 5

    1,767,193.62
    1,767,193.62

    18,550.00
    (18,550.00)
    20,000.00
    (20,000.00)
    53,000.00
    (53,000.00)
    0.00
    1,767,193.62

    156,296.15
    156,296.15

    1,610,897.47

    1,767,193.62
    SQUASH CINNAMON COOKIES
    PROJECTED FIVE-YEAR INCOME STATEMENT

    YEAR 1 YEAR 2 YEAR 3 YEAR 4


    SALES
    Net Sales 2,895,360.00 3,040,128.00 3,192,134.40 3,351,741.12
    Less: Cost of Sales 1,610,419.20 1,690,940.16 1,775,487.17 1,864,261.53
    Gross Profit 1,284,940.80 1,349,187.84 1,416,647.23 1,487,479.59

    Less: Operating Expense


    Depreciation Expense 18,310.00 18,310.00 18,310.00 18,310.00
    Rent Expense 120,000.00 122,400.00 124,848.00 127,344.96
    Utilities Expense 36,000.00 36,720.00 37,454.40 38,203.49
    Repairs and Maintenance 10,000.00 10,200.00 10,404.00 10,612.08
    Free Taste (Store Opening) 2,250.00
    Store Renovation 20,000.00
    Promotional Expense 7,200.00 7,200.00 9,200.00 12,200.00
    Transportation Expense 5,000.00 5,100.00 5,202.00 5,306.04
    Professional Fees 15,000.00 15,300.00 15,606.00 15,918.12
    Supplies Expense 37,148.00 37,890.96 38,648.78 39,421.76
    Permits and Licenses 18,300.00 18,666.00 19,039.32 19,420.11
    Salaries and Wages 690,144.00 703,946.88 718,025.82 732,386.34
    SSS, PhilHealth & HDMF Contribution 1,821.12 1,857.54 1,894.69 1,932.59
    Total Operating Expense 981,173.12 977,591.38 998,633.01 1,021,055.49
    Earnings before income tax 303,767.68 371,596.46 418,014.22 466,424.10
    Income Tax (30%) 91,130.30 111,478.94 125,404.27 139,927.23
    Net Income 212,637.38 260,117.52 292,609.95 326,496.87
    T

    YEAR 5

    3,519,328.18
    1,957,474.60
    1,561,853.58

    18,310.00
    129,891.86
    38,967.56
    10,824.32

    12,200.00
    5,412.16
    16,236.48
    40,210.20
    19,808.51
    747,034.07
    1,971.24
    1,040,866.40
    520,987.18
    156,296.15
    364,691.03
    SQUASH CINNAMON COOKIES
    PROJECTED FIVE-YEAR STATEMENT OF CHANGES IN OWNER'S EQUITY

    YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5


    Owner's Equity Beginning 300,000.00 491,373.64 725,479.41 988,828.36 1,282,675.54
    Add: Net Income 212,637.38 260,117.52 292,609.95 326,496.87 364,691.03
    Total 512,637.38 751,491.16 1,018,089.36 1,315,325.23 1,647,366.57
    Less: 10% Withdrawal 21,263.74 26,011.75 29,261.00 32,649.69 36,469.10
    Owner's Equity End 491,373.64 725,479.41 988,828.36 1,282,675.54 1,610,897.47
    ER'S EQUITY
    SQUASH CINNAMON COOKIES
    PROJECTED FIVE-YEAR CASH FLOW

    YEAR 1 YEAR 2 YEAR 3 YEAR 4


    CASH FLOW FROM OPERATING ACTIVITIES
    Earning before tax 303,767.68 371,596.46 418,014.22 466,424.10
    Add: Depreciation Expense 18,310.00 18,310.00 18,310.00 18,310.00
    Cash Paid for income tax (91,130.30) (111,478.94) (125,404.27)
    Net Cash Provided by Operating Activities 322,077.68 298,776.16 324,845.28 359,329.83

    CASH FLOW FROM INVESTING ACTIVITIES


    Cash to Acquire Cooking Equipment (20,000)
    Cash to Acquire Furniture and Fixtures (18,550)
    Cash to Acquire Delivery Equipment (53,000)
    Net Cash Provided by Investing Activities (91,550)

    CASH FLOW FROM FINANCING ACTIVITIES


    Cash Provided by Owners 300,000.00
    Cash from Withdrawals (21,263.74) (26,011.75) (29,261.00) (32,649.69)
    Net Cash Provided by Financing Activities 278,736.26 (26,011.75) (29,261.00) (32,649.69)

    Increase/Decrease in Cash 509,263.94 272,764.41 295,584.28 326,680.14


    Add: Cash, Beginning 509,263.94 782,028.35 1,077,612.63
    Cash, End 509,263.94 782,028.35 1,077,612.63 1,404,292.77
    YEAR 5

    520,987.18
    18,310.00
    (139,927.23)
    399,369.95

    (36,469.10)
    (36,469.10)

    362,900.85
    1,404,292.77
    1,767,193.62
    SQUASH CINNAMON COOKIES
    PROJECTED FIVE-YEAR STATEMENT OF FINANCIAL RATIO

    YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5


    Net Income 212,637.38 260,117.52 292,609.95 326,496.87 364,691.03
    Gross Profit 1,284,940.80 1,349,187.84 1,416,647.23 1,487,479.59 1,561,853.58

    Net Profit Ratio 16% 19% 20% 21% 23%

    Net Income 212,637.38 260,117.52 292,609.95 326,496.87 364,691.03


    Total Assets 582,503.94 836,958.35 1,114,232.63 1,422,602.77 1,767,193.62

    Return on Asset 36% 31% 26% 22% 20%

    Payback Period The company’s payback period is in 1 year and 4 months.

    You might also like