What is the Loan-to-Cost percentage loaned by the bank to the company (Sheet: Assumptions, Cell: B17)?

Round your answer to the nearest whole number and do notinclude a percent sign, i.e. fifty percent (50%) would be entered as 50.

1 Table 1: Assumptions 2 Assumptions and Inputs 4 Table 1: Assumptions 5 Beer Can (oz 6 Beer Pint (oz) 7 Beer Keg (oz) 8 cans per case 9 pints per keg 10 tax rate 11 DSO 12 DIO 13 DPO 14 Loan Amount 15 Interest Rate 16 Loan Term (yrs) 17 Loan-to-cost 96 18 distribution/mo 19 Original Buildout 20 Sale Multiple 21 22 Output: 23 Annual Net Income 24 Expected Sale Price 25 Original Investment 26 Sale Profit 27 ROI 28 29 balance checks 12 16 1980 124 22% 7 900,000 15 $1,000,000 $139,794 $419,383 $319,383 319% 12 out of 12