excel_create_loan_analysis
Generate a loan amortization worksheet with payment schedules and accounting entries for financial analysis and reporting.
Instructions
Create a loan amortization analysis worksheet with payment schedule and accounting entries
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| annualRate | Yes | Annual interest rate (e.g., 0.05 for 5%) | |
| loanAmount | Yes | Principal loan amount | |
| worksheetName | No | Loan Analysis | |
| years | Yes | Loan term in years |
Input Schema (JSON Schema)
{
"properties": {
"annualRate": {
"description": "Annual interest rate (e.g., 0.05 for 5%)",
"type": "number"
},
"loanAmount": {
"description": "Principal loan amount",
"type": "number"
},
"worksheetName": {
"default": "Loan Analysis",
"type": "string"
},
"years": {
"description": "Loan term in years",
"type": "number"
}
},
"required": [
"loanAmount",
"annualRate",
"years"
],
"type": "object"
}