Find Jobs
Hire Freelancers

Calculation of Annual Percentage Rate

$10-30 USD

Fechado
Publicado há aproximadamente 7 anos

$10-30 USD

Pago na 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 do Projeto: 12955090

Sobre o projeto

26 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
26 freelancers estão ofertando em média $22 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
4,8 (198 avaliações)
7,1
7,1
Avatar do Usuário
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 em 2 dias
4,9 (100 avaliações)
5,7
5,7
Avatar do Usuário
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 em 2 dias
4,6 (4 avaliações)
2,9
2,9
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
2,0
2,0
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
1,2
1,2
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
1,4
1,4
Avatar do Usuário
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 em 3 dias
5,0 (1 avaliação)
1,6
1,6
Avatar do Usuário
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 em 1 dia
3,6 (1 avaliação)
0,8
0,8
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
1,0
1,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I can help you with the formula. If you are interested please open a chat with me. Kind regards, Sorin
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I'm maths genius, will get your job done in no time!
$30 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I will do it within time and I am not able to see the attached sheet.. please share.. .
$20 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRIA
Bad Erlach, Austria
5,0
10
Método de pagamento verificado
Membro desde ago. 4, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.