You decide to purchase a house for $260,000. You have saved money so you are able to do a down payment of $20,000. You are able to finance your house by getting a 25 year mortgage with an interest rate of 7%. What are the monthly payments? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Part 2 - Six years later, you decide to calculate your loan balance? (Use a payment value rounded to 2 decimal places. Round your final answer to 2 decimal places.) (Hint. Use the remaining years for “N”). Part 3 - If the house appreciates at 3.12 percent per year, what will be the value of the house in eight years? (Round your final answer to 2 decimal places.) NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.)

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)?

for x=6

Your classmate tells you the details of the great deal he got on his mortgage: 30-year 1.1% fixed rate with a 20% down payment a.)If his new home costs $136,000, what is his down payment? b.)How much is he going to borrow to buy the house (assuming he only has the money to make the down payment from the previous part)? c.)Use Excel’s PMT function to determine how much his monthly payments would be. d.)How much will he pay in interest over the lifetime of this mortgage?

Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.

1. You deposit  GHS10,000 today into an account paying 6% annual interest and leave it on deposit for exactly eight years. Required: How much will be the amount in the account at the end of eight years if interest is compounded annually?   2. Imagine you are a professional personal finance planner. One of your clients ask you the following question. Use time value of money technique to develop appropriate responses in each question. I borrowed GHS75,000, am required to repay it in six equal (annual) end of year instalments of GHS3,344 and want to know what interest rate I am paying.

PLEASEE THANKKK YOUUUU

Question 3: You just got a loan for $15,000 and you plan to pay it off in three years. Your monthly payments are $500 each. What is the interest rate that the bank is charging you? What if you did bi- monthly payments of $250? How much sooner will the loan be paid off?

After making the twenty-sixth payment on your car loan, you wanted to find out how much is left of your original 5 years loan at 7.1% compounded monthly of $27,000.00. What is the amount of the remaining balance of your car loan? The remaining balance of your car loan would be $. (Round to 2 decimal places.)

You Borrowed $150,000 to for a period of 15 years at fixed APR of 6% to buy a house.  How much is your total payments over 15 years for this loan. Use 6 digits after decimal when calculating. But give your final answer with 2 digits after decimal.    choose the closet answer to yours choices 198756.43 227841.17   179459.38