Annual Percentage Return
Mr. X is a local resident of the USA. He made a fixed rate loan of amount $70,000 for 25 year at 9% annual return. Payment as Installment should be paid on the monthly basis.
The borrower/buyer should pay to Mr. X, $1,500 as discount point.
Calculation of Annual percentage rate (APR) is provided in Excel sheet.
Rows B2 to Row B7 provide the information about the loan and screen shot is provides below:
Under the calculation box net present value of Mortgage loan is calculated by the actual loan minus the prepaid expenses. Cell (E12) shows the value of net present value of loan. Total number of period of installment is shows in cell (E13) which is calculated by multiplication of number of year and number of payment in a year.
In cell (E16) value of installment per month is calculated by following formula:
Rate is 9%
Nper is 300
PV is $70,000
Use the following screenshot to calculate the PMT:
In cell (E16) value of PMT is calculated as $587.44.
Based on PMT value of APR is calculated in Cell E(19) which is calculated by following formula:
Nper is 300
PMT is $587.44
PV is net present value of loan that is $68,500
Use the following screenshot to calculate the RATE:
From the calculation it is fount that APR monthly is 0.77% which shows in Cell (E19). Based on value of monthly APR, annual APR is calculated in cell (E20). Thus APR for the loan is
Actual value of return may differ from the annual percentage return because of following reasons:
1. In the APR calculation it is assume that prepaid expenses is paid by buyer/borrower is at the time of loan disbursement but in actual scenario prepaid expenses may pay later or before the loan disbursement.
2. The lender has some other operating expenses in disbursement of loan which is not considered in the APR calculation.
3. Lender's salary is not considered in APR calculation.
Federal Truth-in-Lending (FTL):
Federal truth-in-lending deals with the cost of mortgage credit, lenders are required to disclose financial information given in the mortgage loan agreement to individuals purchasing one to four family residences. Under this act, the commercial real estate transactions are generally excluded.
The specific disclosures required under Federal Truth-in-Lending act are:
The financial information: The intent of federal truth-in-lending legislation necessitates lenders in disclosing financial information to its borrowers contained in loan agreements and should be in uniform manner.
Cost of Credit: The effective cost of credit to the borrower on an annual basis must be disclosed using actuarial method.
Amount financed: Deducting any finance charges which are paid at closing, the mortgage amount is calculated.
Number of payments: The number of time the payment made by a borrower must be disclosed in federal truth-in-lending legislation.
Amount of payments: The monthly payments amount in dollars needs to be disclosed. In case the amount of payment each month varies due to the cost of mortgage insurance, then the highest and the lowest payment amounts will be disclosed.
Filing fees: The fees for liens against the loan assets must be disclosed as statutory fees by the lender.
An Escrow account is defined as a not interest bearing account in to which a buyer prepay the monthly installment and property taxes and seller deposit the earnings taxes.
This type of account is used for real estate purposes held by a neutral party during the phase of transaction between buyer and seller. Escrow account is generally required in very few type of estate.
Escrow account is generally created by lender to protect himself from the default of the buyer.
Type of Estate in which escrow account is required is mention below:
1. The Estate in which the loan amount is very high. In this type of estate the lender require escrow account.
2. The Estate whose depreciation value is very high, the lender require escrow account.
3. When loan to value of estate is more than 80 percent, lender require escrow account.
4. When the probability of hazards on the estate is very high even then the lender require escrow account.
In US escrow payment is part of mortgage payment. This amount is over the principal and interest amount. It is also used to pay insurance and taxes.
There is no answer for this question