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.

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

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.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1