Stratedic Financial Planning The CEO of a hospital has announced an ambitious building and renovation project that will increase total assets by $40,000,000 over the next four years. You are in charge of reviewing the plan and determining if it is feasible (Millions) Income Statement Revenues 2011 2012 2013 2014 2015 2016 20172018 2019 $100 $106 $112 $119 $126 98 103 111-117-123 $2$3 $1 $2 $3 Net Income Balance Sheet Assets Current Liabilities Long Term Debt Fund Balance 2011 2012 2013 2014 2015 2016 20172018 2019 $80 $82 $85 $86 $90 $100 $110 $120 $130 12 3 13___ _ 10 11 40 39 303233 35 37 40 38 40__ A. Calculate the historical growth rates for revenues, expenses, total assets, current liabilities, and the fund balance Revenues Expenses Total assets Current Liabilities: Fund balance B. Assuming historical patterns continue, calculate the fund balance four years out (the change in fund balance is prior year fund balance - profit or loss). Estimate future current liabilities using its historical growth rate and calculate the amount of long term debt that will be required to balance assets with liabilities and the fund balance (LT Debt- Assets-Current Liabilities and Fund Balance) C. The long term debt to equity ratio ($40m/$37m) is 1.08215), assuming the board of directors wants to maintain a long term debt to equity ratio of 1.40 or less, is the plan feasible? Long Term Debt to Equity ratio2o19): Assume the plan is not feasible, what actions can be taken to ensure LT Debt to equity