Please provide a response to the following questions: a What is common sizing/vertical analysis and what is its importance in data analysis and forecasting? - What is trend/horizontal analysis and what is its importance in data analysis and forecasting? In addition, please complete the following problems. Submit your work in a table format in MS Word or MS ExceL Round to the nearest whole percentage [i.e.. do not round to any decimal places). Every single box below should have a value provided in it. Perform common sizingfvertical analysis for the assets of Hospital A and Hospital B. HospitalA Hospital B Current Assets $ 10,000,000 $ 18,000,000 Proper\"? Plant $100,000,000 $7,000,000 and Equrpment Other Assets $50,000,000 $12,000,000 Total Assets Perform trendX horizontal Analysis for the Assets of Hospital A. $ change % Change $ change % Change Hospital A Year 1 Year 2 year 1 to year 1 to Year 3 year 2 to year 2 to 2 2 3 3 current $10,000,000 $18,000,000 $15,000.000 Assets Property, Plant and $100,000,000 $107,000,000 $110,000,000 Equipment Other $50,000,000 $ 12,000,000 $35 ,000,000 Assets Total Assets