Scribd
Upload
88 views

How to Convert Monthly Interest Rate to Annual in Excel 1

Uploaded by

tradingviewstockscreener
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
88 views

How to Convert Monthly Interest Rate to Annual in Excel 1

Uploaded by

tradingviewstockscreener
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Monthly Interest Rate of J.P.

Morgan

Year Number of Periods Monthly Interest Rate % Annual Interest Rate %

2022 12 0.11
2021 12 0.16
2020 12 0.38
2019 12 0.27
2018 12 0.92

2017 12 0.95

2016 12 0.81
2015 12 0.22
2014 12 0.47
2013 12 0.13
Monthly Interest Rate of J.P. Morgan Methods Overview

Convert Using Simple Multiplication


Monthly
Number of Monthly Interest Number of
Year Year Interest Rate
Periods Rate % Periods
%
2022 12 0.11 2022 12 0.11
2021 12 0.16 2021 12 0.16
2020 12 0.38 2020 12 0.38
2019 12 0.27 2019 12 0.27
2018 12 0.92 Convert Using POWER Function
Monthly
Number of
2017 12 0.95 Year Interest Rate
Periods
%
2016 12 0.81 2022 12 0.11
2015 12 0.22 2021 12 0.16
2014 12 0.47 2020 12 0.38
2013 12 0.13 2019 12 0.27
erview

Annual
Interest
Rate %
1.32
1.92
4.56
3.24

Annual
Interest
Rate %
1.33
1.94
4.66
3.29
Monthly Interest Rate to Annual Interest Rate (Simple)

Number of Annual Interest


Year Periods Monthly Interest Rate % Rate %
2022 12 0.11 1.32
2021 12 0.16 1.92
2020 12 0.38 4.56
2019 12 0.27 3.24
2018 12 0.92 11.04
2017 12 0.95 11.4
2016 12 0.81 9.72
2015 12 0.22 2.64
2014 12 0.47 5.64
2013 12 0.13 1.56
Monthly Interest Rate to Annual Interest Rate (Compound)

Year Number of Monthly Interest Rate % Annual Interest


Periods Rate %
2022 12 0.11 1.33
2021 12 0.16 1.94
2020 12 0.38 4.66
2019 12 0.27 3.29
2018 12 0.92 11.62
2017 12 0.95 12.01
2016 12 0.81 10.16
2015 12 0.22 2.67
2014 12 0.47 5.79
2013 12 0.13 1.57
Monthly Interest Rate of J.P. Morgan

Number of Annual Interest


Year Periods Monthly Interest Rate % Rate %
2022 12 0.11
2021 12 0.16
2020 12 0.38
2019 12 0.27
2018 12 0.92
2017 12 0.95
2016 12 0.81
2015 12 0.22
2014 12 0.47
2013 12 0.13
Monthly Interest Rate of J.P. Morgan

Number of Annual Interest


Year Periods Monthly Interest Rate % Rate %
2022 12 0.11
2021 12 0.16
2020 12 0.38
2019 12 0.27
2018 12 0.92
2017 12 0.95
2016 12 0.81
2015 12 0.22
2014 12 0.47
2013 12 0.13

You might also like