a. What should SMPC pay if it wants an 11 percent return? b. What is the balance of the original loan after five additional years (10 years from origination)?

Q: Assume that a borrower is expected to prepay a loan at the end of Year 5. Based on the following…

A: The Effective Cost of Borrowing is the true and comprehensive cost associated with obtaining and…

Q: Your existing mortgage with SunTrust is: - Outstanding loan amount: $230,000 • Remaining term: 10…

A: In the case of mortgage refinancing, the payback period is the period of time that is needed to…

Q: Please show reaekson and don't use hend raiting

A: To calculate the periodic payment in month 15 for a constant amortization mortgage (CAM) loan, we…

Q: A computer store sells for  $2,200,000 . The buyer made a  30%  down payment and secured a  20…

A: Borrowings are the liability of the company which is used to finance the requirement of the funds.…

Q: 200,000 30 year mortgage with a contract rate of 8.94%, $3000 closing costs (lawyer, appraisal, and…

A: Loans are paid by equal monthly payments and these are fixed monthly payments and these monthly…

Q: Secondary Mortgage Purchasing Company (SMPC) wants to buy your mortgage from the local savings and…

A: Answers has been calculated in spreadsheet given below, formulas used in sheet has been provided in…

Q: etermine the outstanding principal of the given mortgage. HINT [See Example 7.] (Assume monthly…

A: Loan amount,PV is $100,000The time period is 36 yearsThe interest rate is 4.2% compounded…

Q: Consider a 20-year, $185,000 mortgage with a rate of 6.35 percent. Five years into the mortgage,…

A:

Q: Find the monthly payment (in $) and the total interest (in $) for a mortgage of $46,000 at  5 1/4 %…

A: Monthly payment=4.14Total interest=$42,987.20So, the monthly payment is $4.14 and the total interest…

Q: For Problems 17-24, assume you get a 30-year $90,000 mortgage loan at 7.25% interest. 17. Calculate…

A: Note: : We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero…

A: Mortgage refers to the covered loan borrowed for the purchase or the maintenance of the property…

Q: ou took out a fully amortizing 30 year mortgage with the initial balance of $7036. This mortgage has…

A: The objective of the question is to calculate the remaining balance on a 30-year mortgage after five…

Q: Your local bank has offered you a mortgage of 100,000). The mortgage is to be paid back over 10…

A: The loan amount is $100,000.The loan period is 10 years.The annual rate of interest is 12%.

Q: A 30-year fully amortizing mortgage loan was made 10 years ago for $90,000 at 6 percent interest.…

A: Step 1: Determine the original mortgage paymentFirst, lets calculate the original monthly mortgage…

Q: Please show how to solve this problem using excel and please show the spreadsheet formulas.…

A: Part 2: Explanation:Step 1: Calculate the Monthly Interest RateThe annual interest rate is 7.5%. To…

Q: A 30-year fully amortizing mortgage loan was made 10 years ago for $75,000 at 6 percent interest.…

A: A debt is a source of capital that is borrowed by institutions at a predetermined rate of interest,…

Q: A 30-year fully amortizing mortgage loan was made 10 years ago for $82,000 at 6 percent interest.…

A: Loan amortization refers to the systematic periodic payment of loan and interest amount over a…

Q: 1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization…

A: We are required to calculate an amortization table, therefore, we have to use excel and the excel…

Q: The given mortgage is $100,000, so PV = The 4.3% annual interest rate as a decimal is 0.043, so the…

A: The outstanding principal of a mortgage is the remaining amount of money that is still owed on the…

Q: Use PMT= PA [-] financed with a 30-year fixed-rate mortgage at 8%. Complete parts (a) through (e)…

A: A mortgage is a loan on a property where the collateral is the property itself.

Q: hould the homeowner refinance at the lower rate? Yes No quantify the effect of the homeowner's…

A:

Q: Assume the following information for a home mortgage: Original loan amount = $240,000 %3D Annual…

A: Loan is repaid by paying off fixed amount every period. The periodic payment period can be monthly,…

Q: A 30-year fully amortizing mortgage loan was made 10 years ago for $90,000 at 6 percent interest.…

A: Information provided. Loan amount "PV" = $90000 Annual rate = 6% Number of years = 30 Loan value…

Q: i am sending you this question again iwant formula for this and fully explained by you but not in…

A: Principal amount (P) = $750,000Annual interest rate = 5.70%Total number of payments per year (n) =…

Q: (please correct answer and don't use hend raiting and step by step solutions) Bob got a 30 year…

A: Bob's mortgage has a 30-year term with non-constant payments. For the initial 2 years, he pays…

Q: Which of the following statements regarding a 30-year (360-month) $100,000 fixed-rate mortgage is…

A: Loan value = $100,000Term = 30 yearsrate = Fixed rateIn a fixed-rate mortgage loan, the rate of…

Q: of Us Is More.. E Perfect Paper Instr. sS PowerSchool EReading list >> Question Details You have…

A: The question is related to determination of monthly installment on a loan for a period of 10 years.…

Q: 3. BMO administers a mortgage on someone's house. That mortgage obligates the homeowner to pay…

A: The objective of the question is to find the present value of the mortgage and the interest rate…

Q: A borrower has been analyzing different adjustable rate mortgage (ARM) alternatives for the purchase…

A: Adjustable Rate Mortgage(ARM) An adjustable-rate mortgage (ARM) is a loan for a home whose interest…

Q: a. Find the balance owed after 5 years b. Determine the cost of the loan (interest). c. If an extra…

A: The given problem can be solved using PMT function in excel. PMT function computes installment…

Q: What is the dollar amount of each payment Michael pays?

A: Monthly payments refer to the set sum of money that a borrower must pay back on a loan each month.…

Q: Find the first month of the amortization schedule for a fixed-rate mortgage if 70,000 with an…

A: Loans are paid equal and fixed monthly payments and these payments carry the payment for loans and…

Q: i am sending you this question again iwant formula for this and fully explained by you but not in…

A: Principal amount (P) = $750,000Annual interest rate = 5.70%Total number of payments per year (n) =…

Q: A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0% with zero points or…

A: When the lender lends a loan to the borrower, he charges a rate of interest on the borrowed amount.…

Q: 4. The cost of a home is financed with a $120,000 30-year fixed-rate mortgage at 4.5%. a. Find the…

A: Monthly Payments = L[c(1 + c)^n]/[(1 + c)^n - 1], where L stands for "loan," C stands for "per…

Q: Increasing the down payment on a mortgage reduces both the size of the monthly payments and the…

A: Loan is a financial arrangement in which one party provides a lump sum amount to other party. The…

Q: Assume we have a $500,000 mortgage at a 3.5% original interest rate, 30-year term, and monthly…

A: Loan (mortgage) amortization schedule refers to a schedule which is prepared to show the periodic…

Q: Your monthly mortgage payment (principal plus interest) is $1,500. If you have a 34-year loan with a…

A: Information Provided: Interest rate = 0.25% per month Period of loan = 34 years Monthly payment =…

Q: Calculate using formulas (paste into a word document) the amortization year fixed-rate monthly…

A: Mortgage amortization is the gradual repayment of a mortgage loan over its scheduled term through…

Q: a. Calculate the size of the monthly payments. Round to the nearest cent b. Calculate the principal…

A: a) Calculate the amount of monthly payments as shown below: Resultant table Hence, the amount of…

Q: setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's…

A: For calculation of principal part and interest part, we need to calculate the monthly instalment for…

Q: You would like to borrow $800,000.00 to buy a home. The bank offers you a 30 year fully amortizing…

A: Loan amount = $ 800000Number of years = 30Number of months= n= 30*12 = 360Monthly rate = r = 6%/12 =…

Effective Interest Rate

The term interest rate can be defined as the amount that is charged by the lender as a percentage on the principal amount. Interest rate which is charged annually is known as annual percentage rate.