property produces a net operating income of $20,000 in year 1, $30,000 in year 2, and $45,000 in years 3 to 6. The resale price is estimated using a terminal capitalization rate of 7% applied to the sixth year NOI. What is the value of the property using a 10% discount rate? A. $502,634 B. $424,337 C. $468,892 D. $534,625

Please show how to do on excel! Please dont copy a previous answer from another question and adjust numbers