What will be your monthly payment to pay back the loan

Assignment Help Finance Basics

Reference no: EM131241486

Excel Assignment You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%. Solve the problem by creating an Excel spreadsheet like the one presented in the video.

1- What will be your monthly payment to pay back the loan? What is the total interest that you will pay over the life of the loan?

2- How much total interest you would pay on this loan if you can prepay $30,000 on the first month of the second year?

Reference no: EM131241486

Questions Cloud

What is the average time to produce the first three units : The time to produce the "N"th unit (T_N), for a given Learning Cure Rate (LCR), is equal to T_N= T_1 N^b where T1 is the time to produce the first unit and b is a factor for the LCR. If b = - 0.5 and the time to produce the first unit is 100 hours, w..

What is the change in the total internal energy : A gas is allowed to expand adiabatically. The initial pressure and volume are Pini = 203-atm and Vini = 213-L respectively, while the final pressure and volume are equal to Pfin = 0.00674×Pini and Vfin = 20.1×Vini. What is the change in the total int..

How did architecture develop throughout the middle ages : What impact did Charlemagne have on the early medieval period? How did architecture develop throughout the Middle Ages? Explain the influence of Christianity on the visual arts, literature, and music of this time.

Manufacturer would offer the different chiuce to costumer : Create a list of 2 separate manufactured brands for automobiles and list the different makes and model for those brands. Write the analisys the manufacturer would offer the different chiuce to costumer?

What will be your monthly payment to pay back the loan : Excel Assignment You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%. What will be your monthly payment to pay back the loan? What is the total ..

What is the marginal income tax rate : Would you expect trading volume to be higher for dividend-paying stocks on the declaration date or around the cum-date/ex-date?

Find the user''s password or explain why this is not possible : Show that the shift, substitution, and Vigenre ciphers are all trivial to break using a chosen-plaintext attack. How much chosen plaintext is needed to recover the key for each of the ciphers?

Net profit is equal to total revenue minus total cost : A company makes a product and it is interested in how many units per year (Q) it should produce. Its production cost is $10 per unit. The marketing department has determined that the selling price per unit would be equal to $110 minus $0.10 per unit ..

How are these tasks completed in your workplace : What selection criteria does your workplace use to evaluate suppliers? How do these criteria relate to project success criteria? If this evaluation leads to a tie between suppliers, how would you resolve the situation?

User Account

All Pages