Jun 15 Jun 16 1 Jun 17 2 Jun 18 3 Jun 19 4 Jun 20 5 Jun 21 6 Jun 22 7 Jun 23 8 Jun 24 Jun 25 10 Jun 26 11 9 Jun 27 12 Jun 28 13 Jun 29 14 Jun 30 15 0 1 1 The Widget Company Inc (USD $m) 2 Calculations 129 Financing 130 131 Term loans 3 Term loan 1 Opening balance Term loan 1 drawdown (start of year) Term loan 1 repayment (end of year) Ending balance 0.00 4,000.00 (200.00) 3,800.00 3,800.00 0.00 (200.00) 3,600.00 3,600.00 0.00 (200.00) 3,400.00 3,400.00 0.00 (200.00) 3,200.00 ,200.00 0.00 (200.00) 3,000.00 3,000.00 0.00 (200.00) 2,800.00 2,800.00 0.00 (200.00) 2,600.00 2,600.00 0.00 (200.00) 2,400.00 2,400.00 0.00 (200.00) 2,200.00 2,200.00 0.00 (200.00) 2,000.00 2,000.00 0.00 (200.00) 1,800.00 1,800.00 0.00 (200.00) 1,600.00 1,600.00 0.00 (200.00) 1,400.00 1,400.00 0.00 (200.00) 1,200.00 1,200.00 0.00 (200.00) 1,000.00 0.00 0.00 Term loan 2 Opening balance Term loan 2 drawdown (start of year) Term loan 2 repayment (end of year) Ending balance 0.00 142 143 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,000.00 (250.00) 4,750.00 4,750.00 0.00 (250.00) 4,500.00 4,500.00 0.00 (250.00) 4,250.00 4,250.00 0.00 (250.00) 4,000.00 4,000.00 0.00 (250.00) 3,750.00 3,750.00 0.00 (250.00) 3,500.00 3,500.00 0.00 (250.00) 3,250.00 3,250.00 0.00 (250.00) 3,000.00 3,000.00 0.00 (250.00) 2.750.00 2.750.00 0.00 (250.00) 2,500.00 0.00 0.00 144 Term loan 3 Opening balance Term loan 3 drawdown (start of year) Term loan 3 repayment (end of year) Ending balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,000.00 (600.00) 5,400.00 5,400.00 0.00 (600.00) 4,800.00 4,800.00 0.00 (600.00) 4,200.00 4,200.00 0.00 (600.00) 3,600.00 3,600.00 0.00 (600.00) 3,000.00 2 Free Cash Flows Opening cash Cash Flows from Operating Activities Cash Flows from Investing Activities Free Cash Flow Available /(Required) 0.00 755.21 9,464.00 10,219.21 9,911.53 7,124.97 4,613.38 3,889.453,933.57 4,272.02 648.96 6 74.92 695.17 14,449.94 11.733.459,580.57 2,814.17 1,585.83 4 ,619.77 2,175.36 4,598.955,777.595,947.415,556.76 716.02 11,185.44 759.63 782.42 8,129.14 18,548.86 11,326.818,514.54 1,612.91 5,822.83 8 05.89 8.241.638 1,558.33 6,006.67 8 30.06 ,395.06 1,589.01 7,069.35 12,966.99 21,625.35 5,315.07 7.182.97 880.62 13,378.65 ,465.73 6,729.30 907.03 10,102.06 1,810.41 6,983.81 934.24 9,728.47 1,735.69 7,243.05 962.27 9,941.02 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 Financing Cash Flows Equity contribution Term loan drawdown/repayment Scheduled financing cash flows 2,500.00 3,800.00 6,300.00 0.00 (200.00) (200.00) 0.00 (200.00) (200.00) 0.00 (200.00) (200.00) 0.00 (200.00) (200.00) 0.00 4,550.00 4,550.00 0.00 (450.00) (450.00) 0.00 (450.00) (450.00) 0.00 (450.00) (450.00) 0.00 (450.00) (450.00) 0.00 4,950.00 4,950.00 0.00 (1,050.00) (1,050.00) 0.00 (1,050.00) (1,050.00) 0.00 (1,050.00) (1,050.00) 0.00 (1,050.00) (1,050.00) Cash Flow Available / (Required) 16,519.21 14,249.94 11,533.459,380.57 7,929.14 23,098.86 10,876.818,064.54 7,791.637,945.06 26,575.35 12,328.659,052.06 8,678.47 8,891.02 0.00 0.00 0.00 0.00 0.00 0.00 Revolver Opening balance Borrowings Payments Ending balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Equity Distribution to shareholders 6,607.68 7,124.97 6,920.076,566.40 6,343.31 18,479.098,701.456,451.63 6,233.30 6,356.05 21,260.28 9,862.92 7,241.65 6,942.77 7,112.81 Cash on hand Assume calculation based on opening balance Opening cash Cash on hand Interest revenue 4 1 % 0.00 4.00% 0.00 9,911.53 4.00% 396.46 7,124.97 4.00% 285.00 ,613.38 4.00% 184.54 2,814.17 4.00% 112.57 1,585.83 4.00% 63.43 4,619.77 4.00% 184.79 2,175.36 4.00% 87.01 1,612.91 4.00% 64.52 1,558.33 4.00% 62.33 ,589.01 4.00% 63.56 4.0 5,315.07 4.00% 212.60 2,465.73 4.00% 98.63 1,810.41 4.00% 72.42 1,735.69 4.00% 69.43 3,800.00 1,200.00 Term loan 1 Assumes drawdowns happen at the start of the year, repayment at the end of the year Opening balance 0.00 Term loan 1 drawdown (start of year) 4,000.00 Term loan 1 interest % 9.00% Interest expense (360.00) 0.00 3,600.00 0.00 9.00% (324.00) 3,400.00 0.00 9.00% (306.00) 3,200.00 0.00 9.00% (288.00) 3,000.00 0.00 9.00% (270.00) 2,800.00 0.00 9.00% (252.00) 2,600.00 0.00 9.00% (234.00) 2,400.00 0.00 9.00% (216.00) 2,200.00 0.00 9.00% (198.00) 2,000.00 0.00 9.00% (180.00) 1,800.00 0.00 9.00% (162.00) 1,600.00 0.00 9.00% (144.00) 1,400.00 0.00 9.00% (126.00) 0.00 9.00% (342.00) 9.00% (108.00) 1/5 Interest 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 Term loan 2 Assumes drawdowns happen at the start of the year, repayment at the end of the year Opening balance 0.00 Term loan 2 drawdown (start of year) 0.00! Term loan 2 interest % 10.00% Interest expense 0.00 0.00 0.00 10.00% 0.00 0.00 0.00 10.00% 0.00 0.00 0.00 10.00% 0.00 0.00 0.00 10.00% 0.00 0.00 5,000.00 10.00% (500.00) 4,750.00 0.00 10.00% (475.00) 4,500.00 0.00 10.00% (450.00) 4,250.00 0.00 10.00% (425.00) 4,000.00 0.00 10.00% (400.00) 3,750.00 0.00 10.00% (375.00) 3,500.00 0.00 10.00% (350.00) 3,250.00 0.00 10.00% (325.00) 3,000.00 0.00 10.00% (300.00) 2,750.00 0.00 10.00% (275.00) 3,600.00 Term loan 3 Assumes drawdowns happen at the start of the year, repayment at the end of the year Opening balance 0.00 Term loan 3 drawdown (start of year) 0.00 Term loan 3 interest % 11.00% Interest expense 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 0.00 11.00% 0.00 0.00 0.00 11.00% 0.00 0.00 6,000.00 11.00% (412.50) 5,400.00 0.00 11.00% (385.00) 4,800.00 0.00 11.00% (357.50) 4,200.00 0.00 11.00% (330.00) 11.00% (302.50) 203 204 Revolver facility Assume calculation based on opening balance Opening balance Revolver facility Interest expense 205 207 208 209 210 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 13.00% 0.00 0.00 Interest revenue (expense) (360.00) 54.46 (39.00) (121.46) (175.43) (706.57) (542.21) (596.99) (576.48) (535.67) (903.94) (684.40) (727.87) (683.58) (616.07) 211 Analyst comment: "The total interest on the term loans seems wrong" [Error(s) in Calculations!183:202] What is the total interest on the three Term Loans ($m) in the Year ending June 2028? a. b. c. d. e. 996.00 997.00 998.00 999.00 1,000.00 f. 1,001.00