Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below
You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000.
a. What is your loan amount?
b. What is your monthly payment?
c. What will be the loan balance at the end of nine years?
d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years?
e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month?
f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)?
g. What is your annual percentage rate (APR)?
Step by step
Solved in 1 steps
