How do I compute effective yield in Excel when there is a balloon

B

Beanman

The CUMIPMT and CUMPRINC always result in too long an amort period so loan
fee is not fully amortized by maturity.
 
F

Fred Smith

What formula are you using?
Give us an example of what you want solved, including the answer you are
looking for.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Loan amortization Excel X for Mac 10.1.6 1
Calculate Loan Term 1
How do I change the loan period in a amortization from years to mo 7
Finding Cumulative Interest 2
Excel PRICE function: How does it compute Issue Date of the Security 5
Title row to stay in place when scrolling down 2
When amortising a loan based using an IRR rate, the total interestpaid fall short. 0
Excel templates for loan amortization 1

Top