Answered step by step
Verified Expert Solution
Link Copied!

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

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

Office Of Anticorruption And Integrity Annual Report 2023

Authors: Asian Development Bank

1st Edition

9292544381,929254439X

More Books

Students also viewed these Finance questions