al l u need is the interest rate now. then

来源: fanfan88 于 2008-09-22 16:56:50 [] [博客] [旧帖] [给我悄悄话] 阅读数 : (418 bytes)
回答: Fanfan88, please come in, Thank you! 由 liveinca 于 2008-09-22 13:53:59

in the spreadsheet, input the respective data under: date, annual lease payment, interest, payment of net lease excluding interest, lease liability

then, the schedule is done.

for your reconciliation, each year:
1. the interest+payment of net lease excluding interest=each installment $716.93(assumed it is yearly payment);
2. the total payment of net lease excluding =total lease liability

所有跟帖： 

• ok i give u an example: -fanfan88- ♀ 给 fanfan88 发送悄悄话 fanfan88 的博客首页 (934 bytes) () 09/22/2008 postreply 17:32:29

• i cannot write them in one line. u can merge all the line 1 -fanfan88- ♀ 给 fanfan88 发送悄悄话 fanfan88 的博客首页 (39 bytes) () 09/22/2008 postreply 17:34:14

• by the way, i think the lease of ur company does not bear any in -fanfan88- ♀ 给 fanfan88 发送悄悄话 fanfan88 的博客首页 (236 bytes) () 09/22/2008 postreply 18:02:31

请您先登陆，再发跟帖！