Question: answer ONLY in excel with cell reference. thank you An movestment fint bought a property for S500.000 by putting Stadewand facing the rest for ten
An movestment fint bought a property for S500.000 by putting Stadewand facing the rest for ten years of 3 yeat. Alter buying the property, the firm had renovation costs of $20.000 a month for the first three months. After the renovation the firm cented the property for S3000 a month seven years after the property was purchase the rest was raised an additional S1000 a month Twelve years after the property was purchased it was sold it for 5700.000 Asume the opportunity costs for the money used in the down payment and the renovations are zero, Determine the monthly payment on the loan What was the monthly growth rate in the value of the property over the 12 years? points What was the cash flow at the 37 month? What was the cash flow at the mouth? What was the cash flow at the 8th month? What was the annual return on this investments? Create a data table with the anal return as the output variable. The tow input is the initial rent start at $2000 and go to 54000 in increments of 5500. The colummo inputs tha selling price Start at $300,000 and go to $300,000 in increments of S100.000, Ung the data table, what was the annual return when the initial rent was 52500 and the selling price was $600,000 An movestment fint bought a property for S500.000 by putting Stadewand facing the rest for ten years of 3 yeat. Alter buying the property, the firm had renovation costs of $20.000 a month for the first three months. After the renovation the firm cented the property for S3000 a month seven years after the property was purchase the rest was raised an additional S1000 a month Twelve years after the property was purchased it was sold it for 5700.000 Asume the opportunity costs for the money used in the down payment and the renovations are zero, Determine the monthly payment on the loan What was the monthly growth rate in the value of the property over the 12 years? points What was the cash flow at the 37 month? What was the cash flow at the mouth? What was the cash flow at the 8th month? What was the annual return on this investments? Create a data table with the anal return as the output variable. The tow input is the initial rent start at $2000 and go to 54000 in increments of 5500. The colummo inputs tha selling price Start at $300,000 and go to $300,000 in increments of S100.000, Ung the data table, what was the annual return when the initial rent was 52500 and the selling price was $600,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
