Question: hello , i need help with this exercises , i just need the number 12,13 and 14 please. thank you so much . 12. The

hello , i need help with this exercises , i just need the number 12,13 and 14 please. thank you so much . hello , i need help with this exercises , i just need

12. The hotel is considering buying or leasing a car to shuttle customers to and from the airport You hope to keep the monthly payment under $400 and will determine whether leasing or buying will meet that goal. On the Lease or Buy worksheet, type the terms in Figure 2.48 below for the purchase vs. lease of the car. Make sure that dollar amounts and percentages are formatted to match Figure 2.48: CHPurchase Lease ONESO Price of Car $ 25 000 $ 25,000 Residual Value $ 15.000 Interest Rate (per year 60% 7.0% Terms of Loan (years) 6 Monthly Payment Figure 248 Terms for the purchase vs. lease of the 13. In cell B8 create a PMT function to calculate the Monthly Payment if you purchase the car. Make sure the arguments in the PMT function are converted into months and that the Monthly Payment is a positive number. 14. In cell C8 create a PMT function to calculate the Monthly Payment if you lease the car. The car will have a residual value of $15,000 when the lease is over. Assume that payments are made at the end of the month. nat with two decimals

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!