Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone show me how to fill in the cells highlighted in yellow? Property Value $350,000.00 [1] [2] [3] [5] Term Interest Rate Required Percent

Can someone show me how to fill in the cells highlighted in yellow?

image text in transcribed

Property Value $350,000.00 [1] [2] [3] [5] Term Interest Rate Required Percent Down Closing Costs Origination Points ARM Rate after adjustment 30-Year Fixed Rate 30 4.25% 20% $3,000.00 1% N/A 15-Year Fixed Rate 15 3.625% 20% $3,000.00 1% N/A FHA 30-Year Fixed 30 4.625% 5% $3,000.00 1% N/A 5-1 ARM 30 3.50% 20% $4,500.00 1% 5.125% 7-1 ARM 30 3.75% 20% $4,500.00 1% 5.125% [6] [7] 5-Year Interest 2nd Mortgage Only with (on 15% of Balloon value) 30 15 5.00% 6.25% 10% 5% $5,000.00 $1,250.00 2% 1% N/A N/A Amount Financed Monthly Payment Interest paid over life of loan APR Interest portion of 14th payment. Balloon Payment (balance when ARM adjusts) New Payment (ARMs) Increase if payment if rate increases 1.0% $280,000.00 $280,000.00 $332,500.00 $280,000.00 $280,000.00 $315,000.00 $1,377.43 $2,018.90 $1,709.51 $1,257.33 $1,296.72 $215,875.41 $83,402.53 $282,925.00 $172,637.05 $186,820.52 -$315,000.00 4.43% 3.93% 4.79% 3.71% 3.97% 5.32% $973.52 $798.92 $1,259.56 $799.66 $857.54 $1,291.48 N/A N/A N/A N/A N/A N/A N/A $168.74 $141.01 $204.54 $1,888.58 $52,500.00 $450.15 $28,526.46 6.80% $261.09 N/A N/A $29.11

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

Dropshipping Guide 2020

Authors: James Young

1st Edition

979-8644815098

More Books

Students also viewed these Finance questions

Question

Differentiate between a command system and a market system.

Answered: 1 week ago