Please use excel to solve

You just received a job offer from a hedge fund in New York and are thinking of buying a new car. The lease is for 36 months. The financing information is as follows: ( 20 points) - The cost of purchasing the car is $82,000 - Buyers must also pay a destination charge of $1,200, but lessees have no destination charge. - There is a $1,800 acquisition fee paid by the lessee at the beginning of the lease. - There is a $3,200 security deposit for the lessee at the beginning of the lease. - This fee is refunded at the end of the lease. - The lease residual value at the end of 3 years is $42,000. - If the true value is less than this, you must pay the difference. If the true value is greater than this, you do not receive anything. - You believe the value of the car will be worth $45,000 at the end of the lease. - The monthly lease payments are $1,475 a month for 36 months. a. What is the monthly IRR and annual IRR of buying versus leasing? ( 10 points) b. Given a discount rate of 8%, what is the NPV of buying versus leasing? Should you buy or lease? (2 points) c. As "your estimated residual value" increases from 40,000 to 48,000 , how does the IRR and NPV of buying versus leasing change? (4 points) d. Explain why this pattern makes economic sense. (4 points) You just received a job offer from a hedge fund in New York and are thinking of buying a new car. The lease is for 36 months. The financing information is as follows: ( 20 points) - The cost of purchasing the car is $82,000 - Buyers must also pay a destination charge of $1,200, but lessees have no destination charge. - There is a $1,800 acquisition fee paid by the lessee at the beginning of the lease. - There is a $3,200 security deposit for the lessee at the beginning of the lease. - This fee is refunded at the end of the lease. - The lease residual value at the end of 3 years is $42,000. - If the true value is less than this, you must pay the difference. If the true value is greater than this, you do not receive anything. - You believe the value of the car will be worth $45,000 at the end of the lease. - The monthly lease payments are $1,475 a month for 36 months. a. What is the monthly IRR and annual IRR of buying versus leasing? ( 10 points) b. Given a discount rate of 8%, what is the NPV of buying versus leasing? Should you buy or lease? (2 points) c. As "your estimated residual value" increases from 40,000 to 48,000 , how does the IRR and NPV of buying versus leasing change? (4 points) d. Explain why this pattern makes economic sense. (4 points)