The course tackles primarily aspects of the investment policies and financing policies and secondarily touches also the divided policy.

You can have two main approaches in evaluating an investment (fixed assets, non-financial) done by a company, derived from two financial statements. One is the cash flow approach, looking at time value of money and other concepts such as NPV, IRR and phasing of cash-flows. The other one is the P&L approach. Both have advantages and drawbacks and are more suited to specific situations.

On the credits side we have the common fixed installments credit, a bit of financial mathematics and clarifications in calculating the principal and interest payments included in each installment. Last but not least we talk about residual value / leasing complications that can add up to the complexity of a credit. Also we talk about the subtleties of credits with installments at the end (more common) and at the beginning (less common) of the period and how to pinpoint the outstanding from which we derive the interest rate to the correct period.

How can Excel help us, now that we know about the financial mathematics behind, in producing a payment schedule.

Do mind the interpretations and understandings various people might have about the word "investment". Within business but also in your private life between private persons.