ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
假設數據
2
一家薪資收入$58,000<=請自己填入
3
一家房屋租金(月)(13,500.00)<=請自己填入
4
一家生活開銷(月)(30,000.00)<=請自己填入
5
一家保費支出(月)(5,000.00)<=請自己填入
6
物價通膨2.00%
7
調薪幅度2.00%
8
定存年利率1.345%
9
保費年增率0.000%
10
投資1年化收益率6.000%
11
投資1佔收入百分比30.000%
12
定存1佔收入百分比5.000%
13
房貸繳清基準年
14
經過幾年？0123456789101112131415161718192021222324252627282930
15
16
開門
17
現金請自己填入=>80,000 13,115 27,880 43,121 58,851 75,083 91,831 109,108 126,929 145,308 164,260 183,800 203,943 224,706 246,104 268,154 290,874 314,281 338,393 363,228 388,804 415,142 442,262 470,182 498,924 528,509 558,958 590,295 622,541 655,720 689,856
18
投資1請自己填入=>2,000,000 2,271,828 2,553,405 2,845,003 3,146,903 3,459,389 3,782,757 4,117,307 4,463,347 4,821,194 5,191,172 5,573,612 5,968,856 6,377,253 6,799,158 7,234,940 7,684,974 8,149,643 8,629,343 9,124,476 9,635,458 10,162,712 10,706,672 11,267,783 11,846,501 12,443,294 13,058,639 13,693,028 14,346,961 15,020,954 15,715,534
19
定存1請自己填入=>230,000 269,150 309,083 349,815 391,361 433,738 476,963 521,052 566,023 611,894 658,682 706,405 755,083 804,735 855,380 907,037 959,728 1,013,473 1,068,292 1,124,208 1,181,242 1,239,417 1,298,755 1,359,280 1,421,016 1,483,986 1,548,216 1,613,730 1,680,555 1,748,716 1,818,240
20
開門SUM2,310,000 2,554,094 2,890,368 3,237,939 3,597,114 3,968,210 4,351,551 4,747,467 5,156,300 5,578,396 6,014,113 6,463,818 6,927,883 7,406,693 7,900,642 8,410,132 8,935,576 9,477,397 10,036,027 10,611,912 11,205,505 11,817,271 12,447,688 13,097,245 13,766,441 14,455,789 15,165,814 15,897,053 16,650,058 17,425,391 18,223,630
21
22
收入單月*12個月
23
預定薪資收入58,000 783,000 783,000 798,660 814,633 830,926 847,544 864,495 881,785 899,421 917,409 935,757 954,473 973,562 993,033 1,012,894 1,033,152 1,053,815 1,074,891 1,096,389 1,118,317 1,140,683 1,163,497 1,186,767 1,210,502 1,234,712 1,259,406 1,284,594 1,310,286 1,336,492 1,363,222 1,390,486 1,418,296
24
投資1收入120,000 136,310 153,204 170,700 188,814 207,563 226,965 247,038 267,801 289,272 311,470 334,417 358,131 382,635 407,950 434,096 461,098 488,979 517,761 547,469 578,127 609,763 642,400 676,067 710,790 746,598 783,518 821,582 860,818 901,257 942,932
25
定存收益3,094 3,620 4,157 4,705 5,264 5,834 6,415 7,008 7,613 8,230 8,859 9,501 10,156 10,824 11,505 12,200 12,908 13,631 14,369 15,121 15,888 16,670 17,468 18,282 19,113 19,960 20,824 21,705 22,603 23,520 24,455
26
收入SUM906,094 938,590 971,995 1,006,331 1,041,622 1,077,892 1,115,166 1,153,467 1,192,823 1,233,259 1,274,802 1,317,480 1,361,321 1,406,353 1,452,606 1,500,111 1,548,898 1,598,999 1,650,446 1,703,272 1,757,512 1,813,200 1,870,371 1,929,061 1,989,309 2,051,152 2,114,628 2,179,778 2,246,643 2,315,264 2,385,683
27
28
支出
29
房租(13,500)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)(162,000)
30
房貸0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
31
生活費(30,000)(360,000)(360,000)(367,200)(374,544)(382,035)(389,676)(397,469)(405,418)(413,527)(421,797)(430,233)(438,838)(447,615)(456,567)(465,698)(475,012)(484,513)(494,203)(504,087)(514,169)(524,452)(534,941)(545,640)(556,553)(567,684)(579,037)(590,618)(602,431)(614,479)(626,769)(639,304)(652,090)
32
保險支出(5,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)(60,000)
33
再投資0 0 (271,828)(281,577)(291,598)(301,899)(312,487)(323,368)(334,550)(346,040)(357,847)(369,978)(382,441)(395,244)(408,396)(421,906)(435,782)(450,033)(464,669)(479,700)(495,134)(510,982)(527,254)(543,960)(561,111)(578,718)(596,793)(615,346)(634,388)(653,934)(673,993)(694,579)(715,705)
34
滿額定存(39,150)(39,933)(40,732)(41,546)(42,377)(43,225)(44,089)(44,971)(45,870)(46,788)(47,724)(48,678)(49,652)(50,645)(51,658)(52,691)(53,745)(54,819)(55,916)(57,034)(58,175)(59,338)(60,525)(61,736)(62,970)(64,230)(65,514)(66,825)(68,161)(69,524)(70,915)
35
支出SUM(892,978)(910,710)(928,874)(947,480)(966,540)(986,062)(1,006,057)(1,026,538)(1,047,515)(1,068,999)(1,091,002)(1,113,537)(1,136,615)(1,160,249)(1,184,452)(1,209,237)(1,234,617)(1,260,606)(1,287,218)(1,314,468)(1,342,370)(1,370,938)(1,400,189)(1,430,138)(1,460,800)(1,492,193)(1,524,333)(1,557,237)(1,590,923)(1,625,408)(1,660,710)
36
透支警告FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE
37
38
CLOSE
39
現金13,115 27,880 43,121 58,851 75,083 91,831 109,108 126,929 145,308 164,260 183,800 203,943 224,706 246,104 268,154 290,874 314,281 338,393 363,228 388,804 415,142 442,262 470,182 498,924 528,509 558,958 590,295 622,541 655,720 689,856 724,973
40
投資12,271,828 2,553,405 2,845,003 3,146,903 3,459,389 3,782,757 4,117,307 4,463,347 4,821,194 5,191,172 5,573,612 5,968,856 6,377,253 6,799,158 7,234,940 7,684,974 8,149,643 8,629,343 9,124,476 9,635,458 10,162,712 10,706,672 11,267,783 11,846,501 12,443,294 13,058,639 13,693,028 14,346,961 15,020,954 15,715,534 16,431,239
41
定存1269,150 309,083 349,815 391,361 433,738 476,963 521,052 566,023 611,894 658,682 706,405 755,083 804,735 855,380 907,037 959,728 1,013,473 1,068,292 1,124,208 1,181,242 1,239,417 1,298,755 1,359,280 1,421,016 1,483,986 1,548,216 1,613,730 1,680,555 1,748,716 1,818,240 1,889,155
42
43
總資產現值2,554,094 2,890,368 3,237,939 3,597,114 3,968,210 4,351,551 4,747,467 5,156,300 5,578,396 6,014,113 6,463,818 6,927,883 7,406,693 7,900,642 8,410,132 8,935,576 9,477,397 10,036,027 10,611,912 11,205,505 11,817,271 12,447,688 13,097,245 13,766,441 14,455,789 15,165,814 15,897,053 16,650,058 17,425,391 18,223,630 19,045,367
44
比較:買房後資產2,673,000 3,046,315 3,430,155 3,824,735 4,230,272 4,646,991 5,075,119 5,514,888 5,966,535 6,430,301 6,906,433 7,395,181 7,896,803 8,411,559 8,939,717 9,481,548 10,037,330 10,293,881 10,527,672 10,776,279 11,100,004 11,439,152 11,794,038 12,164,978 12,552,299 12,956,331 13,377,415 13,815,893 14,272,120 14,746,453 15,239,258