Question: Can you please show me how to complete this problem on EXCEL? It is a non-profit so there is no tax 11.5 Brandywine Clinic, a

Can you please show me how to complete this problem on EXCEL? Can you please show me how to complete this problem on EXCEL?
It is a non-profit so there is no tax

11.5 Brandywine Clinic, a not-for-profit business, had revenues of $12 million in 2012. Expenses other than depreciation totaled 75 percent of revenues, and depreciation expense was $1.5 million. All revenues were collected in cash during the year, and all expenses other than depreciation were paid in cash. a. Construct Brandywine's 2012 income statement. b. What were Brandywine's net income, total profit margin, and cash flow? c. Now, suppose the company changed its depreciation calculation procedures (still within GAAP) such that its depreciation expense doubled. How would this change affect Brandywine's net income, total profit margin, and cash flow? d. Suppose the change had halved, rather than doubled, the firm's depreciation expense. Now, what would be the impact on net income, total profit margin, and cash flow

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!