Find Jobs
Hire Freelancers

Calculation of Annual Percentage Rate

$10-30 USD

Cerrado
Publicado hace alrededor de 7 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 12955090

Información sobre el proyecto

26 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
26 freelancers están ofertando un promedio de $22 USD por este trabajo
Avatar del usuario
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 en 1 día
4,8 (198 comentarios)
7,1
7,1
Avatar del usuario
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 en 2 días
4,9 (100 comentarios)
5,7
5,7
Avatar del usuario
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 en 2 días
4,6 (4 comentarios)
2,9
2,9
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,4
1,4
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
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 en 1 día
3,6 (1 comentario)
0,8
0,8
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
1,0
1,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I can help you with the formula. If you are interested please open a chat with me. Kind regards, Sorin
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm maths genius, will get your job done in no time!
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will do it within time and I am not able to see the attached sheet.. please share.. .
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRIA
Bad Erlach, Austria
5,0
10
Forma de pago verificada
Miembro desde ago 4, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.