You want to bought a car for $8,000. You have monthly wage is $1,800 of which $600 will be saved for the car. How long it will take to reach $8,000 with your current saving, the interest rate is 7.2% pa compounding monthly? Please show in EXCEL

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 borrow $25,000 to buy a new car. Your annual interest rate is 6.2% over 4 years with…

A: Given: Loan borrowed = $25,000 Interest rate = 6.2% years = 4

Q: You need a $6000 loan to buy a used car.  Your bank offers a 4-year loan at 9% APR. Calculate your…

A: We have to use the following formula of the monthly payment by using the following formula: Monthly…

Q: You want to buy a $33,000 car. The company is offering a 5% interest rate for 5 years. What will…

A: The calculation of a loan's monthly payment is the subject of the topic. This is a typical financial…

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

A: Amount of home = $255,000 Down payment = 5%  The time duration of the loan = 30 years

Q: you want to buy a car for $8300 with $360 monthly payments for 4 years, what is the annual interest…

A: Interest rate is the rate which the customer would have to pay on the periodic payment of the…

Q: You are saving to buy a new car in two years.  You currently have $5000 in an account that pays 4%…

A: We need to use present value formula below to calculate amount required today in account.PV…

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

A: a) Loan Amount = Total price of house - Down payment  = 260,000 - (260,000 * 5%) = 260,000 - 13,000…

Q: You recently graduated from Miami University and are looking to purchase a new vehicle. The car…

A: Monthly Payment:A "monthly payment" refers to a recurring amount of money that is paid on a monthly…

Q: over 4 years with monthly payments. Calculate your monthly payment.

A: Information Provided: Amount borrowed = $15,000 Interest rate = 3.3% Term = 4 years or 48 months

Q: You would like to purchase a new car in the side that you can afford monthly payments of $400 how…

A: The monthly payment is :The aim is to find the initial loan amount

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 negotiating to buy a new car with a car salesman at a local dealer. You have negotiated the…

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

Q: Give typing answer with explanation and conclusion  You want to buy a 35,000 car. The company is…

A: The monthly payments can be regarded as an annuity i.e. as a payment of a fixed amount over a period…

Q: You borrow $18826 to buy a car. You will have to repay this loan by making equal monthly payments…

A: Borrowed amount is $18826 Time period is 5 years APR is 12% To Find: Monthly payment

Q: You want to save $20,000 to purchase a new car. You place $700 a month in a special savings account…

A: Calculation of number of periods: Answer: It will take 26.77 years to save an amount of $20,000

Q: ut an $8,000 car loan that calls for 7 annual payments of $2,400 each.  What is the interest rate?

A: Annual payments are made for payment of loan which carry the interest and payment of principal…

Q: sidering buying a new car. The sticker price is $15, ment. If you can negotiate an annual interest…

A: In this we need to calculate present value factor and get monthly payment.

Q: you decide to buy a car for $25,635, including taxes and license fees. You saved $6000 for a down…

A: Loans are paid by equal monthly installments and these monthly installment carry payment for…

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

A: Amortization of a loan refers to the process of gradually paying off a debt or loan over a fixed…

Q: You buy a car with a down payment of $1000 and $200 per month for 3 years. a) If the interest rate…

A: Loan amount is the present value of monthly payment based on time value of money and intrest rate of…

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

A: Monthly payment refers to an amount that is paid every month for the repayment of a loan amount…

Q: You want to buy a $243,000 home. You plan to pay 10% as a down payment, and take out a loa with a…

A: As per Bartleby honor code, when multiple sub-parts of a question are asked, the expert is required…

Q: You would like to purchase a car that costs $47000 at 7% APR for 3 years. What is your monthly…

A: Cost (PV) = $47000 Interest rate = 7% Monthly interest rate (r) = 7%/12 = 0.583333333333333% Period…

Q: You are saving to buy a new car in two years.  You currently have $5000 in an account that pays 4%…

A: The FV of an investment refers to the combined worth of the cash flows of the investment at a…

Q: If you want to buy a car, and you can afford a monthly payment of $425, how large of a loan can you…

A: Using excel PV function to get the loan amount

Q: Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The…

A: Amount you can borrow = Present value of the maximum monthly paymentsNOTE :here the monthly payment…

Q: Calculate your monthly payment. Round your answer to the nearest cent.

A: Loan Payments: These are payments made by the borrower to amortize the loan value. This is done by…

Q: You want to buy a new car and have saved a down payment of $2000. The car that you want costs…

A: To solve the question, we first need to determine the amount for which the monthly payments has to…

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

A: Price = $226000 Down payment = 5% Interest rate = 6.55% Monthly interest rate (r) = 6.55%/12 =…

Q: can select one of the following loans, each requiring regular monthly payments:   Installment Loan…

A: To calculate the monthly payments and total interest for each loan, we can use the following formula…

Q: ave selected a new car to purchase for $19,500. If the car can be financed over a period of 4 years…

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

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 are planning on buying a new car. You need to finance $32,500 for the purchase. The bank will…

A: Present value of annuity is computed by following formula:-PV = A*wherePV = Present value of…

Q: Suppose you want to save in order to purchase a new car. Take the APR to be 3.6%. If you deposit…

A: Future value of annuity The future value of annuity refers to the total value of the investment at…

Q: The present value price of a car you would like to purchase today is $17,990. . You are approved…

A: Ordinary annuity are the payments which are made at the end of the period.

Q: You want to buy a car and have negotiated a sale price of $50,000. You can get a loan from your…

A: Present value = pv = $50,000 Compound = monthly = 12 interest rate = r = 6 / 12 = 0.5% Time = t = 6…

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

A: A loan is a facility provided by a lender to the borrower under which the borrower can take a lump…

Q: The present value price of a car you would like to purchase today is $17,990. You are approved for a…

A: In this question one has to solve the monthly payment. Monthly payment can either be found out by…

Q: You have decided to purchase a new car that costs $44,500. You need to make a 20% down payment, then…

A: Present value of annuity is computed as follows:-PV = A * wherePV = Present value of annuityA =…

Q: A Chevrolet Sonic Hatchback costs $ 14,980.00. With a 9 %  down payment, you can have an amortized…

A: Down payment- While purchasing a asset, the payment which is made upfront is called down payment.…

Q: consider purchasing a car that has a price of $18,700. You make payments for 6 years at an APR of…

A: A loan is a sum of money that is borrowed from a lender, with the agreement to repay the principal…

Q: You are saving to buy a new car in two years.  You currently have $5000 in an account that pays 4%…

A: Future value refers to the accumulated amount in the fund account by compounding of the amount at…

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.