Assume you work for a company that leases cars. An auto dealership contacts you and tells you that it has a customer that wants to lease a car and can arrange for your company to purchase the vehicle and then lease it to the customer. Note that an important variable for you as a leasing firm is the “residual value” of the vehicle when the lease matures and you as the leasing firm must sell the vehicle. It must be forecast and as a result is the source of much of the risk in the lease. The customer that they have has sufficient credit and wants to lease a $42,000 vehicle for 4 years with monthly payments. Your competitor is a leasing company that offers leases for the vehicle requiring the customer to have a down payment of $4,000 and monthly lease payments of $575 beginning when the lease is signed. So at the signing, the customer must pay $4,575. If your firm meets the competitors’ terms, what must the residual value be at the end of the lease in 4 years for your firm to earn 9% on the lease? Assume the customer will not exceed the mileage restriction and there is no damage to the vehicle. Note that the residual value is as of the date the vehicle is returned to the leasing firm, which is one month after the final payment (the 48th month). It assumes the vehicle will be sold immediately, which might not be realistic but is the easiest assumption. Assume monthly compounding for all calculations.*SOLVE USING EXCEL AND SHOW THE FUCTIONS YOU USED PLEASE*

Lease refers to a contract between two parties under which one party who is the real owner of an…

Answered: what must the residual value be at the…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

Assume you work for a company that leases cars. An auto dealership contacts you and tells you that it has a customer that wants to lease a car and can arrange for your company to purchase the vehicle and then lease it to the customer. Note that an important variable for you as a leasing firm is the “residual value” of the vehicle when the lease matures and you as the leasing firm must sell the vehicle. It must be forecast and as a result is the source of much of the risk in the lease. The customer that they have has sufficient credit and wants to lease a $42,000 vehicle for 4 years with monthly payments. Your competitor is a leasing company that offers leases for the vehicle requiring the customer to have a down payment of $4,000 and monthly lease payments of $575 beginning when the lease is signed. So at the signing, the customer must pay $4,575. If your firm meets the competitors’ terms, what must the residual value be at the end of the lease in 4 years for your firm to earn 9% on the lease? Assume the customer will not exceed the mileage restriction and there is no damage to the vehicle. Note that the residual value is as of the date the vehicle is returned to the leasing firm, which is one month after the final payment (the 48th month). It assumes the vehicle will be sold immediately, which might not be realistic but is the easiest assumption. Assume monthly compounding for all calculations.

*SOLVE USING EXCEL AND SHOW THE FUCTIONS YOU USED PLEASE*

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions