SAMPLE COMPUTATION SHEET
Paid in Full - Cash
Block Lot Lot Area Floor Area
26 33 80 56
Model
Single Home
GROSS SELLING PRICE: P 1,250,000.00
DISCOUNTS:
NET SELLING PRICE: Total: P 1,250,000.00
OTHER CHARGES PAYABLE TO AMAIA: 85,694.00
OTHER CHARGES PAYABLE TO PAGIBIG:
Total: P 51,250.00
TOTAL OTHER CHARGES 136,944.00
TOTAL AMAIA RECEIVABLE: P 1,386,944.00
PAYMENT SCHEDULE: DOWNPAYMENT
Downpayment (10% of Selling Price) 125,000.00
Less: Reservation Fee 5-Jul-12 10,000.00
Total Other Charges 136,944.00
Net Downpayment Payable in 12 Months 251,944.00
12 Months DP Installment
1st --
|
Due Date
|
Downpayment
|
Other Charges
|
Payment
|
2nd --
|
05-Sep-12
|
9,583.33
|
3,804.00
|
13,387.33
|
3rd --
|
05-Oct-12
|
9,583.33
|
3,804.00
|
13,387.33
|
4th --
|
05-Nov-12
|
9,583.33
|
3,804.00
|
13,387.33
|
5th --
|
05-Dec-12
|
9,583.33
|
3,804.00
|
13,387.33
|
6th --
|
05-Jan-13
|
9,583.33
|
3,804.00
|
13,387.33
|
7th --
|
05-Feb-13
|
9,583.33
|
3,804.00
|
13,387.33
|
8th --
|
05-Mar-13
|
9,583.33
|
3,804.00
|
13,387.33
|
9th --
|
05-Apr-13 Townhome Makati
|
9,583.33
|
3,804.00
|
13,387.33
|
10th --
|
05-May-13
|
9,583.33
|
3,804.00
|
13,387.33
|
11th --
|
05-Jun-13
|
9,583.33
|
3,804.00
|
13,387.33
|
12th --
|
05-Jul-13
|
9,583.33
|
3,804.00
|
13,387.33
|
13th --
|
05-Aug-13
|
|
3,804.00
|
3,804.00
|
14th --
|
05-Sep-13
|
|
3,804.00
|
3,804.00
|
15th --
|
05-Oct-13
|
|
3,804.00
|
3,804.00
|
16th --
|
05-Nov-13
|
|
3,804.00
|
3,804.00
|
17th --
|
05-Dec-13
|
|
3,804.00
|
3,804.00
|
18th --
|
05-Jan-14
|
|
3,804.00
|
3,804.00
|
19th --
|
05-Feb-14
|
|
3,804.00
|
3,804.00
|
20th --
|
05-Mar-14
|
|
3,804.00
|
3,804.00
|
21st --
|
05-Apr-14
|
|
3,804.00
|
3,804.00
|
22nd --
|
05-May-14
|
|
3,804.00
|
3,804.00
|
23rd --
|
05-Jun-14
|
|
3,804.00
|
3,804.00
|
24th --
|
05-Jul-14
|
|
3,804.00
|
3,804.00
|
25th --
|
05-Aug-14
|
|
3,804.00
|
3,804.00
|
26th --
|
05-Sep-14
|
|
3,804.00
|
3,804.00
|
27th --
|
05-Oct-14
|
|
3,804.00
|
3,804.00
|
28th --
|
05-Nov-14
|
|
3,804.00
|
3,804.00
|
29th --
|
05-Dec-14
|
|
3,804.00
|
3,804.00
|
30th --
|
05-Jan-15
|
|
3,804.00
|
3,804.00
|
31st --
|
05-Feb-15
|
|
3,804.00
|
3,804.00
|
32nd --
|
05-Mar-15
|
|
3,804.00
|
3,804.00
|
33rd --
|
05-Apr-15
|
|
3,804.00
|
3,804.00
|
34th --
|
05-May-15
|
|
3,804.00
|
3,804.00
|
35th --
|
05-Jun-15
|
|
3,804.00
|
3,804.00
|
36th --
|
05-Jul-15
|
|
3,804.00
|
3,804.00
|
Loanable amount
|
1,125,000.00
|
REQUIRED NET DISPOSABLE INCOME:
|
25,124.44
|
In-House Financing - 5 year term
Model Single Home
GROSS SELLING PRICE W/ VAT:
Less: VAT(if applicable)
|
|
P
|
1,248,852.80
-
|
GROSS SELLING PRICE W/O VAT:
|
|
P
|
1,248,852.80
|
DISCOUNTS:
|
|
|
|
NET SELLING PRICE W/ VAT
|
|
P
|
1,248,852.80
|
OTHER CHARGES PAYABLE TO AMAIA:
|
|
|
137,373.81
|
TOTAL AMAIA RECEIVABLE:
|
|
P
|
1,386,226.61
|
PAYMENT SCHEDULE: DOWNPAYMENT
Downpayment (10% of Selling Price)
|
|
P
|
124,885.28
|
Less: Reservation Fee
|
24-Jul-12
|
|
10,000.00
|
Net Downpayment
|
|
Total: P
|
114,885.28
|
12 Months Downpayment
Due Date Monthly
Downpayment
24-Aug-12 9,573.77 24-Sep-12 9,573.77 24-Oct-12 9,573.77 24-Nov-12 9,573.77 24-Dec-12 9,573.77 24-Jan-13 9,573.77 24-Feb-13 9,573.77 24-Mar-13 9,573.77 24-Apr-13 9,573.77 24-May-13 9,573.77 24-Jun-13 9,573.77 24-Jul-13 9,573.77
PAYMENT SCHEDULE: BALANCE
DUE AND PAYABLE IN 60 MONTHS AT 14% INTEREST
|
P
|
1,123,967.52
|
Other Charges
|
|
137,373.81
|
Schedules
|
Monthly Amort
|
Other Charges
|
Total
|
|
Due Dates
|
1st Payment
|
26,152.81
|
2,289.56
|
|
28,442.37
|
24-Aug-13
|
60th Payment
|
26,152.81
|
2,289.56
|
|
28,442.37
|
24-Jul-18
|
In-House Financing - 10 year term
Model
Single Home
GROSS SELLING PRICE W/ VAT: P 1,248,852.80
Less: VAT(if applicable) -
GROSS SELLING PRICE W/O VAT: P 1,248,852.80
DISCOUNTS:
NET SELLING PRICE W/O VAT 1,248,852.80
Plus: VAT (if applicable) -
NET SELLING PRICE W/ VAT P 1,248,852.80
OTHER CHARGES PAYABLE TO AMAIA: 137,373.81
TOTAL AMAIA RECEIVABLE: P 1,386,226.61
PAYMENT SCHEDULE: DOWNPAYMENT
Downpayment (10% of Selling Price) P 124,885.28 Less: Reservation Fee 24-Jul-12 10,000.00
Total: P 114,885.28
12 Months Schedule(10% DP)
Due Date Monthly
Downpayment
24-Aug-12 9,573.77 24-Sep-12 9,573.77 24-Oct-12 9,573.77 24-Nov-12 9,573.77 24-Dec-12 9,573.77 24-Jan-13 9,573.77 24-Feb-13 9,573.77 24-Mar-13 9,573.77 24-Apr-13 9,573.77 24-May-13 9,573.77 24-Jun-13 9,573.77 24-Jul-13 9,573.77
PAYMENT SCHEDULE: BALANCE
DUE AND PAYABLE IN 120 MONTHS AT 16% INTEREST
|
P
|
1,123,967.52
|
Other Charges
|
|
137,373.81
|
Schedules
|
Monthly Amort
|
Other Charges
|
Total
|
|
Due Dates
|
1st Payment
|
18,827.92
|
1,144.78
|
|
19,972.70
|
24-Aug-13
|
60th Payment
|
18,827.92
|
1,144.78
|
|
19,972.70
|
24-Jul-18
|
61st Payment
|
18,827.92
|
1,144.78
|
|
19,972.70
|
24-Aug-18
|
120th Payment
|
18,827.92
|
1,144.78
|
|
19,972.70
|
24-Jul-23
|
Deferred Cash - 10% Down Payment
Model
Single Home
GROSS SELLING PRICE W/ VAT: P 1,248,852.80
Less: VAT(if applicable) -
GROSS SELLING PRICE W/O VAT: P 1,248,852.80
DISCOUNTS:
5% Discount on 10% SFDP 6,244.26
NET SELLING PRICE W/O VAT P 1,242,608.54
Plus: VAT (if applicable) -
NET SELLING PRICE W/ VAT Total: P 1,242,608.54
OTHER CHARGES PAYABLE TO AMAIA: 81,175.43
TOTAL AMAIA RECEIVABLE: P 1,323,783.97
PAYMENT SCHEDULE: DOWNPAYMENT
Downpayment (10% of Selling Price) P 124,260.85 Less: Reservation Fee 24-Jul-12 10,000.00
Net Downpayment 25-Jul-12 P 114,260.85
PAYMENT SCHEDULE: BALANCE
Due and payable in 23 months at 0% Interest P 1,118,347.68
Other Charges 81,175.43
Total Balance Due and Payable P 1,199,523.11
23 Months Schedule
Monthly
Downpayment
Other Charges Total Monthly Payment
1st -- 25-Aug-12 48,623.81 3,529.37 52,153.18 2nd -- 25-Sep-12 48,623.81 3,529.37 52,153.18 3rd -- 25-Oct-12 48,623.81 3,529.37 52,153.18 4th -- 25-Nov-12 48,623.81 3,529.37 52,153.18 5th -- 25-Dec-12 48,623.81 3,529.37 52,153.18 6th -- 25-Jan-13 48,623.81 3,529.37 52,153.18 7th -- 25-Feb-13 48,623.81 3,529.37 52,153.18 8th -- 25-Mar-13 48,623.81 3,529.37 52,153.18 9th -- 25-Apr-13 48,623.81 3,529.37 52,153.18 10th -- 25-May-13 48,623.81 3,529.37 52,153.18 11th -- 25-Jun-13 48,623.81 3,529.37 52,153.18 12th -- 25-Jul-13 48,623.81 3,529.37 52,153.18 13th -- 25-Aug-13 48,623.81 3,529.37 52,153.18 14th -- 25-Sep-13 48,623.81 3,529.37 52,153.18 15th -- 25-Oct-13 48,623.81 3,529.37 52,153.18 16th -- 25-Nov-13 48,623.81 3,529.37 52,153.18 17th -- 25-Dec-13 48,623.81 3,529.37 52,153.18 18th -- 25-Jan-14 48,623.81 3,529.37 52,153.18 19th -- 25-Feb-14 48,623.81 3,529.37 52,153.18 20th -- 25-Mar-14 48,623.81 3,529.37 52,153.18 21st -- 25-Apr-14 48,623.81 3,529.37 52,153.18 22nd -- 25-May-14 48,623.81 3,529.37 52,153.18 23rd -- 25-Jun-14 48,623.81 3,529.37 52,153.18
|
|