Question: i need the excel formula's for the payment and effective interest rate please!!!! You want to buy a new sports coupe for $79,500, and the

i need the excel formula's for the payment and effective interest rate please!!!!

You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? $ Cost of Car Discount rate # of years # of times compounded per year 79,500 5.8% 5 12 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Payment Effective interest rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You want to buy a new sports coupe for $73,500, and the finance office at the dealership has quoted you an APR of 5.5 percent for a 72 month loan to buy the car. a. What will your monthly payments...

You want to buy a new sports coupe for $76,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 72-month loan to buy the car. a. What will your monthly payments...

*Please post excel formula* You want to buy a new sports coupe for $84,500, and the finance office at the dealership has quoted you an APR of 4.7 percent for a 60-month loan to buy the car. What will...

You want to buy a new sports coupe for $84,500, and the finance office at the dealership has quoted you an APR of 4.7 percent for a 60-month loan to buy the car. What will your monthly payments be?...

Calculating loan payments - Excel 2 x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial - 12 A A = M Paste BIU- %6 Alignment Number Conditional Format as Cell Formatting Table...

DAIA RVICV VIEW Calibri 11 Paste BI U - % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 f A B D EFGHI J K L 1 2 3 You want to buy a new...

I need the formulas to get the payment & the effective interest rate, not just answers. You want to buy a new sports coupe for $84,500, and the finance office at the dealership has quoted you an APR...

Attached are the two spreadsheets that I have already completed, but I can't for the life of me explain how the formula's work. I have also attached the questions that I have to answer. I have...

Hi please see attachments for better formatting, all questions are on Microsoft word attachment except for Ch. 5: Questions 3 & 4 & Chapter: 8 Question 6. have their own individual attached Microsoft...

Property is directly related to the power one has in society. Some individuals argue that the government should offer more protection for property owners. Others argue that in a fair country,...

In the decision to keep or replace an equipment, following data is given below old purchase cost $100 000 Total life of both old and new equipment 4 years Annual depreciation cost 25 000 Variable...

Fiounder Inc. mandactures cycling equipment. Becently, the vice president of operations of the compary has reguested construction of a new plant to meet the increanine demand for the compam / s...

Which of the following is a feature of Logitech as a global collaboration network?