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.

I worked on this futher and by creating two extra cells and referencing them, can get the =PRICE formula, for "Calculate Loan Price" to work. (attached)

However it's not exactly an elegant solution, anyone know how to combine that into a single formula?

Thanks

Lemice,

Thank you; with your tip, I used =PRICE(TODAY(),TODAY()+(365*B18),B17,B19,B15,4,0)

I've got it to work now.

Thanks,
Rom