what is the formula for:

In the Loan Value column, calculate the face value of this mortgage. The purchase price of the building is in cell E

A B C D 7 F G H I Monthly Payment Actual Amount Borrowed J K APR Payment with Balloon Loan Analysis Worksheet 1 2 3 4 5 6 E Purchase Price Number of Compounding Periods/year Optional Balloon Payment Down Payment 20% 10% 5% 0% 20% 10% 5% Nominal Interest Duration Rate/yr (yrs) 4.90% 30 5.25% 30 5.75% 30 6.25% 30 5.50% 30 6.00% 15 6.50% 15 Option# 1 8 2 9 3 10 4 11 5 12 6 13 7 14 15 16 17 Private loan (1) annual rate: 18 Private loan (2) duration: 19 CD value enough for down payment: $ 500,000 4 $ 20,000 Points 3 3 3 3 1 0 0 Fees 375 375 375 0 0 350 350 Loan Value