Calculate percent of total revenue. Please show excel calculations.

Common Size Statements of Cash Flow	12 Months Ended
Consolidated Statements of Cash Flows	Dec. 31, 2018	% of Total Revenue	Dec. 31, 2017	% of Total Revenue	Dec. 31, 2016	% of Total Revenue
CASH FLOWS FROM OPERATING ACTIVITIES
Net income	$216,355,000		$122,327,000		$106,712,000
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization	14,330,000		6,680,000		6,996,000
Depreciation and amortization - marketing and reservation system	19,597,000		20,609,000		20,663,000
Franchise agreement acquisition cost amortization	9,239,000		7,191,000		6,423,000
Impairment of goodwill	4,289,000		0		0
Gain on disposal of assets, net	-56,000		-237,000		-571,000
Provision for bad debts, net	10,542,000		5,514,000		3,365,000
Non-cash stock compensation and other charges	15,986,000		22,857,000		15,346,000
Non-cash interest and other investment (income) loss	3,695,000		-772,000		1,059,000
Deferred income taxes	-3,510,000		57,106,000		-29,723,000
Equity in net losses from unconsolidated joint ventures, less distributions received	7,389,000		6,579,000		1,025,000
Franchise agreement acquisition cost, net of reimbursements	-52,929,000		-30,638,000		-17,410,000
Change in working capital and other, net of acquisition	-2,031,000		40,158,000		38,150,000
Net cash provided by operating activities	242,896,000		257,374,000		152,035,000

Answer rating: 100% (QA)

answer To calculate the percent of total revenue for each year we will divide each item by the respe... View the full answer