Last year, Wildhorse Condos installed a mechanized elevator for its tenants. The owner of the company, Daniel Jackson, recently returned from an industry equipment exhibition where he watched a computerized elevator demonstrated. He was impressed with the elevator's speed, comfortable ride, and cost efficiency. Upon returning from the exhibition, he asked his purchasing agent to collect price and operating cost data on the new elevator. In addition, he asked the company's accountant to provide him with cost data on the company's existing elevator. The information is presented below:

		Old Elevator		New Elevator
	Purchase price	$117,600		$179,900
	Estimated salvage value	0		0
	Estimated useful life	6 years		5 years
	Depreciation method	Straight-line		Straight-line
	Annual operating expenses other than depreciation:
	Variable	$35,000		$12,500
	Fixed	22,800		8,900

Annual revenues are $240,100 and selling and administrative expenses are $28,700, regardless of which elevator is used. If it replaces the old elevator now, at the beginning of 2022, Wildhorse Condos will be able to sell it for $25,900.

Determine any gain or loss if the old elevator is replaced.

If the old elevator is replaced Wildhorse Condos will incur a select an profit or loss of $ .

Question Part Score

--/2

Prepare a 5-year summarized income statement for each of the following assumptions:

(1) The old elevator is kept.

Sales				$enter a dollar amount
Less costs:
Variable operating costs		$enter a dollar amount
Fixed operating costs		enter a dollar amount
Selling and administrative		enter a dollar amount
Depreciation		enter a dollar amount		enter a subtotal of the four previous amounts
Net income				$enter a total amount

(2) The old elevator is replaced.

Sales			$enter a dollar amount
Less costs:
Variable operating costs	$enter a dollar amount
Fixed operating costs	enter a dollar amount
Selling and administrative	enter a dollar amount
Depreciation	enter a dollar amount		enter a subtotal of the four previous amounts
Operating income			enter a total amount for the first part
Less: Loss on old elevator			enter a dollar amount
Net income			$enter a total amount