RIVER COMMUNITY HOSPITAL (B)
Financial Forecasting Review the spreadsheet model, paying particular attention to (1) what assumptions are currently embedded in the model, (2) how the financial forecasts are developed, and (3) how financing feedbacks are handled. Briefly describe the model and its assumptions.
Disregard the forecasting results supplied with the model. (a) Use your own assumptions to develop the hospital's forecasted financial statements. Be sure to analyze your results from the perspectives of both accounting consistency and financial feasibility. (b) Use the current industry comparative data given in case 1 to help assess the hospitals projected financial condition. Summarize your results in a table that shows key financial ratios, retained earnings, and external financing requirements (if required) for each year, along with five-year totals for earnings and financing.
AutoSave OF AAP 2G ... Case 25 River Community Hospital (B) - Student - 6th edition Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial Insert v ~ A A v 12 X G ab Wrap Text Date Ayu 0 Delete Paste BIU Av Y = = = Merge & Center Conditional Format Cell Formatting as Table Styles Sort & & Filter Sensitivity # Format Find & Select Analyze Data V H1 fx A A n E F G H 1 LI Z A. AB 32 NPUT DATA KEY OJTPUT 2017 7 2013 31 Doetinch GOS FOA 75 55 2011 4116 2.82 29 RU Curat. Ourumund ni 262 114.616 rb Opares IND Gewhe FI We 4G REVENUES New 4T hw Tad 2016 2017 SORT 5313 12T 1151 SUES $32424 2017 SET 1. ICH HI we 2016 SA Sny SURE 10 100 NA FI 2016 SVE Sony BALIKE HAM ZIP AIRE FI Fi FIN 120 2121 2161 10 216 rowerowe WET 216 59441 53 64 5384 5.42 tes ES ES? H1 $9.441 5.42 S21 4 210 80 EXPENSES Gries and www Fews HR D1 e Wind Prowaway . Table ubwa ALYAS $19 512 403 $13 110 2492 23 1.16 1993 1.TE 2960 2.65 2.12 2666 0140 0215 RIOR 1939 11011 ST.DISIS Sez 532337 $1620 17. S $16. ROS" Eros $ 311 WEB 2 MO 1000 210 2008 3.100 3.100 3411 2411 3 me 113 112- NA 17 1300 1360 2.104 2.1 2.190 2204 23 230 F 2552 10.07. Subt Sibe" se 4.Le 4 444 10.00 0854 854 DU 1069 100 1.18 100 1.15 125 090 125. 0220 024 084 361 3851 100 12000 13.00 14.20 14.200 1. " 17 2017 1722 11 10 11 1961 NA $7.17 $0.00 $0.00 $0.99 $14.2 $15.03 $125 $18.455 133 1391 1 YA NA 1884 SOS 101 2 R $8.45 84164 SB 54.46: 54. 11. TT 52132 S4 255 83 Bus FI GREX FW Fi MI w MIA FI MA W Non FI 201 2016 2017 MIA 201 We 2102 202 SETS $220 2.C pe NON 5.154 AIO E 15200 $ 39 eu 55.4 0432 0523 0206 772 TS S. 7413 1601 RO TU OBU 10 HE NA ST 100 5.14 100 1 10 NA WHO 100 NA NA 1929 mothorum 71 Creeper 74 NET! BRE SAGA 54501 1. 1100 B. 1 122 1941 Stree 1BC ES 31.101 2919 1.117 $10R Stree DE S.SE $ $rer 22.44 ME YA 1224 $1!! 17177 STIC $ 2.12 1.10 182.145 54501 1190 We 1467 511 ! SPACE 3 86244 *.24 $9=139 H331 112 ce 11 142.545 LES 145.43 ES 145.B 152.14. these 70 53 GATE SEME WEB WORDT voor WOTE $73 17 373173 $ 129 son 51 THE 1.1 18 10 10 SIR $130 1/29 1. sy F W 122 7 WBUTIES AND FUND MAROE M LES 31 , 2 WINS Long and Now $10 1299 1.72 s! 5191 1503 141 54 519 222 DID $1W 1291 1.BIZ 14.841 $16.164 - 529 1. SE KAR *1382 $1 for 1201 SINI $16.666 A BOB 6 $1 53741 11 2360 te: K2 NA BE 1.733 W 2.145 E 8.444 $1680 5.85 116.6 w 31776 3000 III 2560 We $1: 115 4741 be 317.62 1151 www 58447 SAN AF TE F41 ded 992001 4.29 NA ME E IE 2011 390.190 $98.174 SKY SON 2095 SES BE 53.112 53.112 53.100 63.110 R. 6062 Ehad TH ... Question 3 Question 4 3 12 2.888 SEM + 10 Question 2 Question 5 Question Model Question 1 Ready Crcular References 70% AutoSave OF AAP 2G ... Case 25 River Community Hospital (B) - Student - 6th edition Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 Insert v ~ A A Hay Date O X G 2 Wrap Text 0 Delete Paste BIU 7 Av Y = = = Merge & Center v $ %) Conditional Format Cell Formatting as Table Styles Sort & & Filter # Format Find & Select Sensitivity Analyze Data V H1 fx DE A C n F G LI Z A. AB 5310
