Several years ago you got a mortgage loan at 8.75% interest. You currently owe $138,743.03 with a monthly payment of $1108.05. How long until the loan will be paid off?   Please make sure to show the formula for this question for better understanding. The answer in the back of the book is 268 months

Q: Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments…

A: Loan pay-off: It means paying the remaining loan balance in just one payment.

Q: Suppose on January 1 you deposit $1000 in an account that pays a nominal, or quoted, interest rate…

A: Future value is the value of an asset that grows after a specific period of time. The future value…

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: 1)You have taken out a loan of 3,000,000 to buy an apartment. The loan is an annuity loan of 30…

A: The loan is a facility provided by financial institution to buy an asset and repay it in future in…

Q: If I loaned 163,085 today and promised to pay it back after 5 years to the bank with monthly…

A: Loan amount (P) = 163,085 Annual interest rate = 0.11 Monthly interest rate (r) = 0.11/12 =…

Q: Your friend has just arranged to purchase a $400,000 home with no down payment. The mortgage has a…

A: Value of home =$400,000 Interest Rate (r) = 3.5%/12 = 0.291667% Years = 30 Terms(n) = 30*12=360 Let…

Q: Assume you graduate from college with $30,000 in student loans. If your interest rate is fixed at…

A: The monthly payment amount can be calculated with the help of present value of annuity function

Q: You borrow $5,000 at 10% per year and will pay off the loan in 3 equal annual payments starting 1…

A: Principal = 5000 r = 10% period = 3 years after 1 year of taking loan payments = 2010.57 This annual…

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: You entered into a mortgage agreement to borrow $100,000 at an interest rate of 3% and to be…

A: Given: Amount borrowed =$100000Interest rate =3%Term of loan  =30 years

Q: Suppose you borrowed Php 30,000 on a student loan at a rate of 8% and must repay it in three (3)…

A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: Your car loan requires payments of $1,000 per month over the next18 months and payments of $2,000…

A: The concept of time value of money will be used here. As per the concept of time value of money the…

Q: You needed $10,000 and obtained the following loan: Loan specifics: You are expected to pay 24 equal…

A:

Q: A borrower obtains a partially amortizing constant payment mortgage loan for $75,000 at 24 percent…

A: Balloon Payment  Under Balloon payment a large amount of sum is to be paid at the end of loan term…

Q: Consider the following loan: a 60-month, $45,000 car loan with a 12% APR, compounded monthly. Assume…

A: The principal amount is the amount of loan that you owe, whereas the interest amount is what the…

Q: Suppose that you borrow $10,000 from a bank to purchase a car. You agree with the bank to repay the…

A: Given: Particulars Amount Loan $10,000 Interest rate 16% Years 1

Q: If you went to the bank for a 35 year, $180,000 mortgage at an interest rate of 7% compounding…

A: A borrower is required to pay the lender the interest and the original amount by paying regular…

Q: The going annual interest rate for a loan with a term of 30 years is 6% compounded monthly. The…

A: Going interest rate is the interest rate that is prevailing in the market for loans or bonds. It is…

Q: Six years ago, you borrowed $200,000 for a ten-year period from BOB Bank at a stated interest rate…

A: The PMT function or concept can be used to determine the periodic payments required to accumulate a…

Q: You have just taken out a $16,000 car loan with a 8% APR, compounded monthly. The loan is for five…

A: Payment per period can be calculated using PMT function in excel.   PMT(rate, nper, pv, [fv],…

Q: You have just deposited $9,500 into an account that promises to pay you an annual interest rate of…

A: GOAL (FV) 27940 INTEREST RATE 6.20% YEARS 8+12=20 PMT 0 PV 9500

Q: Assume you have secured a loan of $10,000 from a bank which will be paid in one year. The fin bank…

A: Loan: The duration of a loan, or the amount of time it takes for a loan to be repaid in full when…

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: Charmaine has just purchased an apartment at a price of $10 million. She made a down- payment of $4…

A: Loan amount (L) = $6 million n = 15 years = 180 months r = 3% per annum = 0.25% per month Let M =…

Q: A building is sold for ₱10,000,000 and the bank requires 18% down payment. If the effective rate of…

A: Down payment = 18% Mortgage payment = 100% - 18% = 82% Mortgage amount (M) = 82% of P 10,000,000 = P…

Q: you are taking a $100,000 mortgage loan for your business to be repaid over 5 years in equal…

A: Mortgage loan is the loan which is given by keeping something as collateral. This loan is for…

Q: If you borrow $500,000 to buy a house today, what is the amount of your monthly mortgage payment…

A: Journal entry: It is the duty of the accountant to record business economic and non-economic…

Q: Use excel plz and show working You entered into a mortgage agreement to borrow $100,000 at an…

A: Information: a) The annual payments can be computed using PMT function in excel. b) The Principal…

Q: Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at…

A: Amortization Schedule is the schedule or table representing the loan repayment schedule. It includes…

Q: A personal loan for $20,000 has an interest rate of 12% over 5 years with monthly payments. What is…

A: Equated Monthly Instalment(EMI) means a part of the equally divided monthly amount paid for the…

Q: Excellent bank has offered you $40,000, 30-year loan to purchase an equipment in your Factory. The…

A: A = P1+r100n Where  A = Amount P = Principal r = Rate of interest n = Number of periods

Q: You are to pay a bill in Meralco every month for 5 years. The accumulated amount of the payment you…

A: If someone paid an equal amount in the difference of equal interval then it is classified as the…

Q: After making the twenty-sixth payment on your car loan, you wanted to find out how much is left of…

A: Loan amount (PV) = $27000 Interest rate = 7.1% Monthly interest rate (r) = 7.1%/12 =…

Q: You have just taken out a $25.000 car loan with a 4% APR, compounded monthly. The loan is for five…

A: A monthly mortgage payment is a monthly payment that is to be paid for a specific period of time to…

Q: You are getting a mortgage. Your home is worth $237,324, and you will make a $63,651 down payment.…

A: Cost of home= $ 237324 Down payment done= $ 63651 Loan= $ 237324- $ 63651 =$ 173673

Q: The Clarks are arranging a $90,000 mortgage loan from their bank. The mortgage is to be amortized by…

A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…

Q: You borrow $280,000 to buy a house. The mortgage rate is 4.5% and the loan period is 25 years.…

A: The series of payments discussed here is a form of annuity wherein an equal amount is paid every…

Q: You entered into a mortgage agreement to borrow $100,000 at an interest rate of 3% and to be…

A: Given: Amount borrowed=$100000Interest rate =3%Term of loan in year=30

Q: If you buy a computer directly from the manufacturer for $2,241 and agree to repay it in 48equal…

A: Using Excel PMT function.

Q: You have just purchased a car and taken out a $48,000 loan. The loan has a five-year term with…

A: In Installment payment system, loan in not paid collectively with interest due but interest and…

Q: what is the total amount of the loan?

A: The total amount of loan can be calculated using the present value formula. The present value of…

Q: A certain college graduate borrows 7406 dollars to buy a car. The lender charges interest at an…

A: Continuously compounded interest rate refers to the interest rate that is calculated on the…

Q: You will be paying off a mortgage of $250,000 over the next 25 years. You have signed a loan…

A: A loan amortization table is a schedule of payments to pay back the loan in installments. It…