Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Thomas decides to buy a house with price of $450,000. Thomas puts 20% down payment and considers a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Thomas two choices of the mortgage with monthly payments shown in the table as choice 1 and choice 2, assume that the origination cost is $6,000. A. If you hold the loan for 30 years, what is the effective cost for each choice? B. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (i.e. the borrow will pay off the loan at the end of 60 months)?

Q: Use the following to solve questions a. and b. with excel  A house with price of $250,000 20% down…

A: To solve these questions, we would typically use Excel's financial functions to calculate the total…

Q: Frank and Fatima decide they will buy a two-bedroom garden-suite, with a 5750,000 mortgage from…

A: Principal (p)= $750,000 Rate (r)= 2.7% Time (t)= 5 years

Q: Melissa wants to buy a townhouse that costs $71,000. The bank requires a 5% down payment. The rest…

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

Q: You are planning to purchase a house that will require a mortgage of $400,000.  You find 2 mortgage…

A: Company needs to take loan for the financing of its assets. The loan could be taken in several…

Q: (b) What is the total amount of interest EACH loan? Show your work. (c) Overall, how much more…

A: we have to find out monthly payment under each option and calculate interest under each option.

Q: process of utilizing excel to finance properties. Consider the following. A realator has a house on…

A: In this we have to calculate the present value FACTOR monthly payment using EXCEL functions.

Q: Dan is considering borrowing $489,000 to purchase a new condo. Based on that information, answer the…

A: The question is based on the concept of the mortgage loan. A mortgage loan is a secured loan, which…

Q: Use the following to solve questions a. and b. and please buid an excel spreadsheet and please show…

A: Both choices result in the same monthly payment.The total cost over 5 years would be the same, as…

Q: Maria and John have been renting a small apartment but decide to purchase a house. The one they have…

A: using excel PMT function

Q: suppose that you decide to borrow $15,000 for a new car. you can select one of the following loans,…

A: a.Loan ALoan Amount (pv) = $15,000Interest Rate (rate) = 5.9%Time Period = 3 YearsNumber of Payments…

Q: Mia Sato purchased a new condominium for $225,000.  The bank required a $40,000 down payment.…

A: We need to use mortgage amortization formula below to calculate monthly payment of mortgage.PMT…

Q: Please provide working to the solution for the question below: Anna and Bob have decided to buy an…

A: Solution:- When an amount is borrowed, it can either be repaid as lump sum payment or in…

Q: Use the following to solve questions a. and b. with an excel spreadsheet and please show the…

A: Solving for Mortgage Payments with Excel FormulasHere's how you can solve this problem using an…

Q: Option Rex and Bonnie are wanting to buy a new entertainment couch with a sales price of $20,000 for…

A: For Option 1, we are given that the interest is computed using the simple interest method. The…

Q: do you use APR and EAR in finance calculations? I have a question here and unsure how to solve it. I…

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

Q: Maya Womak wishes to purchase a(n) $645,000 house. She has accumulated a $125,000 down payment, but…

A: Working  Note #1 Computation of loan amount::::: Cost of house                 = $645,000 Less: Down…

Q: Mia Sato purchased a new condominium for $225,000.  The bank required a $40,000 down payment.…

A: The first step is to determine the amount of the loan. This is done by subtracting the down payment…

Q: You want to purchase a house and are reviewing variations in how to structure the mortgage. One of…

A: Note: Replace "PMT" in the formulas with the actual PMT() calculations from Excel.Once these…

Q: Maria and John decide to shop for furnishings for the new house.  They choose items that amount to…

A: Formula for simple interest  Future value =Principal + interest rate x number of years

Q: The McDaniel family is purchasing a home, and their mortgage. The home costs $156,000 and they have…

A: First we need to use loanbsp;loan amotorization formula below to calculate monthly payment.  where…

Q: You have been shopping for a new home. You have the choice of financing for your $300,000. You can…

A: Principle amount is $300,000 We have two Choices:- 1st Choice:- Rate of interest is 4.5% Loan…

Q: Maria and John have been renting a small apartment but decide to purchase a house. The one they have…

A: Given information: Selling price: $300,000 Down payment : 20% Annual interest rate: 3.125% Time…

Q: Use the following to solve questions a. and b. with an excel spreadsheet  A house with price of…

A: See the answer in the explanation field.Explanation:Answer information:Step 1:Provided:It is assumed…

Q: You are planning to purchase a house that will require a mortgage of $400,000.  You find 2 mortgage…

A: The company is considering the value of mortgage for the purpose of financing the assets of the…

Q: 14. A couple has decided to purchase in beach condominium as an investment property. The condo has a…

A: Data given: Purchase price= $360,000 Down payment=20% APR=3.6% (with monthly compounding) N=30 years…

Q: You found your dream house. It will cost you $300000 and you will put down $40000 as a down payment.…

A: Houses are a large ticket item. We do not have the cash to buy a house outright on a cash basis.…

Q: Josh and Samantha have been renting a small apartment and have now decided that they are ready to…

A:

Q: Joe Levi bought a home in Arlington, Texas, for $125,000. He put down 30% and obtained a mortgage…

A: Mortgage is a loam which allows a person to get funds for their home purchase and make a small…

Q: Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend…

A: Loan amount Interest rate Years of Loan   $6,10,000.00 7.4% 20           Answer (a)  Monthly…

Q: A family wants to buy an apartment in a building that is being built on Calzada de Tlalpan # 910,…

A: a) Calculation of the Down PaymentThe down payment is calculated as 20% of the total price of the…

Q: John wants to buy a property for $127,500 and wants an 80 percent loan for $102,000. A lender…

A: The mortgage loans are the secured loans and these loans are paid by the monthly payments that carry…

Q: Option Rex and Bonnie are wanting to buy a new entertainment couch with a sales price of $20,000 for…

A: For Option 1, we use the simple interest formula I = P * R * T, where P is the principal amount, R…

Q: ladyn is looking to purchase a home for $182,000 and will make a $40,000 down payment in order to…

A: Mortgage loans are paid by easy monthly payments that carry the payment for interest and payment for…

Q: Option Rex and Bonnie are wanting to buy a new entertainment couch with a sales price of $20,000 for…

A: For Option 1, we are given that the interest is computed using the simple interest method. The…

Q: Please show how to solve this using excel and please show all formulas in the spreadsheet please!!…

A: The EFFECT function in the excel sheet can be used to compute Effective interest rates, which…

Q: An investor plans to purchase a 2-bedroom condo in San Francisco. The price of the property is…

A: A loan is taken after giving the down payment. Mortgage payment on the loan amount will be received…

Q: You purchase a home costing $480,000 with a 20% down payment. After shopping around for a mortgage,…

A: Thus, Monthly Payment in option 1 is $1583.32 and in Option 2 is $1586.07