Find Jobs
Hire Freelancers

Calculation of Annual Percentage Rate

$10-30 USD

Closed
Posted about 7 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 12955090

About the project

26 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average $22 USD for this job
User Avatar
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 in 1 day
4.8 (198 reviews)
7.1
7.1
User Avatar
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 in 2 days
4.9 (100 reviews)
5.7
5.7
User Avatar
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 in 2 days
4.6 (4 reviews)
2.9
2.9
User Avatar
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 in 1 day
5.0 (1 review)
2.0
2.0
User Avatar
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 in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
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 in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
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 in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
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 in 1 day
3.6 (1 review)
0.8
0.8
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
1.0
1.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can help you with the formula. If you are interested please open a chat with me. Kind regards, Sorin
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm maths genius, will get your job done in no time!
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do it within time and I am not able to see the attached sheet.. please share.. .
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRIA
Bad Erlach, Austria
5.0
10
Payment method verified
Member since Aug 4, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.