One loan payment ends...another begins!

  • On the 'Cash Flow' tab, Column G contains loan amounts until completed. Payback period can be adjusted through the 'Data Input' tab. The loan payments in Column G are calculated by a loan calculator found in the Debt P&I tab. When the initial loan is complete in Column G, there is a residual amount owing that must now be financed using a separate loan calculator at tab 'Debt P&I (2). The second loan start line in Column H in the 'Cash Flow' tab, must begin on the line just after loan one is complete in Column G. The loan payment in Column H must run for the specified payback period set by the loan calculator and as input in the 'Data Input' tab. I can attach the entire spreadsheet so that this can be visualized if someone believes that this can be accomplished.

  • Hello,

    You did guess it ... :smile:

    A picture is a totally inert object ... pretty useless ...

    Why don't you attach your file ...:wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!