Need help with the following questions .

Need to be answered in excel

Problem #1 Suppose one of the suppliers to Flagstaff Health System offers terms of 3/20, net 60. a. When does the system have to pay its bills from this supplier? b. What is the approximate cost of the costly trade credit offered by this supplier? (assume 360 days per year) Problem #2 Sedona Healthcare, a not-for-profit business, had revenues of $31 million in 2016. Expenses other than depreciation totaled 74% of revenues, and depreciation expense was $1.8 million. All revenues were collected in cash during the year and all expenses other than deprecation were paid in cash. a. Construct Sedona Healthcare's 2016 income statement. b. What were Sedona Healthcare'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 Sedona Healthcare's net income, total profit margin and cash flow? Make sure your answers are in the proper format (i.e. $, %) a. Here is Sedona Healthcare's income statement (in millions): Make there is a heading on the financial statement Problem #3 Answer the following questions: (there are 7 questions) Each question is worth 6 points. 1 What is variance analysis? 2 Would you rather have a savings account that pays 5% compounded semiannually or one that pays 5 percent compounded daily? Explain. 3 What are the two types of portfolio risk? How is each type defined and measured? 4 What is the primary legal issue facing providers today? 5 a. What is the primary goal of investor-owned corporations? b. What is the primary goal of most not-for-profit healthcare corporations? c. Are there substantial differences between the finance goals of investor-owned and not-forprofit corporations? Explain. 6 Briefly describe the difference between cash and accrual accounting. Be sure to include a discussion of the matching principle. 7 What is wrong with this statement: "The clinic's cash balance for 2016 was $150,000, while its net income on December 31, 2016 was $50,000." Problem #4 Bright Angel Hospital, a not-for-profit acute care facility, has the following cost structure for its inpatient services for 2016: Fixed costs $15,000,000 Variable cost per inpatient day $200 Charge (revenue) per inpatient day $1,400 The hospital expects to have a patient load of 19,500 in patient days next year a. b. c. Construct the hospital's base case project profit and loss statement. Make sure to include the heading. What is the hospital's breakeven point? What volume is required to provide a profit of $1,000,000? A profit of $500,000? a.Here is the hospital's base case projected profit and loss statement