can you do it on microsoft excel.

1) Below is Caprio Services adjusted trial balance for the year ending December 31, 2016. Using thisinformation, prepare the income statement,statement of owners equity and then the balancesheet for the end of December 31, 2016.

Caprio ServicesAdjusted Trial BalanceDecember 31, 2016
Account Titles	DR	CR
Cash	$90,200
Accounts Receivable	47,800
Prepaid Insurance	32,000
Equipment	415,000
Accumulated Depreciation		$145,000
Accounts Payable		26,000
Unearned Revenue		15,800
Bank Loan		260,000
Caprio, Capital		108,200
Caprio, Drawings	40,000
Service Revenue		545,000
Advertising Expense	100,000
Insurance Expense	40,000
Maintenance Expense	5,900
Rent Expense	78,000
Salaries Expense	228,500
Telephone Expense	3,200
Travel Expense	19,400
Total	$1,100,000	$1,100,000