# Finance Assignment | Professional Writing

Mortgage Analysis You are planning to purchase a house that costs \$480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage. 1. Use function “PMT” to calculate your mortgage payment. 2. Use function “PV” to calculate the loan amount given a payment of \$1550 per month. What is the most that you can borrow? 3. Use function “RATE” to calculate the interest rate given a payment of \$1550 and a loan amount of \$384,000. 4. For each scenario, calculate the total interest that you will have paid once the mortgage is paid off. (There is not a function for this, enter the formula into the cell.)

Don't use plagiarized sources. Get Your Assignment on
Finance Assignment | Professional Writing
Just from \$13/Page

5. For each scenario, calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.) 6. Assume that you plan to pay an extra \$300 per month on top of your mortgage payment, calculate how long it will take you to pay off the loan given the higher payment. (Use the data from #1). Calculate how much interest you will pay in total? Compare this to the value that you calculated for #1. You want to determine whether you should only 10% down on your house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). Assume that PMI is 1% of the mortgage amount. Assume that you will pay PMI for 8 years in total (the assumption is that you will have 20% equity at that time so PMI will no longer be needed). 7. Calculate your total monthly payment (mortgage payment plus PMI). 8. Calculate the total cost of financing your home purchase (interest plus PMI). (remember that you only pay PMI for 8 years) 9. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.) 10. Compare this to the costs associated with a 20% down payment (use data from #1).

Get Finance homework help today

Pages(550 words)

Approximate price:-

## Why Choose Our Assignment Writing Services

### Quality Homework Papers

We aim at 100% customer satisfaction. As such, we never compromise on the quality of our assignment services and strive to maintain the highest standards of work for all our clients. Our writers craft each paper carefully to match the requirements on the instructions form while at the same time being surgical and objective while handling client work.

### Professional Homework Help

We receive many applications from writers around the world daily. Nevertheless, we only choose the cream of the crop to tackle your “help with homework” requests. Hence, our homework helpers are highly-qualified individuals who adhere to our quality policy.

### Affordable Homework Help Services

We maintain a fair pricing policy for all our homework help services. Our pricing system generates quotations based on the requirements of each paper. Hence regardless of the complexity or duration of a paper, our system determines the most accurate and pocket-friendly price for all our clients.

### On-Time Assignment Delivery

At MyHomeworkWriters, we guarantee all students swift delivery of their assignments. We understand that time is an essential factor in the academic world. We, therefore, ensure that all assignments are delivered on or before the agreed deadline. This leaves room for editing to incase the client wants changes done to the work delivered by our writers.

### 100% Original Assignment Papers

We maintain a zero-plagiarism policy in all our papers. Our writers stick to the instructions to deliver plagiarism-free work. Other than that, they extensively research the work they are handling and are keen to avoid any chance of similarities with previously written papers. Our editors check every completed work to ascertain it’s at the set standards.

Our main objective is to assist you through every step of your academic journey. Thus, we completely understand that you might run into trouble once in a while when interacting with our system. If you do run into trouble, please get in touch with our support agents and they will immediately provide you with assistance. Feel free to contact us via the Chat window or email us.

## How myhomeworkwriters works?

Fill in the order form and provide all details of your assignment.

### 2). Proceed with the payment

Choose the payment system that suits you most.

### 3). Track Progress

You will be able to track the progress of your paper from our system.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

## Our Assignment Services

Myhomeworkwriters holds a reputation for providing high-quality assignment writing services. You only need to give us all the requirements for your “do my homework” order, and our writers will give you the best results.

### Research Services

Our team is skilled and equipped in searching for information required to complete work handed over to them. Regardless of the complexity of the work, we are determined to get the job done. Extensive research when handling client requests makes it possible for us to be able to stick to the boundaries and guidelines set by the clients. Thus enabling us to keep the work original and plagiarism free.

### Writing Services

We have highly qualified writers to assist you whenever you place in "help with my homework" order. Our essay writing service is designed to not only help students get good grades but also excel in their studies. Our writers are highly experienced and educated specialists and professionals who want to do more than creating a difference in the academic field.