Gisella borrows $120, 000 from Capital Mortgage Co. at 9% per annum interest, monthly payments for 30 years. At the end of 6 years, she sells the house and will pay off the loan at the closing of sale (assume that the sale takes place at the end of the sixth year). What will her loan payoff be? Using excel functions only and an amortization schedule.

Q: Karen obtained a $20,000 loan at 4% compounded semiannually. a-1. What monthly payment will repay…

A: Monthly payment refers to an amount that is paid every month for the repayment of a loan amount…

Q: Luke borrows $200 000 from a bank to set up a medical practice. He agrees to pay a fixed interest…

A: Given: Loans = $200,000 Interest rate = 18.48% years = 10years

Q: ubsequent payment will be $25 less than the pr ts during years 1 and 2, however, she is unable he…

A: Calculate the value of the decreasing payments:The first payment is denoted as P, and each…

Q: arles secured a 5-year car lease at 6.50% compounded annually that required her to make payments of…

A: Cars are purchased by the monthly payments and this makes easy for the customers to buy the car and…

Q: Lillian took out a 20-year loan for $170,000 at 8.8% interest, compounded monthly. If her monthly…

A: A loan is a financial arrangement in which one person borrows funds from another person at a…

Q: Katrina has the option of an 8-year nonsubsidized student loan of $29,000 at an annual interest rate…

A: A subsidized loan refers to a loan (usually provided to students) where the loan does not accumulate…

Q: e borrows $200 000 from a bank to set up a medical practice. He agrees to pay a fixed interest rate…

A: Loans are paid by equal monthly payments that carry interest and loan payments.Given:Loans =…

Q: Remy obtains a 30-year mortgage in the amount of $625,000 for a co-op. She secures a 7/1 ARM at an…

A: ARM is a type of variable interest loan, where the interest amount changes after the initial period.…

Q: Nick received a loan of $5000 from a bank to purchase a bike. He obtained the loan at an interest…

A: Amortization Schedule: The amortization schedule represents a table consisting of periodic loan…

Q: o acquires a loan of $300,000 to be paid off during 6 years with monthly payments. If the…

A: Monthly payments are equal fixed amount of payment that carry the payment for interest and loan but…

Q: Anna has a mortgage of $427,000 through her bank for property purchased. The loan is repaid by end…

A: A mortgage refers to a covered loan that is used to purchase a property with the property itself…

Q: Flo East has $25,000 to invest in a financial institution for a period of three years. Institution A…

A: Explanation : When we are calculating the Compounded Interest calculation Monthly Compounding…

Q: Olivia plans to secure a 5-year balloon mortgage of $210,000 toward the purchase of a condominium.…

A: Olivia secures a balloon payment mortgage for a condominium of $210,000. The loan was amortized for…

Q: Margo borrows $400, agreeing to pay it back with 8% annual interest after 17 months. How much…

A: We need to use simple interest formula to calculate interest to be paid by Margo. Interest =…

Q: Megan invests $1, 500 at the end of each year into an account earning 2% effective annual interest.…

A: Part 1:  Future value of the annuity in the first accountYear Amount Deposited0 $1,5001 $1,5002…

Q: What is the interest paid in the 2nd year of the mortgage?

A: Mortgage refers to a legal contract based upon which a financial institution such as bank grants a…

Q: Click here to access the TVM Factor Table calculator. Interest = $ Principal = $

A: Loans are paid by monthly payments that are fixed and carry payment for interest and payment for…

Q: Anushka and Benicio borrowed $47,000 at 7% compounded semi-annually as a second mortgage loan…

A: Loan amortization involves paying off a debt over time in equal installments. Part of each payment…

Q: Jenny and Leo plan to purchase a new house and the couple is able to obtain a 25-year 3.6% (per…

A: The concept of time value of money will be applied here.   The cost of the house will be the sum of…

Q: Erin has a mortgage of $640,000 through the Tangerine Bank for a vac The mortgage is repaid by end…

A: Loan are paid by equal monthly payments that carry the payment for interest and payment for loan…

Q: Karen obtained a $25.000 loan at 4.5% compounded semiannually. a-1. What monthly payment will repay…

A: The monthly amount will be found using excel’s PMT function. It is the minimum amount that must be…

Q: bought a vacation property for $18 900.00 down and sem nnual period for eight years. Interest is…

A: Price of property can be found from down payment and mortgage amount taken.

Q: Victoria buys a property for $2,500,000 by paying $500,000 down payment and the rest on a 15-year…

A: The amount taken on credit or financed by the person is ascertained by deducting the down-payment…

Q: Kenneth is expected to receive an inheritance of about $250,000 from his grandmother's estate in a…

A: A borrower pays to the lender the interest and original sum borrowed in the form of regular…

Q: Margo borrows $600, agreeing to pay it back with 7% annual interest after 15 months. How much…

A: When a loan is repaid then the repayment amount included both the principal amount borrowed and the…

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.