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