Please use excel and read instructions

A E H M N Problem 8 (10 Points) Assume you are in the 37.5 percent personal tax bracket. You are considering investing $75,000 in for profit Universal Health Services (UHS] bonds that carry an 9.75 percent Interest rate. al How much interest would you receive net of the tax on the investment? bj what is the after tox total amount of your investment? (] Now, consider that Not for Profit Kater Permanante, one of the leading Calidomin Healthcare system, has lawved tax. exempt bonds that have an interest rate of 6.5 percent to finance a new Women's and Children's Pavillion. With all che the same. should you buy 575,090 of the taxable UHS bonds at 10.75% Interest, or 75,000 of Kaiser Permanente bands? Based on your answer to Cabove, please find the point (interest rate) of indifference. [Please explain) CEASE SHOW PROOF)A Problem #9 (10 Points] Please develop TWO forecasts based on ABC Health Clinic's revenues from the previous years using: 1)a moving average two year forecast and 2) Percentage change forecast Flucal Year Collection Collections 2004 $ 22.376.00 2008 3001 $ 21 030 00 2080 2010 $ 16.100.90 2010 2011 5 25 225 00 2011 2012 $ 20,200.00 2012 2013 3 25 030.C0 2013 2015 $ 16,500.00 2015 3018 # 34,450 00 3018 2017 $ 23,030.00 2017 3018 $34,030 00 2018 2016 $ 32,100.90 2019 2020 4 53 000 00 2021 Future year (2020) Future year (202 1 Future your [2022) Future year 12022D H Problem #6 (15 Points] MPA Healthcare currently provides 1,000 white per year at a price of $50 per visit. The variably cost per vhit (variable cost rate] is $30, and total fixed costs are $15,000. The business manager suggests that MPA Pediatrics can increase the number of visits to 1,200 per year by cutting the price per visit by 10% and increasing the food advertising budget by $5,000. a. Construct the base case PAL statement. Please show Contribution Margin in your analysis. b. What I MPA Pediatrics break even? How many patients would have to vish MPA Pediatrics for them to have an economic profits of 56.5007 E. What is the projected PSL statement incorporating the proposed change? . How much would vhits/volume need to Increase in order for MPA Pediatrics to break even with the proposed changes