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);
-
Consider the 1/16 of the 27 factorial discussed in Section 15.11. List the additional 11 defining contrasts.
-
Illustrate the effect of the destruction of the oil fields of Saudi Arabia on the oil market. Explain what then happens to the market for gasoline.
-
Wilmot Real Estate Company experienced the following events during its first year of operations: 1. Received \($50,000\) in cash from investors as an equity investment. 2. Borrowed \($40,000\) in...
-
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...
-
you are required to produce a report on the recent 2 years' performance, position, and prospects of lucara diamond. Your analysis should cover the 2 latest financial years for that company.
-
At June 30, 2022, the end of its most recent fiscal year, Green River Computer Consultants post-closing trial balance was as follows: The company underwent a major expansion in July. New staff was...
-
A historical income statement and balance sheet for Boeing are given. Boeing Company BA 097023105 2108601 NYSE Common stock Source: FactSet Fundamentals DEC '16 DEC '17 DEC '18 DEC '19 INCOME...
-
A company reported net income of \(\$ 200\) on net sales of \(\$ 2,000\). The company's return on sales is: a. \(\$ 1,800\). b. 10 percent. c. 0.1 percent. d. None of the above.
-
How are all manufacturing costs for a series of processing departments accumulated into finished goods inventory?
-
Which of the following is not a true statement? a. Benchmarking analysis involves comparing a company to its industry's averages. b. Benchmarking analysis involves comparing a company to its...
-
Preheating the feed often increases the number of stages required for the separation ( \(\mathrm{F}, \mathrm{z}, \mathrm{x}_{\mathrm{D}}, \mathrm{x}_{\mathrm{B}}, \mathrm{L} / \mathrm{D}\) constant)....
-
Why is it true that in each departments work in process inventory account all beginning inventory and current-period costs must end up either being transferred out or in ending work in process...
-
Question 5 Using the information below, calculate gross profit for the period: Beginning Raw Materials Inventory $ 24,000 Ending Raw Materials Inventory 29,000 Beginning Work in Process Inventory...
-
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...
-
What are workers' compensation premiums? Who pays them? Who pays Social Security and Medicare taxes?
-
Jonas Company issues a 90 -day, 12 percent note payable to replace an account payable to Smith Supply Company in the amount of \(\$ 8,000\). Draft the journal entries (in general journal form) to...
-
The 6 percent bonds of Central Gas \& Electric are selling at a market price of 72, whereas the 6 percent bonds of Interstate Power are selling at a price of 97 . Does this mean that Interstate Power...
Study smarter with the SolutionInn App