Skip to content

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.

    Dieny