Please use formula in solving.   You are interested in buying a house worth P1,200,000. You paid P250,000 as down payment. In order to pay for the remaining amount, you take out a loan from the bank at a 9% interest rate to be paid for 25 years. a) What is your monthly payment? b) What is the total interest paid for the loaned amount? c) How much of the principal has been paid after 10 years? d) After 15 years, you decide to sell the house. How much should the selling price be to  cover the remaining balance of the payments

Q: You want to buy a $170000 home. You plan to pay $34000 as a down payment, and take out a 20 year…

A: Hi, since you have posted a question with multiple sub-parts, I will answer the first three…

Q: If you borrowed $200,000 to buy a house at 6% interest per year, compounded annually, and paid back…

A: Given information: Loan = $200,000 Number of years = 30 Compound interest rate = 6% compounded…

Q: A. A newly married couple decided to buy a brand-new car. The net amount of loan is Php 500, 000.…

A: Given: Loan amount = Php 500,000 Years = 3 Interest rate = 12%

Q: You want to buy a $260,000 home. You plan to pay $26000 as a down payment, and take out a 30 year…

A: When a person does not have enough money to buy any assets, he would consider taking a loan. The…

Q: You want to buy a house, and a local bank will lend you $100,000. The loan will be fully amortized…

A: Monthly loan payment: It is the amount of money that is given to the lender by the borrower on the…

Q: Suppose you wish to start up your coffee shop.  You need to borrow $50,000 today.  You intend to pay…

A: Using PMT function of the excel to calculate monthly withdrawals

Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and…

A: Given:

Q: You were able to sell a car worth 2,100,000, which would be financed by a bank. You told your buyer…

A: “Since you have posted a question with multiple subparts, we will solve first three subparts for…

Q: You want to buy a $210,000 home. You plan to pay $10500 as a down payment, and take out a 30 year…

A: The loan amount would be the remaining amount after deducting the down payment from the purchase…

Q: Suppose that 10 years ago you bought a home for $170,000, paying 10% as a down payment, and…

A: Computation as follows:

Q: Suppose you borrow 11,000 for 5 years at 6% towards the purchase of a car. What would be the monthly…

A: The computation of monthly payments:Hence, the monthly payment is 212.66.

Q: You invest $ 1.000 in a bank account to buy a house at annual interest rate 14 per year, compounded…

A: Present Value (Investment in bank)= $1,000 Annual Interest rate (r)= 14% per year compounded monthly…

Q: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 5.84% interest. Suppose…

A: 30 years 15 years Purchase of house 425000 425000 Downpayment(25%) 106250 106250 Amount…

Q: What is the total amount paid for principal and interest? (Round your answer to the nearest cent.) $…

A: Information Provided: Price = $475,000 Term = 30 years Interest = 5.54% Down payment = 25%

Q: You are interested in buying a house worth P1,200,000. You paid P250,000 as down payment. In order…

A: Here, Note: As payment period is not given in the question, we are assuming it as yearly payments…

Q: You want to buy a $170000 home. You plan to pay $51000 as a down payment, and take out a 15 year…

A: Given:

Q: In order to buy a car, you borrow $25,000 from a friend at 12%/year compounded monthly for 4 years.…

A: a.

Q: How much money was your existing mortgage loan for? suppose that 10 years ago you bought a home for…

A: Given information: Mortgage bought for $150,000 Down payment is 10% Interest rate is 9% Number of…

Q: How much will you invest every month, so by earning interest at 5% compounded monthly, there will be…

A: Future Value of Annuity: It computes the future value of the current annuity payment compounded over…

Q: the amount of the down payment?

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

Q: you want to buy a $360,000 home. You pay 108,000 as a down payment and take out a 15 year loan at…

A: Outstanding balance is calculated by present value of annual payments left to be paid, so PV formula…

Q: Suppose you invest $190 a month for 6 years into an account earning 8% compounded monthly. After 6…

A: The following formula will be used:

Q: . Suppose you want to purchase a home for $440,000 with a 30-year mortgage at 4.24% interest.…

A:

Q: Solve the following and show your solution. 1. Peter borrowed P100,000 at 8% compounded annually?…

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

Q: Suppose you invest $200 a month for 6 years into an account earning 8% compounded monthly. After 6…

A: Annuity refers to series of equalized payments that are paid or received at start or ending of…

Q: You want to buy a $140000 home. You plan to pay $14000 as a down payment, and take out a 20 year…

