Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Do all of the following Cirtant N Ford EX 13 9 0 G H 1 Financing Calculator 2 Cred score Total cost of service 4
Do all of the following
Cirtant N Ford EX 13 9 0 G H 1 Financing Calculator 2 Cred score Total cost of service 4 Down payment 5. Rate analized 6 Term in years) 7 Percentage discount & Amount of count 9 Total amount borrowed 10 Monthly payment 725 517 000.00 $ 3,500.00 4.OON 2 Percent Discount o O.CON 5000 1.50X 9000 S.OON 18000 7.50X 2000 15.00 $12.650.00 Enter a VLOOKUP Function in the space below to return the Percentage discount rate based on the total cost of service B7- Enter a PMT Function in the space below to calculate the monthly payment the Total amount borrowed B10- Enter an IF Function in the space below to calculate the Amount of discount, the only get a discount if the Total cost of service is more than or equal 15000 and down payment is less or equal 3000, the amount of discount is the multiply of the Total cost of service by the Percentage discount, otherwise, the discount is zero. B8- Enter an IFERROR function in the space below to the last formulate to display an "Error" when an error message occurs. B8- Cirtant N Ford EX 13 9 0 G H 1 Financing Calculator 2 Cred score Total cost of service 4 Down payment 5. Rate analized 6 Term in years) 7 Percentage discount & Amount of count 9 Total amount borrowed 10 Monthly payment 725 517 000.00 $ 3,500.00 4.OON 2 Percent Discount o O.CON 5000 1.50X 9000 S.OON 18000 7.50X 2000 15.00 $12.650.00 Enter a VLOOKUP Function in the space below to return the Percentage discount rate based on the total cost of service B7- Enter a PMT Function in the space below to calculate the monthly payment the Total amount borrowed B10- Enter an IF Function in the space below to calculate the Amount of discount, the only get a discount if the Total cost of service is more than or equal 15000 and down payment is less or equal 3000, the amount of discount is the multiply of the Total cost of service by the Percentage discount, otherwise, the discount is zero. B8- Enter an IFERROR function in the space below to the last formulate to display an "Error" when an error message occurs. B8 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started