| 1) Calculate separate and total ending balance of debt for 2021-2022 |
| 2) Calculate separate and total interest expense on debt 2021-2022 |
| 3) What is the wheighted interest rate on the total loan? |
Presented in the table is the information about the company's debt. Balance sheet information (extracts) Accounts payable Short term portion of the bank loan Credit line ( 5% interest) Long term portion of the bank loan 2019A \begin{tabular}{|l|l|l|} \hline 2020A & 2021F & 2022F \\ \hline \end{tabular} Cash flow statement information (extracts) Cash flow from financing activities Payment of the bank loan Payments of the credit line Borrowing on the credit line Note to financial statements \begin{tabular}{|r|r|r|} \hline & Long term bank loan payments & Credit line payments \\ \hline 2020 actual & 2400,0 & 6000,0 \\ \hline 2021 & 1800,0 & 7000,0 \\ \hline 2022 & 1900,0 & 6500,0 \\ \hline 2023 & 2100,0 & \\ \hline \end{tabular} Note: according to the company's credit line agreement and the bank loan agreement Income Statement information Interest expense on the bank loan Interest on the credit line 1171,8 Make forecast for the debt balnces in the balance sheet and interest expense in the Income Statement for 2021-2022 All payments are done at the end of the year The long term bank loan will be paid out no new borrowings Credit line will borrow consistently more than paid uisng the two year trend HINT: Create two separate schedules for the two financial debt items. Presented in the table is the information about the company's debt. Balance sheet information (extracts) Accounts payable Short term portion of the bank loan Credit line ( 5% interest) Long term portion of the bank loan 2019A \begin{tabular}{|l|l|l|} \hline 2020A & 2021F & 2022F \\ \hline \end{tabular} Cash flow statement information (extracts) Cash flow from financing activities Payment of the bank loan Payments of the credit line Borrowing on the credit line Note to financial statements \begin{tabular}{|r|r|r|} \hline & Long term bank loan payments & Credit line payments \\ \hline 2020 actual & 2400,0 & 6000,0 \\ \hline 2021 & 1800,0 & 7000,0 \\ \hline 2022 & 1900,0 & 6500,0 \\ \hline 2023 & 2100,0 & \\ \hline \end{tabular} Note: according to the company's credit line agreement and the bank loan agreement Income Statement information Interest expense on the bank loan Interest on the credit line 1171,8 Make forecast for the debt balnces in the balance sheet and interest expense in the Income Statement for 2021-2022 All payments are done at the end of the year The long term bank loan will be paid out no new borrowings Credit line will borrow consistently more than paid uisng the two year trend HINT: Create two separate schedules for the two financial debt items
