[go: up one dir, main page]

0% found this document useful (0 votes)
21 views12 pages

2023 Updated Computation Template

Uploaded by

maryeneasilo91
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)
21 views12 pages

2023 Updated Computation Template

Uploaded by

maryeneasilo91
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
You are on page 1/ 12

PROJECT: SORRENTO PHASE: 2C BLOCK: 11 LOT: 25

HOUSE MODEL: RAFAELI INNER (CLASSIC) LA: 60 FA: 71


SELLING PRICE: 2,015,000 \

OPTION 1: SPOT CASH WITH IN 30DAYS OPTION 2: DEFERRED CASH


SELLING PRICE: 2,015,000.00 SELLING PRICE: 2,015,000.00
10% SPOT CASH DISCOUNT: 201,500.00 NET SELLING PRICE: 2,015,000.00
NET SELLING PRICE: 1,813,500.00 VAT (If applicable): -
VAT (If applicable): - TOTAL CONTRACT PRICE: 2,015,000.00
TOTAL CONTRACT PRICE: 1,813,500.00 RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 TOTAL PAYMENT: 1,995,000.00
SPOT CASH PAYMENT 1,793,500.00 PAYABLE IN 12MONTHS: 166,250.00

OPTION 3: 20% SPOT DOWNPAYMENT 80% BANK OPTION 4: 20% DP IN 30MONTHS 80% BANK
SELLING PRICE: 2,015,000.00 SELLING PRICE: 2,015,000.00
DISCOUNT (10% of 20% Spot DP): 40,300.00 NET SELLING PRICE: 2,015,000.00
NET SELLING PRICE: 1,974,700.00 VAT (If applicable): -
VAT (If applicable): - TOTAL CONTRACT PRICE: 2,015,000.00
TOTAL CONTRACT PRICE: 1,974,700.00 20% DOWNPAYMENT 403,000.00
20% DOWNPAYMENT 394,940.00 RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 NET DOWNPAYMENT: 383,000.00
SPOT DOWNPAYMENT: 374,940.00 PAYABLE IN 30 MONTH: 12,766.67

OPTION 3 OPTION 4
80% BANK FINANCING: 1,579,760.00 1,612,000.00
YEARS OF PAYMENT: MONTHLY AMORTIZATION REQUIRED INCOME
20 years to pay 13,213.75 13,483.41 44,944.71
15 years to pay 15,097.01 15,405.11 51,350.37
10 years to pay 19,166.85 19,558.01 65,193.36
5 years to pay 32,031.84 32,685.55 108,951.83
0.0083644
0.0095565
0.0121328
0.0202764
PROJECT: NEVIARE PHASE: 2 BLOCK: 17 LOT: 2
HOUSE MODEL: LUCERNE (RFO) LA: 140 FA: 117
SELLING PRICE: 4,949,500

OPTION 1: SPOT CASH WITH IN 30DAYS OPTION 2: DEFERRED CASH


SELLING PRICE: 4,949,500.00 SELLING PRICE: 4,949,500.00
10% SPOT CASH DISCOUNT: 494,950.00 DISCOUNT(3% ON TCP): 148,485.00
NET SELLING PRICE: 4,454,550.00 NET SELLING PRICE: 4,801,015.00
VAT (If applicable): 534,546.00 VAT (If applicable): 576,121.80
TOTAL CONTRACT PRICE: 4,989,096.00 TOTAL CONTRACT PRICE: 5,377,136.80
RESERVATION FEE: 50,000.00 RESERVATION FEE: 50,000.00
SPOT CASH PAYMENT 4,939,096.00 TOTAL PAYMENT: 5,327,136.80
PAYABLE IN 6MONTHS: 887,856.13
OPTION 3: 20% SPOT DOWNPAYMENT 80% BANK
SELLING PRICE: 4,949,500.00 OPTION 4: 20% DP IN 6MONTHS 80% BANK
DISCOUNT (10% of 20% Spot DP): 98,990.00 SELLING PRICE: 4,949,500.00
NET SELLING PRICE: 4,850,510.00 DISCOUNT (5% of 20% DP): 49,495.00
VAT (If applicable): 582,061.20 NET SELLING PRICE: 4,900,005.00
TOTAL CONTRACT PRICE: 5,432,571.20 VAT (If applicable): 588,000.60
20% DOWNPAYMENT 1,086,514.24 TOTAL CONTRACT PRICE: 5,488,005.60
RESERVATION FEE: 50,000.00 20% DOWNPAYMENT 1,097,601.12
SPOT DOWNPAYMENT: 1,036,514.24 RESERVATION FEE: 50,000.00
NET DOWNPAYMENT: 1,047,601.12
OPTION 5: 5% IN 6MONTHS 15 IN 30MONTHS 80% BANK PAYABLE IN 6 MONTH: 174,600.19
SELLING PRICE: 4,949,500.00
NET SELLING PRICE: 4,949,500.00 OPTION 6: 20% DP IN 12MONTHS 80% BANK
VAT (If applicable): 593,940.00 SELLING PRICE: 4,949,500.00
TOTAL CONTRACT PRICE: 5,543,440.00 NET SELLING PRICE: 4,949,500.00
5% DOWNPAYMENT 277,172.00 VAT (If applicable): 593,940.00
RESERVATION FEE: 50,000.00 TOTAL CONTRACT PRICE: 5,543,440.00
5% NET DOWNPAYMENT: 227,172.00 20% DOWNPAYMENT 1,108,688.00
PAYABLE IN 6 MONTH: 37,862.00 RESERVATION FEE: 50,000.00
15% DOWNPAYMENT 831,516.00 NET DOWNPAYMENT: 1,058,688.00
PAYABLE IN 30 MONTH: 27,717.20 PAYABLE IN 12 MONTH: 88,224.00

