Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Steven decides to buy a house with price of $500,000, Steven puts 20% down payment and considers a 15-year fixed rate mortgage to pay the remaining balance. The lender offers him three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?

Q: Roger has found a home to be purchase for $219,626 and has agreed to pay 30% down. Find the amount…

A: Annuity refers to series of annual payment which are paid or received at start or end of specific…

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: Explain which is the better option.

A: Information Provided: House costs = $100,000 Down payment = $25,000 Option A = 3% APR for 20 years…

Q: You decide to use $10,000 from your combined accounts to pay down your student loan, and use the…

A: A mortgage is a kind of loan that a lender or financial institution offers to people or companies to…

Q: Tim wants to buy a new boat for &9,500. If the store is going to charge Tim 8% annual interest on…

A: in this we have to calculate total interest to be paid and total principal and then monthly payment.

Q: You plan to purchase a house for $166,000 using a 15-year mortgage obtained from your local bank.…

A: Discount points refer to the optional fees (extra charges) over the agreed stated interest rate on a…

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: Stephen has just purchased a home for $162,000. A mortgage company has approved his loan application…

A: Buying a house is a once in a life step. Most of the people buying a house do not have enough cash…

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: Maria and John decide to shop for furnishings for the new house.  They choose items that amount to…

A: Computation:

Q: Answer the following questions  about your possible future home purchase by filling in  all…

A: As the house price is not given. Let us assume the house price is $350,000.

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: A home purchaser need to borrow $500,000 to finance their new home. The buyer believes they will…

A: A borrower can acquire a sort of prepaid interest or fees known as a mortgage point, often referred…

Q: A couple take a 30-year home mortgage of $120,000 at 7.8% compounded monthly. They make their…

A: Hi! Thank you for the question, As per the honor code, we are allowed to answer three sub-parts at a…

Q: What is the cost of two points on the mortgage?

A: Information Provided: Selling Price = $125,000 Downpayment = 20% or $25,000 Loan amount = $100,000…

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: A family has a $95,877, 25-year mortgage at 5.1% compounded monthly (A) Find the monthly payment and…

A: Using the PMT function in excel

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: You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit…

A: A mortgage is a loan borrowed for property purchase which is covered by the property itself. It is…

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: Claire needs to borrow $5000 to pay for NHL season tickets for her family. She can borrow from a…

A: Loans are paid in equal monthly installments that carry the payment for interest and payment for the…

Q: Please show how to solve this using an Excel spreadsheet and please show the formulas. The maturity…

A: Balloon Mortgage Calculations in ExcelHere's how to solve this problem using Excel and the provided…

Q: A couple plans to purchase a house. The bank requires a 20% down payment on the $470,000 house. The…

A: A mortgage refers to funds borrowed for buying an asset. This amount should be repaid by periodic…

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: 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: borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's…

A: The given problem can be solved using PMT function in excel. PMT function computes installment…

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: 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: Chris and Becky are comparing mortgages. The mortgage is for $183,500. If they choose 30 years at…

A: interest = total payback - mortgage value

Loans

A loan is a term that we are all familiar with. The processing of loans is one of the most important functions of a bank. It keeps our economy stable and facilitates the implementation of monetary policies. Let's take a look at the different forms of loans and get some answers to some common questions.