π Lecture 5 β Financial Forecasting and Financial Planning
π Overview: This lecture introduces the principles of financial forecasting and planning, explaining how businesses anticipate future financial needs and prepare for uncertainties. It covers the objectives of financial forecasting, the types of planning documents, and focuses primarily on the Percentage of Sales method as a simple yet widely used forecasting technique. Understanding these concepts is crucial for estimating future cash flows, asset investment needs, and external financing requirements.
ποΈ Topics Covered
The lecture outlines the objectives of financial forecasting, including reducing emergency costs and preparing for future opportunities. It then defines the three main planning documents: Cash Budget, Pro Forma Balance Sheet, and Pro Forma Income Statement. The core of the lecture is the Percentage of Sales method, which involves estimating sales growth, linking asset and liability changes to sales, forecasting retained earnings, and calculating discretionary financing needs. The lecture also covers the concept of Sustainable Growth Rate and concludes with the drawbacks of the Percentage of Sales method and a brief introduction to the Pro Forma Cash Flow Statement.
π Lecture Summary
Objectives of Financial Forecasting
Financial planning and forecasting cannot reduce uncertainty but help businesses acknowledge and prepare for future occurrences. The key objectives are to:
- Reduce the cost of responding to emergencies by anticipating future occurrences.
- Prepare to take advantage of future opportunities.
- Prepare contingency and emergency plans.
- Prepare to deal with possible outcomes.
Planning Documents
There are three types of documents prepared in a financial plan:
- Cash Budget
- Pro Forma Balance Sheet
- Pro Forma Income Statement
The term βpro formaβ refers to forecasting. These statements are prepared based on certain estimates.
Methods of Forecasting
Two common methods are used to prepare pro forma statements: β Percentage of Sales: Simple β Cash Budget: Detailed, more complicated
Percentage of Sales Method
This method estimates cash flows based on sales revenue. It involves three steps: Step 1: Estimate year-by-year Sales Revenue and Expenses. Step 2: Estimate Levels of Investment Needs (in Assets) required to meet estimated sales (using Financial Ratios). Step 3: Estimate the Financing Needs (Liabilities).
Revenues and expenses are estimated on a cash basis, rather than an accrual basis.
General Assumptions
Certain assumptions help establish the relationship between sales and balance sheet items:
- Current Assets: Generally grow in proportion to Sales. This includes cash, accounts receivable, and inventory. Marketable securities and prepaid expenses are independent of sales.
- Fixed Assets: Do not always grow in proportion to Sales. You must ask if you need to expand property, office, or factory space to achieve your Sales target. Small year-to-year changes in sales do not affect fixed assets.
- Current Liabilities: Also called Spontaneous Financing. Generally grow in proportion to Sales. If sales increase by 30%, current liabilities also increase by 30%.
- Long Term Liabilities: Also called Discretionary Financing. Do not grow in proportion to Sales.
Numerical Example β Cafeteria Business
Assume you are establishing a cafeteria. Sales Revenue is expected to grow from Rs 200,000 to Rs 300,000, and Expenses from Rs 50,000 to Rs 70,000 after 1 year.
π Formula: Sales Growth Rate = (Current Sales - Previous Sales) / Previous Sales β (300,000 - 200,000) / 200,000 = 0.5 = 50%
Expense growth rate = (70,000 - 50,000) / 50,000 = 40%
To estimate changes in investment and financing, ratios are calculated.
π Formula: Estimated Current Assets for Next Year = [Current Assets for Current Year / Current Sales] x Estimated Sales for Next Year
π Example: Assuming a current assets/sales ratio of 20 percent: Estimated current assets for next year = 300,000 x 0.2 = Rs 60,000. This assumes no change in fixed assets.
Forecasting Retained Earnings
Retained earnings are the amount of profit reinvested in the business. Forecasting this is crucial to identify cash shortfalls and assess external financing needs.
π Formula: Expected Estimated Retained Earnings = Estimated Sales x Profit Margin x Plowback Ratio
Where: Plowback Ratio = 1 - Payout Ratio Payout Ratio = Dividend / Net Income Profit Margin = Net Income / Sales
π Example: Assume profit margin is 25% and payout ratio is 50%: Estimated retained earnings = 300,000 x 0.25 x (1 - 0.5) = 75,000 x 0.5 = Rs 37,500. This means half the income is distributed to owners and half is reinvested.
π‘ Why this matters: This retained earnings figure will appear in the pro forma balance sheet and is a source of internal financing for growth.
Forecasting Discretionary Financing
Also known as external financing, this is the borrowing needed due to sales growth.
π Formula: Estimated Discretionary Financing = Estimated Total Assets β Estimated Total Liabilities β Estimated Total Equity
π Example: Estimated Total Assets = Rs 160,000 (assuming current assets of Rs 60,000 + initial fixed assets of Rs 100,000). Estimated Total Liabilities = Rs 0 (no liabilities assumed). Estimated Total Equity = Initial Investment (Rs 100,000) + Retained Earnings (Rs 37,500) = Rs 137,500. Estimated Discretionary Financing = 160,000 - 0 - 137,500 = Rs 22,500.
This is the amount of loan or equity financing needed.
Sustainable Growth Rate (G)
If you want to maintain forecasted financial ratios and not invest additional personal capital, the business can grow at a certain rate.
π Formula: G (Desired Growth Rate) = Return on Equity x (1 - Payout Ratio)
Where: Return on Equity = Net Income / Total Equity
Drawback of Percent of Sales Method
The method has several disadvantages:
- It is only a rough approximation and is not very detailed.
- If there is a change in fixed assets during the forecasted period, the method does not yield accurate results.
- The method does not account for lumpy assetsβassets that can only be acquired in large discrete units.
Pro Forma Cash Flow Statement
After preparing the pro forma income statement and balance sheet, a pro forma cash flow statement can be created. It is similar to an ordinary cash flow statement, but all figures are estimated.
π Example Pro Forma Cash Flow Statement (Rs β000):
| Item | Amount (Rs β000) |
|---|---|
| Net Income | 400 |
| Add Depreciation Expense | 100 |
| Subtract Increase in Current Assets: | |
| Increase in Cash | (400) |
| Increase in Inventory | (700) |
| Total Increase in CA | (1100) |
| Add Increase in Current Liabilities: | |
| Increase in A/c Payable | 500 |
| Cash Flow from Operations | (100) |
| Cash Flow from Investments | 0 |
| Cash Flow from Financing | 500 |
| Net Cash Flow from All Activities | 400 |
Notes:
- This uses the Indirect Cash Flow Approach.
- The final Net Cash Flow should match the difference in cash balances between two consecutive Balance Sheets.
- Investments include all cash sale and purchases of non-current assets and marketable securities.
- Financing includes all cash changes in loans, leasing, and equity.
β Key Takeaways
The core of financial forecasting is the Percentage of Sales method, which links most balance sheet items to sales growth. Current assets and current liabilities (spontaneous financing) are assumed to grow in direct proportion to sales, while fixed assets and long-term liabilities (discretionary financing) generally do not. The retained earnings forecast, calculated using the profit margin and plowback ratio, is a critical internal source of funding. The need for external or discretionary financing is then determined by subtracting estimated liabilities and equity from estimated total assets. Finally, a pro forma cash flow statement consolidates all these estimates to provide a projected view of cash inflows and outflows.
π§ Quick Revision Questions
- What are the three main types of planning documents prepared in financial planning?
- According to the Percentage of Sales method, which two categories of the balance sheet are generally assumed to grow in direct proportion to sales?
- A company has estimated sales of Rs 500,000. The profit margin is 15%, and the payout ratio is 40%. What is the estimated retained earnings?
- If a company's estimated total assets are Rs 2,000,000, estimated total liabilities are Rs 800,000, and estimated total equity is Rs 900,000, what is the estimated discretionary financing needed?
- List three specific drawbacks of the Percentage of Sales method for financial forecasting.
π Lecture 6 β Present Value and Discounting
π Overview: This lecture introduces the concept of present value and discounting, which are fundamental tools in financial management for comparing cash flows occurring at different points in time. It explains how to translate future cash flows into present terms using interest rates, and demonstrates the application of discounting in evaluating business investments and projects.
ποΈ Topics Covered
The lecture covers the concept of present value and discounting as methods to compare future cash flows with present ones by bringing them to a common point in time. It explains different types of interest rates used in discounting calculations, including nominal, periodic, and effective interest rates. The lecture also presents time and arrow diagrams for visualizing cash flows and concludes with a case study on calculating net present value for a business investment.
π Lecture Summary
Objectives of Present Value
The objective of calculating the present value is to translate future cash flows into present terms. The basic principle is to compare apples with apples. For instance, if you have Rs.10 in your pocket today and may have many rupees ten years after, how can you compare the two? You can do it only by comparing both amounts at the present time. We choose the present (today) as the most convenient point in time where we could compare all the cash flows taking place at various points in time in future. We must compare everything at the same point in time otherwise, we would be neglecting the Time Value of Money concept.
For example, Rs105 is more than Rs100 BUT; Rs105 after 1 year may not necessarily be more than Rs100 today! We first have to bring all cash flows to the Present, or Discount them, and then compare them.
Discounting
"Discounting is defined as bringing the future cash flow to the present time."
Before answering which amount is greater in the aforementioned example, we need to have some concept of interest rates or the cost of money. An interest rate can also be understood as an opportunity cost. One of the simple ways of estimating what opportunity cost or interest rate should be for our discounting calculations is to use interest rate given on the PLS accounts by the banks. For example, if money is deposited in a bank and getting 10% per annum then it is interest or opportunity cost for you. This interest on PLS account becomes minimum rate of return which any investment should be able to generate.
Opportunity cost essentially means the cost of taking up one option while sacrificing the other. For instance, when you deposit your money in the bank and get interest, you are sacrificing by (1) not consuming the money to buy something for yourself and (2) not investing your money elsewhere at a higher return than the bank interest.
π‘ Why this matters: The opportunity cost represents what you give up by choosing one investment over another, making it the minimum acceptable rate for any investment decision.
Interest Rates for Discounting Calculations
The lecture explains three types of interest rates:
Nominal (or APR) Interest Rate = i_nom
- It is usually published in newspapers. Annual Nominal Interest Rate is quoted for 1 year by Credit Card Companies and Leasing Companies because it understates the actual (or Effective) interest you have to pay.
Periodic Interest Rate = i_per Periodic interest rate is used in Financial Management for Discounting and Present Value (PV) calculations. It is defined as: π Definition β Periodic Interest Rate: The interest rate applied over a single compounding period, calculated by dividing the nominal rate by the number of compounding periods per year.
π Formula: i_per = i_nom / m Where m = no. of times compounding takes place in 1 year (e.g., if semi-annual compounding then m = 2)
Effective Interest Rate = i_eff It is very useful to compare securities and investments with different life or compounding cycles but not used for Discounting and PV. π Formula: i_eff = [1 + (i_nom / m)]^m β 1 Where m = no. of times compounding takes place in 1 year. The shorter the compounding cycle, the more frequently money is compounded & the faster the money grows.
Present Value Calculation Example
Coming back to our earlier example: Is Rs100 today worth more than Rs105 a year after, with a periodic interest rate of 10 percent per annum? When solving for present value, we are discounting from the future to the present.
π Formula: PV = FV / (1 + i)^n Where i = interest rate, n = no. of years
π Example: PV = 105/(1+0.10)^1 = Rs.95.45
Now we can see that if we discount Rs.105 from future to the present, its worth today is only Rs.95.45, which is less than Rs.100. Thus, Rs100 today is worth more than Rs.105 one year later. This conclusion is drawn on the assumption that interest rate is 10%, but if we change the interest rate, the answer might be different.
With help of time and arrow diagrams, we can observe the effect of discounting. If Rs105 are to be received after two years, the present value would be even lesser. As future cash flow occurs more distant in time, the more its present value decreases.
Time & Arrow Diagram
Time & Arrow Diagrams are important in visualizing the concept of Discounting:
- Cash inflows (income, other income & cash profits) shown with upward pointing arrow
- Cash outflows (expense) shown with downward pointing arrow
Discounting Cash Flows of a Business, Investment, or Project
There are two steps involved:
- Forecast future cash flows of any business, investment, or project by using percent of sales method.
- Discount the net cash flows back to the present time.
Cafe Case Study
Suppose you are thinking about starting a small cafΓ© or canteen inside a university campus. The Key Financial Data is as follows:
- Initial Investment = Rs 100,000
- Forecasted Cash Receipts (end Year 1) = Rs 200,000
- Forecasted Cash Payments (end Year 1) = Rs 50,000
- Forecasted Future Investment (end Year 1) = Rs 30,000
- Periodic Interest Rate (Opportunity Cost) = 10% p.a.
Cash Flow Diagram CafΓ© Example:
- Cash inflows: Receipts = Rs. 200,000 (upward arrow at Yr 1)
- Cash outflows: Initial Investment = Rs 100,000 (downward arrow at Yr 0)
- Cash outflows: Payments = Rs 50,000 (downward arrow at Yr 1)
- Cash outflows: Future Investment = Rs 30,000 (downward arrow at Yr 1)
The combined effect of the three arrows at Yr 1 can be represented by a single arrow: 200,000 - 50,000 - 30,000 = Rs 120,000. These different arrows can be added or subtracted because they are occurring at the same point of time.
π Simplified Net Cash Flow at Yr 1: Net Cash Receipts = CFβ = FVβ = 200,000 β 50,000 β 30,000 = Rs 120,000
Calculating the NPV of the CafΓ© Business for 1st Year
NPV = Net Present Value (taking Investment outflows into account)
π Formula: NPV = β Initial Investment + Sum of Net Cash Flows from Each Future Year NPV = β Iβ + PV(CFβ) + PV(CFβ) + PV(CFβ) + PV(CFβ) + ...+ β
Present Value of Net Cash Flow from Year 1: PV(CFβ) = CFβ / (1+i)^n = 120,000 / (1+0.1)ΒΉ = Rs 109,000
The value of money has shrunk from Rs.120,000 to 109,000 as the concept of time value of money suggests.
π NPV Calculation: NPV = β Iβ + PV(CFβ) = β100,000 + 109,000 = + Rs 9,000
The NPV of our Business after 1 Year is Positive Rs 9,000 which is a good sign.
β Key Takeaways
The fundamental purpose of discounting is to translate future cash flows into present terms so that cash flows occurring at different times can be compared fairly, accounting for the time value of money. The periodic interest rate, calculated as nominal rate divided by compounding frequency (i_per = i_nom/m), is the correct rate to use in discounting and present value calculations, not the effective rate. The opportunity cost of capital, such as bank PLS account returns, serves as the minimum acceptable rate for any investment, representing what is forgone by choosing one option over another. Future cash flows are worth less in present terms the further they occur in time, as demonstrated by the formula PV = FV/(1+i)^n, and any stream of future cash inflows and outflows occurring at the same point in time can be netted into a single figure before discounting. A positive Net Present Value (NPV), calculated as present value of future net cash flows minus initial investment, indicates a financially viable investment.
π§ Quick Revision Questions
- What is discounting and why is it necessary in financial management?
- What is the formula for calculating the periodic interest rate, and when is it used?
- In the cafΓ© example, what is the net cash flow at Year 1 and how is it calculated?
- Using the formula PV = FV/(1+i)^n, calculate the present value of Rs.200,000 to be received in 2 years at a 10% annual discount rate.
- What does a positive Net Present Value indicate about a business investment?
π Lecture 7 β Discounting Cash Flow Analysis, Annuities And Perpetuities
π Overview: This lecture continues the previous discussion on Net Present Value (NPV) and explores two fundamental cash flow patterns: annuities and perpetuities. It explains how to calculate the future and present values of these cash flow streams, using both annual and multiple compounding, and applies these concepts to practical financial decisions like lease vs. buy and retirement planning.
ποΈ Topics Covered
This lecture covers the concept of discounted cash flow analysis and the simplification of cash flow diagrams. It introduces the definition and types of annuities (ordinary annuity and annuity due) and their future and present value calculations under annual and multiple compounding. The session concludes with an explanation of perpetuities, including their formula and real-world examples such as consol bonds and retirement planning, with detailed numerical examples for lease financing and retirement savings.
π Lecture Summary
Discounted Cash Flows (DCF Analysis) Recap
The lecture begins by recapping the time-and-arrow diagram. Upward arrows represent cash inflows (receipts), and downward arrows represent cash outflows (payments or investments). Arrows at the same point in time can be added or subtracted to create a single Net Cash Flow Arrow. However, arrows at different points in time cannot be added or subtracted due to the time value of money.
π Definition β Net Cash Flow Arrow: A single arrow representing the net effect of all cash inflows and outflows at a specific point in time. π Example: At Year 1, Receipts = Rs. 200,000, Payments = Rs. 50,000, and Future Investment = Rs. 30,000. The Net Cash Flow = 200,000 β 50,000 β 30,000 = + Rs. 120,000.
Annuities
An annuity is a series of fixed payments made over a fixed number of years, over the lifetime of an individual, or both. Common examples include monthly rent, monthly mortgage payments, and insurance premiums.
There are two types of annuities:
- Ordinary Annuity (also known as deferred annuity): Consists of a series of equal payments at the end of each period.
- Annuity Due: Consists of a series of equal payments at the beginning of each period.
The value of an annuity depends on the Constant Cash Flows (CCF) over a finite period and the Discount Factor.
π Definition β Ordinary Annuity: An annuity where payments are made at the end of each period. π Definition β Annuity Due: An annuity where payments are made at the beginning of each period.
Future Value of an Annuity (Annual Compounding):
π Formula: FV = CCF * {[(1 + i)^n - 1] / i}
Where:
FV= Future ValueCCF= Constant Cash Flow per periodi= Interest rate per yearn= Number of years
Future Value of an Annuity (Multiple Compounding):
π Formula: FV = CCF * {[(1 + (i/m))^(m*n) - 1] / (i/m)}
Where:
m= Number of compounding periods per year (e.g., 12 for monthly, 4 for quarterly)
Present Value of an Annuity (Annual Compounding):
π Formula: PV = FV / (1 + i)^n
Where:
PV= Present Valuen= Life of the Annuity in number of years
Present Value of an Annuity (Multiple Compounding):
π Formula: PV = FV / [1 + (i/m)]^(m*n)
Perpetuity
A perpetuity is an annuity with an infinite life, making continual payments forever. The key difference between an annuity and a perpetuity is that a perpetuity is a never-ending stream of payments, while an annuity is for a limited period. A real-life example is a retirement plan where you save a sufficient amount to generate a steady, consistent return for as long as you live.
Future Value of a Perpetuity:
Since a perpetuity is never-ending, time is irrelevant and dropped from the equation. The formula is simpler:
π Formula: PV = CCF / i
Where:
PV= Present Value of the perpetuityCCF= Constant Cash Flow per periodi= Interest rate
π Definition β Perpetuity: A never-ending annuity, a perpetual or infinite stream of constant cash flows at regular intervals.
π‘ Why this matters: For a perpetuity whose cash flow is growing at a constant annual growth rate "g", the formula is: PV = CCF / (i - g). This is crucial for valuing stocks with growing dividends.
Numerical Examples
Example 1: Lease vs. Buy Decision (Annual Payments) Assume a car's market value is Rs. 150,000. A leasing company offers a lease at Rs. 120,000 per year for 2 years at a 20% pa nominal interest rate.
- Calculate Future Value (FV): Using the annuity formula for annual compounding.
FV = 120,000 * {[(1 + 0.2)^2 - 1] / 0.2}FV = 120,000 * {[1.44 - 1] / 0.2}FV = 120,000 * 2.2FV = Rs. 264,000
- Calculate Present Value (PV):
PV = 264,000 / (1 + 0.2)^2PV = 264,000 / 1.44PV = Rs. 183,333- Result: The present value of the lease payments (Rs. 183,333) is Rs. 33,333 more than the car's market value (Rs. 150,000), suggesting buying is cheaper.
Example 2: Lease vs. Buy Decision (Monthly Payments) A more realistic scenario: Car lease rentals are Rs. 10,000 per month for 2 years at 20% pa. Use multiple compounding (m=12).
- Calculate Future Value (FV):
FV = 10,000 * {[(1 + (0.2/12))^(12*2) - 1] / (0.2/12)}FV2 = Rs. 292,150
- Calculate Present Value (PV):
PV = 292,150 / (1 + 0.2/12)^(12*2)PV = Rs. 196,481- Result: The present value of the monthly lease payments (Rs. 196,481) is even higher than the annual payment scenario, reinforcing that leasing is more expensive in this example.
Example 3: Perpetuity β Retirement Planning You want an annual income of Rs. 200,000 forever from a bank account offering 10% pa. How much must you deposit?
- Formula:
PV = CCF / i - Calculation:
PV = 200,000 / 0.10 = Rs. 2,000,000 - Result: You need to deposit Rs. 2,000,000. This works because you only withdraw the interest earned each year (10% of Rs. 2,000,000 = Rs. 200,000), leaving the principal untouched. However, inflation erodes the real value of money, so the real return is lower (e.g., interest rate - inflation rate).
Example 4: Perpetuity β Consol Bonds Consol Bonds were issued by the British Government in the 18th century to consolidate past debts. They have no maturity, paying regular interest forever.
- Calculation: If interest rate is 10% and annual interest payment is Β£1,000:
PV = 1,000 / 0.10 = Β£10,000
β Key Takeaways
The most critical concepts from this lecture are the ability to differentiate between annuities (finite series of payments) and perpetuities (infinite series). You must memorize the formulas for calculating the future and present values of both, under both annual and multiple compounding conditions. The fundamental principle of time value of moneyβthat cash flows at different points in time cannot be added or subtractedβis non-negotiable. Finally, the formula for a growing perpetuity (PV = CCF / (i - g)) is a foundational concept for valuing assets like stocks with growing dividends, and you must understand how inflation impacts the real return of a perpetuity.
π§ Quick Revision Questions
- What is the key difference between an Ordinary Annuity and an Annuity Due?
- A 5-year annuity pays Rs. 50,000 at the end of each year. What is the formula to calculate its Future Value if the annual interest rate is 12%?
- Explain why the formula for the present value of a perpetuity is simpler than that of an annuity.
- In the lease vs. buy example, why did the monthly payment scenario result in a higher present value than the annual payment scenario?
- If a perpetuity pays Rs. 10,000 per year and the interest rate is 5%, what is its present value? What if the cash flow grows at 2% per year?
π Lecture 8 β Capital Budgeting and Capital Budgeting Techniques
π Overview: This lecture introduces capital budgeting, the process of evaluating investments in fixed assets. It covers the importance of capital budgeting for shareholder wealth maximization and presents five key techniquesβPayback Period, Return on Investment (ROI), Net Present Value (NPV), Profitability Index (PI), and Internal Rate of Return (IRR)βused to assess the financial viability of projects.
ποΈ Topics Covered
This lecture begins by explaining the concept of capital budgeting as a decentralized function involving multiple departments in large corporations. It then outlines five capital budgeting techniques: Payback Period, Return on Investment (ROI), Net Present Value (NPV), Profitability Index (PI), and Internal Rate of Return (IRR). Each technique is explained with its formula, an example using a cafΓ© business, and a discussion of its advantages and limitations, with special emphasis on NPV and IRR.
π Lecture Summary
Capital Budgeting
Capital budgeting is about investment in fixed assets, which depreciate over time and need replacement. It is a decentralized function in big corporations where different departments work on different aspects. The biggest challenge in capital budgeting is finding projects that add value to the firm, i.e., projects with positive net present value that maximize shareholders' wealth.
π‘ Why this matters: Companies operate in efficient markets where good business ideas are quickly imitated, so careful capital budgeting is essential to identify valuable projects before opportunities disappear.
Payback Period
In this technique, we try to figure out how long it would take to recover the invested capital through positive cash flows of the business.
π Definition β Payback Period: The length of time required to recover the initial investment from the project's cash flows.
π Formula: No formula β calculated by summing cash flows until initial investment is recovered
π Example: CafΓ© with initial investment of Rs. 200,000, earning Rs 10,000 per month in Year 1 and Rs 20,000 per month in Year 2
- Year 1 recovery: Rs 10,000 Γ 12 = Rs 120,000
- Remaining: Rs 200,000 - Rs 120,000 = Rs 80,000
- Year 2 recovery rate: Rs 20,000 per month
- Time to recover remaining: Rs 80,000 Γ· Rs 20,000 = 4 months
- Payback Period = 16 months
The shorter the payback period, the more attractive the project. However, this method does not take into account the concept of time value of money β cash flows are considered regardless of when they occur.
Return on Investments (ROI)
In capital budgeting, Return on Investment implies the annual average cash flow a business is making as a percentage of investment.
π Formula: ROI = (βCF/n) / Iβ Where:
- βCF = Sum of cash flows over the project life
- n = Number of years
- Iβ = Initial investment
π Example: CafΓ© with Iβ = Rs 200,000, CFβ = Rs 120,000 (Rs 10,000 Γ 12), CFβ = Rs 240,000 (Rs 20,000 Γ 12) ROI = ((120,000 + 240,000)/2) / 200,000 = 180,000 / 200,000 = 0.90 = 90%
A high ROI is considered better, but like payback period, it does not account for time value of money.
Net Present Value (NPV)
Net Present Value is defined as the value today of the Future Incremental After-tax Net Cash Flows less the initial investment. NPV uses the discounting process to account for time value of money.
π Formula: NPV = -Iβ + β [CFβ / (1+i)α΅] Where:
- CFβ = Cash flows occurring in different time periods
- -Iβ = Initial cash outflow (always negative)
- i = Discount/interest rate
- t = Year in which the cash flow takes place
π Example: CafΓ© with Iβ = Rs 200,000, i = 10% (required rate of return), CFβ = Rs 120,000, CFβ = Rs 240,000 NPV = -200,000 + 120,000/(1+0.10) + 240,000/(1+0.10)Β² = -200,000 + 109,091 + 198,347 = +Rs. 107,438
Since NPV > 0, the project should be accepted. When comparing projects, the one with the higher NPV should be accepted. Investing in projects with positive NPV raises shareholders' wealth and company value.
Profitability Index (PI)
Also called the cost-benefit ratio, Profitability Index is defined as the ratio of the present value of future cash flows to the initial investment.
π Formula: PI = [β CFβ / (1+i)α΅] / Iβ
π Example: CafΓ© PI = [120,000/(1+0.1) + 240,000/(1+0.1)Β²] / 200,000 = (109,091 + 198,347) / 200,000 = 307,438 / 200,000 = 1.54
Projects with PI β₯ 1.0 are acceptable. Projects acceptable by NPV method are also acceptable by PI criteria. When ranking, the project with the highest PI is acceptable.
Internal Rate of Return (IRR)
IRR is a widely used measure quoted in terms of percentage, making it comparable to market interest rates or inflation rates. It is the break-even rate of return at which we recover the initial investment in the project's lifetime.
π Formula: NPV = -Iβ + CFβ/(1+IRR) + CFβ/(1+IRR)Β² + ... = 0 (Solve for IRR where NPV equals zero)
Key distinction: In NPV, the discount rate (i) is the required rate of return we expect the project to generate. In IRR, we use existing cash flows to find the forecasted return.
π Example: CafΓ© Step 1: Try IRR = 10% NPV = -200,000 + 120,000/1.1 + 240,000/1.21 = +107,438 (too high)
Step 2: Try IRR = 50% NPV = -200,000 + 120,000/1.5 + 240,000/2.25 = -13,333 (too low)
Step 3: Through trial and error, IRR β 43.6% gives NPV β -48 (close to zero)
The higher the IRR, the better. IRR is calculated by trial and error or iteration method.
β Key Takeaways
The five key capital budgeting techniques are Payback Period, ROI, NPV, PI, and IRR. Payback Period and ROI are simple but ignore the time value of money. NPV is the most important criterionβit uses discounting to determine the present value of future cash flows minus initial investment, and projects with positive NPV increase shareholder wealth. PI is similar to NPV and projects with PI β₯ 1.0 are acceptable. IRR is the discount rate that makes NPV equal to zero, representing the break-even return; it is found through trial and error. For the exam, remember that NPV and IRR are preferred over simpler methods because they account for time value of money.
π§ Quick Revision Questions
- What are the five capital budgeting techniques discussed in this lecture, and what is the main weakness of the first two?
- Calculate the Payback Period for a Rs 300,000 investment with cash flows of Rs 50,000 per month in Year 1 and Rs 75,000 per month in Year 2.
- What is the decision rule for accepting a project under NPV, and why does accepting positive NPV projects increase shareholder wealth?
- Calculate the Profitability Index for a project with an initial investment of Rs 500,000 and expected cash flows of Rs 200,000 in Year 1 and Rs 400,000 in Year 2 at a discount rate of 12%.
- How does the interpretation of 'i' differ between NPV and IRR calculations?
π Lecture 9 β NET PRESENT VALUE (NPV) AND INTERNAL RATE OF RETURN (IRR)
π Overview: This lecture is the foundational core of capital budgeting in financial management. It provides a detailed examination of the two most important investment appraisal criteriaβNet Present Value (NPV) and Internal Rate of Return (IRR)βincluding their formulas, interpretations, and the critical differences between them. Understanding these concepts is essential for making investment decisions that maximize shareholder wealth.
ποΈ Topics Covered
The lecture covers the Net Present Value (NPV) formula, its importance in achieving the objective of financial management (shareholder wealth maximization), and a detailed example of NPV calculation for a Savings Certificate. It then introduces the Internal Rate of Return (IRR), its calculation using trial and error, and the key interpretational difference from NPV. The lecture concludes with a graphical comparison of the NPV Profiles for two investments (Savings Certificate vs. Bank Deposit) to demonstrate ranking conflicts and introduces the concept of Cross-Over IRR, followed by macro and micro aspects of IRR interpretation, including inflation, risk-free rate, ROA/ROE, and WACC.
π Lecture Summary
Net Present value (NPV):
The Net Present Value (NPV) is the most important skill and criterion in capital budgeting. The core idea is to bring back each future cash flow to the present time using a discount rate and then add or subtract them. The project or investment offering the highest NPV gets the highest rank. Calculating NPV is difficult because inputs like future cash flows, project life, and discount rates are based on forecasts and subjective choices.
π Definition β Net Present Value (NPV) : The difference between the present value of future cash inflows and the present value of the initial cash outlay (investment). It represents the value added by undertaking the investment today.
π Formula: NPV = -Io + Ξ£ CFt / (1+i)^t = -Io + CF1/(1+i) + CF2/(1+i)^2 + CF3/(1+i)^3 + ...
β Plain-English meaning: Subtract the initial investment (Io) from the sum of all future cash flows (CFt) that have been discounted back to their present value using the required rate of return (i).
Importance of NPV in terms of objectives of Financial Management:
There is a direct link between shareholder wealth maximization and NPV. When a companyβs management invests in positive NPV projects, they increase the Economic Value Added (E.V.A) and the Market Value Added (M.V.A) , thus increasing the value of the company and, consequently, the shareholders' wealth.
π Definition β Positive NPV: A project where the present value of future cash flows is greater than the initial investment, resulting in a positive NPV value. This indicates the project is expected to generate value and increase wealth. π‘ Why this matters: Positive NPV projects directly create value for shareholders, fulfilling the primary objective of Financial Management.
π Example: You invest Rs 100,000 in a Savings Certificate. After 1 Year, you receive a coupon payment of Rs 12,000 and reclaim your initial investment (principal) of Rs 100,000. The required rate of return (i) is 10%.
- Step 1: Variables: Io = Rs 100,000, CF1 = Rs 12,000, CFI1 = Rs 100,000, n = 1 year, i = 10%.
- Step 2: Solve NPV:
NPV = -100,000 + 12,000 / (1+0.10) + 100,000 / (1+0.10)NPV = -100,000 + 10,909 + 90,909NPV = + Rs 1,818 - Result: NPV is positive, so the investment is acceptable.
- Note: PV = NPV + Io = 1,818 + 100,000 = Rs 101,818.
Internal Rate of Return or IRR:
IRR is a very popular capital budgeting criterion because it provides a simple answer in the form of an annual percentage, which can be compared to inflation, cost of capital, or financial ratios. Its formula is similar to NPV but solves for the discount rate that makes the NPV equal to zero. IRR represents the Break-even Return on Investment.
π Definition β Internal Rate of Return (IRR) : The discount rate (i) at which the Net Present Value (NPV) of a project equals zero. It is the forecasted or intrinsic rate of return of a project, derived from the project's cash flow pattern.
π Formula: NPV = 0 = -Io + Ξ£ CFt / (1+IRR)^t
β Plain-English meaning: Find the interest rate that makes the present value of all future cash flows exactly equal to the initial investment.
π Example: Using the same Savings Certificate example (Io = 100,000, CF1 = 12,000, CFI1 = 100,000), set NPV to 0 and solve for IRR.
0 = -100,000 + [(12,000 + 100,000) / (1+IRR)]
(1+IRR) = 112,000 / 100,000
IRR = 1.12 - 1.00 = 0.12 = 12% per annum
Graphical IRR Estimation Using "NPV PROFILE":
The relationship between NPV and the discount rate (i) is downward sloping: as the discount rate increases, the NPV decreases. The point where the NPV line crosses the horizontal x-axis (where NPV = 0) is the IRR for the project. This graphical technique is useful when the project life is longer than 2 years, for solving polynomial equations, and for comparing the sensitivity of different investments' NPVs to changes in the discount rate.
RANKING TWO DIFFERENT INVESTMENTS:
When choosing between mutually exclusive (can choose only one) and independent (cash flows not linked) investments, NPV and IRR criteria are used. For a Bank Deposit of Rs 100,000 at 10% interest compounded annually for two years:
- NPV Calculation:
FV = 100,000 x (1.10)^2 = 121,000NPV = -100,000 + 10,000/(1.1) + 11,000/(1.1)^2 + 100,000/(1.1)^2 = + Rs 826 - IRR Calculation: Solving
0 = -100,000 + 10,000/(1+IRR) + 111,000/(1+IRR)^2yields IRR = 10.5% per annum. - Comparison: | Criteria | Savings Certificate | Bank Deposit | |----------|--------------------|--------------| | NPV (i=10%) | + Rs 1,818 | + Rs 826 | | IRR | 12% pa | 10.5% pa |
The Savings Certificate is the better investment as it has both a higher NPV and a higher IRR.
Graphical Comparison of 2 Investments "CROSS-OVER IRR":
The NPV Profiles of two investments can intersect at a Cross-Over Point. At this point (IRR = 8.8% in the example), the NPV of both investments is equal. The slope of an investment is steeper if larger cash flows occur later in time. If the discount rate (i) is less than the Cross-Over IRR, the ranking of the two investments based on NPV would be different from the ranking based on IRR.
Investment Criteria - IRR Interpretation - Macro Aspects
- Inflation: An IRR considered low in a medium-inflation country like Pakistan may be considered high in a low-inflation country like the USA.
- Risk Free Rate of Return: In Pakistan, the Government T-Bill rate (7% to 12% pa) is used as the benchmark. An IRR should be compared against this risk-free rate to assess its attractiveness.
Investment Criteria - IRR Interpretation (Micro Aspects)
- ROA & ROE: A new project's IRR should match or exceed the returns (ROA or ROE) of the investorβs existing business. However, ROA and ROE are accounting ratios based on net income and book value, while IRR is based on cash flows and market value.
- Weighted Average Cost of Capital (WACC) or Hurdle Rate: If an investor uses borrowed money, the IRR of a new project must exceed the WACC (cost of financing, e.g., 18% pa in Pakistan). When IRR exceeds WACC, the excess return represents a surplus that increases shareholders' wealth.
β Key Takeaways
A student must remember that NPV and IRR are the two most critical criteria in capital budgeting, both based on the concept of time value of money. The NPV formula discounts future cash flows by an externally specified discount rate (e.g., cost of capital), and a positive NPV directly increases shareholder wealth. In contrast, the IRR is the discount rate that makes the NPV zero, representing the project's intrinsic rate of return calculated from its cash flows. When ranking two independent projects like a Savings Certificate and a Bank Deposit, the one with the higher NPV and higher IRR is typically preferred, but ranking conflicts can arise at the Cross-Over point on the NPV Profile. Finally, for interpretation, IRR must be evaluated against macro factors like inflation and risk-free rates, and micro factors like the firm's existing ROA/ROE or its WACC, ensuring the project generates a surplus over the cost of capital.
π§ Quick Revision Questions
- Write the general formula for Net Present Value (NPV) and explain what each variable represents.
- A project requires an initial investment of Rs 500,000 and is expected to generate a single cash flow of Rs 580,000 after one year. If the required rate of return is 12%, calculate the NPV. Is the project acceptable?
- What is the fundamental difference between the discount rate used in NPV and the discount rate found in IRR?
- Define "Cross-Over IRR" and explain what it implies when comparing the NPVs of two projects.
- Briefly explain how the Weighted Average Cost of Capital (WACC) is used as a criterion for interpreting the Internal Rate of Return (IRR).