1. create an NPER function for column C that calculates how many payments a student would be required to make depending on the payment amounts in Column B. DO NOT add any spaces to the function. use the PV argument to make the answer a positive number.

- enter the first NPER function in cell C7 using the $500 payment amount, then Autofill the function through cell C17 to determine the number of payments for each payment amount.

- the interest rate should be divided by 12

2. create a scenario using Cell B5 as the changing cell and leave the value for the changing cell as 2549. remove all text from the comments box as you create the scenario. name the scenario: General Studies.

3. create four more scenarios. remove all text from the comments box as you create each scenario. use the following info within the scenarios:

- use $2,758 as the value for the changing cell B5 and name the scenario: Math Major

- use $2,792 as the value for the changing cell B5 and name the scenario: Arts Major

- use $2,978 as the value for the changing cell B5 and name the scenario: Science Major

- use $2,986 as the value for the changing cell B5 and name the scenario: Health Science Major

4. show the Arts Major scenario, then close the Scenario Manager.

PLEASE: Show how to do the above step by step. I dont just want the answers I want to know how to do it step by step. I will not give positive feedback unless it is explained step by step. add pictures showing each step please. thank you.

BIU-B Merge & Center - $ -% -% Insert Delete Polat Conditional Format 25 Cell Formatting Table Styles Clear Sort Filters Format Painter Clipboard Font Alignment Number Styles Cells Editing 4 1 A B G H I 1 1 - 1 K L M N O P Q R S C C D EF I CCC Tuition Payment Plan wN + 5 Tuition 6 Interest Payment Amount $2,549 3.50% # of Payments $500 $550 $600 $650 $700 $750 $800 $850 $900 $950 $1,000 Sheet1 Ready Type here to search