📚 PASS Investment Adviser (Level 1) Difficulty: Beginner ℹ️ Info   ~5 min read
📌 Chapter 2.2 — Calculate the following

Imagine you are reviewing a debt restructuring proposal for a mid-cap manufacturing firm in Pune. The client is comparing two loan options: one requires monthly interest payments at the end of each month, while the other—a premium commercial line—requires payments at the beginning of each period. As an analyst, your task is to determine the true cost of capital for these structures. While most beginners default to the standard ‘ordinary annuity’ assumption, a professional understands that the timing of a cash flow is just as critical as the amount itself.

In financial modeling, the ’type’ argument in Excel’s PV or PMT functions is the gatekeeper of precision. Setting the type to 0 defaults to an ordinary annuity, where the payment occurs at the end of the period. Setting it to 1 shifts the valuation to an annuity due, reflecting payments at the start of the period.

This subtle toggle changes the present value calculation because it accounts for the fact that a payment made today cannot earn interest for that initial period, whereas a payment delayed to the end of the period retains earning potential.

Consider an equipment lease agreement valued at ₹50,00,000 with a monthly rental of ₹1,00,000 at a 12% annual discount rate. If the contract mandates payments at the start of the month, the present value of those liabilities will be higher than if payments were made in arrears. Failing to adjust this setting in your valuation model leads to a systematic underestimation of lease liabilities, which can distort your debt-to-equity ratio analysis and jeopardize your recommendation to the investment committee.

This nuance becomes even more pronounced in retirement planning for Indian clients, particularly when evaluating life insurance annuities or pension products. Many retail financial products structure premiums as annuities due to minimize the insurer’s credit risk.

If you are projecting the corpus required for a client to receive ₹20,000 per month for twenty years, choosing the correct type in your spreadsheet is not merely an academic preference; it is the difference between a realistic financial plan and one that leaves the client facing a liquidity shortfall in their later years. Precision in these foundational calculations establishes your credibility as an advisor capable of distinguishing between superficial figures and economic reality.

Nuance

⚠️ Nuance
Candidates often assume that the difference between an ordinary annuity and an annuity due is negligible over long periods, but this is a dangerous misconception. Because of the power of compounding, even a single period’s worth of interest difference is magnified over a long term. An analyst should always verify the specific contract language regarding payment timing, as the ’type’ setting acts as a critical lever for sensitivity analysis in valuation models.

Check Your Understanding

Practice Question 1

An analyst is valuing a series of 120 monthly insurance premium payments of ₹5,000 each. The contract states that the first payment is due immediately. To calculate the present value of these premiums using Excel, which function configuration is required?

Practice Question 2

How does the selection of an annuity due (type = 1) versus an ordinary annuity (type = 0) affect the calculated Present Value (PV) of a set of cash outflows, assuming a positive discount rate?

This is a companion read for Section 2.2 — Calculate the following from PASS Investment Adviser (Level 1) by Akhilesh Gururani, available on Amazon Kindle.

Copyright © 2026 HABSG Consulting