please solve using excel and show excel functions

5. An investor buys a $100.000 condo by putting 10% down and financing the rest for 15 years at an annual rate of 3.296. The conde depreciates in value by 0.5% a month over the next six years During those years the investor has rent of $700 a month coming in. The investor decides to sell it after the 6 years. What was the price of the condo when it was hold? How much equity is in the condo when it was sold? How much interest was paid on the loan over the 6 years? What was the return on this investment? 20 points 5. An investor buys a $100.000 condo by putting 10% down and financing the rest for 15 years at an annual rate of 3.296. The conde depreciates in value by 0.5% a month over the next six years During those years the investor has rent of $700 a month coming in. The investor decides to sell it after the 6 years. What was the price of the condo when it was hold? How much equity is in the condo when it was sold? How much interest was paid on the loan over the 6 years? What was the return on this investment? 20 points