Excel Project #4 - Construction Loan Table - Excel Trevor Holtz File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do Share Calibri - 11 -AA ab Wrap Text General 41 I X Cut * Copy Paste Format Painter Clipboard BIU 3 Merge Merge & Center - $ - % Insert Delete Format ..0.00 Conditional Format as .000 Cell Formatting - Table - Styles Styles AutoSum Fill - Clear Sort & Find & Filter - Select Editing Font Alignment Number Cells 59 fr V A B D E F H L M N N P o R S A developer is working with the bank to get a construction loan for its $15,000,000 apartment project. The developer is supplying an estimated draw schedule. The bank is proposing the following terms for the luani. Please corpule and complete the following draw schedule/Amortization table. You should assume that construction and lease up will take approximately 3 years. Instead of providing extension options, 3 the bank is providing a full 5-year construction loan that begins as an interest only loan and converts to a fully amortizing loan at the beginning of the fourth year. 1) What is the maximum Luan Amount rounded up to the nearest $100,000? 5 2) In what years does the interest rate cap effect the payment schedule? 6 3) What is the total amount of capialized interest accrued during the construction period? 74) What is the total payoff amount of the loan after the Goth monthly payment? Construction Lean Expected 1 year LIBOR Current $ 15.000.000.00 2 3 4 5 0.400% 1.000%. 2.000 6 4.000% 6.000 9 10 Loan Details: 11 12 Project Cost 13 Maximum Loan Amount 14 Reset Period 15 initial RAT 16 Amortization 17 Amortization 18 Amartization 19 Term 20 Interest Rate Cap 71 Index 22 Margin 23 74 1 Year 9.000 3G Months interest Only Negative During the construction period only 25 Years once fully funded 5 Years 1.000 1 year 3.000 Expected Draw Percentage Beginning Period Loan Balance Capped interest Rate Capitalized Payment Interest Payment Principal Payment Ending period Loan Balance Excected Draw Interest Rate Paument 25. Draw Schedule Sheet1 Ready Scroll Lock HWB Month + + 7096 O Type here to search SR A 12:23 AM 11/13/2020 Excel Project #4 - Construction Loan Table - Excel Trevor Holtz File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do Share Calibri - 11 -AA ab Wrap Text General 41 I X Cut * Copy Paste Format Painter Clipboard BIU 3 Merge Merge & Center - $ - % Insert Delete Format ..0.00 Conditional Format as .000 Cell Formatting - Table - Styles Styles AutoSum Fill - Clear Sort & Find & Filter - Select Editing Font Alignment Number Cells 59 fr V A B D E F H L M N N P o R S A developer is working with the bank to get a construction loan for its $15,000,000 apartment project. The developer is supplying an estimated draw schedule. The bank is proposing the following terms for the luani. Please corpule and complete the following draw schedule/Amortization table. You should assume that construction and lease up will take approximately 3 years. Instead of providing extension options, 3 the bank is providing a full 5-year construction loan that begins as an interest only loan and converts to a fully amortizing loan at the beginning of the fourth year. 1) What is the maximum Luan Amount rounded up to the nearest $100,000? 5 2) In what years does the interest rate cap effect the payment schedule? 6 3) What is the total amount of capialized interest accrued during the construction period? 74) What is the total payoff amount of the loan after the Goth monthly payment? Construction Lean Expected 1 year LIBOR Current $ 15.000.000.00 2 3 4 5 0.400% 1.000%. 2.000 6 4.000% 6.000 9 10 Loan Details: 11 12 Project Cost 13 Maximum Loan Amount 14 Reset Period 15 initial RAT 16 Amortization 17 Amortization 18 Amartization 19 Term 20 Interest Rate Cap 71 Index 22 Margin 23 74 1 Year 9.000 3G Months interest Only Negative During the construction period only 25 Years once fully funded 5 Years 1.000 1 year 3.000 Expected Draw Percentage Beginning Period Loan Balance Capped interest Rate Capitalized Payment Interest Payment Principal Payment Ending period Loan Balance Excected Draw Interest Rate Paument 25. Draw Schedule Sheet1 Ready Scroll Lock HWB Month + + 7096 O Type here to search SR A 12:23 AM 11/13/2020
