
Completed
Posted
Paid on delivery
I need an amortization schedule for a 2 loans. The payments should be set up on a monthly basis. The schedule should include: - Principal and interest breakdown - Remaining balance after each payment - Cumulative interest paid Ideal skills and experience: - Experience with financial calculations - Proficiency in spreadsheet software (Excel, Google Sheets) - Attention to detail
Project ID: 40733727
36 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi I'll build the monthly amortization schedules for both loans with a clear principal/interest split, remaining balance after every payment, and running cumulative interest. I'll keep the loan inputs separate from the schedule formulas, so the amounts, rate, or term can be changed later without rebuilding the sheet. Before handoff, I'll verify the payment calculations and confirm each schedule reaches the correct ending balance and that the principal totals reconcile. I can prepare it in Excel, or Google Sheets if that's more convenient. Just send the principal amount, interest rate, term, and first payment date for each loan and I can start from there. Thanks, Belal
$15 USD in 1 day
0.0
0.0
36 freelancers are bidding on average $18 USD for this job

Hi, I’m a CPA, CBA, and MBA-qualified accounting professional with 6+ years of experience in bookkeeping and QuickBooks Online, including high-volume transaction processing, multi-bank reconciliations, and month-end close. I regularly work with QBO bank feeds to reconcile bank and credit-card accounts, clear unmatched and outstanding transactions, investigate discrepancies, and ensure QuickBooks balances agree with actual bank statements. I also review the P&L, Balance Sheet, sales, expenses, and account balances to identify and correct errors before month-end and year-end close. I can independently maintain clean, accurate books while communicating clearly about unusual or unclear transactions. I can also review your existing QBO setup and recommend practical process improvements where needed. I’m comfortable working with multiple accounts and large transaction volumes and can start immediately. I’m also familiar with international bookkeeping workflows and can work with Naira-denominated accounts. Thanks & Regards, Mussadiq Hussain
$20 USD in 7 days
7.2
7.2

Hello, I can build a clean, easy-to-follow amortization schedule for both loans in Excel or Google Sheets. Each loan will show the monthly payment, principal and interest split, remaining balance, and cumulative interest paid. I’ll use transparent formulas so you can change the loan amount, interest rate, term, or start date later and have the full schedule update automatically. I’ll also double-check the final balances and interest calculations to make sure everything reconciles correctly. Please send the loan amounts, interest rates, terms, and payment/start dates for both loans, and I can get started right away. Best regards, Ayaz Akhtar
$30 USD in 1 day
6.8
6.8

Hi, I have read the job description and now ready to start. I will provide 100% quality. Please send me a message for discussion. Let's discuss the project. Thanks
$20 USD in 1 day
5.7
5.7

Hi there, I can create precise monthly amortization schedules for both loans, showing principal, interest, remaining balance, total interest paid, and a combined summary of both loans. I have experience working on similar financial spreadsheets and will make sure everything is clear, correct, and easy to update. I’ll send you the finished Excel or Google Sheets file within 1 to 2 days, with all formulas double-checked and the summary neatly organized. Best regards, Asma
$30 USD in 2 days
5.6
5.6

Hello there, I can create accurate monthly amortization schedules for both loans, including principal and interest breakdowns, remaining balances, and cumulative interest after every payment. I’ll build the schedules in Excel or Google Sheets with clear formulas, organized formatting, and built-in calculation checks to ensure accuracy. I have strong experience with financial spreadsheets and will deliver a clean, easy-to-review file tailored to your loan terms.
$10 USD in 1 day
5.6
5.6

Greetings, I recently completed a similar project for a client where I created detailed amortization schedules for multiple loans, ensuring accurate breakdowns of principal, interest, remaining balances, and cumulative interest paid. I possess the experience and proficiency in financial calculations and spreadsheet software that your project requires. I understand the core requirement of your project is to create an amortization schedule for 2 loans with monthly payments, including comprehensive details such as principal and interest breakdowns, remaining balances, and cumulative interest paid. My portfolio includes relevant samples of amortization schedules I've created in the past, which I can provide upon request. To ensure I tailor the schedule to your specific needs, could you please clarify if you have a preferred format for the final deliverable? I am confident in my ability to deliver a high-quality amortization schedule that meets your specifications. I would love to discuss your project further and explore how I can assist you. Regards, CA. Swati Jain, CPA
$10 USD in 5 days
4.6
4.6

Hi, I have carefully read your project. I’m able to prepare monthly amortization schedules for both loans, showing the principal and interest portion of each payment, remaining balance after every payment, and cumulative interest paid throughout the loan term. I’m a CPA, CBA and CA with six years of experience in financial calculations, bookkeeping, financial reporting, budgeting, and Excel. I can build clear, accurate, and fully formula-driven schedules in Excel or Google Sheets, with calculations structured so the loan terms and payment details can be easily reviewed or updated. I’m ready to complete both schedules with careful attention to calculation accuracy and formatting. I’m committed to delivering a clean, easy-to-use spreadsheet that provides a complete payment-by-payment view of both loans. Please open the chat for further discussion. Thanks & Regards, Humayun Khan
$15 USD in 7 days
4.8
4.8

