Reference no: EM131589788
You are applying for a 30-year, fixed-rate (APR 6.50%) mortgage loan for a house that sells for $80,000 today. The mortgage bank will ask you for 20% initial down payment of the house value, and charge you an extra $3,000 closing cost (carried into loan balance and amortized later) when the loan is approved.
Using only Excel finance formulas ( PV, FV, PMT, NPER or RATE)
a) The monthly loan payment is $423.49
b) After 10 years the remaining principal balance is $56,800
c) 10 years after the house purchase (as Part b aforementioned), the loan market rate drops from 6.50% APR to 4.50% APR, you want to refinance on the remaining loan principal balance, but the bank will charge you an extra $4,000 refinancing fee (which is carried into the remaining loan balance and then amortized over the rest of loan life). By how much would you be able to lower your monthly loan payment if you choose to refinance over the remaining loan life (i.e., instead of the extension of another 30 years)?
Using only Excel finance formulas ( PV, FV, PMT, NPER or RATE) calculate question c) By how much would you be able to lower your monthly loan payment if you choose to refinance over the remaining loan life (i.e., instead of the extension of another 30 years)?
|
Do an internet search to see the recent news on hand disease
: Do an internet search to see the recent news on hand, foot, and mouth disease. Share some of your initial thoughts in how to address the situation.
|
|
Primary functions of the muscular system
: Consider the primary functions of the muscular system. Explain how are these functions critical to survival?
|
|
Physician about the blackheads
: During her regular physical examination, Courtney, a 14-year-old girl, asks her physician about the blackheads on her nose.
|
|
Discuss the symbols that are present in two of the poems
: What is the historical significance of Yeat's work. Discuss the symbols that are present in two of the poems
|
|
Fixed-rate mortgage loan for a house
: You are applying for a 30-year, fixed-rate (APR 6.50%) mortgage loan for a house that sells for $80,000 today.
|
|
Audrey is visiting your clinic for a routine checkup
: Audrey is visiting your clinic for a routine checkup. Following the checkup, she mentions that her older sister was recently diagnosed with ovarian cancer
|
|
Calculate the t-test statistic
: Practice the following problems by hand just to see if you can get the numbers right. Using the following information, calculate the t-test statistic.
|
|
Study the acme corporation case and organize trial notebook
: For the final project, you will study the Acme Corporation case and organize a trial notebook. A trial notebook is an outline that a trial attorney will follow.
|
|
Describe the role of the liver in protein metabolism
: a. Describe the role of the liver in protein metabolism.
|