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
-
Adam and Eve consume only apples. Of the following allocations of apples, which are preferred to which others according to (a) the Pareto criterion, and (b) the efficiency criterion? a. Adam has 12...
-
If a horizontal load applied to the bar AC causes point A to be displaced to the right by an amount L, determine the normal strain in the wire AB. Originally, θ = 45°. -L-
-
The balance sheet of Banc One Corp. at December 31, 2007, reported 500,000 shares of \(\$ 1\) par common stock authorized with 100,000 shares issued. Paid-In Capital in Excess of Par had a balance of...
-
The Jacob Hartz Seed Company, Inc. (Hartz), bought soybeans for use as seed from E. R. Coleman. Coleman certified that the seed had an 80 percent germination rate. Hartz paid for the beans and picked...
-
How do cross-cultural differences in communication styles, values, and norms impact intercultural interactions and collaboration within multinational organizations, and what strategies can leaders...
-
Co B is the issuer of a tranche of mandatorily redeemable convertible preference shares (MRCPS) that was issued on the following terms: Required 1. Identify the elements included in the MRCPS. 2....
-
Explain which operations the following Matlab codes perform. X = 2: X = Y^Z: Z= X*Y X = Y\Z: X = Y/Z: A = [123 4]: size (A): length (A): A': zeros (3,4): B = [12 ;4 5 ;7 8 ): plot (x,y): stem (x,y,...
-
Outline the common stages of a system development life cycle.
-
Describe the most common EDP environments.
-
Give an example of a hardware control.
-
What are contingency plans? Be specific.
-
The following are cutoff values for the upper 5% of a \(t\)-distribution with either degrees of freedom 10, 50 , or 100: \(2.23,1.98\), and 2.01. Identify which value belongs to which distribution...
-
You have given a responsibility from your company (XYZ Construction) to complete all necessary ordering for a 10 m x 10 m x 300 mm concrete slab casting. Analyse the scenario and complete the...
-
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.
-
What is the average rate of return for the values that follow? 0.90, 1.1, 1.2
-
What is the average rate of return for the values that follow? 0.80, 2.0, 5.0
-
State whether the data are symmetrical, skewed to the left, or skewed to the right. 16; 17; 19; 22; 22; 22; 22; 22; 23
Study smarter with the SolutionInn App