# I NEED THIS ON EXCCEL SPREADSHEET WITH ALL THE NUMBER SIR. T

I NEED THIS ON EXCCEL SPREADSHEET WITH ALL THE NUMBER SIR. THE NAME EXCEL PAPER CAN BE HOME WORK P6 , P9 , P10 ,P11 , P12, P13 , P15 Unfortunately, due to rapidly rising housing prices during the decade prior to 2006, many home buyers needed increasingly larger loans to make their real property purchases. For example, a \$200,000 fixed-rate mortgage loan would result in a much higher monthly payment compared to a \$100,000 loan. Rework the above financial calculator spread sheet solutions using a PV of – 200000. The resulting doubling of the monthly payment to \$1,199.10 means that fewer potential home buyers could qualify for these larger loans.P6FV = PV * (1+r)^n;a)5000 = PV * (1+0.05)^10; 5000 = PV * (1.05)^10; PV = 5000/((1.05)^10); PV = \$3,069.57b)5000 = PV * (1+0.07)^7; 5000 = PV * (1.07)^7; PV = 5000/((1.07)^7); PV = \$3,113.75c)5000 = PV * (1+0.09)^4; 5000 = PV * (1.09)^7; PV = 5000/((1.09)^4); PV = \$3,542.13P9FV = PV * (1+r*n);FV = 5000 * (1+0.1*5); FV = 5000 * 1.5; FV = \$7,500P10PV = FV/((1+r)^n)PV = 3000/((1+0.04)^1); PV = 3000/1.04; PV = \$2,884.62PV = 3000/((1+0.04)^2); PV = 3000/1.04; PV = \$2.773.67P11PV = FV/((1+r)^n)PV = 3000 * P12Monthly payments = \$11122.22; annual payment = \$133,466.64P13Monthly payments = \$380.44; annual payments = \$4,565.28P15a)85*8 + 1000 = \$1,680; PV = 1680/((1+0.085)^8); PV = \$874.72b)PV = 1680/((1+0.1)^8) = \$783.73c)PV = 1680/((1+0.08)^8) = \$907.65

Do You Need A Similar Assignment Done For You From Scratch? We Have Qualified Writers To Help You. We Assure You An A+ Quality Paper That Is Free From Plagiarism. Order Now For An Amazing Discount!

Very professional support! Highly recommended.

#### Amos

Researched complicated topic and delivered report by the requested deadline. The paper is of a high standard reflecting careful research and clear assessments. I recommend iLecturers.com.com

#### Daria K

It’s a 5 start for me. Excellent research and writing. The paper reflects a careful assessment of scientific information.

#### Mahone

With Gib’s reflection, they wrote a really specific essay. Very well written, containing all of the languages I required and excellent references. The writer follows my instructions and writes clearly in English.

#### Mario G

I am so grateful and I am 100% happy with your work.

#### Julie

A fantastic piece of work 👏. The writer demonstrated full knowledge of the topic and applying the relevant provided material. Well done.