OPTION 3 OPTION 4 OPTION 5 & 6


80% BANK FINANCING: 4,346,056.96 4,390,404.48 4,434,752.00
YEARS OF PAYMENT: MONTHLY AMORTIZATION REQUIRED INCOME
20 years to pay 36,352.16 36,723.10 37,094.04 123,646.81
15 years to pay 41,533.18 41,956.99 42,380.80 141,269.33
10 years to pay 52,729.66 53,267.72 53,805.78 179,352.60
5 years to pay 88,122.36 89,021.57 89,920.78 299,735.93
0.0083644
0.0095565
0.0121328
0.0202764
PROJECT: NEVIARE PHASE: 2 BLOCK: 17 LOT: 2
HOUSE MODEL: LUCERNE (RFO) LA: 140 FA: 117
SELLING PRICE: 4,949,500

10% DP IN 12MONTHS 90% BANK


SELLING PRICE: 4,949,500.00
NET SELLING PRICE: 4,949,500.00
VAT (If applicable): 593,940.00
TOTAL CONTRACT PRICE: 5,543,440.00
10% DOWNPAYMENT 554,344.00
RESERVATION FEE: 50,000.00
NET DOWNPAYMENT: 504,344.00
PAYABLE IN 12 MONTH: 42,028.67

For Philippine Veterans Bank and Card SME


90% BANK FINANCING: 4,989,096.00
YEARS OF PAYMENT: REQUIRED INCOME
20 years to pay 41,730.80 139,102.66
15 years to pay 47,678.40 158,928.00
10 years to pay 60,531.50 201,771.67
5 years to pay 101,160.88 337,202.93
0.0083644
0.0095565
0.0121328
0.0202764
PROJECT: NEVIARE PHASE: 2 BLOCK: 13 LOT: 2
HOUSE MODEL: LEILA DELUXE W/ TRELLIS (RFO) LA: 125 FA: 64
SELLING PRICE: 2,768,000

OPTION 1: SPOT CASH WITH IN 30DAYS OPTION 2: DEFERRED CASH


SELLING PRICE: 2,768,000.00 SELLING PRICE: 2,768,000.00
10% SPOT CASH DISCOUNT: 276,800.00 DISCOUNT(3% ON TCP): 83,040.00
NET SELLING PRICE: 2,491,200.00 NET SELLING PRICE: 2,684,960.00
VAT (If applicable): - VAT (If applicable): -
TOTAL CONTRACT PRICE: 2,491,200.00 TOTAL CONTRACT PRICE: 2,684,960.00
RESERVATION FEE: 25,000.00 RESERVATION FEE: 25,000.00
SPOT CASH PAYMENT 2,466,200.00 TOTAL PAYMENT: 2,659,960.00
PAYABLE IN 6MONTHS: 443,326.67
OPTION 3: 20% SPOT DOWNPAYMENT 80% IHF
SELLING PRICE: 2,768,000.00 OPTION 4: 20% DP IN 6MONTHS 80% IHF
DISCOUNT (10% of 20% Spot DP): 55,360.00 SELLING PRICE: 2,768,000.00
NET SELLING PRICE: 2,712,640.00 DISCOUNT (5% of 20% DP): 27,680.00
VAT (If applicable): - NET SELLING PRICE: 2,740,320.00
TOTAL CONTRACT PRICE: 2,712,640.00 VAT (If applicable): -
20% DOWNPAYMENT 542,528.00 TOTAL CONTRACT PRICE: 2,740,320.00
RESERVATION FEE: 25,000.00 20% DOWNPAYMENT 548,064.00
SPOT DOWNPAYMENT: 517,528.00 RESERVATION FEE: 25,000.00
NET DOWNPAYMENT: 523,064.00
PAYABLE IN 6 MONTH: 87,177.33

