0% found this document useful (0 votes)
32 views3 pages

Projected Income Statement 5-Year

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
32 views3 pages

Projected Income Statement 5-Year

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

PROJECTED INCOME STATEMENT

Year 1 Year 2 Year 3 Year 4 Year 5


Sales ₱ 807,000.00 ₱ 847,350.00 ₱ 889,717.50 ₱ 934,203.38 ₱ 980,913.54
Cost of Goods Sold 314,280.00 320,565.60 326,976.91 333,516.45 340,186.78
Gross Profit ₱ 492,720.00 ₱ 526,784.40 ₱ 562,740.59 ₱ 600,686.92 ₱ 640,726.76

Less: Opearting Expenses


Pre-operating Expenses
Preparation of Feasibility Study ₱ 5,000.00
Cost of Renovation 9,370.00
Registration and Licensing 6,000.00 6,300.00 6,615.00 6,945.75 7,293.04
General and Administrative
Depreciation Expense 8,334.24 8,750.95 9,188.50 9,647.92 10,130.32
Salaries Expense 108,000.00 110,160.00 112,363.20 114,610.46 116,902.67
Utilities Expense 10,800.00 11,016.00 11,236.32 11,461.05 11,690.27
Supplies Expense 183,096.00 186,757.92 190,493.08 194,302.94 198,189.00
Rent Expense 36,000.00 36,720.00 37,454.40 38,203.49 38,967.56
Transportation Expense 5,040.00 5,140.80 5,243.62 5,348.49 5,455.46
Total Operating Expenses ₱ 366,640.24 ₱ 364,845.67 ₱ 372,594.11 ₱ 380,520.10 ₱ 388,628.31
Income Before Tax 126,079.76 161,938.73 190,146.47 220,166.82 252,098.45
Income Taxes 44,127.92 56,678.55 66,551.27 77,058.39 88,234.46
Net Income ₱ 81,951.84 ₱ 105,260.17 ₱ 123,595.21 ₱ 143,108.44 ₱ 163,863.99
PROJECT COST

PRE-OPERATING EXPENSES
Preparation of Pre Feasibility Study ₱ 5,000.00
Cost of Renovation 2,880.00
Registration and Licensing 6,000.00
₱ 8,880.00
ACQUISITION OF FIXED ASSETS
Office Equipment 20,370.00
Production Equipment 1,236.00
Furniture and Fixtures 13,120.00 ₱ 34,726.00

WORKING CAPITAL ( 4 MONTHS)


Raw Materials ₱ 52,000.00
Production Supplies/ factory Overhead 52,000.00
Office Supplies 52,000.00
Utilities 52,000.00
Rent 52,000.00
Transportation 52,000.00
Salaries and Benefits 52,000.00 ₱ 312,000.00

TOTAL PROJECT COST ₱ 355,606.00

You might also like