Scribd
Upload
13 views1 page

Interest Rate Projections 2022-2026

The document outlines interest earnings on various amounts from 2022 to 2026, consistently at a rate of 6%. It details monthly interest earned based on principal amounts, with a total interest of 5,020 in 2022 and increasing amounts each subsequent year. The final net maturity value in 2026 is projected to be 121,223.

Uploaded by

Raff
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
13 views1 page

Interest Rate Projections 2022-2026

The document outlines interest earnings on various amounts from 2022 to 2026, consistently at a rate of 6%. It details monthly interest earned based on principal amounts, with a total interest of 5,020 in 2022 and increasing amounts each subsequent year. The final net maturity value in 2026 is projected to be 121,223.

Uploaded by

Raff
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

Interest Rates 6% 6% 6% 6% 6%

2022 2023 2024 2025 2026


%age by Interest %age by Interest %age by Interest %age by Interest %age by Interest
Amount Amount Amount Amount Amount
month Earned month Earned month Earned month Earned month Earned
Rolled Forward
96,020 100% 5,761.20 101,781 100% 6,107 107,888 100% 6,473.28 114,361 100% 6,861.68
(P+I)
January 57,000 1.0000 3,420 1.0000 - 1.0000 - 1.0000 - 1.0000 -
February 10,000 0.9167 550 0.9167 - 0.9167 - 0.9167 - 0.9167 -
March 20,000 0.8333 1,000 0.8333 - 0.8333 - 0.8333 - 0.8333 -
April 0.7500 - 0.7500 - 0.7500 - 0.7500 - 0.7500 -
May 0.6667 - 0.6667 - 0.6667 - 0.6667 - 0.6667 -
June 0.5833 - 0.5833 - 0.5833 - 0.5833 - 0.5833 -
July 0.5000 - 0.5000 - 0.5000 - 0.5000 - 0.5000 -
August 0.4167 - 0.4167 - 0.4167 - 0.4167 - 0.4167 -
September 1,000 0.3333 20 0.3333 - 0.3333 - 0.3333 - 0.3333 -
October 1,000 0.2500 15 0.2500 - 0.2500 - 0.2500 - 0.2500 -
November 1,000 0.1667 10 0.1667 - 0.1667 - 0.1667 - 0.1667 -
December 1,000 0.0833 5 0.0833 - 0.0833 - 0.0833 - 0.0833 -
TOTAL 91,000 5,020 96,020 5,761 101,781 6,107 107,888 6,473 114,361 6,862

rounded in This chart isn't available in your version of Excel.


Movements
0000
2022 Dec Forecast 96,020 96 Editing this shape or saving this workbook into a different file format will permanently break the chart.
2023 Pricipal - -
2023 Interest 5,761 6
2024 Pricipal - -
2024 Interest 6,107 6
2025 Pricipal - -
2025 Interest 6,473 6
2026 Pricipal - -
2026 Interest 6,862 7
2026 Net
Maturity Value 121,223 121

You might also like