I need help with the final questions E,F,G,H

Please type your solutions below and return as an Excel file Problem #1 Buildagood Ltd. began the process of self-constructing an office building in 2021. In order to provide for partial financing of the total construction cost, the company issued an 18-month $500,000, 7.50 % note, dated January 1, 2021. Relative to the construction process, Buildagood disbursed the proceeds of the construction note and other funds as follows: Date 1/1/2021 3/31/2021 7/1/2021 8/31/2021 11/30/2021 Periods in months 12 9 6 4 2 Weight 1 0.75 0.5 0.3333 0.1667 Expenditure 500.000 800,000 360,000 600,000 240,000 Weighted expenditure 500,000 600,000 180,000 200,000 40,000 01-Jan-21 31-Mar-21 1-Jul-21 31-Aug-21 30-Nov-21 $ $ $ $ $ 500,000 800,000 360,000 600,000 240,000 Weighted average accumulated expenditure = $1,520,000 B Particulars Bonds LT Notes Bank line of credit Total In addition to the construction note, Buildagood had the following other debt outstanding: Loan 1,000,000 400,000 200,000 1,600,000 int rate 6 7 12 Interst 60.000 28,000 24,000 112,000 Due 15-Jun-30 30-Sep-25 30-Jun-24 Bonds LT Notes Bank line of credit Amount Outstanding 1,000,000 400,000 200,000 $ $ $ Weighted Average interest rate= 112,000/1,600,000 = 7% / Interest Rate 6.0% 7.0% 12.0% 5% $37,500 Total Expenses required $2,500,000 General loan $2,000,000 7% $140,000 Specific loan $500,000 total avoidable interest $177,500 Gernal loan $2,000,000 a a b D Specific Loan $37,500 General loan $112.000 Total Interest $149,500 d e f Instructions Calculate the weighted average accumulated expenditures Calculate the weighted average interest rate for non-specific borrowings rounded to one-tenth of a percent Calculate the "avoidable interest" Calculate the actual interest Calculate the capitalized interest Calculate the avoidable interest assuming Buildagood had no bonds outstanding. Calculate the actual interest assuming Buildagood had no bonds outstanding. Calculate the capitalized interest assuming Buildagood had no bonds outstanding. E g h F G G H