Hi All,
could you please try and solve the below mentioned question in excel. We cannot use PMT formula.
• Asset cost = 100,000
• Contract terms = 48 months
• Annual interest rate
o 9% (for installments 1 to 6)
o 8.5% (for installments 7 to 16)
• Re-payment frequency = Quarterly in Advance
• RV = 10,000 and receivable at the end of contract
• Down payment = 8,000
• Security deposit = 50,000
• Start day of the contract = 15th February 2018
• Asset useful life = 60 months
• Rental numbers 9~10 and 13~16 should be double in amount as compared to rental numbers 1 to 8 with the exception of rental number 11 & 12 which are of fix amount i.e. 5,500 each (e.g. if rental numbers 1 to 8 are 5,000 each then rental numbers 9, 10, 13, 14, 15 & 16 should be 10,000 each)
• Use of XLS Goal Seek is prohibited for rental calculation
Lease Ammortization
Re: Lease Ammortization
What's the prize?
-
- Posts: 3
- Joined: 02 Aug 2022, 13:37
Re: Lease Ammortization
there were three different cases in this assignment. i have not been able to solve this one.
Re: Lease Ammortization
Is this an ACCA exam question ?