ASSUMPTIONS: Lexus IS-250-2 years Purchase Price = $34,000 Down payment = $6,800* - 2-year loan for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ASSUMPTIONS: Lexus IS-250-2 years Purchase Price = $34,000 Down payment = $6,800* - 2-year loan for $27,500 at 8% monthly payment of $1,230.18 5% opportunity cost of down payment a. Agreed-upon purchase price b. Down payment Lease Capitalized cost $34,000 Capitalized cost reduction = $2,950* Monthly lease payments = $459.83 Security deposit = $475 5% opportunity cost of down payment Expected market value of car at the end of 2 years = $23,500. (This value is subtracted in the "Purchase" situation and is used to negotiate the monthly lease payment in the "Lease" situation.) COST OF PURCHASING c. Total loan payments (monthly loan payment of $1,230.18 X 24 months) d. Opportunity cost on down payment (5% opportunity cost X 2 years X line b) e. Less: Expected market value of the car at the end of the loan f. Total cost of purchasing (lines b + c + d - e) COST OF LEASING g. Down payment (capitalized cost reduction) of $2,950 plus security deposit of $475 h. Total lease payments (monthly lease payments of $459.83 X 24 months) i. Opportunity cost of total initial payment (5% opportunity cost X 2 years X line g) j. Any end-of-lease charges (perhaps for excess miles), if applicable k. Less: Refund of security deposit 1. Total cost of leasing (lines g +h+i+j-k) $34,000 $6,800 $29,524.32 $680 -$23,500 $13,504.32 $3,425 $11,035.92 $342.50 $0 -$475.00 $14,328.42 Your Numbers A B C 2 W 9 WORKSHEET Worksheet for the Lease versus Purchase Decision 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 a. Agreed-upon purchase price b. Down payment E Cost of Purchasing c. Total loan payments (monthly loan payment x d. Opportunity cost of down payment number of months) [opportunity cost rate x number of years x line b] e. Less: Expected market value of the car ar the end of the loan f. Total cost of purchasing Cost of Leasing g. Down payment (capitalized cost reduction) + security deposit h. Total lease payments (monthly lease payment x number of months) i. Opportunity cost of total initial payment [opportunity cost rate x number of years x line g] j. Any end-of-lease charges (e.g., excess mileage), if applicable k. Less: Refund of security deposit 1. Total cost of leasing LL F $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 H ASSUMPTIONS: Lexus IS-250-2 years Purchase Price = $34,000 Down payment = $6,800* - 2-year loan for $27,500 at 8% monthly payment of $1,230.18 5% opportunity cost of down payment a. Agreed-upon purchase price b. Down payment Lease Capitalized cost $34,000 Capitalized cost reduction = $2,950* Monthly lease payments = $459.83 Security deposit = $475 5% opportunity cost of down payment Expected market value of car at the end of 2 years = $23,500. (This value is subtracted in the "Purchase" situation and is used to negotiate the monthly lease payment in the "Lease" situation.) COST OF PURCHASING c. Total loan payments (monthly loan payment of $1,230.18 X 24 months) d. Opportunity cost on down payment (5% opportunity cost X 2 years X line b) e. Less: Expected market value of the car at the end of the loan f. Total cost of purchasing (lines b + c + d - e) COST OF LEASING g. Down payment (capitalized cost reduction) of $2,950 plus security deposit of $475 h. Total lease payments (monthly lease payments of $459.83 X 24 months) i. Opportunity cost of total initial payment (5% opportunity cost X 2 years X line g) j. Any end-of-lease charges (perhaps for excess miles), if applicable k. Less: Refund of security deposit 1. Total cost of leasing (lines g +h+i+j-k) $34,000 $6,800 $29,524.32 $680 -$23,500 $13,504.32 $3,425 $11,035.92 $342.50 $0 -$475.00 $14,328.42 Your Numbers A B C 2 W 9 WORKSHEET Worksheet for the Lease versus Purchase Decision 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 a. Agreed-upon purchase price b. Down payment E Cost of Purchasing c. Total loan payments (monthly loan payment x d. Opportunity cost of down payment number of months) [opportunity cost rate x number of years x line b] e. Less: Expected market value of the car ar the end of the loan f. Total cost of purchasing Cost of Leasing g. Down payment (capitalized cost reduction) + security deposit h. Total lease payments (monthly lease payment x number of months) i. Opportunity cost of total initial payment [opportunity cost rate x number of years x line g] j. Any end-of-lease charges (e.g., excess mileage), if applicable k. Less: Refund of security deposit 1. Total cost of leasing LL F $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 H
Expert Answer:
Answer rating: 100% (QA)
It seems that you have provided a worksheet for comparing the cost of purchasing and leasing a Lexus ... View the full answer
Related Book For
Systems Analysis and Design
ISBN: 978-1305494602
11th Edition
Authors: Scott Tilley, Harry J. Rosenblatt
Posted Date:
Students also viewed these finance questions
-
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...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
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...
-
What does the following code fragment print? String \(s=\) "He11o World"; s. toUpperCase(); s. substring (6, 11); StdOut.println(s);
-
A pistoncylinder device initially contains steam at 3.5 MPa, superheated by 5°C. Now, steam loses heat to the surroundings and the piston moves down hitting a set of stops at which point the...
-
What are the three phases of an internal control evaluation? What do auditors do in each of these phases?
-
Does a manager who holds stock options in the company prefer buybacks or dividends? Why?
-
First Bank has some question as to the tax-free nature of $5 million of its municipal bond portfolio. This amount is excluded from First Bank's taxable income of $55 million. Management has...
-
#3.) In the diagram below AL || BK || CH || DG. If DG = 3, GE = 5, HG = 5, KH = 5, LK = 5 determine the fellgul of AL, BK, and CH. B C
-
Consider the idealized, symmetric two-cell wing box shown in the figure below. The area enclosed by the semi-elliptical web 45 is 51,500 mm. The shear modulus of the material is G = 27 GPa....
-
Your answer is correct. Prepare the journal entry to record the sale of these bonds on January 1, 2020. (Credit account titles are automatically indented when amount is entered. Do not indent...
-
On January 1 , 2 0 2 3 , Mona, Incorporated, acquired 9 0 percent of Lisa Company s common stock as well as 7 0 percent of its preferred shares. Mona paid $ 8 9 , 0 0 0 in cash for the preferred...
-
Amy has her own bookkeeping company, ClearBooks Account providing services for the month ended August 31, 2023. Amy administrative assistant and the other is a bookkeeper. The follo D 1 2 Cost Item...
-
1. John found that his plane could fly at 6 times the speed of the wind. He flew 700 miles upwind in 3 hours more than took to fly 560 miles downwind. What was the speed of the plane in still air? 2....
-
Using data provided, does Elaine have any support for her concern ? Information for the prior five years is shown below: Year 2011 2012 2013 2014 2014 JOS Revenue $750,000 $875,000 $1,200,000...
-
Wedmark Corporation's Cupertino, California, plant manufactures chips used in personal computers. Its practical capacity is 4,500 chips per week, and fixed costs are $71,000 per week. The selling...
-
I need help using the direct write off method. I don't understand the below question. The following information is from the 2009 records of Rawhide Leather Products Uncollectible accounts expense is...
-
Time Travel Publishing was recently organized. The company issued common stock to an attorney who provided legal services worth $25,000 to help organize the corporation. Time Travel also issued...
-
List the eight main guidelines for user interface design. How would you rank them in order of importance? Explain your answer.
-
Visit the IT department at your school or a local company to learn about the network they use. Describe the network and draw a sketch of the configuration.
-
The BYOD movement has serious implications for IT professionals, such as managing applications on user devices and security implications. Do you think BYOD is a net positive or a net negative for the...
-
The new printing department of Shark Advertising Inc. provides printing services to the other departments. Prior to the establishment of the in-house printing department, the departments contracted...
-
Shakie Sports Company made 20,000 leather basketballs in a given year. Its total manufacturing costs were $170,000 variable and $70,000 fixed. Assume that no price changes will occur in the following...
-
Lynch, Barney, and Schwab is a stock brokerage firm that evaluates its employees on sales activity generated. Recently the firm also began evaluating its stockbrokers on the number of new accounts...
Study smarter with the SolutionInn App