Question

Question 10 You would like to purchase a car with a negotiated price of $40,000, and the dealer offers financing over a year
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Annual payments are calculated using the PMT function in excel as follows:-

=PMT(rate,nper,pv)

=PMT(7%,6,-40000)

=8391.83

Add a comment
Know the answer?
Add Answer to:
Question 10 You would like to purchase a car with a negotiated price of $40,000, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • *BACH NETE Question You are told that a note has repayment terms of $5,000 per year...

    *BACH NETE Question You are told that a note has repayment terms of $5,000 per year for 5 years, with a stated interest rate of 6. How much of the total payment is for principal, and how much is for interest? (For calculation purposes, use s decimal places as displayed in the factor table provided. Hound final answers to 2 decimal places,.. 5.275.25.) Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor...

  • Exercise 59 DMV leases a building for 20 years. The lease requires 20 annual payments of...

    Exercise 59 DMV leases a building for 20 years. The lease requires 20 annual payments of $12,000 each, with the first payment due immediately. The interest rate in the lease is 10%. What is the present value of the cost of leasing the building? (For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round answer to 2 decimal places, e.g. 52.75.) le provide de seis 20% Click here to view the factor table Future Value...

  • ELA T Question Sandhill Co. is about to issue $105,000 of 8-year bonds that pay a...

    ELA T Question Sandhill Co. is about to issue $105,000 of 8-year bonds that pay a 8.0% annual interest rate, with interest payable semi-annually. The market interest rate is 5%. How much can Sandhil expect to receive for the sale of these bonds? (For calculation purposes, we decimal places as displayed in the factor table provided. Round final answer to 2 decimal places, e.g. 5,275.25.) Click here to view the factor table PRESENT VALUE OF Click here to view the...

  • Brief Exercise G-10 Lloyd Company earns 12% on an investment that will return $453,000 9 years...

    Brief Exercise G-10 Lloyd Company earns 12% on an investment that will return $453,000 9 years from now. Click here to view the factor table (For calculation purposes, use 5 decimal places as displayed in the factor table provided.) What is the amount Lloyd should invest now to earn this rate of return? (Round answer to 2 decimal places, e.g. 25.25.) Lloyd Company should invest $ LINK TO TEXT Brief Exercise G-11 Robben Company is considering investing in an annuity...

  • Joanne Quick made an investment of $18,787.14. From this investment, she will receive $2,000 annually for...

    Joanne Quick made an investment of $18,787.14. From this investment, she will receive $2,000 annually for the next 13 years starting one year from now. Click here to view the factor table Future Value of 1 Click here to view the factor table Future Value of an Annuity of 1 Click here to view the factor table Present Value of 1 Click here to view the factor table Present Value of an Annuity of 1 (For calculation purposes, use 5...

  • Shamrock, Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market...

    Shamrock, Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in Western Canada. In order to do so, Shamrock has decided to locate a new factory in Kelowna, B.C. Shamrock will either buy or lease a site, depending upon which is more advantageous. The site location committee has narrowed down the available sites to the following three buildings. Building A: Purchase for a cash price of $605,000, useful life 25 years. Building B:...

  • Brief Exercise 3-27 As CFO of a small manufacturing firm, you have been asked to determine...

    Brief Exercise 3-27 As CFO of a small manufacturing firm, you have been asked to determine the best financing for the purchase of a new piece of equipment. The vendor is offering repayment options of $12,000 at the end of each year for five years, or no payment for two years followed by one payment of $44,000. The current market rate of interest is 8%. Calculate present value of both options. (For calculation purposes, use 5 decimal places as displayed...

  • PRINTER VERLOR BACK Question Sandhill Co, receives a six-year, $55,000 note that bears interest (paid analy)...

    PRINTER VERLOR BACK Question Sandhill Co, receives a six-year, $55,000 note that bears interest (paid analy) from a customer at me when the market interest rate is what is the present value of the note receved by Sandhi? (For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round final answer to 2 decimal places, eg. 5. 275.25.) Click here to view the factor table PRESENT VALUE OF 1. Gick here to view the factor table...

  • As CFO of a small manufacturing firm, you have been asked to determine the best financing...

    As CFO of a small manufacturing firm, you have been asked to determine the best financing for the purchase of a new piece of equipment. The vendor is offering repayment options of $10,000 at the end of each year for five years, or no payment for two years followed by one payment of $42,500. The current market rate of interest is 9%. Calculate present value of both options. (For calculation purposes, use 5 decimal places as displayed in the factor...

  • Brief Exercise G-4 Cullumber Company issued $1,300,000, 11-year bonds and agreed to make annual sinking fund...

    Brief Exercise G-4 Cullumber Company issued $1,300,000, 11-year bonds and agreed to make annual sinking fund deposits of $75,300. The deposits are made at the end of each year into an account paying 9% annual interest cick here to view the factor table Future Value 1 Cick here to the factor table Future Value of an Annuity of 1 (For calculation purposes, se decimal places as displayed in the factor table provided.) What amount will be in the sinking fund...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT