Spreadsheet to Amortize Multi-Year Prepaid Agreement, expensed once a year.

[Dmenyon]

I am trying to design a workbook that would calculate an annual expensed amount, for a multi-year prepaid agreement. We have a $450,000 five year subscription and software contract, and would like to design a spreadsheet that would amortize and track the annual (once a year) expense.

 

[BSALV]

that's not that difficult, but the description isn't 100%.
Do you want to pay 450.000 during 5 years with what interest rate ? Are you paying the the beginning or the end of the year, ...

Map1
	A	B	C	D	E	F
1	contract	450 000 €			year1	-81 438,66 €
2	years	5			year2	-85 510,59 €
3	perc	5%			year3	-89 786,12 €
4					year4	-94 275,43 €
5					year5	-98 989,20 €
6					total	-450 000,00 €
Blad1

Cell Formulas
Range	Formula
F1:F5	F1	=PPMT($B$3,ROW(),$B$2,$B$1)
F6	F6	=SUM(F1:F5)

 

[Dmenyon]

No interest. We have about three different vendors.

 

[BSALV]

??? Can't help you with such a description.
450.000 $ / 5 years = 90.000 $ / year with 3 vendors = 30.000 $ / vendor / year.