You want to buy a car, and the local bank will lend you $20,000. The loan will be fully amortized over 5 years (60 months) and the nominal interest rate will be 12%. The interest will be paid monthly. What will be the monthly loan payment? draw a time line and identify the known variables and unknown variables as if you were to input in EXCEL

Q: : identify the values for the variables, in write an equation that can be used to find the amount of…

A: Future Value: It is the future worth of the present sum of the amount and is estimated by the…

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

A: Monthly Loan Payment = PV*(r*(1+r)n)((1+r)n-1)  where: PV is the present value of the loan r is the…

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: You have taken out a loan of $32,000 to buy a new Saturn. The loan will be paid off in monthly…

A: A loan is an agreement between two parties where an amount is changed in return for the amount being…

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: Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000…

A: Amount lent = $65,000 Loan period = 5 years* 12 = 60 Nominal interest rate = 8%/12 = 0.6667%

Q: A loan officer is preparing the documents for a commercial term loan. The borrower's risk profile…

A: APR is the annual percentage rate. EAR is the annual effective rate. APR is the nominal rate or the…

Q: A loan officer is preparing the documents for a commercial term loan. The borrower's risk profile…

A: APR is the annual percentage rate. EAR is the annual effective rate. APR is the nominal rate or the…

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 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: You are taking out a single-payment loan that uses the simple interest method to compute the finance…

A: Amount of Loan = $10,000Interest Rate (annual) = 6% = 0.06 (as a decimal)Term of Loan = 2 yearsThe…

Q: An investment offers to pay you $10,000 a year for four years. If it costs $27,980, what will be…

A: given present value    = 27980 future value a year…

Q: Using the information provided please show all work and formulas in excel ! Suppose that you have…

A: Incremental borrowing cost refers to an expense that is incurred for taking an extra amount of loan…

Q: Using a spread sheet, calculate the annual payments on a loan for $ 100,000, 10-year loan, 5% per…

A: The objective of the question is to calculate the annual payments on a loan and build an…

Q: You have received a post - dated check of $10, 000 that is payable in 2 years for a project you…

A: Option 1Option 2Amount (FV)$10,000.00$10,000.00Interest rate25%24%Number of years22Compounding…

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: In this project, you will use a graphing calculator to compare savings plans. For instance, suppose…

A: The objective of this question is to compare the final amount of money you would have after one year…

Q: After reviewing your budget, you can afford to pay $720 per month for a new car. You are looking for…

A: Loan is a financial contract engaging a lender who provides money or assets to a borrower who agrees…

Q: A bank has two options for a certificate of deposit of $4000. Option A has an annual interest rate…

A: Future value refers to the value of the current asset at some future date on the basis of inflation,…

Q: You are offered the opportunity to put some money away for retirement. You will receive 10 annual…

A: The following information has been provided,10 annual payments of $5,000 beginning in 26 years will…

Q: If an investor invests her money in a project with a 10% annual return. What is her nominal rate  of…

A: The effective interest rate (EIR), effective annual interest rate (AER), or simply effective rate is…

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: years? Use the solver. Clearly write the form

A: Mortgage loans are necessary for buying home because these are long term loans paid by equal monthly…

Q: Suppose you have a student loan of $25,000 with an APR of 12% for 20 years. Complete parts (a)…

A: We need to use loan amortisation formula to calculate monthly payment of loan. The formula is PMT…

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

A: An amortization schedule is a table or chart that provides a detailed breakdown of each periodic…

Q: What is the excel function and formula for this question?   Off-The-Books Investment Firm, LLC, has…

A: The return which is determined in terms of percentage which is expected to be earned on investment…

Q: One can solve for payments (PMT), periods (N), and Interest rates (1) for annuities. The easiest way…

A: “Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only…

Q: Please make an excel spreadsheet and show the formulas in the cells for the problem below and please…

A: To calculate how much money you will make in book after 3 years, we need to break down the…

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.