ABCDEFGHIJKLMNOPQRSTU
1
NameAgeMonthly Fixed IncomeYearly variable IncomeMonthly Income After 30% HaircutMonthly Bonus xEst CPF OA Monthly ContriCPF OA BalanceCPF OA Withdrawn for HousingCPF OA Accrued InterestCPF OA Withdrawn for InvestmentsTotal CPF OACPF Contri (OA Only)
2
Hero32$99,999$0$01.50$25,875$999,999$999,999$999,999$0$2,999,997HeroHeroineAvgHeroHeroineTotal
3
Heroine32$99,999$0$01.50$25,875$999,999$999,999$999,999$0$2,999,997Apr 2024$2,274$3,3186 mths$2,071$1,215$3,286
4
Client 30$0$0$00.00$0$0$0$0$0$0Mar 2024$793$89212 mths$1,527$1,057$2,584
5
Client 40$0$0$00.00$0$0$0$0$0$0Feb 2024$6,795$79015 mths$1,478$1,177$2,655
6
Do Not Key In '$', just the numberDo Not Key In '$', just the numberDo Not Key In '$', just the numberJan 2024$705$759No bonus$756$790$1,546
7
Mortgage Servicing Ratio - HDB (HDB Loan) Check (MSR)Dec 2023$762$759
8
Loan ApprovedInterest Stress TestLoan Period (PA APP)MSRCombined IncomeService Ratio %Nov 2023$1,098$770Avg$1,458$1,060$2,518
9
$12,652,4613.00%25$59,999$199,99830%Oct 2023$866$770
10
Sep 2023$734$770
11
Mortgage Servicing Ratio - HDB (Bank Loan) Check (MSR)Aug 2023$759$770Yellow Cells = Manual input
12
Loan ApprovedInterest Stress TestLoan Period (PA APP)MSRCombined IncomeService Ratio %Jul 2023$735$770
13
$10,418,6604.85%25$59,999$199,99830%Jun 2023$2,069$1,551
14
May 2023$728$770
15
Mortgage Servicing Ratio- EC (Bank Loan) Check (MSR)Apr 2023$756$3,300
16
Loan ApprovedInterest Stress TestLoan Period (PA APP)MSRCombined IncomeService Ratio %Mar 2023$2,371$883Est CPF OA Monthly Contri - Cross check with PA App/ CPF Transaction History
17
$11,370,1594.85%30$59,999$199,99830%Feb 2023$728$784
18
19
Total Debt Servicing Ratio Check (TDSR)
20
Loan ApprovedInterest Stress TestLoan Period (PA APP)TDSRCombined IncomeService Ratio %
21
$20,845,2924.85%30$109,999$199,99855%
22
23
Max PTE Budget Based on TDSR Loan @ 75%$27,793,722Cash Savings Available$0Total Cash Funds-$3,210,524
24
Total Cash + Total CPF + Total Loan Approved$23,634,761Total Grants Available$0Total CPF Funds$5,999,994
25
TOTAL CASH + CPF / 29%$9,618,861Cash Proceeds From Sold Property-$3,210,524Total CPF Funds + Grants$5,999,994
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100