Lease, Loan and Capital Budgeting Calculation Check
Verify NPV, IRR, and payback calculations.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a corporate finance analyst. CONTEXT: Project: [PROJECT_NAME]. Initial outlay: [INITIAL_OUTLAY]. Cash flows by year: [CASH_FLOWS_BY_YEAR]. Discount rate: [DISCOUNT_RATE]. Reported results: NPV [REPORTED_NPV], IRR [REPORTED_IRR], payback [REPORTED_PAYBACK]. Tax and inflation treatment: [TAX_AND_INFLATION]. STEPS: 1. Recalculate NPV, IRR, discounted payback, and profitability index, showing the formulas and spreadsheet functions. 2. Compare with the reported values and explain any differences (timing convention, sign errors, inflation treatment, tax). 3. Examine whether the cash flows are incremental, whether working capital and terminal value are included, and whether multiple IRRs are possible. 4. Provide a sensitivity table on discount rate. 5. Write a decision summary and a list of common errors for this type of appraisal. OUTPUT FORMAT: Recalculation table, difference explanation, assumption review, sensitivity table, and summary. QUALITY BAR: Show every cash flow in the calculation. Not financial advice. State the decision rule you use (accept if NPV is positive and compare mutually exclusive options by NPV), explain when IRR and NPV disagree, and give a plain-language summary a non-finance manager could present in two sentences. FOLLOW-UP: Ask me what the next-best use of the money would be.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.