Loan Calc

[John McCabe]

Had DOS program that would do the loan amortization with totals every
December for each year. Have amortization schedules but would like to have
one like the old DOS report.. could start in any month but give totals
every December. Anything like that , could not see one on MS Excel site..

 

[Kevin B]

If you're working in Excel 2003 there's a loan amortization template that's
part of the standard install.

Click FILE in the menu and select NEW, and in the TASK pane click the ON MY
COMPUTER icon in the TEMPLATES panel of the window.

Click the SPREADSHEET SOLUTIONS tab of in the dialog box and select the LOAN
AMORTIZATION template.

A fill-in the blanks form is displayed and after you enter all of the
required information the loan schedule is generated.

 

[John McCabe]

I saw that one - looking to have it total after December as in start 6, 2007
and sub total after December. THEN pick up Jan. 08 thru Dec. 08, subtotal
and carry on to the next year. For year end audits it would be the final
answer.

 

[joeu2004]

I saw that one - looking to have it total after December as in start 6, 2007
and sub total after December.  THEN pick up Jan. 08 thru Dec. 08, subtotal
and carry on to the next year.

Just as I understood your initial inquiry. I am not aware of any
template that does that. In fact, I would think that a template like
that would be difficult (to say the least) to design, unless we use a
macro to generate the amortization schedule, or unless the annual
totals could be in separate table, not interspersed among the monthly
schedule.

You could custom-design an amortization schedule for your loan. But I
suspect that is not what you want. Alternatively, you could create a
macro to do the job, as I mentioned. If you have some knowledge of
how to write a macro, you could use the Record Macro feature to learn
what needs to be done in a loop.

Does any of this sound like a direction you would like to go in? Or
are you looking for a turn-key solution; that is, all you need to do
is "turn the key", like a template?

 

[John McCabe]

Of course wanted "turn key" template.
All financials require current and long term debt so totals at end of every
year would do that. Also it makes the annual interest easy since a total
line would include that.
can do "record" macro and give it a try. Not my favorite but have done
several in the past. Thank you for suggestions - will try the record macro
and just dress it up from there. Again thank you for your help on it..

I saw that one - looking to have it total after December as in start 6,
2007
and sub total after December. THEN pick up Jan. 08 thru Dec. 08, subtotal
and carry on to the next year.

Just as I understood your initial inquiry. I am not aware of any
template that does that. In fact, I would think that a template like
that would be difficult (to say the least) to design, unless we use a
macro to generate the amortization schedule, or unless the annual
totals could be in separate table, not interspersed among the monthly
schedule.

You could custom-design an amortization schedule for your loan. But I
suspect that is not what you want. Alternatively, you could create a
macro to do the job, as I mentioned. If you have some knowledge of
how to write a macro, you could use the Record Macro feature to learn
what needs to be done in a loop.

Does any of this sound like a direction you would like to go in? Or
are you looking for a turn-key solution; that is, all you need to do
is "turn the key", like a template?

 

[joeu2004]

can do  "record" macro and give it a try.  Not my favorite but have done
several in the past.

Nor mine. Just a way to see how to do certain things, like
formatting.

 Thank you for suggestions - will try the record macro and just dress
it up from there.   Again thank you for your help on it.

I'm a little mired down with "work" at the moment; otherwise, I would
be more helpful.

If you still do not have a good solution by Friday, check back here or
send email to joeu2004 "at" hotmail.com. I'm sure I will have
implemented something basic by then, if no one else has posted a good
solution.