I need it to be solved using modeling , sensitivity analysis and financial excel functions with excel or written.

Part2: Sara is going to buy a new car. The amount of money he needs to borrow (with a 6-year repayment period) depends on the monthly payments he can afford. He is unsure about the annual interest rate he will receive. Assume the following values: Monthly Payment 150 BHD Annual Interest Rate 5% 1) How much would be the Loan Amount and the Total Monthly Payment after 4 year? 2) Using this loan amount can Sara buy a car with price 7,000 BHD? 3) If Sara want to buy a car with price 7,000 BHD, how much should be the Monthly Payment? 4) Determine how Loan Amount varies as amount monthly payments from 100 BHD to 200 BHD and as annual interest varies from 5% to 9%. 5) If Sara can pay only 150 BHD as Monthly Payment, explain how the interest rate will affect the Loan amount (from the data table in Q4). 6) If the maximum Loan Amount are limited to 6,000 BHD, how high an annual interest rate can he tolerate? 7) Create a report showing Loan Amount, Total Payment and the difference between Total Payment and Loan Amount for the following scenarios, If Sara wants to buy a car with price 7,000 BHD which Scenario will be the best and why? Years Interest Rate Amount paid each month Lowest payment 4.50 7.0% $140.00 Most-likely payment 4.00 5.0% $160.00 Highest payment 3.50 4.0% $180.00 Part2: Sara is going to buy a new car. The amount of money he needs to borrow (with a 6-year repayment period) depends on the monthly payments he can afford. He is unsure about the annual interest rate he will receive. Assume the following values: Monthly Payment 150 BHD Annual Interest Rate 5% 1) How much would be the Loan Amount and the Total Monthly Payment after 4 year? 2) Using this loan amount can Sara buy a car with price 7,000 BHD? 3) If Sara want to buy a car with price 7,000 BHD, how much should be the Monthly Payment? 4) Determine how Loan Amount varies as amount monthly payments from 100 BHD to 200 BHD and as annual interest varies from 5% to 9%. 5) If Sara can pay only 150 BHD as Monthly Payment, explain how the interest rate will affect the Loan amount (from the data table in Q4). 6) If the maximum Loan Amount are limited to 6,000 BHD, how high an annual interest rate can he tolerate? 7) Create a report showing Loan Amount, Total Payment and the difference between Total Payment and Loan Amount for the following scenarios, If Sara wants to buy a car with price 7,000 BHD which Scenario will be the best and why? Years Interest Rate Amount paid each month Lowest payment 4.50 7.0% $140.00 Most-likely payment 4.00 5.0% $160.00 Highest payment 3.50 4.0% $180.00