Fix current Excel documets

$10-30 AUD

Dalam Kemajuan

Disiarkan 24 hari yang lalu

$10-30 AUD

Dibayar semasa penghantaran

Medical Loans Products 1) Medical Business secured Loan A 3% monthly interest rate on a loan means that every month, the amount of interest charged on the loan will be 3% of the remaining loan balance. (I Must be able to edit) see attached document Medical_Loan_Calculator 2 Example Calculation: Let’s break it down with an example: Loan Amount (Principal): $1,000 Monthly Interest Rate: 3% First Month: Interest for the first month = $1,000 × 3% = $30 New loan balance after interest = $1,000 + $30 = $1,030 Second Month: Interest for the second month = $1,030 × 3% = $30.90 New loan balance after interest = $1,030 + $30.90 = $1,060.90 And this process continues, with the interest being calculated based on the new balance each month. 2) Unsecured interest-only loan Interest-Only Payments: Principal Repayment: After the interest-only period ends (often 3-12 months), you’ll be required to start paying off the principal, and your monthly payment will increase significantly. (I Must be able to edit) see attached document Medical_Loan_Calculator 2 Example: Let’s say you take out an $10,000 interest-only loan at a 18% annual interest rate for 3 months, with the interest-only period lasting for 1 years. During the Interest-Only Period: Loan amount: $10,000 Monthly payment = $10,000 × 18% = $ 1800 (This is only the interest portion) During this period, you pay $1800 each month, but you don’t reduce the principal. After the Interest-Only Period (let’s say the full principal is due after 3 months): Once the interest-only period ends, you will start repaying the principal (the $10,000 loan) plus interest. Depending on the loan terms, you could pay it off in equal monthly payments or as a lump sum at the end of the agreement. If you were to pay it off in equal installments, the loan might change to a traditional amortizing loan. So, after 3 months interest-only payments, you would owe the full $10,000 principal, which you’ll start paying back in addition to the interest. IMPORTANT Reply with whats wrong with the interest Rate in the Doc

ID Projek: 40313652

Tentang projek

7 cadangan

Projek jarak jauh

Aktif 24 hari yang lalu

Ingin menjana wang?

Alamat e-mail

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@eshA0010

I'm Eyesha, an Excel expert dedicated to transforming data chaos into structured clarity. With extensive experience in financial analysis and knowledge of advanced Excel functions like Macros and Visual Basic for Applications (VBA), I am uniquely positioned to help fix the issues in your medical loan templates and elevate them to functional and reliable tools. Your project demands a deep understanding of numerical theories like interest calculation, and I bring that to the table. As you've generously shared the current template ('Medical_Loan_Calculator 2') and invited my scrutiny, I assure that I'll meticulously comb through the document to identify any errors or irregularities in the formulas used for interest rate calculation. This way, we'll not only fix the attachment but also ensure its functionality for future editing as you have highlighted. From intelligently cleaning your data to creating comprehensive dashboards that can reveal actionable insights at a glance, my skill set complements the task at hand. Choose me if you desire an experienced, accountable, and dependable professional who prioritizes accurate data representation and timely completion of tasks. Looking forward to unlocking potential within your medical loan products for an effective financial journey.

$20 AUD dalam 1 hari

5.0

(22 ulasan)

4.8

7 pekerja bebas membida secara purata $21 AUD untuk pekerjaan ini

@saba106

I am an expert statistician, Research Writer, and data analyst with more than eight years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time series prediction models, working with survey data, conducting marketing analysis, building estimators, and medical analysis. I am a perfect match for your project share other details of the work so I can start working on your project. Will complete task on time.

$20 AUD dalam 1 hari

4.9

(49 ulasan)

5.5

@jepita200

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categorical data project effectively and efficiently. I have extensive experience in collecting, cleaning, analyzing, and visualizing data using Python programming, an invaluable asset for a project of this nature. Additionally, I am well-versed with CRISP-DM framework and adept at identifying patterns within datasets Choosing me means benefitting from not only my expertise but also my personal approach to projects. I understand that each task is unique, requiring tailored skills, and so I'm willing to go the extra mile to provide you with results that meet and exceed your expectations. Let's join forces in this project as our combined strengths will surely produce a result that's efficient, elegant and insightful! Let's not waste any more time! Together, we can mine this data efficiently and answer the questions to achieve your goals. Best Regards, Thanks

$20 AUD dalam 1 hari

4.9

(24 ulasan)

4.9

@Bhartifreelancer

Hello, As an experienced professional in Accounting and Data Analysis, I am confident that I possess the skills necessary to fix your current Excel documents with precision and efficiency. Having worked on a multitude of complex formulas and calculations, just like those required for your medical loan products, I am comfortable editing and working with intricate spreadsheets. Rest assured, any interest rate errors you're facing will be resolved. My ability to optimize documents for Excel while ensuring their precision and clarity can help ensure that your medical loan calculators are not just fixed but also better suited to attracting the right target audience. I bring creativity not just to words, but also to numbers: this combination allows me to create more effective communication tools. Best regards Bharti

$30 AUD dalam 1 hari

4.5

(41 ulasan)

4.9

@swatijain5558

Hello there, thank you for considering my proposal for the Medical Loans Products project. I have reviewed the attached document, Medical_Loan_Calculator, and am confident in my ability to provide you with a comprehensive and editable solution for both the Medical Business secured Loan and Unsecured interest-only loan products. I am experienced in financial calculations and can ensure accuracy and efficiency in developing the necessary tools to support your loan products. Regards, CA. Swati Jain, CPA | Indian CA & CS

$10 AUD dalam 4 hari

5.0

(15 ulasan)

4.5

@KirubaNadarajan

Hi there, There is an error in the interest calculation: • The 18% annual rate is being treated as a monthly rate. Correct monthly interest should be 18% ÷ 12 = 1.5%, not 18%. So for $10,000: • Correct monthly interest = $150, not $1800. I can fix the calculator, ensure accurate formulas for both loan types, and make it fully editable. Ready to start. Best regards.

$30 AUD dalam 1 hari

5.0

(13 ulasan)

4.0

@umarabbasi095

Hi, I can fix your existing Excel documents and make them fully functional and editable for both secured loans with monthly compounding interest and unsecured interest-only loans. Approach Medical Business Secured Loan Correct the formula so the monthly interest (3% in your example) is applied to the remaining balance each month. Automatically calculate and display the updated balance month by month. Editable fields for principal, interest rate, and loan duration. Unsecured Interest-Only Loan Set up the interest-only period calculation with separate principal repayment after the interest-only months. Editable fields for principal, interest rate, interest-only period, and total loan term. General Improvements Clear formatting for readability Editable input cells and locked formulas where needed Optional: a summary table or ch

$20 AUD dalam 1 hari