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...
-
The cost of beginning inventory plus the costs added during the period should equal the cost of units _____________________ plus the cost of _____________________.
-
On January 1, 2022, Concord Industries Inc. issued a $101,000,7% bond due in 10 years with interest payable each January 1 and July 1. The effective interest rate is 8%. Assuming instead that the...
-
A vertical shaft passes through a bearing and is lubricated with an oil having a viscosity of \(0.2 \mathrm{~N} \cdot \mathrm{s} / \mathrm{m}^{2}\) as shown in Fig. P6.85. Assume that the flow...
-
The Miramar Company is going to introduce one of three new products: a widget, a hummer, or a nimnot. The market conditions (favorable, stable, or unfavorable) will determine the profit or loss the...
-
1. Referring to the diagram, if the velocity of B is constant at 1.5 m/s upward, determine the angular velocity of the rod AB in rad/s. (use three decimal places)2. Find the velocity of point A along...
-
There is an array A made of N integers. Your task is to choose as many integers from A as possible so that, when they are put in ascending order, all of the differences between all pairs of...
-
Using VSEPR theory, determine the electron- group geometry and molecular shape of the following substances: (a) BF3 (b) NF3 (c) CF4 (d) CF,H2
-
janine worked 15 hours last week one job as a clerk in a sporting good store paid her $7.83 per hour while her job giving piano lessons paid $16 per hour if she gained $158.30 between the two jobs...
-
Pretend you are conducting a survey research study to determine the importance of university brand name / prestige and features on student decision to select a particular university. Would you use...
-
150.The inventory manager's compensation includes a bonus plan based on gross profit. You discover that the inventory manager has knowingly overstated ending inventory by $2 million. What effect does...
-
An item costs $200 and has a markup percentage of 20% based on cost. Find the selling price.
-
The concepts and principles of analytics have remained consistent while the scope of available data and the technology to process data into information has rapidly evolved over time. Pick a...
-
There are no units in process at the beginning of the period, 500 units in process at the end of the period that are 20% complete, and 3050 units transferred out during the period. Based on this...
-
Design an experiment to demonstrate that RNA transcripts are synthesized in the nucleus of eukaryotes and are subsequently transported to the cytoplasm.
-
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...
-
If sand from gravel pit 1 is used, then molten glass for producing armored glass has a random impurity content \(X\) which is \(N(60,16)\)-distributed. But if sand from gravel pit 2 is used, then...
-
The total monthly sick leave time of employees of a small company has a normal distribution with mean 100 hours and standard deviation 20 hours. (1) What is the probability that the total monthly...
-
Let \(X\) have a geometric distribution with \[P(X=i)=(1-p) p^{i} ; \quad i=0,1, \ldots ; 0
Study smarter with the SolutionInn App