excel for finance

Hello, Kindly, help with this task: I want to use Microsoft excel to show loan payment at the beginning of every month, by first creating a schedule for the last 2 months of a draw period of a line of credit (LOC) loan using the average daily balance method with a fixed APR. For example, a file...

Hi all , We are working on an finance calendar where we need the formula to ignore weekends and holidays when we are calculating the day an item is due. for example we have an item due day 7th business day. So that would be 7 business days. So in the case of January Day 1 would be January 2nd...

There are five particulars in summary sheet, and i want data accordingly from RCU MIS Sheet. Particular: 1. Date (C2) - I want data here as per data from RCU MIS, let's say if i select 03-03-2017 then No. and Value should be populated as per RCU MIS data. 2. MTD Sum (E2) - Here MTD stands for...

Hi Guys I am sort of good at using excel for finance function for my job purpose. However I have come across some VBA enabled excel sheets which do excellent job. I would like to learn how to code VBA. I have started reading a book on VBA learning. It would be great if you can give me some...