Question

During a period when the real estate market in Phoenix, Arizona, was undergoing a significant downturn, CSM Consulting Engineers made an agreement with a distressed seller to purchase an office building under the following terms: total price of $2.1 million with a down payment of $400,000 now and no payments for 6 years, after which the remaining balance of $1.7 million would be paid. CSM was able to make this deal because of poor market conditions at the time of purchase, and, at the same time, planning to sell the building in 6 years (when market conditions would probably be better) and move to a larger office building in Scottsdale, Arizona. If CSM was able to sell the building in exactly 6 years for $2.8 million, what rate of return per year did the company make on the investment? Solve the problem using formula, table values and spreadsheet function and compare them.

Answer 1

Salition'- in fomula Annual Rate つPoincipal, or initial investment 2 AR 18.36 % ung spreadsheet tuncHen= IRRI) Hal istent4 Puting abore colminIRo tnal Payement veceip 0o IRR 175 % NOTE Table values o