kthompson1
New Member
- Joined
- Sep 15, 2017
- Messages
- 2
Hello, I'm using a calculation example from accounting guidance related to direct financing leases. There is a monthly rent payment that is fixed for 9 years (10,000 per year) and an initial net investment amount of $65,100. At the end of the 9 years, the lease will have a residual value of $5,260. I can use a simple formula to calculate the net investment at the end of each year by taking the previous net investment amount less the difference between the monthly rent payment and the monthly interest income. However, I need to somehow calculate the monthly interest income to a) be a consistent percentage of the previous years' net investment and b) result in $5,260 net investment at the end of the 9 year lease. The example result is 8%, essentially an amortization rate. As a result A=5,208; B=4,825; C=4,411; D=3,964; E=3,481; F=2,959; G=2,395; H=1,787; I-1,130.
The issue is I need the formula to then calculate the monthly interest income on an actual lease I'm entering into.
[TABLE="width: 655"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Monthly Rent Payment[/TD]
[TD]Monthly Interest Income[/TD]
[TD]Net Investment at end of period[/TD]
[/TR]
[TR]
[TD]Beg.[/TD]
[TD]$ -[/TD]
[TD]$ -[/TD]
[TD]$65,100[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10,000[/TD]
[TD]A[/TD]
[TD]AA=651000-(10000-A)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10,000[/TD]
[TD]B[/TD]
[TD]BB=AA-(10000-B)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10,000[/TD]
[TD]C[/TD]
[TD]CC=BB-(10000-C)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10,000[/TD]
[TD]D[/TD]
[TD]DD=CC-(10000-D)[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10,000[/TD]
[TD]E[/TD]
[TD]EE=DD-(10000-E)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10,000[/TD]
[TD]F[/TD]
[TD]FF=EE-(10000-F)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10,000[/TD]
[TD]G[/TD]
[TD]GG=FF-(10000-G)[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10,000[/TD]
[TD]H[/TD]
[TD]HH=GG-(10000-H)[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10,000[/TD]
[TD]I[/TD]
[TD]5,260.00
[/TD]
[/TR]
</tbody>[/TABLE]
1 The rate for amortizing the unearned income and initial direct costs to produce a constant periodic rate of return on the
remaining net investment is X%. This can only be determined by trial and error or by using a computer program.
2 This is the unguaranteed residual value at the end of the lease term.
Thank you for any help!
The issue is I need the formula to then calculate the monthly interest income on an actual lease I'm entering into.
[TABLE="width: 655"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Monthly Rent Payment[/TD]
[TD]Monthly Interest Income[/TD]
[TD]Net Investment at end of period[/TD]
[/TR]
[TR]
[TD]Beg.[/TD]
[TD]$ -[/TD]
[TD]$ -[/TD]
[TD]$65,100[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10,000[/TD]
[TD]A[/TD]
[TD]AA=651000-(10000-A)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10,000[/TD]
[TD]B[/TD]
[TD]BB=AA-(10000-B)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10,000[/TD]
[TD]C[/TD]
[TD]CC=BB-(10000-C)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10,000[/TD]
[TD]D[/TD]
[TD]DD=CC-(10000-D)[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10,000[/TD]
[TD]E[/TD]
[TD]EE=DD-(10000-E)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10,000[/TD]
[TD]F[/TD]
[TD]FF=EE-(10000-F)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10,000[/TD]
[TD]G[/TD]
[TD]GG=FF-(10000-G)[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10,000[/TD]
[TD]H[/TD]
[TD]HH=GG-(10000-H)[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10,000[/TD]
[TD]I[/TD]
[TD]5,260.00
[/TD]
[/TR]
</tbody>[/TABLE]
1 The rate for amortizing the unearned income and initial direct costs to produce a constant periodic rate of return on the
remaining net investment is X%. This can only be determined by trial and error or by using a computer program.
2 This is the unguaranteed residual value at the end of the lease term.
Thank you for any help!