rapidly-rising-housing-prices-accounting-homework-help

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.

P6

FV PV * (1+r)^n;

a)5000 PV * (1+0.05)^10; 5000 PV * (1.05)^10; PV 5000/((1.05)^10); PV $3,069.57

b)5000 PV * (1+0.07)^7; 5000 PV * (1.07)^7; PV 5000/((1.07)^7); PV $3,113.75

c)5000 PV * (1+0.09)^4; 5000 PV * (1.09)^7; PV 5000/((1.09)^4); PV $3,542.13

P9

FV PV * (1+r*n);

FV 5000 * (1+0.1*5); FV 5000 * 1.5; FV $7,500

P10

PV FV/((1+r)^n)

PV 3000/((1+0.04)^1); PV 3000/1.04; PV $2,884.62

PV 3000/((1+0.04)^2); PV 3000/1.04; PV $2.773.67

P11

PV FV/((1+r)^n)

PV 3000 *

P12

Monthly payments $11122.22; annual payment $133,466.64

P13

Monthly payments $380.44; annual payments $4,565.28

P15

a)85*8 + 1000 $1,680; PV 1680/((1+0.085)^8); PV $874.72

b)PV 1680/((1+0.1)^8) $783.73

c)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!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.