Amortization schedules require precise financial modeling to ensure accurate principal-interest allocation across payment cycles, especially when handling multiple loans with different terms simultaneously. This project demands robust spreadsheet architecture that handles compounding calculations while maintaining audit-trail clarity. The deliverable will include dual-loan modeling in Excel with automated monthly payment breakdowns, showing principal reduction, interest accrual, and remaining balances. Each loan will have independent amortization logic while maintaining synchronization for cumulative reporting. The structure will accommodate variable interest rates and payment adjustments if needed. The schedule will incorporate Turnitin-verified documentation confirming accuracy, with all formulas fully transparent and editable. Cumulative interest tracking will be cross-verified against total principal to eliminate calculation drift common in manual implementations. Delivery includes the master spreadsheet, verification report, and documentation of all assumptions. Timeline: 3-5 days depending on loan complexity and data availability. Ready to commence immediately upon receiving loan parameters—principal amounts, interest rates, and term lengths.
$10 USD in 1 day
4.6
4.6

I can build a clean, accurate Excel amortization workbook for both loans, with monthly payment calculations and a transparent schedule that makes principal, interest, and outstanding balances easy to track. Thank you for considering my proposal. I have gone through the requirements in detail. I’ll create separate schedules for each loan with monthly payment dates, opening balance, payment amount, principal component, interest component, remaining balance, and cumulative interest paid. The workbook will use clear formulas rather than hardcoded results, allowing you to update loan amount, interest rate, tenure, or payment assumptions easily. I’ll also cross-check the final balances and total interest calculations to ensure the schedules fully reconcile. I have uploaded samples similar to this project completed by me earlier in my profile. With 10+ years of experience, Chartered Accountant (ICAI) and CPA, I bring strong financial modelling, Excel, financial calculations, and quality-control expertise. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion Please share the principal amount, interest rate, loan tenure, and start date for both loans, and I can structure the schedules accordingly.
$20 USD in 1 day
3.7
3.7

As a skilled professional, I have a strong background in financial calculations and an in-depth understanding of spreadsheet software, such as Excel and Google Sheets. These skills lend themselves perfectly to creating amortization schedules efficiently and accurately. Over the years, I have honed my data analysis abilities, making meticulous attention to detail one of my primary strengths. In addition, having handled numerous similar projects before, I possess a deep understanding of the important components that make up an effective amortization schedule: principal and interest breakdowns, remaining balance after each payment, and cumulative interest paid. Allow me to leverage my expertise in accounting, data entry and financial analysis in order to provide you with a detailed, well-structured amortization schedule for your loans. I ensure timely delivery without compromising quality or accuracy. Choose me for this project, and you can rest easy knowing that you are getting top-tier service from a dedicated professional who values precision and efficiency.
$10 USD in 1 day
3.3
3.3

Hi, I am Adeel. I work regularly with financial models in Excel, including payment schedules with principal and interest splits, running balances and cumulative totals. For your 2 loans I would build a clean monthly schedule with formulas driven by loan amount, rate and term, so you can adjust inputs and see it recalculate. Are the two loans on different rates or terms, or the same structure with different amounts?
$10 USD in 1 day
2.7
2.7

Hello, I can create accurate monthly amortization schedules for both loans in Excel or Google Sheets. Each schedule will clearly show the monthly payment, principal, interest, remaining balance, and cumulative interest paid. I will use formulas so the workbook remains fully editable and updates correctly if any loan details change. I’m experienced with Excel formulas, financial calculations, and clean spreadsheet formatting, and I will double-check all calculations before delivery. I can start as soon as you provide the loan amount, interest rate, term, and payment details for each loan.
$20 USD in 1 day
2.4
2.4

Hi, I can create the monthly amortization schedules for both loans in Excel or Google Sheets. For each loan, I will include: • Monthly payment schedule • Principal and interest breakdown • Beginning and remaining balance • Cumulative interest paid • Payment dates • Total interest and principal summaries I will use accurate financial formulas and structure the spreadsheet clearly so the calculations can be easily reviewed or updated if the loan terms change. Please provide the loan amount, annual interest rate, loan term, start date, and payment details for both loans, and I can get started.
$10 USD in 1 day
1.4
1.4

Hello there, I can assist you in creating an accurate and detailed monthly amortization schedule for your two loans. With my expertise in financial calculations and proficiency in spreadsheet software like Excel and Google Sheets, I can ensure that the schedule includes a clear breakdown of principal and interest, remaining balance after each payment, and cumulative interest paid. Attention to detail is my forte, guaranteeing precise and error-free results for your financial needs. Thanks,
$20 USD in 1 day
0.6
0.6

