Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If you could help me with the latter half of the page beginning with question 4 but plz use 10% down and monthly appreciation of

If you could help me with the latter half of the page beginning with question 4 but plz use 10% down and monthly appreciation of .15%. Also, this has to be solved using excel. Thanks image text in transcribed
Investor buys property worth $1.5 million. Puts 20% down financing the rest for 10 year at an annual rate of 3.2% a year. What are the monthly payments? How much is owed on the loan after 70 months? How much of the first 70 payments went to paying down the principal? How much went to paying off the interest? A. $\\,698.40 @70 months 546,920.89 CCumirite="683,07 = What happens if an extra $500 is added each month to the payment? Principal art goes upi interest ant goes down, loan gets pdoft quicker alok less than orig. terms What are the answers if initially 10% is put down? Prt 13,160.70 => @70-615,284 ->CUMPRINC= 734,714 D=> Eumeam= 186,535,20 Property appreciates by 0.15% a month. 4) What is the value of the property after 70 months? How much equity is in the property after 70 months? What percent of the equity after 70 months comes from paying down of the principal? What percent from the down payment? What percent from the growth in the property? (14,03 If the property is sold after the 70 months what is the monthly return to the investor? 674 What happens to the return if there is rental income of $5000 a month

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Finance questions

Question

Create a corporate story for a company with which you are familiar.

Answered: 1 week ago

Question

Find examples of good corporate advertising.

Answered: 1 week ago