What would be the debt return, debt payment, and pay off debt?

20-year amortizing loan of $500,000 at 5%. Payment made each 5 years. Have to pay the remaining balance of debt back in year 5. 50% of the project is financed with debt at 5%

Debt Pay Off Calc N 20 5% 500,000 PV FV PMT 5% Fill In/Calculate Remaining Balacnce Fill In/Calculate Remaining Balacnce ($40,121.29) Calculate 28 Debt Payment Calc 29 N 30 31 PV 32 FV 33 PMT 34 35 Unlevered Cash Flows 36 Debt Return of Capital 37 Debt Payment 38 Pay off Debt 39 110,000 $ 110,000 110,000 $ $(1,000,000) s 500,000 110,000 $ 910,000 This indicates less equity you need, if you finance it You have to pay off the debt for 5 years, so this should be negative and link to payment Iyou have to pay the remaining balance when you sell the field, so this should be negative and link to final balance of mortgage Debt Pay Off Calc N 20 5% 500,000 PV FV PMT 5% Fill In/Calculate Remaining Balacnce Fill In/Calculate Remaining Balacnce ($40,121.29) Calculate 28 Debt Payment Calc 29 N 30 31 PV 32 FV 33 PMT 34 35 Unlevered Cash Flows 36 Debt Return of Capital 37 Debt Payment 38 Pay off Debt 39 110,000 $ 110,000 110,000 $ $(1,000,000) s 500,000 110,000 $ 910,000 This indicates less equity you need, if you finance it You have to pay off the debt for 5 years, so this should be negative and link to payment Iyou have to pay the remaining balance when you sell the field, so this should be negative and link to final balance of mortgage