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

Dmenyon

New Member
Joined
Jun 15, 2022
Messages
2
Office Version
  1. 365
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.
 
Last edited by a moderator:

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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
ABCDEF
1contract450 000 €year1-81 438,66 €
2years5year2-85 510,59 €
3perc5%year3-89 786,12 €
4year4-94 275,43 €
5year5-98 989,20 €
6total-450 000,00 €
Blad1
Cell Formulas
RangeFormula
F1:F5F1=PPMT($B$3,ROW(),$B$2,$B$1)
F6F6=SUM(F1:F5)
 
Upvote 0
??? Can't help you with such a description.
450.000 $ / 5 years = 90.000 $ / year with 3 vendors = 30.000 $ / vendor / year.
 
Upvote 0

Forum statistics

Threads
1,216,075
Messages
6,128,662
Members
449,462
Latest member
Chislobog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top