Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am not good at accounting and need to work on this worksheet and I need to make an Excel spreadsheet from scratch. Please make

image text in transcribed

image text in transcribed

I am not good at accounting and need to work on this worksheet and I need to make an Excel spreadsheet from scratch. Please make sure all the input words, numbers, and formulas into individual cells, and make it appear as close to the original as you can.

This information below is taken directly from the HCA financial statements. It is here to orient you to the source of the information and to assist you in preparing an appropriate heading for your spreadsheet: HCA HEALTHCARE, INC. CONSOLIDATED INCOME STATEMENTS FOR THE YEARS ENDED DECEMBER 31, 2022, 2021 AND 2020 (Dollars in millions, except per share amounts) Revenues HCA HEALTHCARE, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Continued) NOTE 1 - ACCOUNTING POLICIES Our revenues by primary third-party payer classification and other (including uninsured patients) for the years ended December 31, are summarized in the following table (dollars in millions): This information below is the information you need to prepare on your spreadsheet. Use the title information above to create a useful title for the reader and center it above the financial information that you prepare. Do not worry about improving on what the author has done. Work to match your spreadsheet to be as close to theirs as you can. S.B. 10/2/23 v1.0 Page 3 In this learning exercise, take the time to practice your spreadsheet skills. Here is checklist of the things you need to consider and incorporate in your spreadsheet: 1. Use the underlines as shown in the columns. Make sure they are the same width as the column. 2. Use the calculation formulas in the cells where appropriate. (This will also serve to ensure you understand the calculations on the schedule). Do this everywhere that there is a calculation. 3. Format the numbers and words as the author has done. This includes using the same (or very close) font and presenting numbers to the same decimal level. Use a "\$" and show as whole numbers using a comma. For "\$" and "\%" symbols, always be careful on noting when and how that is to be presented. This is true with "Words" as well. They should be centered or justified to the right or left were appropriate. 4. Set the column width to ensure the numbers and words are readable. 5. Use the "bold" formatting as appropriate to emphasize certain areas. 6. Prepare the spreadsheet for printing by using the "file > print > page setup" commands and entering the appropriate fields to print. When your completed spreadsheet is printed by the reader, they should not have to make any formatting changes for it to print in the manner that you want. For this exercise, set the spreadsheet to print in Landscape on 1 page with a footnote as instructed. 7. Save the file using a filename that includes your name and the date. Having useful information in a file name is very helpful to both the reader and you. 8. Run "spellcheck" ( Review > ABC Spelling; or use the "F7" key) to catch any misspellings. 9. Put your name as the preparer in a footnote on the spreadsheet. Get used to using the footnote field at the bottom of the spreadsheet. You can use your name, or page number, or date, or file name. All are useful things 10. Prepare an appropriately worded and centered title to appear at the top of the document. 11. Use this checklist after you are done to check your work

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Inventory

Authors: Steven M. Bragg

4th Edition

1642210714, 9781642210712

More Books

Students also viewed these Accounting questions