Find Jobs
Hire Freelancers

Calculation of Annual Percentage Rate

$10-30 USD

Zamknięte
Opublikowano ponad 7 lat temu

$10-30 USD

Płatne przy odbiorze
In the attached file you can find an excel-file with a calculation of monthly instalments for a loan. The loan has a monthly fee. The calculation of the monthly installments is correct - the problem is the calculation of the Annual Percentage Rate (C5). I don´t know how to include the monthly fee to get the correct number. With the given numbers in row #2, the result must be 14,79%. So basically I need the right formula to get this number.
Identyfikator projektu: 12955090

Informację o projekcie

26 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
26 freelancerzy składają oferty o średniej wysokości $22 USD dla tej pracy
Awatar Użytkownika
I am an expert in math and statistics with a PhD degree. I've done many projects in business statistics, econometrics, and financial math. I understand exactly what you need and how do that. It would be my pleasure to complete your little project.
$20 USD w 1 dzień
4,8 (198 opinii)
7,1
7,1
Awatar Użytkownika
Hi I am an Engineering undergraduate with exceptional skills in mathematics. I can do this for you. Please message to discuss further on this Thanks Note-please check my profile for past projects and reviews.
$30 USD w 2 dni
4,9 (100 opinii)
5,7
5,7
Awatar Użytkownika
I’m an Engineer by Profession and also qualified in PMP and CIMA - Management Accounting, looking forward for an extra earning. Currently employed as a Project Manager by a HK based Energy Project Development Company. Being a new freelancer I value getting positive feedback and reviews from the employers. Hence ensure the deliverable to be within the scope, budget and time. I possess good skills in Ms Office package including Excel. Hence the work is simply doable. Further details regarding the work, I would like to be clarified over chat, in detail. Based on that the timeframe and milestones will be open for negotiation. Kindly note that I’ve placed a lower bid just because of the need to get the job, and can assure you that it won’t compromise on the quality of the deliverable. Looking forward for the project details and to be hired. Thank you,
$30 USD w 2 dni
4,6 (4 opinii)
2,9
2,9
Awatar Użytkownika
hello dear I am here to assist u for this project I have great exposure in excel can assist with u great regards, I am anACCA member currently working in finance dept f QatarAirways I cam generate reports for u and make any formula please share more info to proceed further Thanks
$20 USD w 1 dzień
5,0 (1 opinia)
2,0
2,0
Awatar Użytkownika
Hi, I am professional freelancer and student of theoretic informatics, I have several experience with mathematics. I can get you a formula you need. Hire me and you will get a TOP quality product! Regards, Bc. Martin Risa
$30 USD w 1 dzień
5,0 (1 opinia)
1,2
1,2
Awatar Użytkownika
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data from the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$15 USD w 1 dzień
5,0 (1 opinia)
1,4
1,4
Awatar Użytkownika
I am familiar with Excel and spreadsheet software as well as mathematical formulae. I have done many calculations with basic accounting such as compound interest and values of annuities. I will make a temporary copy of the spreadsheet to test out various formulas until the correct one is found. I will also research Annual Percentage Rates and how they are calculated when including monthly fees.
$20 USD w 3 dni
5,0 (1 opinia)
1,6
1,6
Awatar Użytkownika
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD w 1 dzień
3,6 (1 opinia)
0,8
0,8
Awatar Użytkownika
hi, you doing this totally wrong I am financial audit and let me fix it for you and send revised file PM if interested Thanks & Regards
$35 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Feel free to hire for: - Data entry - data processing - data scraping - Microsoft Office - Microsoft Excel I guarantee good quality of my work, so should a need for corrections arise after the project is completed, I will gladly do that for you.
$25 USD w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am an associate chartered accountant with more than five years practical experience in accounting, bookkeeping, and financial analysis. I am a lecturer in an ACCA and ICAN accredited center in Nigeria. I have taught advance financial management for more than five years. from your explanation the formula will not be far from annuities. I will discharge this job successfully if hired, clients satisfaction is my concerns
$15 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear client? I have read and understood what the project needs. With my good experience in this area, i believe i Will deliver good work and in time if awarded. Kindly contact me for more details. Thank you
$10 USD w 1 dzień
0,0 (0 opinii)
1,0
1,0
Awatar Użytkownika
Update: What I am getting from the info on the second row: APR: 13.9949 % Monthly Payment: $44.89 Total Payment: $538.71 Total Interest: $38.71 Hi, I hope you are doing well. I graduated from the University of Texas at Austin with a BS in Computer Science 10-11 months ago. I used a calculator, and I am getting aroun 14%, not 14.79. Extra fees is 5.4 = 0.45*12. Total loan is 500. Interest rate is listed as 11.95%. Number of months is 12. Please, contact me for further details. Feel free to ask questions. Thanks. Best, Dilnur
$25 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello, I can help you with the formula. If you are interested please open a chat with me. Kind regards, Sorin
$15 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I'm maths genius, will get your job done in no time!
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I have your solution. I can send you Mathematica 7.0 file or I can send you your Excel file extended with the proper formulas or both.
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I will do it within time and I am not able to see the attached sheet.. please share.. .
$20 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. Areas of expertise: • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP B1, ERP, Venture Capital system, CRM, etc.). • Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies. • Business valuation and ratios (NPV, IRR, DCF, ROA, ROE, MCDA, CPI, SPI, EVM, KPI, Monte Carlo technique). • Extensive experience in accounting, consolidating, forecasting, budgeting, and costing. • Budget Development & Management. • Business expansion and start-up. • I served as CFO, Controller, and Chief Accountant at global parent companies.
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$15 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi In actual it is 14.772216% to be precise. I have already figured it out. Let me know in case you want to discuss about how to reach to get it using the formulae I am CFA(US) and FRM expert. Let me know in case you need my help with any of the financial analysis. In Mathematics, I secured 100 out of 100 in every class Thanks and Warm Regards Girisha
$15 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRIA
Bad Erlach, Austria
5,0
10
Zweryfikowana metoda płatności
Członek od sie 4, 2013

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.