1. Problem Definition
As I have mentioned in my previous blog (https://simatupangaace2014.wordpress.com/2013/10/18/w7_tom_-lease-vs-purchase-own-analysis-of-a-diesel-generator/) , I will try to simulate how Lease VS Purchase impacts the profitability (Profit and Loss Statement or P&L).
Continuing from previous blog, the case study is still a mini-mart business.
2. Development of Feasible Alternative
The simulation will be using Microsoft Excel which in my opinion is the best and the easiest software to generate an analysis.
3. Development Outcomes for Alternatives
The indicators I will use to compare how lease VS purchase giving impact to the P&L are:
Free Cash Flow For The Firm (FCFF)
Internal Rate of Return (IRR)
Net Present Value (NPV)
4. Selection of Criteria
To have the simulation (modeling) works, the step by step processes prior to generate the model are:
Prepare assumption of Sales per Month (Revenue) and assumption of annual incremental rate (%)
Prepare assumption of Expense per Month and assumption of annual incremental rate (%)
Prepare the assumption of Initial Investment (CAPEX)
Identify the economic life of the CAPEX
Period of Investment (years)
5. Analysis of the Alternative
After all the assumptions/inputs are being prepared and the next step is generate the Profit & Loss Statement Projection based on:
Purchase of CAPEX basis
Lease of CAPEX basis
Referring to my previous blog (https://simatupangaace2014.wordpress.com/2013/10/18/w7_tom_-lease-vs-purchase-own-analysis-of-a-diesel-generator/) , that I have compared Lease VS Purchase of Generator Set, further in this model I will try to simulate it in a Profit & Loss Projecttion.
Below are two (2) table showing the P&L Projection of Purchase Basis and Lease Basis:
Table 1 – P&L Projection Purchase of CAPEX (Generator Set) Basis
Table 2 – P&L Projection Lease of CAPEX (Generator Set) Basis
6. Selection of Preferred Alternative
Here are the financial ratios as the result of the simulation:
Table 3 – Financial Ratios
Based on the result, Purchase basis is the most preferred alternative in order to get a better NPV, IRR and earlier payback period.
7. Performance Monitoring & Post Evaluation Result.
In this modeling/simulation I encourage anyone who would like to start their business for not funding the investment through a bank loan. If you could not fund the business alone then asks for partnership from anyone you trust or start a smaller business based on your affordable scheme. In my opinion, bank interest gives more disaster than good deed therefore please thinks hundreds time before you decided to proceed for a bank loan.
For anyone who are interested for the excel file of this P&L Projection, please send your inquiry to: email@example.com and I will be very pleased to share it with you.
- Sullivan, W. G., Wicks, E. M., & Koelling, C. P. (2012). Engineering economy (15th ed.). Chapter 13 The Capital Budgeting Process, Leasing Decisions (pp. 539). Boston, MA: Prentice Hall.
- Sullivan, W. G., Wicks, E. M., & Koelling, C. P. (2012). Engineering economy (15th ed.). Chapter 7 Depreciation and Income Taxes, Property Class and Recovery Period (pp. 297-298). Boston, MA: Prentice Hall.
- Amos, S.J. (2012). Skills & Knowledge of Cost Engineering, 5th Edition Revised. In G. Levin (Ed.), Chapter 27, Basic Engineering Economics, Discount Factors (pp. 27.4). Morgantown, WV: AACE International.
WordPress.com, W7_TOM_Lease VS Purchase (own) Analysis of a Diesel Generator.
Retrieved on 24-Oct-13 from: https://simatupangaace2014.wordpress.com/2013/10/18/w7_tom_-lease-vs-purchase-own-analysis-of-a-diesel-generator/
WordPress.com, FCFF Definition.
Retrieved on 24-Oct-13 from: http://www.investopedia.com/terms/f/freecashflowfirm.asp