a. Planning Activities and Developing Budget Number
b. Budgeting Cycle
c. Output and report of Budgeting2. Microsoft Excel – Spreadsheet
a. Basic Purpose Of A Spreadsheet Program
b. Various Components Of The Excel
c. Purpose And Usage Of Excel’s Built-
a. Workbook and Worksheet Tricks
b. Data Analysis Tricks
c. Chart Tricks4. Cash Budget With Excel
a. Calculate total cash collections and disbursements
b. Calculate expected ending cash balance and short-
c. Determine the optimal timing of major cash expenditures.
d. Scenario Manager to evaluate different assumptions
a. Relevant cash flows in capital budgeting.
b. Calculating the after-
c. payback period, discounted payback, NPV, PI, IRR, and MIRR
d. Scenario analysis in Excel.
e. Excel’s Solver to determine optimal capital budget under capital rationing6. Forecasting Techniques
a. Percent of sales method is used to develop pro-
b. Financial Statements and how to construct such statements in Excel.
c. TREND function for forecasting sales or any other trending variables.
d. Regression analysis with Excel’s built-