乙案稅率試算 - 股票
By Mason
at 2017-10-08T15:33
at 2017-10-08T15:33
Table of Contents
※ 引述《vbn22 (vbn22)》之銘言:
: CASE1:假設收入全由 所得總額=股利總額=1179666,可扣抵8.5%=80000上限
: 實際繳稅0+22532=22532元
: 實際資本利得=1179666-22532=1157134
: ==================================
: CASE2:假設收入全由 所得總額=股利總額=1017685,可扣抵8.5%=80000上限
: 一來一往抵銷 實際繳稅=-19438+19438=0元
: 實際資本利得=1017685-0=1017685
: ==================================
: CASE3:假設收入全由 所得總額=股利總額=941176,可扣抵8.5%=80000
: 實際退稅28619-17976=10643元
: 實際資本利得=941176+10643=951819
: ===================================
: CASE4:假設收入由 所得總額=薪資1200000+股利總額941176=2141176,可扣抵8.5%=80000
: 實際繳稅138035+17976=156011元
: 實際資本利得=2141176-156011=1985165
原PO算得很清楚
不過我覺得寫一堆算式看得很累
我提供一個試算表方便大家自行套自己的所得試算
上面幾個case我都驗算過了 稅額與退稅額計算結果都一樣
Excel載點dropbox Google縮址
https://goo.gl/ 需要Excel版就從試算表下載吧
修了幾個bug Google試算表才是最新的
Google試算表版
https://goo.gl/inmtdc <-手機使用者請點這個 用chrome/試算表app開啟
應該只有C2 C3能動 希望不會被玩壞XD 可以自行建立副本回去慢慢玩~~
https://i.imgur.com/RqfxftK.jpg
黑色方框中輸入自己的 薪資/股利所得
右邊我把薪資跟股利按累進稅率各級的數量拆開
優先算薪資 後算股利 所以股利的稅率都比較高
補充保費直接加到股利的稅金
扣抵額優先從股利稅金扣 扣完再扣薪資的稅金
所以F11出現數字的話就是有額外退稅扣抵薪資稅金的部分
右下角橘框就是分開的稅金
左下就是總稅金+補充保費
--
: CASE1:假設收入全由 所得總額=股利總額=1179666,可扣抵8.5%=80000上限
: 實際繳稅0+22532=22532元
: 實際資本利得=1179666-22532=1157134
: ==================================
: CASE2:假設收入全由 所得總額=股利總額=1017685,可扣抵8.5%=80000上限
: 一來一往抵銷 實際繳稅=-19438+19438=0元
: 實際資本利得=1017685-0=1017685
: ==================================
: CASE3:假設收入全由 所得總額=股利總額=941176,可扣抵8.5%=80000
: 實際退稅28619-17976=10643元
: 實際資本利得=941176+10643=951819
: ===================================
: CASE4:假設收入由 所得總額=薪資1200000+股利總額941176=2141176,可扣抵8.5%=80000
: 實際繳稅138035+17976=156011元
: 實際資本利得=2141176-156011=1985165
原PO算得很清楚
不過我覺得寫一堆算式看得很累
我提供一個試算表方便大家自行套自己的所得試算
上面幾個case我都驗算過了 稅額與退稅額計算結果都一樣
Excel載點dropbox Google縮址
https://goo.gl/ 需要Excel版就從試算表下載吧
修了幾個bug Google試算表才是最新的
Google試算表版
https://goo.gl/inmtdc <-手機使用者請點這個 用chrome/試算表app開啟
應該只有C2 C3能動 希望不會被玩壞XD 可以自行建立副本回去慢慢玩~~
https://i.imgur.com/RqfxftK.jpg
黑色方框中輸入自己的 薪資/股利所得
右邊我把薪資跟股利按累進稅率各級的數量拆開
優先算薪資 後算股利 所以股利的稅率都比較高
補充保費直接加到股利的稅金
扣抵額優先從股利稅金扣 扣完再扣薪資的稅金
所以F11出現數字的話就是有額外退稅扣抵薪資稅金的部分
右下角橘框就是分開的稅金
左下就是總稅金+補充保費
--
Tags:
股票
All Comments
By Doris
at 2017-10-08T23:38
at 2017-10-08T23:38
By Agatha
at 2017-10-12T23:20
at 2017-10-12T23:20
By Madame
at 2017-10-13T10:24
at 2017-10-13T10:24
By Daniel
at 2017-10-17T21:28
at 2017-10-17T21:28
By Hedda
at 2017-10-20T15:23
at 2017-10-20T15:23
By Daph Bay
at 2017-10-25T06:31
at 2017-10-25T06:31
By Puput
at 2017-10-25T21:32
at 2017-10-25T21:32
By Brianna
at 2017-10-28T00:26
at 2017-10-28T00:26
By Noah
at 2017-10-28T12:12
at 2017-10-28T12:12
By Emma
at 2017-10-31T10:45
at 2017-10-31T10:45
By Edith
at 2017-11-04T15:58
at 2017-11-04T15:58
By Irma
at 2017-11-05T10:27
at 2017-11-05T10:27
By Catherine
at 2017-11-06T09:53
at 2017-11-06T09:53
By Daph Bay
at 2017-11-07T10:19
at 2017-11-07T10:19
By Skylar Davis
at 2017-11-09T12:23
at 2017-11-09T12:23
By Isla
at 2017-11-12T19:06
at 2017-11-12T19:06
By Lydia
at 2017-11-16T17:06
at 2017-11-16T17:06
By Elizabeth
at 2017-11-17T07:33
at 2017-11-17T07:33
By Brianna
at 2017-11-19T04:40
at 2017-11-19T04:40
By Isla
at 2017-11-23T08:52
at 2017-11-23T08:52
By William
at 2017-11-26T14:42
at 2017-11-26T14:42
By Hamiltion
at 2017-11-29T23:26
at 2017-11-29T23:26
By Caitlin
at 2017-12-03T01:05
at 2017-12-03T01:05
By Mary
at 2017-12-05T10:46
at 2017-12-05T10:46
By Linda
at 2017-12-07T19:35
at 2017-12-07T19:35
By Gary
at 2017-12-11T14:58
at 2017-12-11T14:58
By Hedwig
at 2017-12-13T15:37
at 2017-12-13T15:37
By Mason
at 2017-12-14T08:23
at 2017-12-14T08:23
By Zenobia
at 2017-12-19T06:49
at 2017-12-19T06:49
By Zanna
at 2017-12-22T10:40
at 2017-12-22T10:40
By Annie
at 2017-12-23T18:08
at 2017-12-23T18:08
By Frederic
at 2017-12-23T21:29
at 2017-12-23T21:29
By Edwina
at 2017-12-28T08:41
at 2017-12-28T08:41
By Edith
at 2018-01-01T18:05
at 2018-01-01T18:05
By Charlie
at 2018-01-03T14:21
at 2018-01-03T14:21
By Charlie
at 2018-01-06T04:02
at 2018-01-06T04:02
By Kelly
at 2018-01-11T01:48
at 2018-01-11T01:48
By James
at 2018-01-14T21:06
at 2018-01-14T21:06
By Anonymous
at 2018-01-17T11:33
at 2018-01-17T11:33
By Susan
at 2018-01-19T20:08
at 2018-01-19T20:08
By Caroline
at 2018-01-22T05:58
at 2018-01-22T05:58
By Susan
at 2018-01-27T04:49
at 2018-01-27T04:49
By Caroline
at 2018-01-27T20:51
at 2018-01-27T20:51
By Suhail Hany
at 2018-01-29T17:19
at 2018-01-29T17:19
By Yedda
at 2018-01-31T02:00
at 2018-01-31T02:00
By Susan
at 2018-02-04T23:58
at 2018-02-04T23:58
By Connor
at 2018-02-08T16:18
at 2018-02-08T16:18
By Delia
at 2018-02-09T17:27
at 2018-02-09T17:27
By Emily
at 2018-02-12T05:36
at 2018-02-12T05:36
By Lily
at 2018-02-16T22:03
at 2018-02-16T22:03
By Zanna
at 2018-02-19T10:27
at 2018-02-19T10:27
By Irma
at 2018-02-23T02:18
at 2018-02-23T02:18
By Elvira
at 2018-02-27T16:32
at 2018-02-27T16:32
By Zanna
at 2018-03-02T17:09
at 2018-03-02T17:09
By Emily
at 2018-03-04T18:02
at 2018-03-04T18:02
By Christine
at 2018-03-08T14:55
at 2018-03-08T14:55
By Genevieve
at 2018-03-09T09:41
at 2018-03-09T09:41
By Ida
at 2018-03-12T04:59
at 2018-03-12T04:59
By Connor
at 2018-03-13T04:45
at 2018-03-13T04:45
By Thomas
at 2018-03-16T16:37
at 2018-03-16T16:37
By Zanna
at 2018-03-21T08:55
at 2018-03-21T08:55
By Joe
at 2018-03-23T07:49
at 2018-03-23T07:49
By Joe
at 2018-03-23T12:07
at 2018-03-23T12:07
By David
at 2018-03-26T08:37
at 2018-03-26T08:37
Related Posts
乙案稅率試算
By Yuri
at 2017-10-08T12:06
at 2017-10-08T12:06
新日光
By Necoo
at 2017-10-08T11:49
at 2017-10-08T11:49
無薪資所得,股利收入100萬,到底要繳多少稅?
By Hamiltion
at 2017-10-08T11:12
at 2017-10-08T11:12
被駭18億 遠銀竟無人工覆核
By Genevieve
at 2017-10-08T11:03
at 2017-10-08T11:03
懶人投資法--布林通道之應用
By Wallis
at 2017-10-08T10:55
at 2017-10-08T10:55