Build a Flexible Student Loan Amortization Calculator in Excel with Executive Summary Page
Budget: $10 – $30 USD
Hi, I need someone who is good in excel and finance to build a flexible student loan amortization calculator in Excel with an executive summary page. I have worked on a basic spreadsheet (that still needs fixing) and have included additional instructions - attached for your review.
Essentially, I want the spreadsheet to calculate student loan monthly payments for as many loans as 10 different loans or even more from different providers with different repayment terms.
For instance, a graduate student who has undergraduate loans.
The model should account for ongoing monthly repayments and account for future repayments based on current loans in deferment. In summary, I want to know how much a student will have as monthly loan repayments every month and that depends on the number of loans they have, when they took them, grace periods (if any), terms and conditions, etc.
Essentially, I want the spreadsheet to calculate student loan monthly payments for as many loans as 10 different loans or even more from different providers with different repayment terms.
For instance, a graduate student who has undergraduate loans.
The model should account for ongoing monthly repayments and account for future repayments based on current loans in deferment. In summary, I want to know how much a student will have as monthly loan repayments every month and that depends on the number of loans they have, when they took them, grace periods (if any), terms and conditions, etc.