Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years (180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?

Q: Suppose that you decide to buy a car for $26,635, including taxes and license fees. You saved $7000…

A: Car Value = $ 26,635Down payment =$ 7000Loan Amount = Car Value - Down paymentLoan Amount = $ 26,635…

Q: Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan…

A: PV = $20,000r = 7% / 2 = 0.07 / 2 = 0.035 (semiannual interest rate)n = 5 years * 2 = 10 payments

Q: Suppose you take out a home mortgage for $160,000 at a monthly interest rate of 0.6%. If you make…

A: Loans are defined as a type of credit vehicle through which a sum of money is lent to some other…

Q: .You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can…

A: The excel formula to calculate the monthly payment is - Monthly payment = PMT (Interest…

Q: Suppose you take out a 25-year $100,000 mortgage with an APR of 6%. You make payments for 3 years…

A: When a loan's conditions, including its interest rate, payment schedule, or other terms, are…

Q: The price of a home is $600,000. The bank requires a 20% down payment. The cost of the home is…

A: compound = monthly = 12 Price of home = $600,000 Down payment = 20% Time = t = 30 * 12 = 360…

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: Suppose you take out a 25-year $100,000 mortgage with an APR of 6%. You make payments for 3 years…

A: As per our guidelines, we are supposed to answer only 3 sub-parts (if there are multiple sub-parts…

Q: Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can…

A: In this scenario, we utilized Excel formulas to calculate the amount of discount points charged on a…

Q: Suppose that you want to avoid paying interest and decide you'll only buy the furniture when you…

A: Annuity refers to the contract that is made between the insurer and the insurance company for making…

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

A: Loan is amount borrowed by some investor or company from the stock market or taken by individual…

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

A: Closing cost is the cost which has to be paid by either seller or the buyer to the government when…

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: Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can…

A: A mortgage is the amount borrowed from lending institutions at a prevalent interest rate, it…

Q: Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the…

A: Excel Spreadsheet to Solve Loan Questionsa. Loan AmountInput the house price in cell A1:…

Q: P LIC Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of…

A: A mortgage is a type of loan that is linked to real estate. It is a form of a secured loan on the…

Q: rate

A: Introduction: Simple interest can be defined as interest which is computed from the principal loan…

Q: You have a chance to buy an annuity that pays $50,000 at the beginning of each year for 15 years.…

A: Present value means today’s value of money you expect to receive or pay in future.   PV = PMT…

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: After doing a complex amortization calculation to find the payment, we often will calculate how much…

A: Monthly payment I = $312Period = 5 yearsMonthly payment II = $837Period = 30 yearsTo find: Total…

Q: two choices. Choice 1: 30-year fixed rate at 6 % with closing costs of $1800 and no points. Choice…

A: Housing loans are refer as the amount of money borrowed from financial institution or bank to…

Q: You want to buy a $230,500 home. You plan to pay 20% as a down payment, and take ou 5% for the rest.…

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

Q: Imagine you borrow $600 from your roommate, agreeing to pay her back $600 plus 7 percent nominal…

A: Fisher Equation defines the relationship between the real rate of interest and the nominal rate of…

Q: Prepare an amortization schedule for a five-year loan of $67,500. The interest rate is 7 percent per…

A: The process of extending out the repayment of a loan over a period of time is referred to as…

Q: please answer all subsets, I am trying to get an idea of how to do these types of proplems so I can…

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

Q: ou want to borrow $27,000 from your local bank to buy a new car. you can afford to make monthly…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: Suppose your gross monthly income is $5,200 and your current monthly payments are $425. If the bank…

A:

Q: 1. Nelson wants to buy a car that costs $42,000. He has arranged to borrow the total purchase price…

A: Using the PMT function in excel

Q: Suppose that you and your friend both need to borrow the same amount of money. You borrow money…

A: In compounding there is interest on interest also including the principal amount and due to which…

Q: Suppose you are in charge of annuities for a life insurance company. A customer comes in and wants…

A: Annuity amount =1,000,000 Lets assume Remaining Life =55 years Life in months =660 Interest rate 7%…

Q: Suppose you want to borrow $90,000 and you find a bank offering a 20-year term for a loan of that…

A: Compound = Monthly = 12Present Value = pv = $90,000Time = t = 20 * 12 = 240Interest rate = r = 7 /…

Q: Suppose you have the following three student loans: $11,000 with an APR of 8.5% for 12 years,…

A: Here,First LoanSecond LoanThird LoanLoan Amount $  11,000.00 $  17,000.00 $…

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

A: Compound = n = Monthly = 12Present Value = pv = $25,000Time = t = 5 * 12 = 60Interest Rate = r = 9 /…