Accounting 2130 Project
Project1. Open the folder Challenge Template2. There are 4 worksheets for April, Might, June and Consolidated. The tabs are labeled.For every of the three months, full the worksheet as follows:a. Insert formulation for Rental Earnings (UNITS X OCCPANCY X RENT PER UNIT)b. Insert a formulation for month-to-month fee utilizing the PMT perform. The end result willshow as a destructive quantity in RED and that's right. Go away it as a destructive.c. Insert formulation for Gross Revenue (RENT INCOME + MONTHLY PAYMENT)d. Copy all formulation downe. Insert formulation for totals on the backside for columns F,G,H,Ok,L and M.f. Format all numbers for zero decimal locations and to indicate comma for 1000's.three. Open the CONSOLIDATED worksheet and insert formulation to whole the three months of information for Rental Earnings, Month-to-month Cost and Gross Revenue.four. Format the Consolidated Worksheet for zero decimal and daring the column headings and Title. Be happy so as to add colours if you want.5. Utilizing the consolidated worksheet, create a Pivot Device Desk for the consolidated sheet, which reveals The title of the event inside county. Then present the Sum of the Rental Earnings and Gross Revenue for every Improvement. See exhibit on subsequent web page.6. Open the Question sheet and question the music database to indicate solely these data with the LABEL of CAPITOL7. Open the SORT sheet and type the music database by ARTIS from A to Z.