Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the Lenders Yield of the following variable rate loan. Loan Amount 180,000 30 year loan with monthly payments 2% first year rate, 4%
What is the Lenders Yield of the following variable rate loan.
Loan Amount 180,000
30 year loan with monthly payments
2% first year rate, 4% years 2 and 3
Loan is to be paid off in 3 years
Loan fees to the lender of 3 points
Fill this out:
Adjustable Rate | Loan Amount: | |||||||||||||||
Lender's and Borrower's | Loan Term (In Years): | years | Eff | Lend | Borrow | |||||||||||
First Year Int. Rate: | 0 | $0.00 | $0.00 | $0.00 | ||||||||||||
Years 2 - 3 Rate: | 1 | $0.00 | $0.00 | $0.00 | ||||||||||||
Points: | 2 | $0.00 | $0.00 | $0.00 | ||||||||||||
Closing Costs: | 3 | $0.00 | $0.00 | $0.00 | ||||||||||||
Paid off in: | years | 4 | $0.00 | $0.00 | $0.00 | |||||||||||
5 | $0.00 | $0.00 | $0.00 | |||||||||||||
6 | $0.00 | $0.00 | $0.00 | |||||||||||||
7 | $0.00 | $0.00 | $0.00 | |||||||||||||
0 | 1 | 2 | 3 | 8 | $0.00 | $0.00 | $0.00 | |||||||||
CF0 | CF1 | CF2 | CF3 | 9 | $0.00 | $0.00 | $0.00 | |||||||||
Effective: | 10 | $0.00 | $0.00 | $0.00 | ||||||||||||
Lender's: | 11 | $0.00 | $0.00 | $0.00 | ||||||||||||
Borrower's: | 12 | $0.00 | $0.00 | $0.00 | ||||||||||||
13 | $0.00 | $0.00 | $0.00 | |||||||||||||
14 | $0.00 | $0.00 | $0.00 | |||||||||||||
15 | $0.00 | $0.00 | $0.00 | |||||||||||||
N | I/Y | PV | PMT | FV | 16 | $0.00 | $0.00 | $0.00 | ||||||||
1st Year Pymt. | 17 | $0.00 | $0.00 | $0.00 | ||||||||||||
New Balance: | 18 | $0.00 | $0.00 | $0.00 | ||||||||||||
Payments Yrs 2 - 3: | 19 | $0.00 | $0.00 | $0.00 | ||||||||||||
Balance after 3 yrs: | 20 | $0.00 | $0.00 | $0.00 | ||||||||||||
21 | $0.00 | $0.00 | $0.00 | |||||||||||||
22 | $0.00 | $0.00 | $0.00 | |||||||||||||
Effective | Lender's | Borrower's | 23 | $0.00 | $0.00 | $0.00 | ||||||||||
CF0 | 24 | $0.00 | $0.00 | $0.00 | ||||||||||||
CF1 | 25 | $0.00 | $0.00 | $0.00 | ||||||||||||
F1 | 26 | $0.00 | $0.00 | $0.00 | ||||||||||||
CF2 | 27 | $0.00 | $0.00 | $0.00 | ||||||||||||
F2 | 28 | $0.00 | $0.00 | $0.00 | ||||||||||||
CF3 | 29 | $0.00 | $0.00 | $0.00 | ||||||||||||
F3 | 30 | $0.00 | $0.00 | $0.00 | ||||||||||||
IRR = | 31 | $0.00 | $0.00 | $0.00 | ||||||||||||
32 | $0.00 | $0.00 | $0.00 | |||||||||||||
33 | $0.00 | $0.00 | $0.00 | |||||||||||||
34 | $0.00 | $0.00 | $0.00 | |||||||||||||
35 | $0.00 | $0.00 | $0.00 | |||||||||||||
36 | $0.00 | $0.00 | $0.00 |
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