A man has 4240,000 home loan for 20 years at a nominal rate of 4.5% convertible monthly. He makes fixed principal repayment of $1000 each month. Find, a. his loan balance after 12 years b. his 100th month payment c. the sum of amount of interest paid in the 5 th year (from 49th month to 60th month).

Q: For how long will Markus have to make payments of $179 at the end of every year to repay a loan of…

A: Loan amount=$2130Annual payment=$179Interest rate=7%Compounding quarterly.

Q: ames has a mortgage of $88,500 at 4% for 15 years. The property taxes are $3,700 per year, and the…

A: The PITI payment includes payments for mortgage, insurance and taxes towards the mortgage.

Q: You borrowed $300,000 for your new house with a 15-year fixed-rate loan at an annual interest rate…

A: A written agreement through which a lender gets the right to take the property that is put as a…

Q: You buy a house for $800,000.  It is a 20 Year mortgage where the payments are made quarterly and at…

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

Q: Mr. and Mrs. Jones have taken out a mortgage loan of $195,000.00 from a bank at 5.5% APR for a fixed…

A: Formula to calculate monthly payments PMT=PV x i x (1+r)n(1+r)n-1 Where, PMT = Monthly payment n =…

Q: semiannual payments over the next 9 years.

A: Amortization is an accounting method that lowers the book value of the loan or intangible asset…

Q: ribes a debt to be amortized. (Round your answers to the nearest cent.) A man buys a house for…

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

Q: Consider a $230,000 home mortgage in which the payment per month is $945.38 for a thirty-year…

A: A Loan refers to the amount of money taken by one party named borrower from the other party named…

Q: If Rochelle obtained a business loan of $205,000.00 at 4.67% compounded semi-annually, how much…

A: Business loan = $205,000.00 Interest Rate = 4.67% compounded semi-annually Time Period = 30 Years

Q: 1. On a fixed-payment loan with 12 years (144 payments) remaining, at an interest rate of 9 percent,…

A: MS-Excel --> Formulas --> Financials --> PV Therefore, the remaining mortgage balance is…

Q: Doreen Short was looking over the repayment schedule for a loan of $37,858 at 7% interest for 5…

A: The remaining balance after making payments for 15 months as the remaining payments will be 45 is…

Q: You have taken a loan of $76,000.00 for 22 years at 5.2% compounded quarterly  1st-3rd month…

A: Payment refers to the periodic payments which are made in lieu of repayment of a loan. Payment…

Q: James borrows $280 000 and repays the loan in equal fortnightly repayments of $1250 over 20 years.…

A: The time value of money is a concept used to compute and analyze the present worth of the future…

Q: Peter just borrowed a $50,000 business loan from the  bank at 5% annual interest. He must repay the…

A: Given, Loan borrowed is $50,000 Interest rate is 5% Term of loan is 5 years.

Q: How much will be owed at the end of 5 years?

A: Time value of money means the amount of received in the present period will have more value than…

Q: Dustin obtained a business loan of $220,000 at 5.21% compounded semi-annually.a. What was the size…

A: Sure, let's tackle these questions step by step.a. To find the size of the semi-annual payments to…

Q: Tom Bond borrowed $6,200 at 6-% for three years compounded annually. What is the compound amount of…

A: Compound amount = Principal(1 + Rate/100)t Interest = Compound amount - Principal

Q: Matt borrowed $23,000 at 5.5% compounded semi-annually. If the loan is to be repaid in equal…

A: Loan is contract between lender and borrower where lender provide funds to borrower that is repaid…

Q: You are purchasing a $79,500 house with monthly payments on a twenty-year note with interest at 6.8%…

A: Amortization Schedule For loans with flat payments, a loan amortisation schedule is a table that…

Q: The owner of the Pink Flamingo Motel borrowed $19 500.00 at 8.11% compounded semi-annually and…

A: Borrowed Loan = $19500Quarterly Payment =$1110Interest Rate = 8.11%Term of periodic payment =…

Q: Mr. Herymann bought a house for Rp. 500 million on credit for 5 years. Bank BNI offers mortgages…

A: Mortgages: When a house is purchased on credit,  the home buyer is required to contribute a certain…

Q: A house’s mortgage is $300,000. It will be repaid over the course of 25 years at 5% interest in…

A:

Q: Theodore D. Kat is applying to his credit union for a mortgage of $200,000. The bank has quoted 8%…

A: Calculating Effective Annual Rate using Excel Effective annual rate functionEAR = 8.30%

Q: Hassan borrows  AED 4,000,000 to be repaid over 15 years at 7 percent. What is the repayment of…

A: There are several functions in Microsoft Excel that can be used to perform time value of money…

Q: The problem describes a debt to be amortized. (Round your answers to the nearest cent.) A man buys…

A: Loans are to be paid by the periodic payments that carry the payment for the principal amount and…