Projected Income Statement.docx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Projected Income Statement.docx as PDF for free.
More details
- Words: 541
- Pages: 4
CAFÉ DE AMOR PROJECTED INCOME STATEMENT For the ended July 2017-June 2019
Sales Less: Cost of Goods Sold Inventory Beginning Purchases TOTAL GOODS AVAILABLE FOR SALE Less: Inventory End Cost of Goods Sold GROSS PROFIT Less: Administrative Expenses Operating Expenses TOTAL EXPENSES NET INCOME BEFORE TAXES INCOME TAXES NET INCOME AFTER TAX
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
3,168,000
3,326,000
3,492,510.00
3,869,553.55
4,998,026.75
1,820,035
91,002 1,911,037
95,552 2,006,589
100,329 2,106,918
105,346 2,212,264
1,820,035.00
2,002,038.50
2,102,140.43
2,207,247.45
91,002 1,729,033.25 1,438,966.75
95,552 1,906,486.66 1,419,513.34
100,329 2,001,811.00 1,490,699.00
105,346 2,101,901.55 1,767,652.00
2,317,609.82 156,699 2,206,996.62 2,791,030.13
884,940 536,224.95 1,421,164.95 17,801.80 (4,450.45)
929,187 550,140.15 1,479,327.15 (59,413.81) 0
975,646.35 564,751.10 1,540,397.45 (49,698.45) 0
1,024,428.67 580,092.61 1,604,521.28 163,130.72 (40,782.68)
1,075,650.1 596,201.19 1,671,851.29 1,119,178.84 (279,794.71)
13,351.35
(59,413.81)
(49,698.45)
122,348.04
839,384.13
CAFÉ DE AMOR PROJECTED FIVE-YEAR CASH FLOW STATEMENT For the ended July 2017-June 2019 Pre-operation CASH INFLOWS: Equity Sales of Restaurant Less: CASH OUTFLOWS Land Building Machines and Equipment Furniture and Fixture Dining Utensil Kitchen Utensil Purchases Administrative Expensive
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
3,168,000
3,326,000
3,492,510.00
3,869,553.55
4,998,026.75
1,820,035
1,911,037
2,006,589
2,106,918
2,212,264
884,940
929,187
975,646.35
1,024,428.67
1,075,650.1
278,303.95
292,219.15
306,830.10
322,171.61
338,280.19
4,450.45
0
0
40,782.68
279,794.71
7,335,220
2,987,729
3,132,443
3,289,065
3,494,301
3,905,989
-
180,271
193,557
203,445
375,253
1,092,038
180,271
373,828
577,273
952,526
373,828
577,273
952,526
2,044,564
7,335,220
700,000 5,158,435 536,000 341,035 63,750.00 536,000
Cash operating Expensive Income taxes TOTAL CASH OUTFLOWS NET CASH OUT FLOW Add: Cash Beginning Balance TOTAL CASH BALANCE
-
180,271
CAFÉ DE AMOR PROJECTED FIVE-YEAR BALANCE SHEET For the ended July 2017-June 2019 Pre-operation
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
-
180,271 91,002 271,273
373,828 95,552 469,380
577,273 100,329 677,602
952,526 105,346 1,057,872
2,044,564 156,699 2,201,263
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
536,000
536,000
536,000
536,000
536,000
536,000
341,035 63,750.00 536,000
341,035 63,750.00 536,000 257,921
341,035 63,750.00 536,000 515,442
341,035 63,750.00 536,000 773,363
341,035 63,750.00 536,000 1,031,285
341,035 63,750.00 536,000 1,335,292
TOTAL FIXED ASSET
7,335,220
7,077,299
6,819,778
6,561,857
6,303,935
5,999,928
TOTAL ASSET
7,335,220
7,348,572
7,289,158
7,239,459
7,361,807
8,201,191
-
-
-
-
-
-
7,335,220
7,535,220
7,548,571.35
7,489,157.54
7,439,459.09
7,561,807.13
0
13,352
(59,413.81)
(49,698.45)
122,348.04
839,384.13
7,335,220
7,348,572
7,289,158
7,239,459
7,361,807
8,201,191
ASSETS Current Asset: Cash on Hand Inventories TOTAL CURRENT ASSET Fixed Assets: Land Building Machines and Equipment Furniture and Fixture Dining Utensil Kitchen Utensil LESS: Accum. Dep’n
LIABILITIES AND EQUITY Liabilities Capital, beginning Add: Net Income Total Equity
Schedule of Expenses
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
774,000
812,700
853,335
896,001.75
940,801.84
38,700 7,740 64,500
40,635 8,127 67,725
42,666.75 8,533.35 71,111.25
44,800.09 8,960.02 74,666.81
47,040.09 9,080.02 78,400.15
884,940
929,187
975,646.35
1,024,428.67
1,075,650.1
OPERATING EXPENSES Light and Water Travel Permit & Licenses Advertising Telephone Kitchen Fuel Spoilage Office Supplies Kitchen and General Supplies Contingencies Depreciation
25, 561.60 5,000 50,000 20,000 6,000 50,000 13,000.35 17,665 17,665 73,412 257,921.00
26,839.68 5,250.00 52,500.00 21,000.00 6,300.00 52,500.00 13,650.37 18,548.25 18,548.25 77,082.60 257,921.00
28,181.66 5,512.50 55,125.00 22,050.00 6,615.00 55,125.00 14,332.89 19,475.66 19,475.66 80,936.73 257,921.00
29,590.75 5,788.13 57,881.25 23,152.50 6,945.75 57,881.25 15,049.53 20,449.45 20,449.45 84,983.57 257,921.00
31,070.28 6,077.53 60,775.31 24,310.13 7,293.04 60,775.31 15,802.01 21,471.92 21,471.92 89,232.74 257,921.00
TOTAL
536,224.95
550,140.15
564,751.10
580,092.61
596,201.19
ADMINISTRATIVE EXPENSES Salaries Employees Benefits: SSS Philhealth 13th Month Pay/Bonus TOTAL
Sales Less: Cost of Goods Sold Inventory Beginning Purchases TOTAL GOODS AVAILABLE FOR SALE Less: Inventory End Cost of Goods Sold GROSS PROFIT Less: Administrative Expenses Operating Expenses TOTAL EXPENSES NET INCOME BEFORE TAXES INCOME TAXES NET INCOME AFTER TAX
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
3,168,000
3,326,000
3,492,510.00
3,869,553.55
4,998,026.75
1,820,035
91,002 1,911,037
95,552 2,006,589
100,329 2,106,918
105,346 2,212,264
1,820,035.00
2,002,038.50
2,102,140.43
2,207,247.45
91,002 1,729,033.25 1,438,966.75
95,552 1,906,486.66 1,419,513.34
100,329 2,001,811.00 1,490,699.00
105,346 2,101,901.55 1,767,652.00
2,317,609.82 156,699 2,206,996.62 2,791,030.13
884,940 536,224.95 1,421,164.95 17,801.80 (4,450.45)
929,187 550,140.15 1,479,327.15 (59,413.81) 0
975,646.35 564,751.10 1,540,397.45 (49,698.45) 0
1,024,428.67 580,092.61 1,604,521.28 163,130.72 (40,782.68)
1,075,650.1 596,201.19 1,671,851.29 1,119,178.84 (279,794.71)
13,351.35
(59,413.81)
(49,698.45)
122,348.04
839,384.13
CAFÉ DE AMOR PROJECTED FIVE-YEAR CASH FLOW STATEMENT For the ended July 2017-June 2019 Pre-operation CASH INFLOWS: Equity Sales of Restaurant Less: CASH OUTFLOWS Land Building Machines and Equipment Furniture and Fixture Dining Utensil Kitchen Utensil Purchases Administrative Expensive
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
3,168,000
3,326,000
3,492,510.00
3,869,553.55
4,998,026.75
1,820,035
1,911,037
2,006,589
2,106,918
2,212,264
884,940
929,187
975,646.35
1,024,428.67
1,075,650.1
278,303.95
292,219.15
306,830.10
322,171.61
338,280.19
4,450.45
0
0
40,782.68
279,794.71
7,335,220
2,987,729
3,132,443
3,289,065
3,494,301
3,905,989
-
180,271
193,557
203,445
375,253
1,092,038
180,271
373,828
577,273
952,526
373,828
577,273
952,526
2,044,564
7,335,220
700,000 5,158,435 536,000 341,035 63,750.00 536,000
Cash operating Expensive Income taxes TOTAL CASH OUTFLOWS NET CASH OUT FLOW Add: Cash Beginning Balance TOTAL CASH BALANCE
-
180,271
CAFÉ DE AMOR PROJECTED FIVE-YEAR BALANCE SHEET For the ended July 2017-June 2019 Pre-operation
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
-
180,271 91,002 271,273
373,828 95,552 469,380
577,273 100,329 677,602
952,526 105,346 1,057,872
2,044,564 156,699 2,201,263
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
700,000 5,158,435
536,000
536,000
536,000
536,000
536,000
536,000
341,035 63,750.00 536,000
341,035 63,750.00 536,000 257,921
341,035 63,750.00 536,000 515,442
341,035 63,750.00 536,000 773,363
341,035 63,750.00 536,000 1,031,285
341,035 63,750.00 536,000 1,335,292
TOTAL FIXED ASSET
7,335,220
7,077,299
6,819,778
6,561,857
6,303,935
5,999,928
TOTAL ASSET
7,335,220
7,348,572
7,289,158
7,239,459
7,361,807
8,201,191
-
-
-
-
-
-
7,335,220
7,535,220
7,548,571.35
7,489,157.54
7,439,459.09
7,561,807.13
0
13,352
(59,413.81)
(49,698.45)
122,348.04
839,384.13
7,335,220
7,348,572
7,289,158
7,239,459
7,361,807
8,201,191
ASSETS Current Asset: Cash on Hand Inventories TOTAL CURRENT ASSET Fixed Assets: Land Building Machines and Equipment Furniture and Fixture Dining Utensil Kitchen Utensil LESS: Accum. Dep’n
LIABILITIES AND EQUITY Liabilities Capital, beginning Add: Net Income Total Equity
Schedule of Expenses
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
774,000
812,700
853,335
896,001.75
940,801.84
38,700 7,740 64,500
40,635 8,127 67,725
42,666.75 8,533.35 71,111.25
44,800.09 8,960.02 74,666.81
47,040.09 9,080.02 78,400.15
884,940
929,187
975,646.35
1,024,428.67
1,075,650.1
OPERATING EXPENSES Light and Water Travel Permit & Licenses Advertising Telephone Kitchen Fuel Spoilage Office Supplies Kitchen and General Supplies Contingencies Depreciation
25, 561.60 5,000 50,000 20,000 6,000 50,000 13,000.35 17,665 17,665 73,412 257,921.00
26,839.68 5,250.00 52,500.00 21,000.00 6,300.00 52,500.00 13,650.37 18,548.25 18,548.25 77,082.60 257,921.00
28,181.66 5,512.50 55,125.00 22,050.00 6,615.00 55,125.00 14,332.89 19,475.66 19,475.66 80,936.73 257,921.00
29,590.75 5,788.13 57,881.25 23,152.50 6,945.75 57,881.25 15,049.53 20,449.45 20,449.45 84,983.57 257,921.00
31,070.28 6,077.53 60,775.31 24,310.13 7,293.04 60,775.31 15,802.01 21,471.92 21,471.92 89,232.74 257,921.00
TOTAL
536,224.95
550,140.15
564,751.10
580,092.61
596,201.19
ADMINISTRATIVE EXPENSES Salaries Employees Benefits: SSS Philhealth 13th Month Pay/Bonus TOTAL
Related Documents
Projected Income Statement.docx
December 2019 32
Revenue Projected
June 2020 7
Income
May 2020 38
Income
December 2019 51
Income
April 2020 27
More Documents from ""
Revised-tax-complexity-and-compliance.docx
November 2019 16
Projected Income Statement.docx
December 2019 32
Consti 2 Cases Batch 1 Final Number
October 2019 38
Chapter 1, 2 And 3.docx
December 2019 33