As discussed last Fri, the attachments is the comparison file to compare between buying asset and leasing asset.
Please study and expect to do the analysis by yourself in the future ka. Any questions, I'm very happy to explain ka.
1. Sheet ' Master w PMT' --> Use this one 2. Sheet ' No PMT' --> for your understanding and compare with #1
The different between this 2 sheets is the first one calculate in detail of rent is paid every month. The 2nd one is which leasing company normally shows with assumption that the leasing payment is paid in lump sum at the end of the yr, which is not perfectly correct as lease rental is paid on monthly basis.