Develop A Finance Calculator

Completed Posted Mar 10, 2015 Paid on delivery
Completed Paid on delivery

We wish to provide a range of lending options to businesses with Principal and Interest loans ranging from 3 months to 18 months. Principle is repaid on Rule of 78 basis. We wish to market a flat interest rate (eg 10% for 12 months, or 6% for 6 months) but have a user friendly calculator that shows both the "flat interest rate" and the "Annual Finance Rate". Input variables will be: term in months/amount/flat rate/fees - output will be AFR - including fees or AFR excluding fees. An option to alternatively put in the AFR and solve for flat rate would be desirable. The attached file shows flat rate calculations for 6 & 12 months - we need something similar that can also have a variable term and a variable fee (example just has a fixed $50 fee).

Excel Mathematics

Project ID: #7285406

About the project

11 proposals Remote project Active Mar 13, 2015

Awarded to:

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am t More

$30 NZD in 2 days
(108 Reviews)
6.3

11 freelancers are bidding on average $41 for this job

javed1705

I am an ACCA (UK) professional , APA and Mcom finance. Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing sa More

$36 NZD in 0 days
(54 Reviews)
5.7
best4best

I am an Excel expert. I have understood your requirement and can create an easy-to-use Interest Rate Calculator for both the options.

$36 NZD in 1 day
(88 Reviews)
5.5
sambestsolutions

Hi I am an Electronic and telecommunication engineer with exceptional skills in mathematics. I am also experienced in excel for more than 3 years. I can help you. Please message to discuss further on this. Thanks More

$51 NZD in 1 day
(64 Reviews)
5.1
gokulanand

Hello, I think I can get this done. Please ping me if you are interested, I have some questions too. Thanks

$50 NZD in 0 days
(36 Reviews)
4.9
raghav1101

Hi, I would love to work on this project. I am a chartered accountant (CPA equivalent) student with my result awaited for the degree. I have 8 years of experience in Microsoft Excel including working with excel modeli More

$50 NZD in 2 days
(37 Reviews)
4.7
TonmoyRoy111

Dear Sir, I can accomplish the job for you. I am an Electrical Engineer, have a sound knowledge in Mathematics. I have also carried out a number of excel related projects using formulas and macros. Kindly contact me More

$36 NZD in 1 day
(12 Reviews)
3.0
touqeerqamar

Hello, I have seen your project and offering my services. I already have prepared calculation sheet like this. Contact through PM enabling me to show my sample working. Hope you will like it. Thanks!

$30 NZD in 1 day
(7 Reviews)
1.8
swatiag1101

Hi, I am an Excel expert and an MBA in Finance as well. I can build the Calculator to provide lending options to your clients. I will provide for an input page where you can enter / change variables, and a separa More

$44 NZD in 2 days
(3 Reviews)
1.0
mc22fl

Please review the portfolio Fee calculator. File is already done for your review. If you are satisfied with calculation I can handover the file right away. If you want to discuss the formula I can share that as well. More

$31 NZD in 0 days
(0 Reviews)
0.0
moneymagicwa

I already have an Excel spreadsheet that calculates the reducible interest paid on a monthly basis on financed car loans etc. Therefore, at any given time you will know what the payout figure is. It will need a few adj More

$61 NZD in 3 days
(0 Reviews)
0.0