Lease Ammortization

Topics related to universal accounting principles and best practices, local GAAP, audit, laws and regulations affecting financial reporting, and other financial reporting topics.
This is also the appropriate forum for beginners to ask any questions, even if they pertain to IFRS.
Post Reply
ahamid1987
Posts: 3
Joined: 02 Aug 2022, 13:37

Lease Ammortization

Post by ahamid1987 »

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
User avatar
Marek Muc
Site Admin
Posts: 3228
Joined: 15 Oct 2018, 17:21
Contact:

Re: Lease Ammortization

Post by Marek Muc »

What's the prize? :lol:
ahamid1987
Posts: 3
Joined: 02 Aug 2022, 13:37

Re: Lease Ammortization

Post by ahamid1987 »

:D

there were three different cases in this assignment. i have not been able to solve this one.
Leo
Posts: 908
Joined: 05 Apr 2020, 22:31

Re: Lease Ammortization

Post by Leo »

Is this an ACCA exam question ?
JRSB
Trusted Expert
Posts: 1309
Joined: 01 Mar 2020, 01:10
Location: UK

Re: Lease Ammortization

Post by JRSB »

:lol:
ahamid1987
Posts: 3
Joined: 02 Aug 2022, 13:37

Re: Lease Ammortization

Post by ahamid1987 »

NO
Post Reply