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

  • Thread starter Thread starter Beanman
  • Start date Start date
B

Beanman

The CUMIPMT and CUMPRINC always result in too long an amort period so loan
fee is not fully amortized by maturity.
 
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

CUMIPMT with balloon payment 5
Calculate Loan Term 1
How do I change the loan period in a amortization from years to mo 7
Finding Cumulative Interest 2
CUMPRINC Function 5
how do i create funciton values_entered in excel 1
How do I change the values in loan amortization 2
how do I figure out mortgage payment term? 3

Back
Top