A: Hi, since you have posted a question with multiple sub-parts, we will answer the first three (as per…

Q: You need a home loan of $95,000 after your down payment. How much will your monthly house payment be…

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

Q: .  You are purchasing a house for $310,000. You plan to take out a 25-year loan to pay for the…

A: a. The monthly payments will be $1812. Note: The calculation has been made on excel.

Q: If you borrow $25,000 from a local finance company and you are required to pay $4,424.50 per year…

A: Given values: Present value (PV) is $25,000. Annual payments (PMT) are $4,424.50. Maturity period…

Q: Suppose that 10 years ago you bought a home for $160,000, paying 10% as a down payment, and…

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

Q: You decide to buy a house costing $400,000. You pay $100,000 down, and the remainder will be paid in…

A: Loans are a way through which individual finance their big expenditures. These types of loans help…

Q: You want to buy a $330000 home. You plan to pay $33000 as a down payment, and take out a 20 year…

A: given, price =  $330000 downpayment = $33000 principal = $330000 - $33000 = $297,000 n=20 m=12…

Q: Suppose you want to buy a $148,000 home. You found a bank that offers a 30-year loan at 3.5%…

A: Loan Amount = $148,000 Time Period = 30 years Interest Rate = 3.5%   The calculation of the monthly…

Q: You buy a house and finance $250,000 at 4% per year. One loan is 30 years (360 monthly рayments) and…

A: Monthly payments is calculated by present value of annuity formula. r is annual percentage rate and…

Q: Suppose you want to buy a $153,000 home. You found a bank that offers a 30-year loan at 4.5% APR.…

A: Price of Home (PV) is $153,000 APR (r) is 4.5% Time Period (n) is 30 years and 25 years Compounding…

Q: You are buying a $10,000 second hand car with a down-payment of $3,000 and you finance the remaining…

A: Solution:- When a loan is taken, generally equal periodic installments are paid inclusive of…

Q: You took out a loan 10 years ago that had the following terms. Amount $1,200,000, rate 5.5% and 30…

A: Loan Amount = $1,200.000 Interest rate = 5.5% Time Period = 30 Years Refinance Fee = 5% After 10…

Q: Suppose that you wish to buy a new home that will cost you $476,301. You must put $80,000 down, and…

A: Negative amortization is where the principal to be paid increases due to non payment of interest due…

Q: You wish to buy a house. The market value of the house is $650,000 and you have saved $120,000 as a…

A: Interest Rate = 6.5% Time Period = 26 Years Market Value = $650,000 Down Payment = $120,000

Q: You want to buy a $280000 home. You plan to pay $56000 as a down payment, and take out a 15 year…

A: Dear student we need to use excel to solve this problem. The formulas that you need to understand to…

Q: Suppose you want to buy a $141,000 home. You found a bank that offers a 30-year loan at 3.7% APR.…

A: Given Information:Amount is $141,000 Number of years is 30 APR is 3.7%

Q: You decide to borrow $250,000 to build a new home. The bank charges an interest rate of 8%…

A: Monthly payments to be paid on the loan amount are calculated using the interest rate, loan amount…

Q: Goldberg planned to build a P1,500,000-house after 2 years. How much should be deposited in a…

A: Amount To be deposited now is Present value = Future Value/(1 + Interest rate)n Where , Interest…

Q: Suppose you invest $200 a month for 6 years into an account earning 9% compounded monthly. After 6…

A: Time Value of Money states that a dollar is worth more today than anytime in the future because they…

Q: Suppose you loaned P200,000 from a local bank to be paid back uniformly in five years. How much will…

A: The concept of the time value of money states that the current worth of money is more than its value…

Q: You want to buy a $205,000 home. You plan to pay 10% as a down payment, and take out a 30 year loan…

A: Home value = $205,000 Down payment = 0.10 (10%) Monthly interest rate (r) = 0.00345833333333333…

Q: You want to buy a $227,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: Total cost of the home is $227,000. 5% of the amount will be paid as down payment. The monthly…

Q: Suppose you save $4,000 per year at the beginning of each year for 10 years and earn 8.5% interest…

A: Hey, since there are multiple questions posted, we will answer the first question. If you want any…

Q: A man wants to buy a $33,000 car.  He will put 20 % down and finance the rest over 5 years.  How…

A: Given information: Purchase price = $33,000 Loan = $33,000 -20%×$33,000 = $26,400 Term = 5 years…