Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show functions in excel 2. A property is bought 7 years ago for $350.000 putting 10% down and financing the rest for 30 years

image text in transcribed
please show functions in excel
2. A property is bought 7 years ago for $350.000 putting 10% down and financing the rest for 30 years with a fixed rate loan of 5% a year. What is the monthly payment on the loan? The property has appreciated at a rate of 0.2% a month What is the amount of equity today? What percent of the equity today is due to the increase in the value of the property? Due to the low down payment. PMI of 1.2% a year is charged based on the initial amount borrowed. What is the monthly PMI amount (in dollars) charged by the lender? Create a new tab with the following based on the original information. An extra $10,000 is paid along with the 12" payment. How many months will it take until there is 20% equity in the property? How much is owed on the loan at that time

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computational Finance And Its Applications

Authors: C. A. Brebbia, M. Costantino

1st Edition

1853127094, 978-1853127090

More Books

Students also viewed these Finance questions

Question

How many customers are there?

Answered: 1 week ago