Use the inputs below the loan calculator for each scenario Run the numbers for scenario 1 and record the results. Then do the same for scenarios 2.3. Additional Questions Place an"x" in the correct box (4 pts each) F Scenario 1 $250,000 20% 5.5% Scenario 2 $250.000 20% 5.5% Scenario 3 $250,000 20% 7.096 Tractor Oost Down payment Annual interest rate Loan period Corn price Yield Higher interest rates increase monthly payments? The longer the loan the greater the interest paid? Corn prices have little impact on the ability to finance the tractor? Lower avg net returns means higher breakeven acres? Greater the down payment the lower the monthly payment? 6 yrs 4 yrs 6 yrs $7.50 170 $7.50 170 $5.50 170 Put Your Answers Below (4 pts each) Monthly payment Annual payment Total interest Total loan cost Bu needed to cover anl payment Breakeven acres Loan Calculator Fill the shaded cells with appropriate information from each scenario to the right. Enter values Percent bu./ac $0 Tractor cost Down payment Financed Amount Annual interest rate Loan period in years Start date of loan Corn Avg annual yield Gross revenue Avg net returns acre $0 4/25/2022 Annual tractor payment #VALUE! Bushels needed to cover anl pmt #VALUE! bu. Acres needed to cash flow tractor #VALUE! Breakeven acres Monthly payment Number of payments Total interest Total cost of loan Payment Date Beginning Balance Ending Balance Interest Principal Payment No. Use the inputs below the loan calculator for each scenario Run the numbers for scenario 1 and record the results. Then do the same for scenarios 2.3. Additional Questions Place an"x" in the correct box (4 pts each) F Scenario 1 $250,000 20% 5.5% Scenario 2 $250.000 20% 5.5% Scenario 3 $250,000 20% 7.096 Tractor Oost Down payment Annual interest rate Loan period Corn price Yield Higher interest rates increase monthly payments? The longer the loan the greater the interest paid? Corn prices have little impact on the ability to finance the tractor? Lower avg net returns means higher breakeven acres? Greater the down payment the lower the monthly payment? 6 yrs 4 yrs 6 yrs $7.50 170 $7.50 170 $5.50 170 Put Your Answers Below (4 pts each) Monthly payment Annual payment Total interest Total loan cost Bu needed to cover anl payment Breakeven acres Loan Calculator Fill the shaded cells with appropriate information from each scenario to the right. Enter values Percent bu./ac $0 Tractor cost Down payment Financed Amount Annual interest rate Loan period in years Start date of loan Corn Avg annual yield Gross revenue Avg net returns acre $0 4/25/2022 Annual tractor payment #VALUE! Bushels needed to cover anl pmt #VALUE! bu. Acres needed to cash flow tractor #VALUE! Breakeven acres Monthly payment Number of payments Total interest Total cost of loan Payment Date Beginning Balance Ending Balance Interest Principal Payment No