Calculate the rate per period in cell H9. All mortgages being financed will be paid monthly. After completing the formula, use the fill handle to copy the formula down, stopping in cell H28.

 

Granger Vacation Properties Date High risk down payment % Low risk down payment % Low risk cut off Lot # Down payment rate 15% 5% 450 House Cost 130767 $ 372705 $ 394976 $ 135587 $ 435782 $ 142881 $ 266692 $ 543283 $ 290433 $ 283444 $ 100307 $ 624582 $ 598217 $ 356725 $ 262367 $ 557585 $ 235620 $ 146243 $ 605747 $ 221998 $ 369,546.00 120,082.00 376,269.00 348,781.00 111,905.00 262,945.00 390,340.00 391,746.00 173,540.00 297,150.00 264,567.00 130,611.00 295,136.00 335,153.00 247,494.00 150,546.00 151,154.00 163,946.00 137,707.00 320,594.00 Credit Score 519 738 489 750 774 635 705 351 431 668 690 350 597 710 544 524 509 596 739 629 Credit Score 100 600 750 Down Payment $55,431.90 $18,012.30 $56,440.35 $52,317.15 $16,785.75 $39,441.75 $58,551.00 $19,587.30 $8,677.00 $44,572.50 $39,685.05 $6,530.55 $44,270.40 $50,272.95 $37,124.10 $22,581.90 $22,673.10 $24,591.90 $20,656.05 $48,089.10 APR 8.00% 6.50% 4.25% % Financed Amount Financed $314,114.10 $102,069.70 $319,828.65 $296,463.85 $95,119.25 $223,503.25 $331,789.00 $372,158.70 $164,863.00 $252,577.50 $224,881.95 $124,080.45 $250,865.60 $284,880.05 $210,369.90 $127,964.10 $128,480.90 $139,354.10 $117,050.95 $272,504.90 Mortgage Rate Rate per period Years 15 15 15 30 20 20 20 30 30 30 20 20 15 30 15 30 20 30 20 20