Secondary Loan Pricing Calculation (price of loan being bought/sold)

I'm trying to calculate the price for a loan (by entering rate, maturity & YTM). This is where loans are bought and sold, so would be the same math as bond calculations. I don't need exact (to a specific date) duration entries, and am OK with just a simple "how many years" input for this purpose.

Attached is a spreadsheet and thanks in advance for any assistance.