Excel VBA - Loan Calculator
Lenders and borrowers need some quick reference tool that tells them how much the borrower will be required to pay in fixed installments for a loan of a given amount, interest and repayment period. The calculation is based on a formula found in finance text textbooks which is also included in excel as the pmt function. The problem with the formula is that it is not easy to understand and apply for the non-finance people. This macro solves the problem by enabling the user to make the calculation easily without bothering about the details of the various parameters of the formula. The other problem is that in certain countries the law does not allow the employer to deduct more than two thirds of the gross salary of an employee even though the employee, the employer and the lender are all in agreement because the employee has to be left with something to live on. This macro determines whether the employee is qualified for a loan based on this rule.
About Me
Hello. I am good at customizing excel to solve your business problems. I can do excel VBA macros and VBA solutions to make your office tasks easier . I do prepare financial models and projections that making business decision making easy. Please check out samples of my work from the portfolio section of this profile. Kind Regards, Martin.
$ 15 USD/hr
NEW FREELANCER!
