Remember: Do all your calculations in Excel, and submit the final spreadsheet with all your work. Each cell must contain the correct formula in order for you to get credit. Financial calculators are not acceptable. You work for a private equity firm that is considering purchasing the office building below: 950s Brondway - The Brosdway Your business model focuses on investments where you can achieve gains from significant leverage. In this deal, you want to use 10 dollars of debt for every 1 dollar of equity. 1. What is the total loan amount that you hope to get from the bank? 2. How much equity will you need to invest? 3. How easy or difficult do you think it will be to obtain a loan with this LTV? 950 S Broadway - The Broadway Orbce - Downtown Loe Angeies Subinarket Lot Angriet. CA 10015 - Wobsite 31,616ACtol0.11Buatinenor1913/2018Aulabie351,68234,831StoPrice$24.0049.80mow$14.5M$458.63 ow Remember: Do all your calculations in Excel, and submit the final spreadsheet with all your work. Each cell must contain the correct formula in order for you to get credit. Financial calculators are not acceptable. You work for a private equity firm that is considering purchasing the office building below: 950s Brondway - The Brosdway Your business model focuses on investments where you can achieve gains from significant leverage. In this deal, you want to use 10 dollars of debt for every 1 dollar of equity. 1. What is the total loan amount that you hope to get from the bank? 2. How much equity will you need to invest? 3. How easy or difficult do you think it will be to obtain a loan with this LTV? 950 S Broadway - The Broadway Orbce - Downtown Loe Angeies Subinarket Lot Angriet. CA 10015 - Wobsite 31,616ACtol0.11Buatinenor1913/2018Aulabie351,68234,831StoPrice$24.0049.80mow$14.5M$458.63 ow