Suppose that you wish to purchase a car and that your bank is offering to you...

Suppose that you wish to purchase a car and that your bank is offering to you a loan. You wish to explore the nature of this loan and the payments that you would have to make given certain circumstances such as the amount that you borrow. Fortunately, Excel offers a function (PMT) that calculates the payment for a loan based on constant payments and a constant interest rate. The syntax of the function is: PMT(rate, nper, pv) where rate is the interest rate for the loan, nper is the total number of payments for the loan, and pv is the amount of the loan. Create a spreadsheet where you may enter the three parameters and have the payment be calculated for you. Once you have done this, create a single variable table that will list for you the different payments given different amounts of money borrowed (assume you are considering buying a car in the $10,000 to $20,000 range looking at $1000 increments). Also on this tab solve the following double variable problem: Create a double variable table that has amount borrowed as the column variable and number of years as the row variable and payment as the output variable. Also on this tab solve the following double variable problem: Create a double variable table that has interest rate as the column variable and number of years as the row variable and Payment as the output variable. (NOTE: Rather than use number of years, if you are making monthly payments, the value would be number of months (i.e., three years would be 36). Finally, create three scenes (high, medium, low) using Scenario for the problem stated above.

How to do this in excel?

Expert Solution

jeff jeffy answered 1 year ago

Suppose you purchase a new car for $27,000. You do not have money in your bank...

Suppose you purchase a new car for $27,000. You do not have money in your bank today but since you have just graduated from UTSA and have a job with high five figure annual salary, you see no problems in taking a five-year loan from your dealer. After looking at your options, you agree to the following terms: 0% down payment with 6.75% APR (compounded monthly). The loan must be paid back in monthly payments over the five years. (Round...

The car you wish to purchase, costs $12000 today. A bank has a deposit account for...

The car you wish to purchase, costs $12000 today. A bank has a deposit account for the purchase of automobiles with an interest of 12% anually. It is expected that the cost of the car will increase at a rate of 3% anually. a. Indicate the inflation rate b. Indicate what is the market rate c. Indicate what is the real interest rate d. Determine the cost of the car in 5 years e. Determine how much you will need...

As part of your financial planning, you wish to purchase a new car 7 years from...

As part of your financial planning, you wish to purchase a new car 7 years from today. The car you wish to purchase costs $10,000 today, and your research indicates that its price will increase by 2% to 4% per year over the next 7 years. a. Estimate the price of the car at the end of 7 years if inflation is (1) 2% per year and (2) 4% per year. b. How much more expensive will the car be...

You take out a car loan at your local bank for the purchase of a new...

You take out a car loan at your local bank for the purchase of a new car. The total cost including taxes and preparation costs are: $25,985. Your bank’s nominal interest rate for car loans is at the moment 7 1⁄4 % for a 5-year amortization period. Calculate your monthly payments and the remaining balance after 3 years.

Suppose you wish to make 28 regular annual withdrawals from your bank account for the next...

Suppose you wish to make 28 regular annual withdrawals from your bank account for the next 28 years. All the withdrawals will be of the amount of $1,543. You plan to make the first withdrawal a year from now, the second one two year from now, the third one three years from now, and so on. In order to make these withdrawals possible, what is the least amount of money that you need to have in the account right now?...

You are getting ready to purchase your first home. You wish to purchase a $400,000 home...

You are getting ready to purchase your first home. You wish to purchase a $400,000 home and the bank requires a 20% deposit. Your father-in-law will provide whatever amount you need after using the governments Homestart scheme and you withdraw your savings from Kiwisaver. Interest rates on a 20-year mortgage with fortnightly payments are 6 percent per annum. a. What will your fortnightly payment be on a 20 year mortgage? b. After 5 years of paying off this mortgage, you...

You are deciding whether to lease or purchase a car. If you lease the car, your...

You are deciding whether to lease or purchase a car. If you lease the car, your annual payments will be $7,400 for the next four years (due at year end). If you buy the car, you will pay $30,000 to purchase the car. You estimate the car will have a resale value of $12,000 at the end of four years. Assume the appropriate discount rate is 10%. Should you lease or buy the car? To answer this question, assume the...

Suppose that you wish to borrow $325,000 today to finance the purchase of an asset and...

Suppose that you wish to borrow $325,000 today to finance the purchase of an asset and that you will repay me with equal quarterly payments over 15 years. a) If the APR is 4.426%, how much will you pay me each quarter? b) Amortize the first 2 payments. Make a table, and show the calculation of each cell in the table. c) Suppose that you plan to pay off the loan immediately after payment 35. What is the remaining principal?...

1.Suppose you want to buy a car that costs $19,000. If the dealer is offering 100%...

1.Suppose you want to buy a car that costs $19,000. If the dealer is offering 100% financing at 6.2% APR for a 5 year loan, what would be the monthly payment? (Answer to the nearest penny) 2.Suppose you want to buy a house that costs $850,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house. If you want a 30 year mortgage, and the borrowing rate is...

Suppose you received in your mailbox, a pre-approved credit card application from Flight-by-Night bank, offering an...

Suppose you received in your mailbox, a pre-approved credit card application from Flight-by-Night bank, offering an introductory interest rate of 12.00 percent per year, compounded monthly for the first 6 months, increasing thereafter to 24 percent per year, compounded monthly. Assuming you transferred/borrowed $3000 from this card and made no subsequent payments, how much interest will you owe at the end of the year?

Question