Hello, With my skill set focused on data manipulation in a financial context, I am confident that I can create an accurate and reliable amortization schedule for your two loans. Navigating spreadsheets such as Excel or Google Sheets is second nature to me, and my ability to scrutinize and organize large amounts of data with attention to detail is critical for this project. My experience extends beyond simply organizing numbers. I have successfully leveraged technology to create user-friendly interfaces, gamifying customers' experiences for successful campaigns; skills that would translate fluidly into a comprehensive and easy-to-understand amortization schedule for you. Moreover, my proven record in conversion copywriting ensures not only the right presentation of data but also the clear communication of complex concepts. Working together, we can tailor these amortization schedules to your specific needs and provide a clear outline of payments, principal and interest breakdowns as well as cumulative interest paid. My ultimate aim is to deliver a meticulously created product that not only serves its purpose but is also user-friendly and easy to understand. Let's connect today to kickstart this rewarding collaboration! Thanks!
$10 USD in 6 days
0.0
0.0

Hello, I’m interested in helping with this project. I have experience working with Excel, data management, and administrative tasks, and I’m very detail-oriented when handling information and calculations. I can create a clear monthly amortization schedule for both loans, including: * Principal and interest breakdown for each payment. * Remaining balance after each monthly payment. * Cumulative interest paid. * Separate and organized schedules for each loan. I can use Excel or Google Sheets and apply formulas so the schedule is easy to review and update if any loan terms change. I’m organized, careful with numerical information, and committed to checking the calculations before delivery. I’m available to start and can work according to your specific loan terms and requirements.
$15 USD in 7 days
0.0
0.0

Hello, I can create a clear Excel workbook with a monthly amortization schedule for each of your two loans, showing the payment amount, principal and interest breakdown, remaining balance, and cumulative interest paid. I’ll use formulas so the schedules update when the loan details change, and check that the principal repayments reconcile with the original balances and the final payments account for rounding. Could you share each loan’s amount, annual interest rate, term, and first payment date? Please also confirm whether the rates are fixed and whether there are any fees or extra payments to include.
$20 USD in 3 days
0.0
0.0

I can build a clean, accurate amortization schedule for your two loans in Excel, with monthly payment breakdowns showing payment date, payment amount, principal, interest, and remaining balance for each loan. I'll use formulas (such as PMT, IPMT, and PPMT) so the schedule recalculates automatically if any loan terms change, and I'll double-check all totals against the original loan terms. I'm detail-oriented and comfortable working with spreadsheets and formulas. I'm new to Freelancer and don't have completed projects on the platform yet, so I'm pricing this competitively and will make sure the workbook is accurate, well-formatted, and easy to follow. To get started, please share each loan's amount, interest rate, term, and start date (and whether any extra payments apply), and I'll deliver the finished schedules within 3 days.
$20 USD in 3 days
0.0
0.0

Hello, I hope your week is going well. I've built loan amortization models in Excel and Google Sheets for lenders and small businesses, so monthly payment splits are familiar ground. One recent build covered two commercial loans with different rates and start dates. I used IPMT and PPMT with named ranges so each month's interest, principal, and running balance updated automatically when the rate changed. Adding a cumulative interest column came down to a simple running SUM, and it caught an early payoff error the client had missed. I'd start by laying out your inputs clearly: loan amount, rate, term, and payment dates, then drive everything from formulas rather than hardcoded numbers. For two loans I'd usually keep a separate schedule per loan, plus a summary tab comparing them side by side. Could we have a short call to confirm a couple of things, namely whether payments fall on the first of each month and if there are any extra payments to account for? Those two details change how I structure the schedule. Thank you, Zohaib
$10 USD in 1 day
0.0
0.0

Hello, I can create the amortization schedule for both loans in Excel, with monthly payments and clear formulas. The spreadsheet will include: * Principal and interest breakdown for each payment * Remaining loan balance after each payment * Cumulative interest paid * Separate calculations for each loan * Clear and editable Excel formulas I will make sure the calculations are accurate and the spreadsheet is easy to use and review. I can complete the project within 1 day. Thank you.
$15 USD in 1 day
0.0
0.0

Pompano Beach, United States
Payment method verified
Member since Sep 25, 2026
$15-25 USD / hour
₹600-1500 INR
$30-50 USD
$250-750 USD
£10-20 GBP
₹12500-37500 INR
₹750-1250 INR / hour
₹600-1500 INR
$250-750 USD
$250-750 USD
$30-250 USD
₹1500-12500 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR
$20-100 USD / hour
$10-30 USD
₹12500-37500 INR
$10-30 USD
min $50 USD / hour