Question: hello , i need help with this exercises , i just need the number 12,13 and 14 please. thank you so much . 12. The
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
Get step-by-step solutions from verified subject matter experts
