Need excel expert to make excel sheet for group loan
Budget: ₹1,500 – ₹12,500 INR
Project Description: Excel Sheet for Group Loan with Loan Repayment Schedule, Chart, and Automation
I am looking for an excel expert who can create a comprehensive excel sheet for managing group loans. The sheet should be able to perform the following functions and calculations:
Loan Repayment Schedule: for weekly
- The excel sheet should be able to generate a loan repayment schedule based on the loan amount, interest rate, and loan term.
- It should calculate the monthly installment amount, interest paid, principal paid, and outstanding balance for each period.
Chart or Visual Representation:
- The sheet should include a chart or visual representation of the loan repayment schedule to provide a clear overview of the payment plan.
Automation and Interactivity:
- The excel sheet should be automated and interactive, allowing for easy data entry and updates.
- It should have features like drop-down menus or forms for entering loan details and generating the repayment schedule.
- The sheet should also automatically update the repayment schedule and chart when any changes are made to the loan parameters.
Ideal Skills and Experience:
- Proficiency in Excel with advanced knowledge of formulas, functions, and data visualization.
- Experience in creating loan repayment schedules and financial models in Excel.
- Strong attention to detail to ensure accurate calculations and data representation.
- Ability to create user-friendly and interactive
I am looking for an excel expert who can create a comprehensive excel sheet for managing group loans. The sheet should be able to perform the following functions and calculations:
Loan Repayment Schedule: for weekly
- The excel sheet should be able to generate a loan repayment schedule based on the loan amount, interest rate, and loan term.
- It should calculate the monthly installment amount, interest paid, principal paid, and outstanding balance for each period.
Chart or Visual Representation:
- The sheet should include a chart or visual representation of the loan repayment schedule to provide a clear overview of the payment plan.
Automation and Interactivity:
- The excel sheet should be automated and interactive, allowing for easy data entry and updates.
- It should have features like drop-down menus or forms for entering loan details and generating the repayment schedule.
- The sheet should also automatically update the repayment schedule and chart when any changes are made to the loan parameters.
Ideal Skills and Experience:
- Proficiency in Excel with advanced knowledge of formulas, functions, and data visualization.
- Experience in creating loan repayment schedules and financial models in Excel.
- Strong attention to detail to ensure accurate calculations and data representation.
- Ability to create user-friendly and interactive