Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started