Input: Receipts & Payments. Functions to be used: Data validation, Audit Toolbar, âfxâ â functions, Conditional Formatting, Combo Boxes, Controls, Scenarios, Goal Seek, Auto Correct. Expected Output: Income Statement Input: Cash Flows. Functions to be used: FV, NPER, PMT, PV, TYPE, Expected Output: NPV, IRR, ROI
Input: Share Prices. Functions to be used: Graph, Trend Setting. Expected Output: Trend line Input: Share Prices.Functions to be used: CAPM Functions Expected Output: Beta value and Trend line
Input: Cash Flows. Functions to be used: Solver Parameters Expected Output: Ranking based on Pay-back period Input: Various Costs. Functions to be used: Goal Seek. Expected Output: DOL, DFL and DCL; BEP graph
Input: Summarized Income Statement. Functions to be used: Goal Seek Expected Output: EPS, EPS growth rate Input: Inventory data. Functions to be used: Scenarios Expected Output: EOQ, Max level, Min level, Graph
Input: Opening and Closing Receivables. Functions to be used: Min, Max. Expected Output: Aging Schedule Input: Cash flows. Functions to be used: Auto correct Expected Output: Cash Budget
Reference Book:
1 Bodhanwala.R.J Financial Management using Excel Spreadsheet Taxmann Publication 2010 3rd ed.
Text Book:
1 Bodhanwala.R.J Financial Management using Excel Spreadsheet Taxmann Publication 2010 3rd ed.