Apartment calculations
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Enter your numbers in the yellow boxes :) Will add a barometer during the week.
2
InsatsInsatsNyckel
Maximum loan/price per sqm ratio
3
Person 11,000,00050.00%70%
4
Person 21,000,00050.00%
5
Summa2,000,000
6
7
Curing period
Share of loan
Interest rate
8
Bank nameBank 1 Bank 2Bank 3Bank 4
9
Interest rate deal3 month20%1.40%1.48%1.34%1.47%
10
1 year20%1.60%--1.47%
11
3 years40%1.50%1.52%1.38%1.62%
12
5 years20%1.70%1.92%1.92%1.92%
13
7 years02.33%--2.22%
14
10 years0%----
15
Average interest rate100.00%1.22%1.29%1.20%1.33%
16
With 5% increase6.22%6.29%6.20%6.33%
17
18
19
20
21
22
AdressApt 1
23
Ask price8,000,000
24
Person 1 bet
25
Person 2 bet
26
Bid/Closing price8,500,000
27
sqm85
28
Per sqm100,000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
29
Loan needed6,500,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000-2,000,000
30
Loan portion76.5%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
31
Interest per year79,300-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400-24,400
32
Amortization if 2% per year130,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000-40,000
33
Interest and amortization per month17,442-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367
34
If 5% interest rate increase404,300-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400-124,400
35
Per month33,692-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367
36
Monthly fee4,000
37
Operating cost (8kr/kvm/mån)680
38
Total cost per month22,122-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367-5,367
39
if 5% interest rate increase38,372-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367-10,367
40
Per person11,061-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683-2,683
41
Person 1 per month11,060.83-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33
42
Person 2 per month 11,060.83-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33-2,683.33
43
Per pers 5% ränteökning19,185.83-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33-5,183.33
44
Cost per person per sqm130.13#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
45
Need for renovation
46
Balcony (yes/no)
47
Elevator (yes/no)
48
Washing machine
49
Dishwasher
50
51
Operating cost/sqm8#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
52
Web addresswww.
53
Person 1 soft score
54
Person 2 soft score
55
56
Lot ownership (Yes/No)Yes
57
Housing society loan per sqm2,600
58
Your loan per sqm76,471#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
59
Total loan exposure per sqm79,071#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
60
Loan/price per sqm79%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
61
Too much loan?Too much#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
62
% change from ask price6%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
63
Actual increase/decrease500,00000000000000000000000000000
64
Up/Down per sqm5,882#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
65
66
67
Score0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
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
Loading...