0% found this document useful (0 votes)
76 views22 pages

Project Cost: Building Area Building Permit

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 22

PROJECT COST

APARTMENT (2 STOREY - 8 UNITS)


ITEM TOTAL FLOOR AREA UNIT PRICE (PHP) TOTAL PRICE (PHP)
1. LOT AREA 165.75 5,000.00 828,750.00
2. SITE DEVELOPMENT
Lot Area to Develop 100.95 1,500.00 151,425.00
3. BUILDING CONSTRUCTION COST -
Building Area 129.60 2,500.00 324,000.00
Building Permit 1,000,000.00

TOTAL 2,304,175.00
Cash Flow

Total (10 years) Jun-14 Jul-14 Aug-14 Sep-14


Beginning Balance 108,171,250.00 108,137,970.25 108,137,970.25
Cash-in
Capital 33,000,000.00 33,000,000.00 - - -
Loan 77,000,000.00 77,000,000.00 - - -
Gross Income 3,120,000.00 - - - -

Total Cash-in 113,120,000.00 110,000,000.00 108,171,250.00 108,137,970.25 108,137,970.25

Cash-out
Fixed Expenses
Lot Acquisition 828,750.00 828,750.00 - - -
Building Cost (School) 324,000.00 - - - 35,640.00
Site Development 151,425.00 - - - -
School Facilities 9,340.00 - - - -
Design Cost 33,279.75 - 33,279.75 - -
Operating Expenses
Permits 1,000,000.00 1,000,000.00 - - -
Interest 23,730,000.00 - - - -
Maintenance (including Bills) 24,000.00 - - - -
Salary of Employees - - - - -
Financing Expenses
Principal Loan Payment 77,000,000.00 - - - -

Total Cash-Out 103,100,794.75 1,828,750.00 33,279.75 - 35,640.00

Ending Balance 10,019,205.25 108,171,250.00 108,137,970.25 108,137,970.25 108,102,330.25


Cash Flow

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15


108,102,330.25 108,060,210.25 108,011,610.25 107,953,290.25 107,891,730.25 107,813,970.25 107,653,205.25

- - - - - - -
- - - - - - -
- - - - - - -

108,102,330.25 108,060,210.25 108,011,610.25 107,953,290.25 107,891,730.25 107,813,970.25 107,653,205.25

- - - - - - -
42,120.00 48,600.00 58,320.00 61,560.00 77,760.00 - -
- - - - - 151,425.00 -
- - - - - 9,340.00 -
- - - - - - -

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -

- - - - - - -

42,120.00 48,600.00 58,320.00 61,560.00 77,760.00 160,765.00 -

108,060,210.25 108,011,610.25 107,953,290.25 107,891,730.25 107,813,970.25 107,653,205.25 107,653,205.25


Cash Flow

May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15


107,653,205.25 107,653,205.25 97,064,205.25 97,095,205.25 97,126,205.25 97,157,205.25 97,188,205.25

- - - - - - -
- - - - - - -
- 31,200.00 31,200.00 31,200.00 31,200.00 31,200.00 31,200.00

107,653,205.25 107,684,405.25 97,095,405.25 97,126,405.25 97,157,405.25 97,188,405.25 97,219,405.25

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -

- - - - - - -
- 4,620,000.00 - - - - -
- 200.00 200.00 200.00 200.00 200.00 200.00
- - - - - - -

- 6,000,000.00 - - - - -

- 10,620,200.00 200.00 200.00 200.00 200.00 200.00

107,653,205.25 97,064,205.25 97,095,205.25 97,126,205.25 97,157,205.25 97,188,205.25 97,219,205.25


Cash Flow

Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 May 2014 to May 2015
97,219,205.25 97,250,205.25 97,281,205.25 97,312,205.25 97,343,205.25 97,343,005.25

- - - - - - 33,000,000.00
- - - - - - 77,000,000.00
31,200.00 31,200.00 31,200.00 31,200.00 - -

97,250,405.25 97,281,405.25 97,312,405.25 97,343,405.25 97,343,205.25 97,343,005.25 110,000,000.00

- - - - - - 828,750.00
- - - - - - 324,000.00
- - - - - - 151,425.00
- - - - - - 9,340.00
- - - - - - 33,279.75

