Question

Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 3.26%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase.

After 20 years of payments, what is the balance outstanding on your loan?

Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do not type the $ symbol

Answer #1

We calculate the principal paid off after 20 years (240 months) using CUMPRINC function in Excel :

rate = 3.26%/12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 100000 (original loan amount)

start period = 1 (We are calculating principal paid off between 1st and 240th month)

end period = 240 (We are calculating principal paid off between 1st and 240th month)

type = 0 (each payment is made at the end of month)

CUMPRINC is calculated to be $55,428.53

The balance loan principal outstanding after 20 years = $100,000 - $55,428.53 = $44,571.47

Suppose that you are considering a conventional, fixed-rate 30-year
mortgage loan for $100,000. The lender quotes an APR of 6.13%,
compounded monthly; mortgage payments would be monthly, beginning
one month after the closing on your home purchase. After 13 years
of payments, what is the balance outstanding on your loan? Do not
round at intermediate steps in your calculation. Round your answer
to the nearest penny. Do not type the $ symbol.

Suppose that you are considering a conventional, fixed-rate
30-year mortgage loan for $100,000. The lender quotes an APR of
7.46%, compounded monthly; mortgage payments would be monthly,
beginning one month after the closing on your home purchase. After
19 years of payments, what is the balance outstanding on your
loan?

You are a lender and have offered a borrower a $400,000 30-year
fixed-rate mortgage loan at 4.68% with monthly payments and fully
amortize. The loan does not have any origination fees, but does
have a 2% prepayment penalty during the loan's first 5 years. What
is the ANNUAL PERCENTAGE RATE (APR) of the loan that you as the
lender are required to disclose to the borrower at the time of
origination given the borrower anticipate they will prepay the loan...

You are purchasing a new home and need to borrow $325,000 from a
mortgage lender. The mortgage lender quotes you a rate of 6.5% APR
for a 30-year fixed-rate mortgage (with payments made at the end of
each month). The mortgage lender also tells you that if you are
willing to pay one point, they can offer you a lower rate of 6.25%
APR for a 30-year fixed rate mortgage. One point is equal to 1% of
the loan value....

You need a 30-year, fixed-rate mortgage to buy a new home for
$265,000. Your mortgage bank will lend you the money at an APR of
5.6 percent for this 360-month loan. However, you can only afford
monthly payments of $1,050, so you offer to pay off any remaining
loan balance at the end of the loan in the form of a single balloon
payment.
How large will this balloon payment have to be for you to keep
your monthly...

A lender makes a loan of $100,000 at a 6% interest rate
for 25 years with monthly payments. The lender will require an
origination fee of $1,000 and will also discount the loan by some
amount.
PART B- By what amount must the lender discount the loan
such that the effective interest rate would be 8%, assuming the
mortgage will be sold at par one year after closing? (How many
discount points will the lender charge)?
a. $743 (0.74 dp)...

You are a lender and have offered a borrower a $400,000 30-year
fixed-rate mortgage loan at 4.68% with monthly payments and fully
amortize. The loan does not have any origination fees, but does
have a 2% prepayment penalty during the loan's first 5 years. What
would be the size of the prepayment penalty if the borrower repaid
all remaining principal after the 46th payment? Please indicate
your answer with two spaces right of the decimal.

Suppose that you take out a mortgage loan with the following
characteristics: compounding period is monthly loan is for $350,000
APR = 5% life of loan for the purpose of calculating the mortgage
payments is 30 years the loan requires a balloon payment of the
balance of the principal owed at the end of year 5, i.e., the
balance owed immediately after the 60th payment. What is the size
of the balloon payment? Do not round at intermediate steps in...

What is the loan balance after 5 years on a conventional
fixed-rate 6.5% mortgage with the original maturity of 30 years and
initial balance of $100,000? Assume only required monthly payments
have been made.
A. $99,543
B. $93,735
C. $93,611
D. $83,581
E. $83,333

A loan officer states, "Thousands of dollars can be
saved by switching to a 15-year mortgage from a 30-year mortgage."
Calculate the difference in payments on a 30-year mortgage loan
(APR of 3.5%) vs. a 15-year mortgage (APR of 3.0%). Assume both
mortgages are for $100,000 and require monthly payments. Then,
calculate the total payments over the entire loan period under each
scenario. What is the difference in total loan
payments to the lender between the 2 scenarios? (Round the...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 20 minutes ago

asked 22 minutes ago

asked 42 minutes ago

asked 45 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago