please help

File Paste $3 X Cut Home 18 19 Cipboard 11 Option 1: 12 13 Option 2: 14 23 Copy M Format Painter 20 4 points 21 22 33 34 35 Insert Ede Fy E Draw E X fr A B C DE F G You are the manager of a healthcare facility that is considering different payment 3 options for buying supplies for your facility. The annual charges for these supplies 9 is $10,000 and the vendor is offering you three payment options to consider. 10 Calibri BIU Page Layout Font 11 15 16 Option 3: Monthly payments at the beginning of each month with a service charge of 3% for each monthly payment. 17 Formulas Sheet1 Sheet2 Data Review Y A A = Type here to search IM $ A : A discount of 3% if you make the full payment in 30 days. 2 Payments for these supplies are made from your bank account which has a current balance of $30,000 and earns monthly interest of 0.2%. Undertake analysis to 24 a Which of these three options now provides the best value for money? 25 5 points 26 b. At what interest rate would you be indifferent between Options 1 and 27 27 3 points 28 c. At what interest rate would you be indifferent between Options 2 and 37 29 3 points 30 d. Consider the ending balances under each of these three options for 31 12 points interest rate ranging from 0.0% to 2.0%. Develop data tables to compute the ending balances for this range of interest (consider interest Depict your results in a line graph 32 Quarterly payments at the beginning of each quarter with a service charge of $100 per quarter. 1 Which of these three options provides the best value for money? Why? O HI C View Alignment H increments of 0.2%) 29