Samantha has recently graduated from college and is trying to determine her monthly

budget. She knows that, at most, she can afford $$500$ per month to pay down the student

debt she accumulated while in school. However, based on her calculations $($shown below$),$

her monthly payment will exceed what she can afford.

Assume that Samantha's loan provider has informed her that they are willing to extend the

term of her loan to $15$ years $($i$.$e$.180$ months$).$ Reproduce Samantha's calculations in Excel

and determine whether she could afford her monthly student debt payments with the

extension of the loan's term.

It is impossible to calculate based on the variables given in this example.

No$!$ Samantha will still not be able to afford the student debt payments as her monthly payment are

still too high.

Yes! Samantha will be able to afford the student debt payments as her monthly payment is now

within her budget.

Yes! Samantha will be able to afford the student debt payments as her monthly payment is now

exactly equal to her monthly budget.