You have found the car that you've been looking for. You finally come to a purchase...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have found the car that you've been looking for. You finally come to a purchase price with the dealership. Now comes the financing. After lengthy discussions, there are several options you can choose. The drive-out price (car, taxes, title, registration) is $45,000. Financing Options: 1. You do not have a trade-in for your car. The dealership is offering financing for 6%, per year, for a period of 6 years, assuming a down payment of $1,500. 2. From the dealership, you can get a lower interest rate (4%) but the term of the loan is 5 years; no down payment required; no trade-in. 3. Your local bank has a "New Graduate" deal which includes an interest rate of 2% with a no down payment, no trade-in. Payments are only $600/month. First payment isn't until 6 months, from now. In Excel, create an amortization schedule for each of the scenarios so that you can compare your results. Your amortization schedule should show the monthly payments, interest and running loan balance until the maturity of the loan. Additionally, show totals of payments and interests over the term of the loan as well as calculate an effective interest rate. Pick an option, from above, that works best for your personal situation. Write a narrative telling me WHY you would pick the option you chose. Now...... 4. After 6 months, you sold your old vehicle and received $1,200, cash and have decided to pay it towards the financing YOU CHOSE. Additionally, you found out that the company usually awards a Christmas bonus each year of $500. You believe that you can apply that $500, every year, to your car note, at the end of December of each year (12th month). Based on the option that you selected above, update your amortization schedule and provide a narrative on how the amortization changes. 5. What if you are able to pay an extra $25 per month against the loan? Describes how your loan changes. You have found the car that you've been looking for. You finally come to a purchase price with the dealership. Now comes the financing. After lengthy discussions, there are several options you can choose. The drive-out price (car, taxes, title, registration) is $45,000. Financing Options: 1. You do not have a trade-in for your car. The dealership is offering financing for 6%, per year, for a period of 6 years, assuming a down payment of $1,500. 2. From the dealership, you can get a lower interest rate (4%) but the term of the loan is 5 years; no down payment required; no trade-in. 3. Your local bank has a "New Graduate" deal which includes an interest rate of 2% with a no down payment, no trade-in. Payments are only $600/month. First payment isn't until 6 months, from now. In Excel, create an amortization schedule for each of the scenarios so that you can compare your results. Your amortization schedule should show the monthly payments, interest and running loan balance until the maturity of the loan. Additionally, show totals of payments and interests over the term of the loan as well as calculate an effective interest rate. Pick an option, from above, that works best for your personal situation. Write a narrative telling me WHY you would pick the option you chose. Now...... 4. After 6 months, you sold your old vehicle and received $1,200, cash and have decided to pay it towards the financing YOU CHOSE. Additionally, you found out that the company usually awards a Christmas bonus each year of $500. You believe that you can apply that $500, every year, to your car note, at the end of December of each year (12th month). Based on the option that you selected above, update your amortization schedule and provide a narrative on how the amortization changes. 5. What if you are able to pay an extra $25 per month against the loan? Describes how your loan changes.
Expert Answer:
Answer rating: 100% (QA)
ANSWER Option 2 from the dealership with a lower interest rate of 4 and a term of 5 years no down payment required and no trade in would be the best o... View the full answer
Related Book For
Principles of Auditing and Other Assurance Services
ISBN: 978-0078025617
19th edition
Authors: Ray Whittington, Kurt Pany
Posted Date:
Students also viewed these general management questions
-
In your audit of JJC Corporation you have found the following information: On January 1, 2022, JJC acquired 30% of Chiyo Companys voting shares for P10,000,000. The fair value of Chiyos net...
-
You have found the following stock quote for RJW Enterprises, Inc., in the financial pages of todays newspaper. What is the annual dividend? What was the closing price for this stock that appeared in...
-
You have found the following stock quote for RJW Enterprises, Inc., in the financial pages of todays newspaper. What is the annual dividend? What was the closing price for this stock that appeared in...
-
112 S cos-(2x) dx
-
Weinberg Canning produces fillet, smoked salmon, and salmon remnants in a single process. The same amount of disposal cost is incurred whether a product is sold at split-off or after further...
-
Which firm will have a higher level of economic performance: (a) a firm with valuable, rare, and costly-to-imitate resources and capabilities operating in a very attractive industry or (b) a firm...
-
Explain why the amount of cash salaries paid to employees does not equal salaries expense for the employer.
-
Wassons Classic Cars restores classic automobiles to showroom status. Budgeted data for the current year are: The company anticipated that the restorers would work a total of 12,000 hours this year....
-
HOW Francisco Company has 20 employees, each of whom earns $3,000 per month and is paid on the last day of each month. All 20 nove been employed continuously at this amount since January 1. On March...
-
Assume there is a risk-free asset, and assume that a factor model holds in which each factor f1, fk is an excess return. Show that each return R on the mean-variance frontier equals R + Bj fj j=1...
-
Develop and defend the appropriate plans and documentation needed to initiate a project including project charter, scope, team organization, work authorization system, and change control system.
-
The inception of a lease is 1/1/201. A third party guarantees the residual value of the asset under the lease, estimated to be $12,000 at 1/1/20X6, the end of the lease term. Annual lease payments...
-
How many times will this loop run? for n in range(54, 22, -13): print(n) Submit Answerl
-
Choose the appropriate type of IP protection ( patent , trademark, design ) for smart home assistant and justify your choice.
-
An amortization of a debt is in a form of gradient series of P4,000 on the first year, P3,500 on the second year, P3,000 on the third year, and P2,500 on the fourth year. a. What is the equivalent...
-
2a) Outline three factors to consider when determining the method of compaction of construction materials The ratio of the mixed concrete The (6 marks) b) Using sketches, differentiate between a...
-
What tools are available to help shoppers compare prices, features, and values and check other shoppers opinions?
-
Nancy Howe, your staff assistant on the April 30, 20X2, audit of Wilcox Company, was transferred to another audit engagement before she could complete the audit of unrecorded accounts payable. Her...
-
Your working papers for an integrated audit being performed under PCAOB Standard No. 5 include the narrative description below of the cash receipts and billing portions of internal control of...
-
Audit working papers are the property of the auditors, who may destroy the papers, sell them, or give them away. Criticize this quotation.
-
Many employers offer 401(k) retirement savings plans as an employee benefit. Many companies match a certain percentage of each employees deposits in the plan.
-
Justify a corporations decision to split its stock when the stock price has risen significantly.
-
Investors purchase common stock as a way to increase their income. As stockholders, they earn the right to vote on company business.
Study smarter with the SolutionInn App