Hi Guys,
Looking to get this solved. Trying for hours to fix it, but not really sure how.
Task:
Trying to calculate a loan amortization schedule with multiple loans, which also include a interest only (IO) period. I also want to have the option to set multiple start dates for the different loans. The problem is that if i set a start month <>0, the IO period keeps being calculated from the beginning.
Goal:
is to have the IO period started, when the loan is scheduled to start.
Below the listed formula. Let me know if you need additional information to solve this problem. Help will be much appreciated.
Assumptions:
C6=Loan Amount
C10=Interest Rate
C11=Interest Only (Months)
C12=Amo. Period (Months)
C14=Loan Start (Month)
C18=Peridod Reference (1,2,3 etc.)
Formula:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}span.s2 {color: #006107}span.s3 {color: #ab30d6}span.s4 {color: #a54a29}span.s5 {color: #33af4a}span.s6 {color: #ff9c1b}</style>=IF(C$18<=$C$14,0,IF(C$18>$C$12+$C$11,0,1)*IF(AND($C$11>0,C$18+$C$14<$C$11+1),-($C$10/12)*$C$6,PMT($C$10/12,$C$12,$C$6)))
Looking to get this solved. Trying for hours to fix it, but not really sure how.
Task:
Trying to calculate a loan amortization schedule with multiple loans, which also include a interest only (IO) period. I also want to have the option to set multiple start dates for the different loans. The problem is that if i set a start month <>0, the IO period keeps being calculated from the beginning.
Goal:
is to have the IO period started, when the loan is scheduled to start.
Below the listed formula. Let me know if you need additional information to solve this problem. Help will be much appreciated.
Assumptions:
C6=Loan Amount
C10=Interest Rate
C11=Interest Only (Months)
C12=Amo. Period (Months)
C14=Loan Start (Month)
C18=Peridod Reference (1,2,3 etc.)
Formula:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}span.s2 {color: #006107}span.s3 {color: #ab30d6}span.s4 {color: #a54a29}span.s5 {color: #33af4a}span.s6 {color: #ff9c1b}</style>=IF(C$18<=$C$14,0,IF(C$18>$C$12+$C$11,0,1)*IF(AND($C$11>0,C$18+$C$14<$C$11+1),-($C$10/12)*$C$6,PMT($C$10/12,$C$12,$C$6)))
