Scenarios

Hiya Katie

How are you today, thanks for this question

The answer to this is you wouldn't do scenarios to calculate loan amounts, you would do calcs of loan amounts with either a PMT formula, or you can use a template called Loan Amortization fill in the boxes at the top left of the file

this should then work it all out for you

Hope this helps you

Mark East

mark@stl-training.co.uk

MOUS Master Instructor