Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel forat 15 year loan forecasted interest rate

Excel forat 15 year loan Forecasted Interest Rate Calculated TSY STRIP Yield Index Forecast...

70.2K

Verified Solution

Question

Accounting

image

image

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

Answer & Explanation Solved by verified expert
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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Why might the exponential family of distributions be important? In other words, if areal-world application turned...

Statistics
Q

1. discuss the relationship between the three cords of the branchial plexus and their position in...

Medical Sciences
Q

1. Who can contribute to a traditional IRA, and how much? Nick, age 53, is single...

Accounting
Q

What is the Interpretation between the two companies' ratios for The 2015 & 2016 Celgene &...

Accounting
Q

Ground anchor 2 is exactly 58 feet from the base of the tower dashed line...

Geometry
Q

ABCD is a parallelogram with coordinates A(4, 2), B(3,-1), C(-1,-1),and D(-1, 2). To prove that...

Algebra
Q

Use the slope-intercept form to graph the equation.y = -7xUse slope and y-intercept when drawing...

Algebra
Q

26) During 2021 Major Company purchased 8,000 shares of Minor, Inc. for $10 per share....

Accounting
Q

Lopez Inc. owned the following assets when it came out of Chapter 11 bankruptcy: Inventory:...

Accounting
Q

Marigold Corporation began operations on December 1, 2016. The only inventory transaction in 2016 was...

Accounting
Q

Suppose we decide to execute ("run") a clustering algorithm to try to detect which groups...

Accounting
Q

A company manufactures two products using the same production process. The joint costs incurred up...

Accounting