Contents:
Case Study
(The Scenario - Comprehensive Practical Example); Paper Industry has been selected for demonstration
Putting Inputs/ Assumptions
Taking all aspects into account whether related to costs or sales or cash flow etc
All workings will be based on these inputs and all sheets will be integrated
Allow customization to users
Costing
Material (Paper, Tissue and Card) [As per paper cutting according to copy size as well as taking paper weight to work out number of copies to be prepared]
Labor (Taking all rates relating to multiple steps required by the labor)
FOH (For the sake of simplicity calculated with relation to labor cost)
Budgeting
Projected Profit & Loss Statement (Alongwith necessary schedules)
Projected Cash Flow Statement
Projected Balance Sheet (Alongwith necessary schedules)
Financial Analysis: Ratio Analysis; Horizontal Analysis; Vertical Analysis; Charts
Analysis of Profitability (Selected Product): Sales, Costs, and GP by Month
Production Schedule for a Proposed Production Line: To get maximum profit taking raw material constraints into account
Analysis of Min. Acceptable Price: Analyzing C.M. and Profit at different prices by using Data Table
Assessing Alternatives: Taking NPV of Cash Flow after Tax; Work out Equivalent Annual Value
Lease Vs. Loan: Preparation of Amortization Table; Considering NPV of both to decide the best option
|