ahaa
New Member
- Joined
- Jul 5, 2015
- Messages
- 1
- Reaction score
- 0
Hello everybody.
I am trying to do a financial modeling for the finance lease liabilities:
The lease amount is $ 500 in the first year and $ 250 in the third year
The annual lease payments are $ 100 for the first two years and $ 150 for the three years after.
The advance (upfront) payment is $ 50
The residual value is $60
Number of periods is 5
How can I calculate the below:
Net Cash Flow
IRR
Net Present Value.
Principal Lease payments
Interest Lease Payments
Your help is appreciated.
Thanks
I am trying to do a financial modeling for the finance lease liabilities:
The lease amount is $ 500 in the first year and $ 250 in the third year
The annual lease payments are $ 100 for the first two years and $ 150 for the three years after.
The advance (upfront) payment is $ 50
The residual value is $60
Number of periods is 5
How can I calculate the below:
Net Cash Flow
IRR
Net Present Value.
Principal Lease payments
Interest Lease Payments
Your help is appreciated.
Thanks