Question: Hello, I need help. I am not sure how to work out these 2 problems on excel. Can anyone help me I am not sure

Hello, I need help. I am not sure how to work out these 2 problems on excel. Can anyone help me I am not sure what formulas to use for excel. Thank you!!

9. Mr. & Mrs. Bernard purchased a home for $750,000. They made a 20% down payment, with the balance paid off by a 25-year mortgage at 4.5% compounded monthly. a) How much is the down payment? b) How much did they borrow? c) How much is their payment each month? d) How much interest is paid the first month? e) How much of the first month's payment is applied to paying off the principal? 10. A car manufacturing company offered a choice of a 0% loan for 60 months, or $5000 cash back on the purchase of a $29,061 car. a) If someone took the 0% loan offer, how much will the monthly payment be? b) If someone took the $5000 cash-back offer and can borrow money from their local bank at 6% interest compounded monthly for 5 years, how much will the monthly payment be? (Assume you use the cash-back offer as a down payment on the car) c) Which of the 2 offers is more favorable
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
