excel_create_loan_analysis
Generate a loan amortization worksheet with payment schedules and accounting entries to analyze repayment terms, interest costs, and financial impact.
Instructions
Create a loan amortization analysis worksheet with payment schedule and accounting entries
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| loanAmount | Yes | Principal loan amount | |
| annualRate | Yes | Annual interest rate (e.g., 0.05 for 5%) | |
| years | Yes | Loan term in years | |
| worksheetName | No | Loan Analysis |