SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage loan is made for $100,000 at 6...

SHOW CLEAR WORK ON EXCEL

A fully amortizing mortgage loan is made for $100,000 at 6 percent interest for 30 years. Determine payments for each of the periods a–d below if interest is accured:

a. Monthly.

b. Quarterly.

c. Annually.

d. Weekly.

Expert Solution

Particulars	rate	nper	PV	FV	Answer
Monthly	0.50000%	360	-100,000	-	$599.55
Quarterly	1.50000%	120	-100,000	-	$1,801.85
Annually	6.00000%	30	-100,000	-	$7,264.89
Weekly	0.11538%	1560	-100,000	-	$138.26

Check the formula below:

Particulars	rate	nper	PV	FV	Answer
Monthly	=6%/12	=30*12	-100000	0	=PMT(6%/12,30*12,-100000,0)
Quarterly	=6%/4	=30*4	-100000	0	=PMT(6%/4,30*4,-100000,0)
Annually	=6%	=30	-100000	0	=PMT(6%,30,-100000,0)
Weekly	=6%/52	=30*52	-100000	0	=PMT(6%/52,30*52,-100000,0)

jeff jeffy answered 2 years ago

SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago...

SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago for $75,000 at 6 percent interest. The borrower would like to prepay the mortgage balance by $10,000. a. Assuminghecanreducehismonthlymortgagepayments,whatisthenewmortgagepayment? b. Assuming the loan maturity is shortened and using the original monthly payments, what is the new loan maturity?

A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will...

A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will be made monthly. Calculate the following: a. Monthly payments b. Interest and principal payments during month 1. c. Total interest and principal payments made over the life of the loan (30 years). d. If the property were sold at the end of year 15, how much is still owed on the mortgage? e. At the end of year 15, how much has been paid...

A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....

A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a. Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b. Interest and principal payments during month 1. c. Total Principal and total interest paid over 30 years. d. The outstanding loan balance...

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing...

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. e. Total monthly interest and principal payments...

PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial...

PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial payments of $500 per month for the first year. The interest rate is 9 percent. After the first year, payments will increase to an amount that makes the loan fully amortizable over the remaining 24 years with constant monthly payments. a. Calculate the interest deductions for the loan for the first year. b. How much, if any, interest must be deferred until the second...

Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan...

Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining?   B. Assume you have taken out a partially amortizing loan for $325,000 that has a term of 7 years, but amortizes over 30 years. Calculate the balloon payment at maturity (Year 7) if the interest rate on...

SHOW CLEAR WORK ON EXCEL A borrower is faced with choosing between two loans. Loan A...

SHOW CLEAR WORK ON EXCEL A borrower is faced with choosing between two loans. Loan A is available for $75,000 at 6 percent interest for 30 years, with 6 points to be included in closing costs. Loan B would be made for the same amount, but for 7 percent interest for 30 years, with 2 points to be included in the closing costs. Both loans will be fully amortizing. a. If the loan is repaid after 20 years, which loan...

A fully amortizing CPM loan is made for $150,000 at 5% interest rate for 20 years...

A fully amortizing CPM loan is made for $150,000 at 5% interest rate for 20 years with monthly repayments. 1. Calculate the monthly debt service. 2. What will be the outstanding loan balance at the end of year 10 and how much total interest will have been paid on the loan by then? 3. If the borrower chooses to reduce the loan balance by $20,000 at the end of year 10, when will the loan be fully repaid if the...

Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and...

Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and has a maturity of 25 years. Payments are monthly. What is the payoff of the loan in 12 years?

Question