need help to answer the question below 1

Attached below are screenshots of the activity assigned. It says exam, however we are using it as an extra credit activity. Please solve showing all the calculations and work relevant to the problem’s answer. Please show both methods using a financial calculator with correlating key strokes and on an excel sheet. Please also follow directions listed in the last paragraph ignoring the factors that have been adjusted and are listed above.