How do you use the financial formulas to get the answers in this excel worksheet?

fx A B C D E F J K L M N O P Q G H ILLUSTRATION 9-1: Loan Ratios 1 3 Loan-to-value ratio Fill in all green cells 5 The value of the restaurant building that you are mortgaging: $350,000 350000 7 Lender's loan-to-value ratio: 65% 65.00% Maximum possible loan from lender = 9 10 11 12 - 13 If you need a loan of $300,000, what loan-to-value ratio do you need to find in a lender? = . 14 Debt service coverage ratio 17 18 19 20 21 - 22 The annual debt service from your loan to purchase a new fleet of golf carts is $125,000, and your annual cash flow is $400,000. What is your debt service coverage ratio? If you are about to seek a loan and know that most hospitality lenders today require a debt service coverage ratio of between 1.25 and 1.50, would you be able to obtain a loan? Loan Amount = 125000 Annual Cash Flow = 400000 Debt service coverage ratio = Cash flow/Debt service = 23 24 25 26 27 28 You are well above the 1.25 to 1.50 range, so obtaining a loan should not be a problem. 29 fx A B C D E F J K L M N O P Q G H ILLUSTRATION 9-1: Loan Ratios 1 3 Loan-to-value ratio Fill in all green cells 5 The value of the restaurant building that you are mortgaging: $350,000 350000 7 Lender's loan-to-value ratio: 65% 65.00% Maximum possible loan from lender = 9 10 11 12 - 13 If you need a loan of $300,000, what loan-to-value ratio do you need to find in a lender? = . 14 Debt service coverage ratio 17 18 19 20 21 - 22 The annual debt service from your loan to purchase a new fleet of golf carts is $125,000, and your annual cash flow is $400,000. What is your debt service coverage ratio? If you are about to seek a loan and know that most hospitality lenders today require a debt service coverage ratio of between 1.25 and 1.50, would you be able to obtain a loan? Loan Amount = 125000 Annual Cash Flow = 400000 Debt service coverage ratio = Cash flow/Debt service = 23 24 25 26 27 28 You are well above the 1.25 to 1.50 range, so obtaining a loan should not be a problem. 29