- - - - - - 1,000,000.00
- - - - - - -
200.00 200.00 200.00 200.00 200.00 200.00 -
- - - - - - -

- - - - - - -

200.00 200.00 200.00 200.00 200.00 200.00 2,346,794.75

97,250,205.25 97,281,205.25 97,312,205.25 97,343,205.25 97,343,005.25 97,342,805.25 107,653,205.25


Cash Flow

May 2015 to May 2016 May 2016 to May 2017 May 2017 to May 2018 May 2018 to May 2019
107,653,205.25 97,342,805.25 85,392,405.25 73,422,005.25

- - -
- - -
312,000.00 312,000.00 312,000.00 312,000.00

107,965,205.25 97,654,805.25 85,704,405.25 73,734,005.25

- - -
- - -
- - -
- - -
- - - -

- - -
4,620,000.00 4,260,000.00 3,780,000.00 3,270,000.00
2,400.00 2,400.00 2,400.00 2,400.00
- - - -

6,000,000.00 8,000,000.00 8,500,000.00 9,000,000.00

10,622,400.00 12,262,400.00 12,282,400.00 12,272,400.00

97,342,805.25 85,392,405.25 73,422,005.25 61,461,605.25


Cash Flow

May 2019 to May 2020 May 2020 to May 2021 May 2021 to May 2022 May 2022 to May 2023
61,461,605.25 50,041,205.25 38,160,805.25 26,880,405.25

- - - -
- - - -
312,000.00 312,000.00 312,000.00 312,000.00

61,773,605.25 50,353,205.25 38,472,805.25 27,192,405.25

- - - -
- - - -
- - - -
- - - -
- - -

- - - -
2,730,000.00 2,190,000.00 1,590,000.00 990,000.00
2,400.00 2,400.00 2,400.00 2,400.00
- - - -

9,000,000.00 10,000,000.00 10,000,000.00 11,500,000.00

11,732,400.00 12,192,400.00 11,592,400.00 12,492,400.00

50,041,205.25 38,160,805.25 26,880,405.25 14,700,005.25


Cash Flow

May 2023 to May 2024 May 2024 to May 2025


14,700,005.25 9,709,605.25

- -
- -
312,000.00 312,000.00

15,012,005.25 10,021,605.25

- -
- -
- -
- -
- -

- -
300,000.00 -
2,400.00 2,400.00
- -

5,000,000.00 -

5,302,400.00 2,400.00

9,709,605.25 10,019,205.25
Balance Sheet

May 2014 to May 2015 May 2015 to May 2016 May 2016 to May 2017
ASSETS
Current Asset
Cash in Bank 107,653,205.25 97,342,805.25 85,392,405.25

FIXED ASSET
Lot Acquisition 828,750.00 828,750.00 828,750.00
Project Cost (School) 475,425.00 475,425.00 475,425.00
School Facilities 9,340.00 9,340.00 9,340.00
Design Cost 33,279.75 33,279.75 33,279.75

Total Fixed Assets 1,346,794.75 1,346,794.75 1,346,794.75

Other Assets
Pre-Operating 1,000,000.00 800,000.00 600,000.00

Total Assets 110,000,000.00 99,489,600.00 87,339,200.00

LIABILITIES AND OWNER'S EQUITY


Current Liabilities
Loan 77,000,000.00 71,000,000.00 63,000,000.00

OWNERS EQUITY
Capital 33,000,000.00 33,000,000.00 33,000,000.00
Net Income - (4,510,400.00) (4,150,400.00)
Retained Earnings - - (4,510,400.00)

Total Equity 33,000,000.00 28,489,600.00 24,339,200.00


Balance Sheet
Total Liabilities and Equity 110,000,000.00 99,489,600.00 87,339,200.00
Balance Sheet
BALANCE SHEET
May 2017 to May 2018 May 2018 to May 2019 May 2019 to May 2020 May 2020 to May 2021 May 2021 to May 2022

73,422,005.25 61,461,605.25 50,041,205.25 38,160,805.25 26,880,405.25

828,750.00 828,750.00 828,750.00 828,750.00 828,750.00


475,425.00 475,425.00 475,425.00 475,425.00 475,425.00
9,340.00 9,340.00 9,340.00 9,340.00 9,340.00
33,279.75 33,279.75 33,279.75 33,279.75 33,279.75

