Question

In: Finance

You receive a $25,000 car LEASE at 6% nominal annual for 3 years. Interest is compounded...

You receive a $25,000 car LEASE at 6% nominal annual for 3 years. Interest is compounded monthly and you make monthly payments. Your Residual value at the end of your lease is $15,000. Assume LEASE payments are made at the END of the month, (first payment due end of first month). You can also get a LOAN for the same terms (although you will pay off the entire car in 3 years).

Assume your MARR for investment is 4% annual (compounded monthly as well).

Compute the PV of your LEASE and LOAN payments and subtract these two values. Enter this difference as a POSITIVE value if the LOAN is better or a NEGATIVE value if the LEASE is better.

For example, if the PV of the LOAN was $12,000 and the PV of the LEASE was $11,500 then the Lease is cheaper so you would enter -500.

This is all of the information given in the problem. Please show work. Thank you.

Solutions

Expert Solution

LEASE PAYMENT
Amount of car lease $25,000
Residual Value of the car after 3 years $15,000
Number of monthly payments 36 (3*12)
Interest rate per month=(6/12)= 0.50%
Amount of lease payment per month $304.22 (Using PMT function of excel with Rate=0.5%,Nper=36, PV=-(25000-15000))
Payment at the end of lease $15,000
MARR=4%
Monthly minimum acceptable rate of return (4/12)%
Present Value(PV) of Lease $9,164.30 (Using PV function of excel with Rate=(4/12)%, Nper=36, Pmt=-304.22, FV=-15000
LOAN PAYMENT
Amount of Loan $25,000
Amount of Loan Repayment per month $760.55 (Using PMT function of excel with Rate=0.5%,Nper=36, PV=-25000)
MARR=4%
Monthly minimum acceptable rate of return (4/12)%
Present Value(PV) of Loan repayment $14,144.75 (Using PV function of excel with Rate=(4/12)%, Nper=36, Pmt=-760.55
Lease Is CHEAPER ($4,980.45)
Difference ($4,980.45)

Related Solutions

You receive a $25,000 car LEASE at 6% nominal annual for 3 years. Interest is compounded...
You receive a $25,000 car LEASE at 6% nominal annual for 3 years. Interest is compounded monthly and you make monthly payments. Your Residual value at the end of your lease is $15,000. Assume LEASE payments are made at the END of the month, (first payment due end of first month). You can also get a LOAN for the same terms (although you will pay off the entire car in 3 years). Assume your MARR for investment is 4% annual...
You receive a $35,000 car LEASE at 6% nominal annual for 60 months. Interest is compounded...
You receive a $35,000 car LEASE at 6% nominal annual for 60 months. Interest is compounded daily and you make monthly payments. Your Residual value at the end of your lease is $15,000. Assume LEASE payments are made at the BEGINNING of the month, (first payment due immediately). What is your monthly LEASE payment?
You receive a $35,000 car LEASE at 6% nominal annual for 60 months. Interest is compounded...
You receive a $35,000 car LEASE at 6% nominal annual for 60 months. Interest is compounded daily and you make monthly payments. Your Residual value at the end of your lease is $15,000. Assume LEASE payments are made at the BEGINNING of the month, (first payment due immediately). What is your monthly LEASE payment? Please show work so I can compare my answer, I got an answer of 434.2 as of a first time. Thanks
You receive a $35,000 car loan at 6% nominal annual for 60 months. Interest is compounded...
You receive a $35,000 car loan at 6% nominal annual for 60 months. Interest is compounded daily and you make monthly payments. How much PRINCIPLE do you pay on your 12th payment?
You are financing a new car with a three-year loan at 10.5% annual nominal interest, compounded...
You are financing a new car with a three-year loan at 10.5% annual nominal interest, compounded monthly. The price of the car is $14,500. Your down payment is $1,500. What are your monthly payments at 10.5%? (Assume your payments start one month after the purchase, or at the end of the first period.)
You just deposited $25,000 in a bank account that pays a 12.0% nominal interest rate, compounded...
You just deposited $25,000 in a bank account that pays a 12.0% nominal interest rate, compounded semi-annually. If you also add another $3,000 to the account each year over the next five years, how much will be in the account five years from now?
You will receive $100 from a zero-coupon savings bond in 3 years. The nominal interest rate...
You will receive $100 from a zero-coupon savings bond in 3 years. The nominal interest rate is 7.20%. a. What is the present value of the proceeds from the bond? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. If the inflation rate over the next few years is expected to be 2.20%, what will the real value of the $100 payoff be in terms of today’s dollars? (Do not round intermediate calculations. Round your answer...
Compute the interest paid on a 3-year lease for a $29,767 car if the annual rate...
Compute the interest paid on a 3-year lease for a $29,767 car if the annual rate of depreciation is 19% and the lease's annual interest rate is 3.6%. Round your answer to the nearest dollar.
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded...
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded monthly. The loan is to be repaid by 36 monthly payments of 367.21 over 37 months, starting one month after the loan is made, there being a payment at the end of every month but one. At the end of which month is the missing payment? For your reference, the answer is at the 17th month.
The U.S. nominal annual rate of interest is 3% and the European annual nominal rate of...
The U.S. nominal annual rate of interest is 3% and the European annual nominal rate of interest on the Euro is 2%. At the same time, the spot exchange rate is $1.20 per Euro and the real interest rate is 2% in both the U.S. and Europe. What is the one year forecast of the U.S. dollar (USD) per Euro spot exchange rate, assuming the international Fisher effect holds? Show work. What is the U.S. dollar (USD) per Euro one-year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT