7. True case, slightly stylized: The GMC Denali Ultimate is $91,000. The Dodge Limited, fully equipped...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
7. True case, slightly stylized: The GMC Denali Ultimate is $91,000. The Dodge Limited, fully equipped truck is $81,000. Yes, trucks are the new luxury vehicles... You have a Ford F150 to trade and the GMC dealer wants it as he owns a Ford dealership too, but the Dodge dealer does not really like mixing brands in the used car section. As a result, they potentially offer you very different trade in values, and have different financing offers as well. Cost of GMC truck Trade Value used as downpayment Amount to finance: Rate per year: payments/year: years: effective r per period: number of periods: payment per month: Cost of Dodge Truck Solve for trade value required to make the payment the same Amount to finance: Rate per year: payments/year: years: number of periods: effective r per period: payment per month: 91,000 30,660 (trade value) 6% 12 6 81,000 4% 12 6 calcualte this first.... (hint - use Goal Seek or Solver to find this value such that the monthly payments are the same - you can use a staring guess of $20,000) 1 1 Syntax USPV(r,t) SPPV(r,t) SFD(r,t) USCA(r,t) Description CR(r,t) Uniform Series Present Value Single Pay Present Value Sinking Fund Deposit Uniform series compound amount SPCA(r,t) Single pay compound amount Capital Recovery (loan payment) r 0.04 0.05 0.03 0.04 0.04 0.005 t 6 10 20 5 5 360 Result Formula 5.24214 = P 0.61391 V V(1+r)" = 0.03722 P-V₁ 5.41632 1.21665 0.006 [(1+r)^-1] 7(1+r)" V = P 7 (1+r)" (1+r)-1 V₂ = Vo(1+r)" 7(1+ 7)" [(1+)-1] P₁ = Vo Excel Financial Formulas ########## =PV(D4, E4,1,0,0) ########## =PV(D5, E5,0,1,0) ########## =PMT(D6,E6,0,1,0) ########## =FV(D7,E7,1,0,0) ########## =FV(D8,E8,0,1,0) #### =PMT(rate,nper,pv,fv,type) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) 7. True case, slightly stylized: The GMC Denali Ultimate is $91,000. The Dodge Limited, fully equipped truck is $81,000. Yes, trucks are the new luxury vehicles... You have a Ford F150 to trade and the GMC dealer wants it as he owns a Ford dealership too, but the Dodge dealer does not really like mixing brands in the used car section. As a result, they potentially offer you very different trade in values, and have different financing offers as well. Cost of GMC truck Trade Value used as downpayment Amount to finance: Rate per year: payments/year: years: effective r per period: number of periods: payment per month: Cost of Dodge Truck Solve for trade value required to make the payment the same Amount to finance: Rate per year: payments/year: years: number of periods: effective r per period: payment per month: 91,000 30,660 (trade value) 6% 12 6 81,000 4% 12 6 calcualte this first.... (hint - use Goal Seek or Solver to find this value such that the monthly payments are the same - you can use a staring guess of $20,000) 1 1 Syntax USPV(r,t) SPPV(r,t) SFD(r,t) USCA(r,t) Description CR(r,t) Uniform Series Present Value Single Pay Present Value Sinking Fund Deposit Uniform series compound amount SPCA(r,t) Single pay compound amount Capital Recovery (loan payment) r 0.04 0.05 0.03 0.04 0.04 0.005 t 6 10 20 5 5 360 Result Formula 5.24214 = P 0.61391 V V(1+r)" = 0.03722 P-V₁ 5.41632 1.21665 0.006 [(1+r)^-1] 7(1+r)" V = P 7 (1+r)" (1+r)-1 V₂ = Vo(1+r)" 7(1+ 7)" [(1+)-1] P₁ = Vo Excel Financial Formulas ########## =PV(D4, E4,1,0,0) ########## =PV(D5, E5,0,1,0) ########## =PMT(D6,E6,0,1,0) ########## =FV(D7,E7,1,0,0) ########## =FV(D8,E8,0,1,0) #### =PMT(rate,nper,pv,fv,type) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf) (note sign difference on cf)
Expert Answer:
Related Book For
Introduction To Business Law
ISBN: 9780324826999
3rd Edition
Authors: Jeff Rey F. Beatty, Susan S. Samuelson
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A monatomic ideal gas that is initially at a pressure of 1.50 X 105 Pa and has a volume of 0.0800 m' is compressed adiabatically to a volume of 0.0400 m3. (a) What is the final pressure? (b) How much...
-
Is it possible for the temperature of a system to remain constant ever though heat flows into or out of it? If so, give one or two examples.
-
Refer to Exercise 10 in Section 3.2. Assume that = 30.0 0.1 Pa, h = 10.0 0.2 mm, and = 1.49 Pa s with negligible uncertainty. a. Estimate V and find the uncertainty in the estimate. b. Which...
-
The annual report of a major public limited company included the following statement: Going concern The directors consider that the group and the company have adequate resources to remain in...
-
Interpret the following information regarding Westlake Corporation's cash flows. Sales..................$ 550,000 Accumulated depreciation........ 190,000 Cash ? Cost of goods sold........ 320,000...
-
(6) a) Sketch the function f(x) = 2 from x = -2 to 2 = 2. b) Approximate the signed area of f(x) on [-2, 2] by using right hand sums with n = 4. Is this an overestimate or and underestimate of the...
-
Thompson Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A container, a class K container, or a class T container. A single class A container...
-
How do blockchains work? What is the purpose of a hash?
-
What types of technical reviews should be conducted?
-
What is a Phase of Operation?
-
What is an IPR and what is it intended to accomplish?
-
What is a System Retirement/Disposal Concept? Identify examples of its UCs.
-
What is a PMB?
-
The standard cost card for the single product manufactured byCutter, Incorporated, is given below:Inputs(1) Standard Quantity or Hours(2) Standard Price or RateStandard Cost (1) ? (2)Dir 2 answers
-
Prove the result that the R 2 associated with a restricted least squares estimator is never larger than that associated with the unrestricted least squares estimator. Conclude that imposing...
-
Match the following terms with their definitions: ___ A. ULP ___ B. Exclusivity ___ C. Collective bargaining unit ___ D. Union shop ___ E. Concerted action 1. A specific group of employees that a...
-
1. Did Wells undermine Dunlap intentionally? 2. Under a traditional employment-at-will doctrine, did Ormet have the right to fire Wells? 3. Did the court permit Ormet to fire Wells?
-
1. In general, Article 2 of the UCC governs what kind of transactions? 2. What are goods? 3. The dispute here is about whether the UCC or the common law governs the trans-action. However, isnt it...
-
Support equipment used to drill a development well cost $13,000 and has a 10-year life with a salvage value of $1,000. The equipment was used for three months in drilling Badger #1. Record...
-
Bartz Corporation paid a seismic crew $2,000 to complete a G&G survey to select a drillsite where Cellar #1 would be spudded-in. Record the above transaction.
-
Decade Petroleum incurred and paid the following costs during 2016: Record Decade Petroleum's transactions. Lease A Unproved Lease B Unproved Lease C Proved Lease D Proved Purchased Acquisition costs...
Study smarter with the SolutionInn App