Here we will be illustrating application of MS Excel and VBA in preparation of balance sheet and schedules.