Question

Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes...

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

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT