Excel file for calculating monhtly credit rates

If you go to [login to view URL] and click on “Probiere unseren Ratenrechner” you will find a calculator for small loans (up to € 1.500). In this calculator you can choose the credit amount (Betrag) and the monthly rate (Monatliche Rate) and you get as a result the number of rates (Laufzeit) and the total amount (Rückzahlung), as well as the amount of the last rate (Letzte Rate), which is smaller than the others.

What I need is a simple excel file with a “reverse calculator” with exactly the same conditions. So there I can type in the credit amount and the number of rates and get as results the monthly rates, the last rate and the total amount. The results have to be identical with the results from the calculator I linked above.

Here are the conditions of the loan:

- number of rates is up to 23 months

- first two months are interest free, after that the borrowing rate is 13,99% per year

Skills: Excel, Mathematics

See more: creation excel file, convert excel file address book, read excel file javascript, loan repayment schedule excel download, how to calculate total payments in excel, how to calculate total interest paid in excel, how to calculate loan amount in excel, excel loan payment template, loan interest calculator excel formula, loan calculator excel reducing balance, loan payment formula excel, php create mysql excel file, program sort excel file, search excel file vbscript, pdf image excel file, save datagrid excel file, translate excel file french english, create excel file visual, contact excel file, excel file dog breeds

About the Employer:
( 11 reviews ) Bad Erlach, Austria

Project ID: #17621204

Awarded to:


I have excellent command on MS Excel and can create the calculator as required. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet au More

$30 USD in 1 day
(79 Reviews)

28 freelancers are bidding on average $29 for this job


Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I have more than 5 More

$100 USD in 1 day
(299 Reviews)

Hello Sir Im excel vba expert :) i can make calculator in excel like your web Sir please give me this job and im able to start working today

$30 USD in 1 day
(336 Reviews)

Hi, I am an Excel expert and can create an easy-to-use Excel sheet to perform loan calculations as described by you. Thanks Soni

$25 USD in 1 day
(131 Reviews)

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

$20 USD in 1 day
(40 Reviews)

Hi there, I am keen to help you here. Look forward to hear from you. Thanks, RRC

$100 USD in 7 days
(50 Reviews)

I am an Excel guru who likes challenges and problem solving. I am confident that I could accomplish this task faster than others so feel free to contact me so we can discuss more about this project

$25 USD in 1 day
(84 Reviews)

hi! let me help you with your project. Just award the project to me and I will make it happen for you. thanks

$25 USD in 1 day
(23 Reviews)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis More

$30 USD in 1 day
(17 Reviews)

Hi, Good Day! i'm sorry if my bid is a little bit high but it is negotiable. Can you message me and let's see if we can agree on your budget I am a VBA Macro developer and has strong knowledge in MS Excel formulas More

$20 USD in 1 day
(19 Reviews)
$30 USD in 1 day
(8 Reviews)

Hello, I am an Excel expert working in banking industry. I could write the file you desired with reasonable price. Please pm me for further discussion about the details. Thank you!

$15 USD in 3 days
(9 Reviews)

I have experience working with excel and VBA, I can help you to create this calculator on excel and you will be satisfied with the final result

$30 USD in 10 days
(1 Review)

hey employer, i can build this project with the help of formulas in excel and also make it more interactive .you can see my recently completed work in excel . thanks regards

$15 USD in 1 day
(1 Review)
$15 USD in 1 day
(0 Reviews)

It is an easy task for the one knowing excel formulas and how to use them. I am offering my services for this task. Feel free to contact me. Best regards Petar

$25 USD in 1 day
(0 Reviews)

worked as an finance executive in four wheeler showroom and done work like this before, and i am ready to spend all my time until the project get finished.

$15 USD in 1 day
(0 Reviews)
$15 USD in 1 day
(0 Reviews)

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Thanks.

$15 USD in 1 day
(1 Review)
$20 USD in 7 days
(0 Reviews)

Hi I believe I should be able to complete this project fairly quickly I may need a little extra information regarding how you want to manipulate the monthly interest on the first two payments but otherwise it is defini More

$15 USD in 3 days
(0 Reviews)