Please solve using Excel and show formulas. You have decided to buy a car with price tag of $60,000 but you are able to negotiate the price down to $58,000.  You have $5,000 saved, so you need to borrow $53,000 in a 5-year loan from your bank (your bank offers lower rates than the auto-dealer) at a 4.5% APR (annual rate). How much will you owe to the bank after 3 years?

Q: Suppose you are planning to buy a car and just found one that is selling for $5,700. You have $1,000…

A: Equated monthly payment is a fixed payment given by the borrower of the loan to the lender on a…

Q: You are selling your car and the dealership says to you, "we can either give you $15,000 today or we…

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

Q: Suppose that LilyMac Photography expects EBIT to be approximately $210,000 per year for the…

A: Given that Lily Mac photography  has 1000, 10 year ,9% annual coupon bond outstanding.Multiplying…

Q: a) You first go to a used car lot. You find a used Corolla for $6000. The dealer offers you a loan…

A: Equated monthly installments (EMI) is the equally divided installments of the loan outstanding…

Q: You purchase a basic package, 4-door sedan for your company's fleet for $18,000. The 3 year loan has…

A: Assumption: It is assumed the given situation is in monthly compounding. The question gives the…

Q: Please show all equations and work as needed. Make the correct answer clear. If possible, please…

A: The computation of net amount is as follows:Hence, the net amount of funds from the loan is $511560.…

Q: Your parents are buying a house for $187,500. They have a good credit rating, are making a 20% down…

A:

Q: You are looking to buy a car and can afford to pay $210 per month. If the interest rate on a car…

A: Loan amount refers to an amount that is being borrowed by the borrower from the lender at a…

Q: Suppose you can afford to pay $ 250 a month for 8 years towards a new car with no down payment. If…

A: Given details are : Monthly payment = $250 Time period = 8 years Interest rate = 4.75% We need to…

Q: Someone offers an investment opportunity that will pay you $725 at the end o next 17 years. How much…

A: Maximum value is the present value of cash flow from the annuity based on the time value of money…

Q: Someone offers to buy your car for four, equal annual payments, beginning 2 years from today. If you…

A: Present value of car = $9,000Interest rate = 10%Number of annual payments = 4To find: Minimum annual…

Q: You see that First National Bank is willing to make you a four-year $40,000 car loan with an…

A: Variables in the question:Interest charged on car loan =4.2%Interest charged on credit card=16.5%

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: You are considering a $75,000, 30-year mortgage to purchase a new home. The bank at which you have…

A: Mortgage payments are the regular monthly payments made to cover the amount borrowed as a loan…

Q: You need a new car and the dealer has offered you a price of $20,000, with the following payment…

A: When a borrower borrows a loan from the lender, He has to pay some interest charges on the loan…

Q: What is the effective interest rate per year?   What would you owe if you kept the money for 1…

A: First, I'm going to list the formula, and then solve them in excel. We need to determine the…

Q: You need a new car and the dealer has offered you a price of $20,000, with the following payment…

A: In this question, a person needs a car and dealer give him some offers and we have to see that which…

Q: You have decided to buy a car, the price of the car is $18,000. The car dealer presents you with two…

A: Using a loan amortization calculator or formula, we can calculate the monthly payment for option…

Q: Suppose you take out a loan for $15,000 to buy a car to start driving Uber as a side hustle. Suppose…

A: The objective of the question is to determine how long it will take to pay off a loan of $15,000…

Q: Finally, you have decided to buy a car. You are able to negotiate the price down to $12,000. You…

A: given, r = 2.5% n = 3 m =12 p =12000 applying formula for monthly payment:…

Q: What does this tell you about total cost when financing for longer periods?

A: Leasing a vehicle refers to driving a car through periodic payments towards the car without actually…

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

A: A= 182,0000t= 30 yearsDown Payment = 20%

Q: You go into a car dealership to buy a car.  You negotiate a price of $20,000 for the car.  The…

A: Installment is the amount of periodic payments a borrower makes to its lender in order to pay back…

Q: your client wants to buy a new car. the financing terms are: sticker price: 100,000.00 usd cash…

A: Upfront purchase price = $ 100,000 - 21% discount = 79,000Hence, PV = - 79,000Otherwise under…

Q: You are planning to buy an used car from a local dealer. The list price of the car is $12,000. If…

A: List Price of Car = $12,000Down Payment = $5,500Cash cost of car = $11,000Bank Interest rate =…

Q: We really want a new car and want to know if we can realistically afford it but also see how much…

A: Monthly payment is calculated by pmt formula in excel.

Q: You need to purchase a car, but don’t have the money to buy it outright. Therefore, you’ll have to…

A: Cost of car=$11999 Down payment =5500 monthly payment =250 interest rate =7%

Q: You just got a new part-time job and you need to buy a new car for your job. Suppose you have enough…

A: Variables in the question:PMT=$400Annual interest rate=6%Monthly interest rate=6%/12=0.5%N=5…