銀行
A | B | C | D | E | F | |
1 | 利率 | 0.30% | =MAX(F3:F1000) | |||
2 | 元金 | 税引前利息 | 国税 | 地方税 | 税引後利息 | 税引き後利息/元金 |
3 | 1,000,000 | =INT(A3*$B$1*14/365) | =INT(B3*15%) | =INT(B3*5%) | =B3-C3-D3 | =E3/A3/14*365 |
USD/JPY | EUR/JPY | GBP/JPY | CHF/JPY |
CAD/JPY | AUD/JPY | NZD/JPY | HKD/JPY |
EUR/USD | GBP/USD | AUD/USD | NZD/USD |