Solve a. b. c. d. and e. step by step using excel or a financial calculator, please show steps to get the answer. Maria bought a house with price of $250,000. Her LTV (loan-to-value ratio) is 80%. She chooses the 30-year mortgage with interest rate 6%. Assuming the total origination cost is $10,000. a. What is Maria's loan amount? What is her monthly payment? What will be the loan balance at the end of nine years? b. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? c. In the monthly payment, how much does Maria pay for the principle and how much does Maria pay for the interest in the 1st and the 2nd month? d. What will be Maria's interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? e. What is Maria's annual percentage rate (APR)?

Solve a. b. c. d. and e. step by step using excel or a financial calculator, please show steps to get the answer. Maria bought a house with price of $250,000. Her LTV (loan-to-value ratio) is 80%. She chooses the 30-year mortgage with interest rate 6%. Assuming the total origination cost is $10,000. a. What is Maria's loan amount? What is her monthly payment? What will be the loan balance at the end of nine years? b. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? c. In the monthly payment, how much does Maria pay for the principle and how much does Maria pay for the interest in the 1st and the 2nd month? d. What will be Maria's interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? e. What is Maria's annual percentage rate (APR)?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

Please show all steps and formulas in an excel spreadsheet 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 solve this
Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $
Your friend is currently paying $734 in rent monthly in Fort Wayne and would rather apply the payment toward purchasing a home. If she can get a 30 year mortgage at 4.67% APR using her current payment amount, how much could she borrow? What could you type into Excel to calculate this value?
The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Loan Payment Formula.png| A. Calculate the total amount paid for Mortgage A. B. Calculate the total interest paid for Mortgage A. C. Calculate the monthly payment for Mortgage B. D. Calculate the total amount paid for Mortgage B. E. Calculate the total interest paid for Mortgage B. F. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. G. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.
Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Steven decides to buy a house with price of $500,000, Steven puts 20% down payment and considers a 15-year fixed rate mortgage to pay the remaining balance. The lender offers him three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?
Use the following to solve questions a. and b. with an excel spreadsheet and please show the formulas on the excel spreadsheet. A house with price of $250,000 20% down payment, loan amount $200.000 30-year fixed rate mortgage with interest rate as follows: Suppose that there is $2,500 origination cost. a. Which choice would you like to choose if you will live in the house for 30 years? b. Which choice would you like to choose if you will live in the house for 5 years?
You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?
Use the following to solve questions a. and b. and please buid an excel spreadsheet and please show the formulas on the excel spreadsheet. A house with price of $250,000 20% down payment, loan amount $200.000 30-year fixed rate mortgage with interest rate as follows: Suppose that there is $2,500 origination cost. a. Which choice would you like to choose if you will live in the house for 30 years? b. Which choice would you like to choose if you will live in the house for 5 years?
Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Thomas decides to buy a house with price of $450,000. Thomas puts 20% down payment and considers a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Thomas two choices of the mortgage with monthly payments shown in the table as choice 1 and choice 2, assume that the origination cost is $6,000. A. If you hold the loan for 30 years, what is the effective cost for each choice? B. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (i.e. the borrow will pay off the loan at the end of 60 months)?
Give The Answer With Correct Value
The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Calculate the total amount paid for Mortgage A. Calculate the total interest paid for Mortgage A. Calculate the monthly payment for Mortgage B. Calculate the total amount paid for Mortgage B. Calculate the total interest paid for Mortgage B. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.