- Next Level Financial Modeling
- Posts
- π3 Ways To Calculate Interest on Your Next Acquisition
π3 Ways To Calculate Interest on Your Next Acquisition
Numbers Don't Lie: The only newsletter helping you become an expert commercial real estate underwriter every Saturday 11am EST/10am CST.
Commercial real estate lenders calculate interest on loans in three ways:
30/360
Actual/365 (aka 365/365)
Actual/360 (aka 365/360)
Real estate underwriters should be aware of these 3 methods and understand which calculation the lender is using.
The differences can have a significant impact on the amount of interest paid over the life of the loan. Similarly, it can also have an impact on the amount of cash flow that is available to be distributed to your investors.
To confirm which interest rate calculation the lender will be using, look in the loan agreement, as shown below:
In simple terms, letβs break down how to calculate interest 3 different ways:
30/360
With the 30/360 interest accrual method, it is assumed that there are 30 days in every month and 360 days in the year.
First, the annual interest rate is divided by 360 to get the daily rate. 5.00% divided by 360 days equals .013889%.
Daily accrual rate is multiplied by 30 days in the month to get .041667%. This is the monthly accrual rate.
Finally, the monthly accrual rate is multiplied by the loan balance of $1,000,000. The result is $4,166. This is the interest of the first loan payment.
Actual/365
With Actual/365, interest is accrued based on the actual number of days in the month and the assumption that there are 365 days in the year.
Annual interest rate is divided by 365 days to get the daily accrual rate. The 5% divided by 365 days equals .013699%.
Second, the daily accrual rate is multiplied by the actual number of days in the month. Assume that the first payment occurs in January, which has 31 days. So, .013699 * 31 is equal to .042%.
Finally, the loan of $1,000,000 is multiplied by .042% to get the monthly interest payment of $4,246 for the first monthβs payment
Actual/360
With Actual/360, interest is accrued based on the actual number of days in the month and the assumption of 360 days in a year. The calculation follows the same three steps.
First, the annual interest rate is divided by 365 days to get the daily accrual rate. The 5% divided by 365 days equals .013699%.
Second, the daily accrual rate is multiplied by the actual number of days in the month. For this example, assume that the first payment occurs in January, which has 31 days. So, .013699 * 31 is equal to .0424658%.
Finally, this number is calculated by the outstanding balance of $1,000,000 to get the monthly interest payment of $4,246 for the first monthβs payment.
π CRE & Market News
π Stay Up-To-Date on Rates
US Ten Year Treasury Yield: 3.73%
30 Day Term SOFR: 5.14%
30 Day Average SOFR: 5.06%
Fannie Mae (1.35x DSC / 65% LTV / 10Y): 5.20% - 5.85%
Freddie Mac (1.35x DSC / 65% LTV / 10Y): 5.15% - 5.45%
5 Year FHLB: 4.54%
WSJ Prime Rate: 8.25%
π Chart of The Week
Apartment Rent Collections Reach Highest Mark Since Pre-COVID
Market-rate apartment renters are paying their monthly rent at the highest frequency in three years. Rent collections in February 2023 climbed to 96.03%, the highest rate since March 2020.
The fact that the vast majority of renters continued to pay rent through COVID and the inflationary period that followed helps explain why eviction filings never spiked as much as some feared.
π Did you enjoy this newsletter? The best compliment would be for you to share this on social media or with a friend.
π Modeling Your Success,
Miss Last Week's Newsletter? Read Here