What were Brandywine’s net income, total profit margin, and cash flow?

Question 1:
For question 1 of this homework, answer these questions from problem 11.5 in the ‘Fundamentals’ textbook, page 349:
a. Construct Brandywine’s 2016 income statement
b. What were Brandywine’s net income, total profit margin, and cash flow?
Please attach your work in Excel.
Question 2:
For question 2 of this homework, first read Case 23 in the ‘Cases’ textbook (pages 149-158) and answer the following questions:
1. Review and interpret Commonwealth’s statement of cash flows for 2017. What information does it provide regarding the HMO’s sources and uses of cash over the past year?
2. Use the Du Pont equation to obtain a rough feel for Commonwealth’s financial condition as compared to national averages. What are your conclusions?
3. Conduct a financial statement and operating indicator analysis and interpret the resulting data. Use both national and state competitor data in the analysis. (Note that all ratios do not have a complete set of comparative data.)
Download the accompanying student spreadsheet .

Last Completed Projects