Have financing offers reviewed

I can gladly upload my Excel tonight, in which I have recreated something like this. But I am still at the company and therefore cannot access the file.

I couldn’t edit my post anymore somehow... unfortunately, I can’t upload any Excel file here. If anyone is interested, feel free to contact me via private message.

Couldn’t edit my post anymore somehow... unfortunately can’t upload Excel here. If anyone is interested, feel free to contact me via PM.

PM has been sent

Couldn't edit my post anymore somehow... unfortunately can't upload any Excel here. Anyone interested can gladly contact me via PM.

But a PDF

But it is an Excel with formulas into which I enter my data and thus get calculated values output. That works rather poorly as a PDF.
But we could clarify everything via DM.

So in Excel you can easily calculate annuities yourself, see below. But why don’t you use the convenient online calculators that calculate monthly, generate a payment plan, and even consider special repayments etc. (e.g. google Zinsen-berechnen de / hypothekenrechner.php).

EXCEL formula for annuities:
PMT(rate, nper, pv, [fv], [type])

[*]rate Required. The interest rate per period (payment period).


[*]nper Required. Specifies over how many periods the respective annuity (rent) is paid. ("nper" = number of payment periods)


[*]pv Required. The present value or the total amount that a series of future payments is worth at the present time. This value is also called "loan amount." (pv = present value)


[*]fv Optional. The future value (final value) or the cash balance you want to have after the last payment. If the argument fv is omitted, the value 0 (zero) is assumed, i.e., the final value of a loan is equal to 0. (fv = future value)

but why don’t you use the convenient online calculators that calculate monthly, create a payment plan, and can even take into account special repayments etc. (e.g. google Zinsen-berechnen de / hypothekenrechner.php).

Because I don’t know anyone that cannot consider irregular special repayments and "skip years".