Excel application to
formulate project
FV FUNCTION
FV EXERCISE
FV EXERCISE
FVSCHEDULE FUNCTION
FVSCHEDULE EXERCISE
PV FUNCTION
PV EXERCISE
PV EXERCISE
NPER FUNCTION
NPER EXERCISE
NPER EXERCISE
IF FUNCTION
RATE EXERCISE
PMT FUNCTION
PMT EXERCISE
PMT EXERCISE
PPMT FUNCTION
PPMT EXERCISE
IPMT FUNCTION
IPMT EXERCISE
ISPMT FUNCTION
ISPMT EXERCISE
PMT, PPMT, IPMT EXERCISE
LOAN REPAYMENT PLAN
NPV FUNCTION
NPV EXERCISE
IRR FUNCTION
IRR EXERCISE
IRR EXERCISE
DEPRECIATION METHODS
SLN FUNCTION (Straight Line)
SLN EXERCISE
SLN EXERCISE
DB FUNCTION (Declining
Balance)
DB EXERCISE
DB EXERCISE
DDB FUNCTION (Double Declining
Balance)
DDB EXERCISE
DDB EXERCISE
VDB FUNCTION (Variable Declining
Balance)
VDB EXERCISE
VDB EXERCISE
SYD FUNCTION (Sum-of-Years’
Digits)
SYD EXERCISE
SYD EXERCISE
CHAPTER 2
GRAPHS AND CHARTS IN FINANCIAL
ANALYSIS
GOAL SEEK FUNCTION
GOAL SEEK FUNCTION (TARGET FUNCTION)
GOAL SEEK EXERCISE
GOAL SEEK EXERCISE
GOAL SEEK EXERCISE
GOAL SEEK EXERCISE
STEPS TO DRAW CHART IN EXCEL
STEPS TO DRAW CHART IN EXCEL
STEPS TO DRAW BREAKEVEN POINT CHART
DRAW NPV, T CHART
CHOOSE INVESTMENT PLANS BY USING
NPV
CHOOSE INVESTMENT PLANS BY USING
NPV
CHOOSE INVESTMENT PLAN BY USING
NAV
CHOOSE INVESTMENT PLANS BY
USING NAV
CHOOSE INVESTMENT PLANS BY USING
IRR
CHOOSE INVESTMENT PLANS BY
USING IRR
CHOOSE INVESTMENT PLANS BY USING
IRR
CHOOSE INVESTMENT PLANS BY USING
IRR
CHOOSE INVESTMENT PLANS BY USING
IRR
DATA TABLE FUNCTION
DATA TABLE EXERCISE
DATA TABLE EXERCISE
CHAPTER 5 LOOKUP FUNCTION
VLOOKUP FUNTION
HLOOKUP FUNTION
VLOOKUP, HLOOKUP EXERCISE
VLOOKUP, HLOOKUP EXERCISE
CASH FLOW EXERCISE
CASH FLOW EXERCISE
CASH FLOW (TOTAL CAPITAL)
(Indirect method)
Microsoft Project
application to
manage project
CHAPTER 6
MICROSOFT PROJECT INTRODUCTION
BASIC SETTING
BASIC SETTING
BASIC SETTING
BASIC SETTING
CHAPTER 7
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
SETTING PROJECT TIMELINE CALENDAR
CHAPTER 8
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
EXERCISES PRACTICE
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
SETTING PROJECT SCHEDULES TASKS
CHAPTER 9
PROJECT RESOURCE ALLOCATION
PROJECT RESOURCE ALLOCATION
PROJECT RESOURCE ALLOCATION
EXERCISES PRACTICE
EXERCISES PRACTICE
PROJECT RESOURCE ALLOCATION
PROJECT RESOURCE ALLOCATION
PROJECT RESOURCE ALLOCATION
PROJECT RESOURCE ALLOCATION
CHAPTER 10 PROJECT MONITORING
PROJECT MONITORING
PROJECT MONITORING
EXERCISES PRACTICE
PROJECT TASK MONITORING
EXERCISES PRACTICE
PROJECT TASK MONITORING
EXERCISES PRACTICE
PROJECT TASK MONITORING
PROJECT TASK MONITORING
EXERCISES PRACTICE
PROJECT RESOURCE
MONITORING
PROJECT TASK MONITORING
EXERCISES PRACTICE
PROJECT RESOURCE
MONITORING
EXERCISES PRACTICE
MONITORING PROJECT
EXERCISES PRACTICE
EXERCISES PRACTICE
