Excel forat 15 year loan Forecasted Interest Rate Calculated TSY STRIP Yield Index Forecast...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Excel forat
15 year loan Forecasted Interest Rate Calculated TSY STRIP Yield Index Forecast Forecasted Interest Rate + 2% Index + Margin = Index Forecast + 2.5% Teaser Rate-3% Contract Rate- Actual Interest Rate Used That Year Periodic Cap-2% Life Cap = 5% . . You pull the following TSY STRIP prices from the Wall Street Journal website Stripped T-Bond Price Dollars 100.000 99.873 99.348 97.231 97.219 94.749 92.539 89.225 85.699 80.71 78.876 72.418 69.139 66.05 61.654 60.193 Loan Year Year 2014 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2 4 9 12 13 15
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.