Question
In: Finance
Create AS for a $250,000 M to be repaid in equal monthly payments at the end...
Create AS for a $250,000 M to be repaid in equal monthly payments at the end of each month for the next 15 years. AIR=5% compounded monthly.
AS= amortization schedule, M=mortgage, AIR = annual interest rate
b. How large must each MP be if the loan is for $350,000? IR stays at 5% and that the loan is paid off over 15 years.
MP=monthly payment, IR = interest rate
c. How large must each payment be if the loan is for $350,000, the interest rate is 5%, and the loan is paid off in equal monthly payments at the end of each month for the next 30 years? This loan is for the same amount as the loan in part b, but the payments are spread out over twice as many periods. Why are these payments not half of the payments on the loan in part (b)?
Solutions
Expert Solution
| 1) | Mortgage Loan | $250,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| No of payments(15*12) | 180 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Monthly Interest Rate | 0.416666667 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| We can use the PMT function in excel to find out the monthly payment for the mortgage loan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| PMT(0.416%,180,250000) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ($1,975.94) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Monthly payment would be $ 1975.94 for 180 months
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
jeff jeffy answered 2 years agoRelated Solutions
a) A loan of $5,000 is to be repaid in equal monthly payments over the next...
a) A loan of $5,000 is to be repaid in equal monthly payments
over the next 2 years.
Determine the payment amount if interest is charged at a nominal
annual rate of
15% compounded semiannually.
b) Net receipts from a continuously producing oil well add up to
$120,000 over 1 year.
What is the present amount of the well if it maintains steady
output until it runs dry in
8 years if r = 10% compounded continuously?
A $10,000 loan is to be repaid in monthly equal payments in 10 years with an...
A $10,000 loan is to be repaid in monthly equal payments in 10
years with an annual effective interest rate of 19.56% charged
against the unpaid balance. What principal remains to be paid after
the third payment?
A loan of €50,000 is being repaid with monthly level payments at the end of each...
A loan of €50,000 is being repaid with monthly level payments at
the end of each year for 6 years at 5% effective rate. Just after
making the payment of the second annuity, it is decided to change
the amortization method, the loan is being repaid with constant
annual principal repayments for the remaining 3 years at an
interest rate of 4.5%.
A) find the outstanding debt just after the payment of the third
annuity
A loan of €50,000 is being repaid with monthly level payments at the end of each...
A loan of €50,000 is being repaid with monthly level payments at
the end of each year for 6 years at 5% effective rate. Just after
making the payment of the second annuity, it is decided to change
the amortization method, the loan is being repaid with constant
annual principal repayments for the remaining 3 years at an
interest rate of 4.5%.
find the outstanding debt just after the payment of the third
annuity
Suppose that a loan is being repaid with 60 equal monthly payments, the first coming a...
Suppose that a loan is being repaid with 60 equal monthly
payments, the first coming a month after the loan is made. If the
rate of interest is 9.7 percent convertible monthly, and the amount
of principal in the 22nd payment is 260, how much interest is in
the 44th payment?
$5,000 are borrowed now with the understanding that it will be repaid in equal monthly payments over 24 months
$5,000 are borrowed now with the understanding that it will be
repaid in equal monthly payments over 24 months, if the interest
rate is 1% per month, for payment number 6 find the amount that is
due to principal? Your answer might be exact or to the closest.a. $833.33b. $194.83c. -540.54d. $40.54
A 50000$ mortgage is to be repaid by means of monthly payments, at the beginning of...
A 50000$ mortgage is to be repaid by means of monthly payments,
at the beginning of each month, for 20 years. If the nominal
interest rate is 12% convertible monthly, (a) Find the monthly
payment (b) Suppose now an extra payment of 1000$ is made at the
end of each year. Determine the monthly payment (This problem needs
to be solved using the concept of annuities)..
A 50000$ mortgage is to be repaid by means of monthly payments, at the beginning of...
A 50000$ mortgage is to be repaid by means of monthly payments,
at the beginning of each month, for 20 years. If the nominal
interest rate is 12% convertible monthly,
(a) Find the monthly payment
(b) Suppose now an extra payment of 1000$ is made at the end of
each year. Determine the monthly payment.
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal
payments at the end of each of the next 4 years so that the ending
balance at the end of year 4 is 0. The interest rate on the loan is
10 percent. The principal repayment in year 3 is:
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal
payments at the end of each of the next 4 years so that the ending
balance at the end of year 4 is 0. The interest rate on the loan is
10 percent. The beginning balance in year 2 is:
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
- Kant says that to act morally is to act out of duty. How does this differ...
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
- List the arithmetic operators used in BASIC and state their priorities of execution in a statement....
- Describe the espoused values of a company you have worked for (or been exposed to -...
ADVERTISEMENT