Question

In: Accounting

Facts and Assumptions: Lease Term in Months 24 Lease Down Payment $ 500.00 Monthly Lease Payments...

Facts and Assumptions: Lease Term in Months 24 Lease Down Payment $ 500.00 Monthly Lease Payments $ 300.00 Sales Tax Rate 8% Lease Buyout at End $ 15,000.00 Title Fee $ 25.00 Car Loan Market Rate 7% Outright Purchase Price Before Tax and Title $ 19,500.00 What is the NPV of the lease?

What would it cost you to buy the car today if you were paying cash? Round you answer to the nearest whole number. Do not use $, commas, or decimal points and enter as a positive number.

Solutions

Expert Solution

NPV of the lease
Outright purchase price $19,500
Down payment of Lease $500
Title Fees $25
Sales tax $1,560
Monthly installment
1 $300 1.00583 $298.26
2 $300 1.011693989 $296.53
3 $300 1.017592165 $294.81
4 $300 1.023524727 $293.10
5 $300 1.029491876 $291.41
6 $300 1.035493814 $289.72
7 $300 1.041530743 $288.04
8 $300 1.047602867 $286.37
9 $300 1.053710392 $284.71
10 $300 1.059853523 $283.06
11 $300 1.066032469 $281.42
12 $300 1.072247439 $279.79
13 $300 1.078498641 $278.16
14 $300 1.084786288 $276.55
15 $300 1.091110592 $274.95
16 $300 1.097471767 $273.36
17 $300 1.103870028 $271.77
18 $300 1.11030559 $270.20
19 $300 1.116778671 $268.63
20 $300 1.123289491 $267.07
21 $300 1.129838269 $265.52
22 $300 1.136425226 $263.99
23 $300 1.143050585 $262.46
24 $300 1.14971457 $260.93
$6,700.80
NPV of lease = Down payment of lease + Pv of monthly installment
                            = $500+$6700.80
                            =7200.80
Cost of car
Outright purchase price $19,500
Title fees $25
Sales tax 1562
Cash price of car $21,087

Related Solutions

$5,000 are borrowed now with the understanding that it will be repaid in equal monthly payments over 24 months
$5,000 are borrowed now with the understanding that it will be repaid in equal monthly payments over 24 months, if the interest rate is 1% per month, for payment number 6 find the amount that is due to principal? Your answer might be exact or to the closest.a. $833.33b. $194.83c. -540.54d. $40.54
A car may be purchased with $3,500 down payment now and 72 monthly payments of $489....
A car may be purchased with $3,500 down payment now and 72 monthly payments of $489. If the interest rate is 9% per year compounded monthly, what is the price of the car?
You lease a car with a $600 down payment (due at the start of the lease),...
You lease a car with a $600 down payment (due at the start of the lease), 48 monthly payments of $553 (first payment due one month from today), and a $12,000 residual value. You plan to keep the car for 6 years total and sell it for an estimated $7,000. If your cost of capital is an APR of 4.8% (compounded monthly), what is the net cost of the lease including the effects of down payment, lease payments, residual value,...
3-year annuity immediate with monthly payments has an initial payment of 200. Subsequent monthly payments are...
3-year annuity immediate with monthly payments has an initial payment of 200. Subsequent monthly payments are x% more than each preceding payment. Given that the amount of the 14th payment is 481.969, determine the present value of the annuity using a 9%, compounded monthly, interest rate.
Consider a $5,000,000, 9%, CPM with monthly payments. What is the regular monthly payment and the...
Consider a $5,000,000, 9%, CPM with monthly payments. What is the regular monthly payment and the balloon payment amounts in each of the following cases: (a) Fully-amortizing, 30-year loan (b) 30-year amortization, 10-year balloon (c) 15-year amortization, 10-year balloon (d) What is the major disadvantage, and advantage, of the 15-year amortization-rate 10-year loan in (c) as compared to the 30-year amortization-rate 10-year loan in (b)? Please answer only if sure.
You have saved $3,000 for a down payment on a new car. The largest monthly payment...
You have saved $3,000 for a down payment on a new car. The largest monthly payment you can afford is $500. The loan will have a 11% APR based on end-of-month payments. What is the most expensive car you can afford if you finance it for 48 months? Do not round intermediate calculations. Round your answer to the nearest cent. $ What is the most expensive car you can afford if you finance it for 60 months? Do not round...
You have saved $4,000 for a down payment on a new car. The largest monthly payment...
You have saved $4,000 for a down payment on a new car. The largest monthly payment you can afford is $450. The loan will have a 9% APR based on end-of-month payments. What is the most expensive car you can afford if you finance it for 48 months? Do not round intermediate calculations. Round your answer to the nearest cent. $   What is the most expensive car you can afford if you finance it for 60 months? Do not round...
You have saved $5,000 for a down payment on a new car. The largest monthly payment...
You have saved $5,000 for a down payment on a new car. The largest monthly payment you can afford is $450. The loan will have a 6% APR based on end-of-month payments. What is the most expensive car you can afford if you finance it for 48 months? For 60 months? Do not round intermediate calculations. Round your answers to the nearest cent. Financed for 48 months: $   Financed for 60 months: $   Find the present values of the following...
saved $3000 for a down payment on a car. the largest monthly payment you can afford...
saved $3000 for a down payment on a car. the largest monthly payment you can afford is $400. The loan will be at 8%APR based on end of month payments. a) What is the most expensive car you can afford if you finance for 48 months? b) What is the most expensive car financing 60 months?
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is due in 10 years, has a 25 year amortization, at 5% interest? What is the amount of the 120th payment? Please use Excel and explain. Make sure that formulas are set to show in excel sheet.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT