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

1. ## 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.  Register To Reply

2. ## Re: Secondary Loan Pricing Calculation (price of loan being bought/sold)

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  Register To Reply

3. ## Re: Secondary Loan Pricing Calculation (price of loan being bought/sold)

Hello,

You can always include a formula in another one, like this
=PRICE(TODAY(),B20+(365*B18),B17,B19,B15,4,0)

Hope this help.  Register To Reply

4. ## Re: Secondary Loan Pricing Calculation (price of loan being bought/sold)

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  Register To Reply