Arie Bos
Board Regular
- Joined
- Mar 25, 2016
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
As a non-financial guy, I am struggling a bit with the following:
I want to calculate a lease-back situation:
Which is the correct function to use to calculate the monthly amount to have paid back the 1,000,000 after 60 months? There are so many functions in excel, but without proper understanding of financial models, I don't know which one to use for this.
Many thanks,
Arie
I want to calculate a lease-back situation:
- amount: 800,000
- interest: 5%
- Years: 5 (but could vary)
Which is the correct function to use to calculate the monthly amount to have paid back the 1,000,000 after 60 months? There are so many functions in excel, but without proper understanding of financial models, I don't know which one to use for this.
Many thanks,
Arie