Your brother's garden supplies business obtained a 30-year amortized mortgage loan for $250,000 at anominal annual rate (APR) of 7.0%, with 360 end-of-month payments. What is his monthly loan payment? What is the balance on his loan at the end of the first month? Please show work in excel

Q: Karen takes an 8-year car loan of $50,000 at 2.14%, compounded monthly. If the payments are done at…

A: Monthly Compounding Loan Amount = 50,000 Time Period of loan = 8 years or 96 months Interest rate =…

Q: Miss Clare Jarrett just closed a loan of $400 000 to assist with the purchase of equipment and…

A: Loan Amount = $400,000 Time Period = 5 Years Interest Rate = 8%

Q: Mae purchased a home for ₱4,570,000 and obtained a 20-year loan with an annual interest rate of…

A: Given Information : Cost of home = 4,570,000 pesos Period of loan = 20 years Annual interest rate =…

Q: Leslie borrowed $25,000 at a rate of 6% compounded monthly (j12) for a term of 10 years. Calculate…

A: The loan is repaid in equal monthly instalments. Each instalment has interest and a portion of the…

Q: An engineer plans to borrow $100,000 to open his own consulting business. He must repay $2,150 a…

A: using financial calculator, N = 5*12 =60 PMT = -2150 PV= 100,000 FV = 0

Q: Justin is financing S169,600 for a home at 5.25% interest with a 25-year fixed-rate loan. Find the…

A: Using excel pmt function

Q: Carter bought a new car and financed $⁢25,000 to make the purchase. He financed the car for 60…

A: Loan amount (PV) = $ 25000 Interest rate = 5.5% Monthly interest rate (r) =…

Q: A man buys a house for $350,000. He makes a $150,000 down payment and amortizes The rest of the…

A: Price of house = $350,000 Down payment = $150,000 Mortgage amount = $350,000 -$150,000 Mortgage…

Q: John Adams borrowed $25,000 at a 10% annual interest rate for a vehicle purchase from First  State…

A: solution given Amount of loan $25,000 Rate of interest 10% Payment Three equal end…

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: Jeffrey Wei received a 6 year non-subsidized student loan of $30,000 at an annual interest rate of…

A: Present Value = $30,000 Interest Rate = 5.9% Time Period= 6 Years Loan Start after 4 Years

Q: A couple purchased a home and signed a mortgage contract for $500, 000 to be paid with half-yearly…

A: Mortgage is a value which is borrowed from the other sources like banks to arrange the funds and…

Q: Matt purchased a car for 22,000 he paid 4400 as a down payment and financed the balance at 3.7%…

A: given, price of car = 22000 downpayment = 4400 r=3.7% m=12 (monthly compounding) n=5 years

Q: Dominic Torreto borrows $300,000 from a lending company in his hometown at 12% interest compounded…

A: Loan Amount = $300,000 Interest rate = 12% Time Period = 6 Months

Q: Tim Houston purchased a wall unit for $2,400. He made a $600 down payment and financed the balance…

A: The yearly rate that borrower pays on loan and investors receives on deposits is the annual…

Q: James received a 15 year loan of $230,000 to purchase a house. The interest rate on the loan was…

A: Working Note #1 Loan amount ($) 230000 N (years) 15 Period 180 Rate(Compounded annually)…

Q: Sergio purchased a house for $440,000; he paid $44000 as a down payment and financed the balance…

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

Q: Allison purchased a house for $350,000. She made a downpayment of 30% of the value of the house and…

A: Given: Particulars Amount Cost of house $350,000 Down payment 30% Interest rate 6.50%…

Q: Juan took out a $20,000 loan for 146 days and was charged simple interest. The total interest he…

A: We need to use simple interest formula to solve this problem Simple interest =Principal*Rate*Time

Q: Marcel Thiessen purchased a home for $205,600 and obtained a 15-year, fixed-rate mortgage at 7%…

A: Interest part is the amount of interest payable on outstanding loan balance and principal repayment…

Q: Peggy made a down payment of $400 toward the purchase of new furniture. To pay the balance of the…

A: Purchase price of the furniture is present value of monthly payments plus down payments

Q: On January 1, 2018, Jimbo Enterprises purchased new equipment for its training center.  The…

A: Following are the calculation of total interest expense will pay over the life of loan:

Q: You have borrowed $130,000 to buy a new motor home. Your loan is to be repaid over 15 years at 8%…

A: Therefore, the principal amount paid in month 2 is $378.19.

