Question
In: Finance
You took out a fully amortizing 30 year mortgage with the initial balance of $199,755. This...
You took out a fully amortizing 30 year mortgage with the initial balance of $199,755. This mortgage has a fixed interest rate at 4%. After you completed two full years of monthly payments, how much have you paid toward principal? Round your answer to the nearest cent (e.g. if your answer is $7000.9873, enter 7000.99).
Solutions
Expert Solution
Ans $ 7178.84
| P = | Regular Payments | |||
| PV = | Loan Amount | |||
| r = | rate of interest | |||
| n = | no of periods | |||
| P = | r (PV) | |||
| 1 - (1 + r )^-n | ||||
| P = | (4%/12)*199755 | |||
| 1 - (1 / (1 + 4%/12)^360)) | ||||
| P = | 665.85 | |||
| 0.698204135 | ||||
| P = | 953.66 | |||
| Beginning Balance | Interest | Principal | Ending Balance | |
| 1 | 1,99,755.00 | 665.85 | 287.81 | 199467.19 |
| 2 | 1,99,467.19 | 664.89 | 288.77 | 1,99,178.42 |
| 3 | 1,99,178.42 | 663.93 | 289.73 | 1,98,888.69 |
| 4 | 1,98,888.69 | 662.96 | 290.7 | 1,98,597.99 |
| 5 | 1,98,597.99 | 661.99 | 291.67 | 1,98,306.32 |
| 6 | 1,98,306.32 | 661.02 | 292.64 | 1,98,013.68 |
| 7 | 1,98,013.68 | 660.05 | 293.62 | 1,97,720.06 |
| 8 | 1,97,720.06 | 659.07 | 294.59 | 1,97,425.47 |
| 9 | 1,97,425.47 | 658.08 | 295.58 | 1,97,129.89 |
| 10 | $1,97,129.89 | $657.10 | $296.56 | $1,96,833.33 |
| 11 | $1,96,833.33 | $656.11 | $297.55 | $1,96,535.78 |
| 12 | $1,96,535.78 | $655.12 | $298.54 | $1,96,237.24 |
| 13 | $1,96,237.24 | $654.12 | $299.54 | $1,95,937.70 |
| 14 | $1,95,937.70 | $653.13 | $300.54 | $1,95,637.17 |
| 15 | $1,95,637.17 | $652.12 | $301.54 | $1,95,335.63 |
| 16 | $1,95,335.63 | $651.12 | $302.54 | $1,95,033.09 |
| 17 | $1,95,033.09 | $650.11 | $303.55 | $1,94,729.54 |
| 18 | $1,94,729.54 | $649.10 | $304.56 | $1,94,424.98 |
| 19 | $1,94,424.98 | $648.08 | $305.58 | $1,94,119.40 |
| 20 | $1,94,119.40 | $647.06 | $306.60 | $1,93,812.80 |
| 21 | $1,93,812.80 | $646.04 | $307.62 | $1,93,505.19 |
| 22 | $1,93,505.19 | $645.02 | $308.64 | $1,93,196.54 |
| 23 | $1,93,196.54 | $643.99 | $309.67 | $1,92,886.87 |
| 24 | $1,92,886.87 | $642.96 | $310.70 | $1,92,576.16 |
| TOTAL | 15709.02 | 7178.84 |
jeff jeffy answered 1 year agoRelated Solutions
You took out a fully amortizing 30 year mortgage with the initial balance of $571,179. This...
You took out a fully amortizing 30 year mortgage with the
initial balance of $571,179. This mortgage has a fixed interest
rate at 5%. After you completed two full years of monthly payments,
how much have you paid toward principal? Round your answer to the
nearest cent (e.g. if your answer is $7000.9873, enter
7000.99).
When you purchased your home, you took out a fully amortizing mortgage for $250,000 with a...
When you purchased your home, you took out a fully amortizing
mortgage for $250,000 with a 6.5% rate for a 30-year term. After 10
years, you have a chance to refinance for the remaining 20 years
with a rate of 4.5%, fully amortizing over the remaining 20 years;
however, you have to pay $4,500 up front for the new loan. Based on
the fee and how much you will be saving per month, what is the
effective annualized return (RATE...
You qualify for an $800,000 fully amortizing 30-year fixed rate mortgage with monthly payments. If the...
You qualify for an $800,000 fully amortizing 30-year fixed rate
mortgage with monthly payments. If the annual interest rate is
3.63%, compounded monthly, what will the monthly mortgage payment
be?
Two years ago you took out a mortgage at 4.5%. The initial balance of the loan...
Two years ago you took out a mortgage at 4.5%. The initial
balance of the loan was $200,000 and it was for 25 years (300
months.) Today, you observe that you could take out a new loan at
4.25% (with a 300 month term), but you would have to pay $5,000 in
closing and other fees.
What is the current value of the loan (liability from your
perspective)?
*Note: The answer is $195,579.52. I want to know how to get...
A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%....
A borrower is offered a 30 year, fully amortizing ARM with an
initial rate of 3.2%. After the first year, the interest rate will
adjust each year, using 1 yr LIBOR as the index, plus a margin of
175bp. The price of the property is $8,000,000 and the loan will
have an initial LTV ratio of 75% At the first reset date, 1 year
LIBOR is at 3%. What is the borrower’s payment during the 2nd year
of the loan?
A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%....
A borrower is offered a 30 year, fully amortizing ARM with an
initial rate of 3.35%. After the first year, the interest rate will
adjust each year, using 1 yr LIBOR as the index, plus a margin of
175bp. The price of the property is $8,000,000 and the loan will
have an initial LTV ratio of 75% At the first reset date, 1 year
LIBOR is at 3%. What is the borrower s payment during the 2nd year
of the...
A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%....
A borrower is offered a 30 year, fully amortizing ARM with an
initial rate of 3.35%. After the first year, the interest rate will
adjust each year, using 1 yr LIBOR as the index, plus a margin of
175bp. The price of the property is $8,000,000 and the loan will
have an initial LTV ratio of 75% At the first reset date, 1 year
LIBOR is at 3%. What is the borrower s payment during the 2nd year
of the...
A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%....
A borrower is offered a 30 year, fully amortizing ARM with an
initial rate of 3.35%. After the first year, the interest rate will
adjust each year, using 1 yr LIBOR as the index, plus a margin of
175bp. The price of the property is $8,000,000 and the loan will
have an initial LTV ratio of 75% At the first reset date, 1 year
LIBOR is at 3%. What is the borrower s payment during the 2nd year
of the...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate
Mortgage with monthly payments for $4,500,000.
Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5
points upfront.
Mortgage B has a 6% interest rate and requires Ann to pay zero
fees upfront.
Assuming Ann makes payments for 2 years before she sells the
house and pays the bank the
the
bank the balance, which mortgage has the lowest cost of borrowing
(lowest annualized IRR)
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate
Mortgage with monthly payments for $4,500,000.
Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5
points upfront.
Mortgage B has a 6% interest rate and requires Ann to pay zero
fees upfront.
Assuming Ann makes payments for 2 years before she sells the
house and pays the bank the balance, which mortgage has the lowest
cost of borrowing (ie lowest annualized IRR)? Type 1 for...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Allocation: Fixed and Variable Costs, Budgeted Fixed and Variable Costs Biotechtron, Inc., has two research laboratories...
- Do you think that there is still institutionalized racial discrimination in the United States today and...
- Computer Security Consider a desktop publishing system used to produce documents for various organizations. a. Give...
- Review the discussion question and answer below. Do you agree with the answer? why or why...
- For the assignment you have to do two thing Passing arguments when running the jar or...
- Explain how biology, culture, and their interaction shape sex differences.
- Write a program that computes the tax and tip on a restaurant bill for a patron...
ADVERTISEMENT