please see the attachment is the dates that will answer the question. please do the format as you do it in excel. it is very confusing for me.

1. Income statement

1. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create formulas in Excel to address the following questions for 19X1:
2. What is the collection percentage?
3. What percentage of total expenses are human resources (wages and benefits)?
4. What percentage of net income went to physician distributions?
5. How do you access the income statement for 19X1? Explain.

1. Income statement

1. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create formulas in Excel to address the following questions for 19X1:
2. What is the collection percentage?
3. What percentage of total expenses are human resources (wages and benefits)?
4. What percentage of net income went to physician distributions?
5. How do you access the income statement for 19X1? Explain.

please see the attchments

212 Chapter 7 Measuring and Managing Cash Flows Here are the deliverables: a. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create 1. Income statement formulas in Excel to address the following questions for 19X1 : b. What is the collection percentage? c. What percentage of total expenses are human resources (wages and benefits)? d. What percentage of net income went to physician distributions? e. How do you access the income statement for 19X1? Explain. 212 Chapter 7 Measuring and Managing Cash Flows Here are the deliverables: a. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create 1. Income statement formulas in Excel to address the following questions for 19X1: b. What is the collection percentage? c. What percentage of total expenses are human resources (wages and benefits)? d. What percentage of net income went to physician distributions? e. How do you access the income statement for 19X1? Explain. 212 Chapter 7 Measuring and Managing Cash Flows 212 Chapter 7 Measuring and Managing Cash Flows Here are the deliverables: a. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create 1. Income statement formulas in Excel to address the following questions for 19X1 : b. What is the collection percentage? c. What percentage of total expenses are human resources (wages and benefits)? d. What percentage of net income went to physician distributions? e. How do you access the income statement for 19X1? Explain. 212 Chapter 7 Measuring and Managing Cash Flows Here are the deliverables: a. Create this statement in Excel, transcribing all the numbers highlighted in yellow. Then create 1. Income statement formulas in Excel to address the following questions for 19X1: b. What is the collection percentage? c. What percentage of total expenses are human resources (wages and benefits)? d. What percentage of net income went to physician distributions? e. How do you access the income statement for 19X1? Explain. 212 Chapter 7 Measuring and Managing Cash Flows