OPTION 3 OPTION 4
80% IN-HOUSE FINANCING: 2,170,112.00 2,192,256.00
YEARS OF PAYMENT: MONTHLY AMORTIZATION REQUIRED INCOME
10 years to pay 36,352.22 36,723.16 122,410.55
5 years to pay 52,772.91 53,311.41 177,704.69
0.01675131
0.02431806
PROJECT: SORRENTO PHASE: 1 BLOCK: 9 LOT: 6
HOUSE MODEL: LOT ONLY LA: 192
SELLING PRICE: 2,174,000

OPTION 1: SPOT CASH WITH IN 30DAYS OPTION 2: DEFERRED CASH


SELLING PRICE: 2,174,000.00 SELLING PRICE: 2,174,000.00
10% SPOT CASH DISCOUNT: 217,400.00 NET SELLING PRICE: 2,174,000.00
NET SELLING PRICE: 1,956,600.00 VAT (If applicable): 260,880.00
VAT (If applicable): 234,792.00 TOTAL CONTRACT PRICE: 2,434,880.00
TOTAL CONTRACT PRICE: 2,191,392.00 RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 TOTAL PAYMENT: 2,414,880.00
SPOT CASH PAYMENT 2,171,392.00 PAYABLE IN 12MONTHS: 201,240.00

OPTION 3: 30% SPOT DOWNPAYMENT 70% BANK OPTION 4: 30% DP IN 12MONTHS 70% BANK
SELLING PRICE: 2,174,000.00 SELLING PRICE: 2,174,000.00
DISCOUNT (10% of 30% Spot DP): 65,220.00 NET SELLING PRICE: 2,174,000.00
NET SELLING PRICE: 2,108,780.00 VAT (If applicable): 260,880.00
VAT (If applicable): 253,053.60 TOTAL CONTRACT PRICE: 2,434,880.00
TOTAL CONTRACT PRICE: 2,361,833.60 30% DOWNPAYMENT 730,464.00
30% DOWNPAYMENT 708,550.08 RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 NET DOWNPAYMENT: 710,464.00
SPOT DOWNPAYMENT: 688,550.08 PAYABLE IN 12 MONTH: 59,205.33

OPTION 3 OPTION 4
80% BANK FINANCING: 1,653,283.52 1,704,416.00
YEARS OF PAYMENT: MONTHLY AMORTIZATION REQUIRED INCOME
20 years to pay 13,828.73 14,256.42 47,521.39
15 years to pay 15,799.64 16,288.29 54,294.29
10 years to pay 20,058.89 20,679.27 68,930.90
5 years to pay 33,522.63 34,559.41 115,198.04
0.0083644
0.0095565
0.0121328
0.0202764
PROJECT: SORRENTO PHASE: 2 BLOCK: LOT:
HOUSE MODEL: LOT ONLY LA: 200
SELLING PRICE: 2,448,000

OPTION 1: SPOT CASH WITH IN 30DAYS OPTION 2: DEFERRED CASH IN 36MONTHS


SELLING PRICE: 2,448,000.00 SELLING PRICE: 2,448,000.00
10% SPOT CASH DISCOUNT: 244,800.00 NET SELLING PRICE: 2,448,000.00
NET SELLING PRICE: VAT (If applicable): 293,760.00
VAT (If applicable): - TOTAL CONTRACT PRICE: 2,741,760.00
TOTAL CONTRACT PRICE: - RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 TOTAL PAYMENT: 2,721,760.00
SPOT CASH PAYMENT (20,000.00) PAYABLE IN 36MONTHS: 75,604.44

OPTION 3: 30% SPOT DOWNPAYMENT 70% BANK OPTION 4: 30% DP IN 12MONTHS 70% BANK
SELLING PRICE: 2,448,000.00 SELLING PRICE: 2,448,000.00
DISCOUNT (10% of 30% Spot DP): 73,440.00 NET SELLING PRICE: 2,448,000.00
NET SELLING PRICE: 2,374,560.00 VAT (If applicable): 293,760.00
VAT (If applicable): 284,947.20 TOTAL CONTRACT PRICE: 2,741,760.00
TOTAL CONTRACT PRICE: 2,659,507.20 30% DOWNPAYMENT 822,528.00
30% DOWNPAYMENT 797,852.16 RESERVATION FEE: 20,000.00
RESERVATION FEE: 20,000.00 NET DOWNPAYMENT: 802,528.00
SPOT DOWNPAYMENT: 777,852.16 PAYABLE IN 12 MONTH: 66,877.33

OPTION 3 OPTION 4
80% BANK FINANCING: 1,861,655.04 1,919,232.00
YEARS OF PAYMENT: MONTHLY AMORTIZATION REQUIRED INCOME
20 years to pay 15,571.63 16,053.23 53,510.75
15 years to pay 17,790.95 18,341.18 61,137.27
10 years to pay 22,587.01 23,285.58 77,618.60
5 years to pay 37,747.65 38,915.10 129,717.02
0.0083644
0.0095565
0.0121328
0.0202764

You might also like