Q: Sean Lee purchases $40,000 worth of supplies for his restaurant by making a $3,000 down payment and…

A: The present value is the value of the sum received at time 0. It is the current value of the sum…

Q: Jeffrey received a $32,950 loan from a bank that was charging interest at 5.75% compounded…

A: Amortized Loan:  Amortized loan is a type of loan in which the borrower would pay periodic payments…

Q: A civil engineering student borrowed P40,000 to meet college expenses during his senior year. He…

A: We need to find the future value at the end of 3 years then use pmt function to calculate equated…

Q: Nelson took out a 25-year home loan of $500,000. He made equal month-end repayments at the interest…

A: A loan is a borrowing that is taken by an individual or a corporation from a bank or financial…

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: Doris purchased a Steinway concert piano for $132,000 with a down payment of 25%, and a loan for the…

A: Cost of piano is $132,000 Down payment is 25% Equal Monthly Payment is $1,650 Interest rate…

Q: Matthew has a $32,500 student loan at 4.80% compounded quarterly amortized over 12 years with…

A: monthly interest rate = (1+quarterly rate)^(1/3) -1       = (1+4.80%/4)^(1/3) -1           =…

Q: Stacey purchased a car for $58,300; she paid 5% of the cost as a down payment and finance he balance…

A: The loans are paid equal end of the period payments and these periodic payments carry the payment…

Q: principal balance at the end of the first year, prior to make the lump sum payment? b. By how much…

A: The amortization period refers to the time taken to pay off the full loan amount on the basis of…

Q: An employee obtained a loan of P486,555 at the rate of 20.774% compounded bimonthly to build a…

A: Loan amount is P486,555 Interest rate is 20.774% Compounded bimonthly To Find: Nominal rate…

Q: Carlos purchased a house for $230,000; he paid $11500 as a down payment and financed the balance…

A: Value of House is $230,000 Down Payment is $11,500 Therefore, Loan Amount is : =$230,000-$11,500…

Q: Gabrielle obtained a business loan of $245,000.00 at 4.03% compounded semi-annually, how much should…

A: Loans are paid by the periodic payments that carry the payment for interest and payment for…

Q: xandra received a 30 year loan of $280,000 to purchase a he the loan was 4.60% compounded…

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

Q: Samuel Ng received a 3-year subsidized student loan of $12,000 at an annual interest rate of 5%.…

A: Computation of monthly loan payments:

Q: Morgan received a $29,050 loan from a bank that was charging interest at 3.25% compounded…

A: Loan is the value or an amount which is borrowed from other sources like banks for a finite period…

Q: A couple who borrow $70,000 for 15 years at 8.4%, compounded monthly, must make monthly payments of…

A: formula for remaining balance: remaining balance=princial×1+rmn-pmt×1+rmn-1rm where, r = rate of…

Q: John obtained a loan of $25,000 at 4.6% compounded monthly. How long (rounded up to the next payment…

A: Loan amount = $25,000 Interest rate = 4.6% Monthly payment = $2,810

Q: Jason received a 10-year non-subsidized loan of $40,000 at an annual interest rate of 6%. What are…

A: Loan amount refers to the amount that is borrowed by the borrower for fixed time period at fixed…

Q: Lisa has a $37,500 student loan at 3.15% compounded quarterly amortized over 16 years with payments…

A: Interest refers to the amount charged by the lender on the lent amount. The borrower of the loan is…

Q: An employee obtained a loan of P10,000 at the rate of 6% compounded annually in order to repair a…

A: Loan amount (PV) = P10,000 Interest rate = 6% Monthly interest rate (r) = [1+0.06]1/12 -1…

Q: When Florio and Rhoda bought their home, they borrowed $200,000 for 30 years at 6%, compounded…

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

Q: Quentin Satham borrows $500,000 from a lending company in his hometown at 12% interest compounded…

A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…

Q: A student takes out a loan for $40,000 and loan repayment is to begin after 6 years. Interest during…

A: Here, Loan Amount is $40,000 Interest Rate is 3% Compounding Period is Monthly i.e 12 Repayment of…

Mortgages

A mortgage is a formal agreement in which a bank or other financial institution lends cash at interest in return for assuming the title to the debtor's property, on the condition that the obligation is paid in full.

Mortgage

The term "mortgage" is a type of loan that a borrower takes to maintain his house or any form of assets and he agrees to return the amount in a particular period of time to the lender usually in a series of regular equally monthly, quarterly, or half-yearly payments.