A smooth used-car salesman is offering you a great deal on a “preowned” car. He says, “For...

A smooth used-car salesman is offering you a great deal on a “preowned” car. He says, “For only five annual end-of-the year payments of $2,180, the beautiful 2016 Honda Civic can be yours.” If you can borrow money a 5.47%, what is the price of the car? If you are to make the payment at the beginning of the year, what is the price of the car?

Solutions

Expert Solution

Ans:- In this question, we need to calculate the price of the car that means the present value of an annuity. we will use the PV function of excel to find the present value.

For PV of an ordinary annuity, Rate=5.47%, Nper=5, Pmt=-$2,180, FV=0, TYPE=0

For PV of annuity due, Rate=5.47%, Nper=5, Pmt=-$2,180, FV=0, TYPE=1

Note:- In excel we Put TYPE=0 when payment or withdrawal is done at the end of the period (ordinary annuity), and TYPE=1, when it is done at the beginning of the period (annuity due).

Therefore, the price of the car if payment is made at the end of the period is $9,316.88 and if the payment is made at the beginning of the period, then the price would be $9,826.52.

Note:- If this answer helps you pls give thumbs up.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Your friend says that Company A is doing a great job for shareholders. He says that...

Your friend says that Company A is doing a great job for shareholders. He says that their ROA is high. You point out that shareholders tend to like debt and the Company A has low debt. Furthermore, ROA is biased towards companies with low debt. You suggest that ____________ is a better measure of the job management is doing for shareholders.

You are negotiating to buy a new car with a car salesman at a local dealer....

You are negotiating to buy a new car with a car salesman at a local dealer. You have negotiated the price to $35,000. You have $5,000 to put towards the down payment and plan to get a loan for the rest. If you can get an annual interest rate of 11 percent APR (with monthly compounding) over a 5-year period, what would be your monthly payment? Round it to two decimal place (cents), e.g., 234.56.

The word "omnichannel" is used a great deal to describe the consumer options today in an...

The word "omnichannel" is used a great deal to describe the consumer options today in an ever changing marketing environment. 1. Give an example of how "omnichannel" plays a role in your experiences as a consumer. 2. 2 Pros and 2 cons of omnichannel

A used car salesperson claims that the probability of he selling a used car to an...

A used car salesperson claims that the probability of he selling a used car to an individual looking to purchase a used car is 70% and this probability does not vary from individual to individual. Suppose 5 individuals come to speak to this salesperson one day. If his belief is correct, The probability (to 4 decimal places) that he will sell a car to the first individual he speaks to is ______ The probability (to 4 decimal places) that he...

A car salesman tells you that the model you are looking at gets on average 36...

A car salesman tells you that the model you are looking at gets on average 36 miles per gallon overall (highway and street driving) with a standard deviation of 4 miles per gallon. He also tells you that 20% of the cars get at least 44 miles per gallon. a. ( Do you think this is a normal distribution? Explain why or why not. (there is no one right answer for this) b. Analyze the salesman's statement mathematically. Is he...

Seller says to Buyer Bob: "I'll sell you my bicycle for $400." Buyer Bob says: "Great,...

Seller says to Buyer Bob: "I'll sell you my bicycle for $400." Buyer Bob says: "Great, but I can only pay you $200 now. I'll pay you the other $200 next Friday and pick up the bicycle then." Seller responds: "Well, I wouldn't do this for everyone, but since I know you’re a man of your word, Bob, I’ll take that deal.” Buyer Bob and Seller shake hands to show their agreement. Which of the following statements is true: -...

30. "I will sell you my car for $5,000," says A. "I will pay $4000" says...

30. "I will sell you my car for $5,000," says A. "I will pay $4000" says B. The offer to sell for $5,000 has been terminated. Group of answer choices True False Flag this Question Question 312 pts 31. In a unilateral contract, the consideration for the promise is: a. the surrender of a claim against the promisor. b. the returning of the promisor's property. c. a promise to do the act called for by the promisor. d. the doing...

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...

1/ Assume you purchased a car that costs $14,000. The car dealership is offering financing at...

1/ Assume you purchased a car that costs $14,000. The car dealership is offering financing at 5% per year. How much is your annual payment assuming you financed the car for 5 years? How much did the car actually cost? 2/ At the beginning of the season on April 1, Green Acres Golf Course completed a physical inventory count and found that $3,000 of inventory was still on hand. Throughout the month of April, Green Acres had the following purchase...

Donald is in the market for a used car. He has found the same sports car...

Donald is in the market for a used car. He has found the same sports car at two different dealerships and is now considering which dealer he should purchase the car from. Dealer 1 requires Donald to get the loan through their lending department. Dealer 1 has told Donald that because they do their own financing, they can get Donald the very best loan possible and Donaldwill only have to pay $365 per month for 60 months (5 years). Dealer...

Subjects