Sagrada Pastelaria
Autor: Tim • February 16, 2019 • 1,085 Words (5 Pages) • 542 Views
...
Our cost of sales is based on an average food cost of 20% for dine in desserts and 15% for take outs. We project a consistent food cost percentage of these amounts for the following two years. Keeping food costs low while sales increase is vital to the profitability of Sagrada Pastelaria
FINANCIAL INFORMATION
Projected Income Statement of Sagrada Pastelaria business:
Sales
2017
2018
2019
2020
2021
4,665,600
4,898,880
5,181,840
5,440,932
5,712,714
Less: Cost of Goods Sold
P1,111,320
P1,129,744
P1,148,537
P1,167,706
P1,187,258
Gross Income
3,554,280
3,769,136
4,033,303
4,273,226
4,525,456
Less : operating Expenses
Rent Expense
P 48,000
P 48,000
P 48,000
P 48,000
P 48,000
Salary
P 327,600
P 327,600
P 327,600
P 327,600
P 327,600
Supplies
P 15,229
P 15,229
P 15,229
P 15,229
P 15,229
Promotion
3,600
3,600
3,600
3,600
3,600
Income Before Tax
P3,159,851
3,374,707
3,638,874
3,926,797
4,131,027
Less: Income Tax (32%)
P 1,011,152
P1,079,906
P1,164,439
P1,256,575
P1,321,928
Net Income
P 2,148,699
P2,689,229
P2,868,864
P3,016,651
P 3,203,528
Projected Statement of Cashflow
Projected Statement of Cashflow
For the ended Dec.31,2017-Dec.25,2021
2017 2018 2019
Cash flow
Cash , Beg P200,000
Partners contribution P25,000
Sales P4,898,880 P5,181,840 P5,440,932
Total cash inflows:
Less: Cash Outflows
Purchased of fixed assets P16,850.00
Purchase of raw materials P939,664 P958,457 P997,626
Packaging P190,080 P190.080 P190.080
Direct Labor P58,080.12 P58,080.12 P58,080.12
Salary and wages P 490,628.8 P490,628.8 P490,628.8
Rent P54,000 P54,000 P54,000
Transportation expenses P2,880 P2,880 P2,880
Promotional expense P3,600 P3,600 P3600
Income tax P1,011,152 P1,079,906 P 1,164,439
Total operating Expenses P2,750,064 P2,457,471 P 2,961,333
Cash Balance, End. P2,148,816 P 2,724,389 P 2,479,599
Balance Sheet
At this point we haven't included any assets in our calculations. Whether we purchase new or used kitchen equipment will determine those numbers at a later date
Balance Sheet
As of Beginning
Sagrada Pastelaria
Assets
Current Assets
Cash On Hand 5,000.000.00
Cash In Bank 5,000.000.00
Prepaid Expenses
Rent 50,000.00
Utilities 250,000.00
Pastry Café Items 100,000.00
Advertisement 100,000.00
Licenses And Operating Taxes 80,000.00
Fixed Assets
Pastry Café Equipments 200,000.00
Speakers
...