Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me put this into an Amortization Schedule Yield for 5 years Year 1 2 3 4 5 Monthly Payments Loan balances in the

Please help me put this into an Amortization Schedule

image text in transcribedimage text in transcribed

Yield for 5 years Year 1 2 3 4 5 Monthly Payments Loan balances in the year end $ 899.33 $ 148,157.98 $ 1,200.31 $ 147,043.20 $ 1,359.42 $ 146,126.42 $ 1,467.12 $ 145,281.91 1,630.42 $ 144,561.64 10.16% Month Interest Principle Ending Balance Beginning Balance $ 150,000.00 Payment $ 1 899.33 8000 vown Loan Amount $ 150,000.00 Amortization period in years 30 Initial interest rate 6.00% Index 1-year Treasuries Payment reset Each year Margin 2.00% Interest rate cap None Payment cap None Negative amoritization | Not allowed Discount points 2.00% Year Index Margin 7.00% 8.50% 9.50% 11.00% 2.00% 2.00% 2.00% 2.00% Composite Interest Rate Monthly Rate 6.00% 0.50% 9.00% 0.75% 10.50% 0.88% 11.50% 0.96% 13.00% 1.08% BOY Balance Monthly Payments EOY Loan Balances $150,000.00 $ 899.33 $ 148,157.98 $148,157.98 $ 1,200.31 $ 147,043.20 $147,043.20 $ 1,359.42 $ 146,126.42 $146,126.42 $ 1,467.12 $ 145,281.91 $145,281.91 $ 1,630.42 $ 144,561.64 | $ $ Loan Amount Initial amount after 2% discount points 1st year annual payment 2nd year annual payment 3rd year annual payment 4th year annual payment 5th year annual payment + outstanding loan amount Internal Rate of Return (yield for the unrestricted ARM for the 5-year period) Monthly Payments Annual Total Payments 150,000.00 (147,000.00) (147,000.00) 899.33 $ 10,791.91 1,200.31 $ 14,403.76 1,359.42 $ 16,313.04 1,467.12 $ 17,605.45 144,561.64 $ 1,630.42 $ 164,126.65 10.16% $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Sustainable Finance

Authors: Dirk Schoenmaker, Willem Schramade

1st Edition

0198826605, 978-0198826606

More Books

Students also viewed these Finance questions