1,346,794.75 1,346,794.75 1,346,794.75 1,346,794.75 1,346,794.75

400,000.00 200,000.00 - - -

75,168,800.00 63,008,400.00 51,388,000.00 39,507,600.00 28,227,200.00

54,500,000.00 45,500,000.00 36,500,000.00 26,500,000.00 16,500,000.00

33,000,000.00 33,000,000.00 33,000,000.00 33,000,000.00 33,000,000.00


(3,670,400.00) (3,160,400.00) (2,620,400.00) (1,880,400.00) (1,280,400.00)
(8,660,800.00) (12,331,200.00) (15,491,600.00) (18,112,000.00) (19,992,400.00)

20,668,800.00 17,508,400.00 14,888,000.00 13,007,600.00 11,727,200.00


Balance Sheet
75,168,800.00 63,008,400.00 51,388,000.00 39,507,600.00 28,227,200.00
Balance Sheet

May 2022 to May 2023 May 2023 to May 2024 May 2024 to May 2025

14,700,005.25 9,709,605.25 10,019,205.25

828,750.00 828,750.00 828,750.00


475,425.00 475,425.00 475,425.00
9,340.00 9,340.00 9,340.00
33,279.75 33,279.75 33,279.75

1,346,794.75 1,346,794.75 1,346,794.75

- - -

16,046,800.00 11,056,400.00 11,366,000.00

5,000,000.00 - -

33,000,000.00 33,000,000.00 33,000,000.00


(680,400.00) 9,600.00 309,600.00
(21,272,800.00) (21,953,200.00) (21,943,600.00)

11,046,800.00 11,056,400.00 11,366,000.00


Balance Sheet
16,046,800.00 11,056,400.00 11,366,000.00
Income Statement

INC
May 2014 to May 2015 May 2015 to May 2016 May 2016 to May 2017
GROSS INCOME - 312,000.00 312,000.00

OPERATING EXPENSES
Maintenance (including Bills) - 2,400.00 2,400.00
Interest Payment - 4,620,000.00 4,260,000.00
Yearly Salary of Employees - - -
Depreciation Value - 200,000.00 200,000.00
Total Expenses - 4,822,400.00 4,462,400.00

Net Income - (4,510,400.00) (4,150,400.00)


Income Statement

INCOME STATEMENT
May 2017 to May 2018 May 2018 to May 2019 May 2019 to May 2020 May 2020 to May 2021 May 2021 to May 2022
312,000.00 312,000.00 312,000.00 312,000.00 312,000.00

2,400.00 2,400.00 2,400.00 2,400.00 2,400.00


3,780,000.00 3,270,000.00 2,730,000.00 2,190,000.00 1,590,000.00
- - - - -
200,000.00 200,000.00 200,000.00 - -
3,982,400.00 3,472,400.00 2,932,400.00 2,192,400.00 1,592,400.00

(3,670,400.00) (3,160,400.00) (2,620,400.00) (1,880,400.00) (1,280,400.00)


Income Statement

May 2022 to May 2023 May 2023 to May 2024 May 2024 to May 2025
312,000.00 312,000.00 312,000.00

2,400.00 2,400.00 2,400.00


990,000.00 300,000.00 -
- - -
- - -
992,400.00 302,400.00 2,400.00

(680,400.00) 9,600.00 309,600.00


Equipment Quantity Unit Unit Cost Total Cost
bed 4.00 pcs 2,000.00 8,000.00
tabo at timba 10.00 pcs 50.00 500.00
walis,tambo at despan 7.00 pcs 120.00 840.00
pcs 0.00
pcs 0.00
pcs 0.00
pcs 0.00
Total 9,340.00
Salaries of Staffs Number of Staff Salary per Month Total Salary

Total in a Month -
Total in a Year -
Utilities No.of Operating months per year Price per month Total Cost
Electricity
Water
Staff Materials
Maintenance of Building 12.00 200.00 2,400.00

Total in a Year 2,400.00


FOR 1st FLOOR
Rent per Year No. of Students per Room No. of Rooms
12,000.00 4.00 4.00

FOR 2nd FLOOR


Rent per Year No. of Rooms Total income per year
60,000.00 2.00 120,000.00

TOTAL INCOME per year 312,000.00


Total income per year
192,000.00

You might also like