Calculate Real Interest rate for a loan bank would grant to a consumer in USA or Egypt

Real Rate=(Nominal Interest Rate Rate of Inflation)/(1+Rate of Inflation)

For Nominal Interest Rate take interest rate any bank in USA or Egypt currently applies to consumer loans.

For Rate of Inflation take expected inflation rate for 2022. If not available take current inflation rate.

All sources should be mentioned. TASK MUST BE IN EXCEL