What is my amortization schedule for my bed-and-breakfast? The loan is for $25,000 at an interest rate of 12% for 4yrs.?

To calculate your amortization schedule for your bed-and-breakfast loan, you can follow these steps:

1. Determine the loan terms: In this case, the loan amount is $25,000, the interest rate is 12%, and the loan duration is 4 years.

2. Calculate the monthly interest rate: Divide the annual interest rate by 12 to get the monthly interest rate. In this case, 12% divided by 12 equals 1% or 0.01 in decimal form.

3. Determine the number of payments: Multiply the loan duration by 12 to get the total number of monthly payments. In this case, 4 years multiplied by 12 equals 48 monthly payments.

4. Use the loan amortization formula to calculate the monthly payment amount: The formula is: P = (Pv * r) / (1 - (1 + r)^(-n)), where P is the monthly payment, Pv is the loan principal (loan amount), r is the monthly interest rate, and n is the total number of payments.

Using the formula and substituting the values, we have:
P = ($25,000 * 0.01) / (1 - (1 + 0.01)^(-48))
P ≈ $689.47

So, your monthly payment amount will be approximately $689.47.

5. Construct the amortization schedule: This is a table that outlines each monthly payment, specifying the principal amount, interest amount, and remaining balance.

Here is a simplified version of your amortization schedule:

Month | Payment | Principal | Interest | Remaining Balance
--------------------------------------------------------------
1 | $689.47 | $520.20 | $169.27 | $24,479.80
2 | $689.47 | $524.12 | $165.35 | $23,955.68
3 | $689.47 | $528.06 | $161.41 | $23,427.62
... (continue for the remaining 45 months)

Repeat the process until you reach the final payment after 48 months.

Please note that this is a simplified example and does not account for compounding interest, fees, or additional factors that may apply to your specific loan. It's advisable to consult with your lender or use professional loan amortization software to get a more accurate and detailed amortization schedule.