90.2K

Verified Solution

Link Copied!

Need help on what formulas to use for this. I need to know how to approach the "total" column per what the professor requested. I also do not know in what way to configure % of total operating revenues. I do not have a lot of excel experience, so guidance for the bar graphs would be greatly appreciated. Please list and specify which formulas are used where.

Revenues and Expenses Bar Charts Budgeted Expenditures + Expenses E F Operating expenses: Salaries and Wages Benefits Utilities, supplies, and other services Scholarships and fellowships Depreciation Expense Pmts. To or on behalf of TTU Total operating expenses Operating Loss + Nonoperating Revenues (Expenses) State Appropriations Gifts, including 1,380,357.17 from comp. unit Grants and Contracts Inv. Income(exp)(net 274,355.71) Interest on capital asst-related debt Bond Issuance costs Other nonoperating revs. (exp) Total nonoperating revs. (exp) Income before other revenues, expenses, gains or losses 71. Create a worksheet called "Revenues and Expenses." Then, go to the Statement of Revenues, Expenses, and Changes in Net Position for the Year Ended June 30, 2021, on page 17 of the audit report and duplicate the table (including formatting) down to the line for Income before other revenues, expenses, gains, or losses. You should have formulas anywhere figures are sub-totaled or totaled. Then, add a separate column that totals the amounts for the University and the Component Unit. Create another column called "\% of Total Operating Revenue." Your spreadsheet should look something like this: Account University. Revenues Unit Total Revenue (list each account) Expenses % (list each account) Nonoperating Revenues (Expenses) % (list each account) 72. Create a second worksheet in the excel file called "Bar Charts." Create a bar chart using the Total column for all the sources of operating revenue and include a description of each revenue type. 73. Create another bar chart for the operational expenses and include a description of each expense type. 74. Create another bar chart for the nonoperating revenues (expenses) and include a description of each item type. 75. Create one more spreadsheet called "Budgeted Expenditures," then open up the 2022-2023 TTU Budget file. Find page 8 of the report that Revenues and Expenses Bar Charts Budgeted Expenditures + Expenses E F Operating expenses: Salaries and Wages Benefits Utilities, supplies, and other services Scholarships and fellowships Depreciation Expense Pmts. To or on behalf of TTU Total operating expenses Operating Loss + Nonoperating Revenues (Expenses) State Appropriations Gifts, including 1,380,357.17 from comp. unit Grants and Contracts Inv. Income(exp)(net 274,355.71) Interest on capital asst-related debt Bond Issuance costs Other nonoperating revs. (exp) Total nonoperating revs. (exp) Income before other revenues, expenses, gains or losses 71. Create a worksheet called "Revenues and Expenses." Then, go to the Statement of Revenues, Expenses, and Changes in Net Position for the Year Ended June 30, 2021, on page 17 of the audit report and duplicate the table (including formatting) down to the line for Income before other revenues, expenses, gains, or losses. You should have formulas anywhere figures are sub-totaled or totaled. Then, add a separate column that totals the amounts for the University and the Component Unit. Create another column called "\% of Total Operating Revenue." Your spreadsheet should look something like this: Account University. Revenues Unit Total Revenue (list each account) Expenses % (list each account) Nonoperating Revenues (Expenses) % (list each account) 72. Create a second worksheet in the excel file called "Bar Charts." Create a bar chart using the Total column for all the sources of operating revenue and include a description of each revenue type. 73. Create another bar chart for the operational expenses and include a description of each expense type. 74. Create another bar chart for the nonoperating revenues (expenses) and include a description of each item type. 75. Create one more spreadsheet called "Budgeted Expenditures," then open up the 2022-2023 TTU Budget file. Find page 8 of the report that

Answer & Explanation Solved by verified expert

See Answer