一、案例定位

整合原書 Table 1.14–1.16,從 Other Income、Net Interest Expense、EBT、Tax 一路預測到 Net Income 與 EPS。

二、學習目標

三、案例情境

原書在第 1 章先以簡化方式設定 projected Net Interest Expense 為 0,Other Income 在 183 與 (203) 間交替,再用 21% tax rate 計算 2021E–2025E Net Income。

四、開始資料

US$ millions except EPS 2021E 2022E 2023E 2024E 2025E
EBT 60,967.5 72,727.5 81,634.3 89,242.3 94,270.6
Tax Rate 21% 21% 21% 21% 21%
Income Tax Expense 12,803.2 15,272.8 17,143.2 18,740.9 19,796.8
Net Income as Reported 48,173.3 57,440.7 64,507.1 70,510.4 74,459.8
Diluted EPS 92.76 110.61 124.21 135.77 143.38

五、Excel/VBA 分析方法

EBT = EBIT + Other Income − Net Interest Expense;Income Tax Expense = EBT × Tax Rate;Net Income from Continuing Operations = EBT − Tax;Reported Net Income 再反映 equity-method investment activity;EPS = Reported Net Income ÷ Average Shares Outstanding。

六、計算結果

2021E EBT 60,967.5,Tax 12,803.2,Net Income from Continuing Operations 48,164.3,Reported Net Income 48,173.3;Basic EPS 95.52、Diluted EPS 92.76。2025E Reported Net Income 74,459.8,Diluted EPS 143.38。

七、結果分析與管理解讀

稅率假設直接影響淨利與 EPS;share count 則決定同一份淨利分配到每股後的結果。原書此階段將 projected net interest 暫設為 0,後續債務排程會再完善融資成本。

八、AI Prompt

請只根據 Amazon 2021E–2025E EBT、Tax、Reported Net Income 與 EPS 結果,說明 tax rate 與 share count 分別如何影響每股盈餘。不得補入本章尚未建模的利息數字。

九、思考/What-if

**問題:**若 2021E Tax Rate 改為 23%,其他條件不變,Net Income from Continuing Operations 為多少?