Calculating Total Return
Great to see so many of you have downloaded this already. I am happy to address the private responses I have received from some of you. Keep them coming!
------------------------------
Neil Stanley
------------------------------
-------------------------------------------
Original Message:
Sent: 01-19-2022 11:40
From: Neil Stanley
Subject: Calculating Total Return
When I started in banking years ago, I realized that many bank executives focused on portfolio yields and yet often had a disproportionate fear of unrealized losses, but really didn't know how to balance these factors as they considered their performance goals. In response, I built my approach to Total Return analysis to look back at historical results and forward with forecasts at the impact of alternative investment and funding choices.
With the recent and projected volatility in interest rates today, I thought this audience might like access to a simple Excel spreadsheet that calculates the total return for a holding period for individual fixed income securities.
Please let me know if you have any questions or would like a guided tour.
------------------------------
Neil Stanley
------------------------------
------------------------------
Neil Stanley
------------------------------
-------------------------------------------
Original Message:
Sent: 01-19-2022 11:40
From: Neil Stanley
Subject: Calculating Total Return
When I started in banking years ago, I realized that many bank executives focused on portfolio yields and yet often had a disproportionate fear of unrealized losses, but really didn't know how to balance these factors as they considered their performance goals. In response, I built my approach to Total Return analysis to look back at historical results and forward with forecasts at the impact of alternative investment and funding choices.
With the recent and projected volatility in interest rates today, I thought this audience might like access to a simple Excel spreadsheet that calculates the total return for a holding period for individual fixed income securities.
Please let me know if you have any questions or would like a guided tour.
------------------------------
Neil Stanley
------------------------------
0 Comments
Join the Conversation! 🗣️✨
Be part of our community—sign up now to share your thoughts, connect with others, and stay in the loop!